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
  50
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
EXXS--------4swap(BC,BC');swap(DE,DE');swap(HL,HL')
HALTS--------4waits for interrupt
IM nSImmediate-------8Interrupt mode:=n
IN (c)URegister--0P0SS12in(BC)?
IN A, (n)SAccumulatorImmediate------11A := in(An)
IN r, (c)SRegisterRegister-0P0SS12r := in(BC)
INC (HL)SIndirect--0!SSS11HL*++
INC (IXY+d)SIndexed--0!SSS23(IXY+d)*++
INC BC/DE/HL/SPSRegister-------6rr++
INC IXYSRegister-------10rr++
INC rSRegister--0!SSS4r++
INDS--?1??!?16HL*:=in(BC); HL--; B--
INDRS--?1??1?21x+16do IND while(B>0)
INIS--?1??!?16HL*:=in(BC); HL++; B--
INIRS--?1??1?21x+16do INI while(B>0)
JP (C)ERegister-??????13PC:=PC&$C000+IN(C)<<6
JP (HL)SRegister-------4PC:=HL (not PC:=HL*)
JP (IXY)SRegister-------8PC:=IXY (not PC:=IXY*)
JP Z/NZ/NC/C/PO/PE/P/M, nnSAddress-------10if cc PC:=nn
JP nnSAddress-------10PC:=nn
JR C/NC/Z/NZ, nnSImmediate-------12 ; 7 if not ccif cc PC+=nn
JR nnSImmediate-------12PC+=nn
LD (BC/DE), ASIndirectAccumulator------7rr* := A
LD (HL), nSIndirectImmediate------10HL* := n
LD (HL),rSIndirectRegister------7HL* := r
LD (IXY+d), nSIndexedImmediate------19(IXY+d)* := n
LD (IXY+d),rSIndexedRegister------19(IXY+D)* := r
LD (nn), ASAddressAccumulator------13(nn)* := A
LD (nn), BC/DE/SP/IXYSAddressRegister------20(nn)* := rr
LD (nn), HLSAddressRegister------16(nn)* := HL
LD A, (BC/DE)SAccumulatorIndirect------7A := rr*
LD A, (nn)SAccumulatorAddress------13A := (nn)*
LD A, ISAccumulatorRegister-0!0SS9A := I; P/V:=IFF2
LD A, RSAccumulatorRegister-0!0SS9A := R; P/V:=IFF2
LD BC/DE/HL/SP, nnSRegisterImmediate------10rr := nn
LD BC/DE/SP/IXY, (nn)SRegisterAddress------20rr := (nn)*
LD HL, (nn)SRegisterAddress------16HL := (nn)*
LD I, ASRegisterAccumulator------9I := A
LD IXY, nnSRegisterImmediate------14rr := nn
LD R, ASRegisterAccumulator------9R := A
LD SP, HLSRegisterRegister------6SP := HL
LD SP, IXYSRegisterRegister------10SP := IXY
LD r, (HL)SRegisterIndirect------7r := HL*
LD r, (IXY+d)SRegisterIndexed------19r := (IXY+d)*
LD r, r'SRegisterRegister------4r := r'
LD r,nSRegisterImmediate------7r := n
LDDS---0L0--16DE*:=HL*; DE--; HL--; BC--
LDDRS---000--21x+16do LDD while(BC>0)
LDDRXE--------21/16do LDDX while(BC>0)
LDDXE--------16{if HL*!=A DE*:=HL*;} DE++; HL--; BC--