Semantic search

Jump to: navigation, search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
SQLStore debug output
ASK Query
[[IsZ80Instruction::true]]
SQL Query
SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_di_bool` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (
   (t1.o_value='1') AND t1.p_id='725')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  100
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_valueo_value2const400Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4specnext_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
Mnemonic (use uppercase)StatusAddressing Mode 1Addressing Mode 2CNPVHZST-StatesSummary
LDIS---0L0--16DE*:=HL*; DE++; HL++; BC--
LDIRS---0L0--21x+16do LDI while(BC>0)
LDIRXE--------21/16do LDIX while(BC>0)
LDIXE--------16{if HL*!=A DE*:=HL*;} DE++; HL++; BC--
LDPIRXE--------21/16do{t:=(HL&$FFF8+E&7)*; {if t!=A DE*:=t;} DE++; BC--}while(BC>0)
LDWSE---0!SSS14DE*:=HL*; INC L; INC D;
MIRROR AERegister-------8A[76543210]:=A[01234567]
MUL d,eE--------8DE:=D*E
NEGS--!1!SSS8A:=0-A
NEXTREG n, AEImmediateAccumulator------17HwNextReg_n:=A
NEXTREG n,n'EImmediateImmediate------20HwNextReg_n:=n'
NOPS--------4PC+=1
OR (HL)SIndirect-00P0SS7A := A OR HL*
OR (IXY+d)SIndexed-00P0SS19A := A OR (IXY+d)*
OR nSImmediate-00P0SS7A := A OR n
OR rSRegister-00P0SS4A := A OR r
OTDRS--?1??1?21x+16do OUTD while (B>0)
OTIRS--?1??1?21x+16do OUTI while (B>0)
OUT (c),0URegisterImmediate------12out(BC,0)
OUT (c),rSRegisterRegister------12out(BC,r)
OUT (n),ASImmediateAccumulator------11out(An,A)
OUTDS--?1??!?16B--; out(BC,HL*); HL--
OUTIS--?1??!?16B--; out(BC,HL*); HL++
OUTINBE--??????16out(BC,HL*); HL++
PIXELADE--------8HL:=$4000+((D&$C0)<<5)+((D&$07)<<8)+((D&$38)<<2)+(E>>3)
PIXELDNE--------8if(HL&$0700!=$0700) HL+=256;
else if(HL&$e0!=$e0) HL:=HL&$F8FF+$20;
else HL:=HL&$F81F+$0800
POP AFSRegister-!!!!!!10rr:=SP*; SP+=2
POP BC/DE/HLSRegister-------10rr:=SP*; SP+=2
POP IXYSRegister-------14rr:=SP*; SP+=2
PUSH BC/DE/HL/AFSRegister-------11SP-=2; SP*:=rr
PUSH IXYSRegister-------15SP-=2; SP*:=rr
PUSH nnEImmediate-------23SP-=2; SP*:=nn
RES b,(HL)SImmediateRegister------15HL*:=HL* & (~(1<<b))
RES b,(IXY+d)SImmediateIndexed------23(IXY+d)*:=(IXY+d)* & (~(1<<b))
RES b,rSImmediateRegister------8r:=r & (~(1<<b))
RES r,b,(IX+d)UImmediateIndexed------23(IX+d)*:=(IX+d)* & (~(1<<b)); r:=(IX+d)*
RETS--------10PC:=SP*; SP+=2
RET Z/NZ/C/NC/PO/PE/P/MS--------11 ; 5 if not ccif cc {PC:=SP*; SP+=2}
RETIS--------14PC:=SP*; SP+=2
RETNS--------14IFF1:=IFF2; PC:=SP*; SP+=2
RL (HL)SIndirect-!0P0SS15x:=HL*[7]; HL*:=HL*<<1; HL*[0]:=CF; CF:=x
RL (IXY+d)SIndexed-!0P0SS23x:=(IXY+d)*[7]; (IXY+d)*:=(IXY+d)*<<1; (IXY+d)*[0]:=CF; CF:=x
RL rSRegister-!0P0SS8x:=r[7]; r:=r<<1; r[0]:=CF; CF:=x
RL r,(IX+d)URegisterIndexed!0P0SS23x:=(IX+d)*[7]; (IX+d)*:=(IX+d)*<<1; (IX+d)*[0]:=CF; CF:=x; r:=(IX+d)*
RLAS--!0-0--4x:=A[7]; A:=A<<1; A[0]:=CF; CF:=x
RLC (HL)SIndirect-!0P0SS15x:=HL*[7]; HL*:=HL*<<1; HL*[0]:=x; CF:=x
RLC (IXY+d)SIndexed-!0P0SS23x:=(IXY+d)*[7]; (IXY+d)*:=(IXY+d)*<<1; (IXY+d)*[0]:=x; CF:=x
RLC rSRegister-!0P0SS8x:=r[7]; r:=r<<1; r[0]:=x; CF:=x
RLC r,(IX+d)URegisterIndexed!0P0SS23x:=(IX+d)*[7]; (IX+d)*:=(IX+d)*<<1; (IX+d)*[0]:=x; CF:=x; r:=(IX+d)*
RLCAS--!0-0--4x:=A[7]; A:=A<<1; A[0]:=x; CF:=x