Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[IsZ80Instruction::true]]
 |?Cleandesc=Mnemonic (use uppercase)
 |?Status
 |?Admode1=Addressing Mode 1
 |?Admode2=Addressing Mode 2
 |?Ceffect=C
 |?Neffect=N
 |?Pveffect=PV
 |?Heffect=H
 |?Zeffect=Z
 |?Seffect=S
 |?Tstates=T-States
 |?Summary
 |format=table
 |limit=50
 |offset=50
 |sort=
 |order=asc
 |mainlabel=-
}}

Results 51 – 100 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

The query [[IsZ80Instruction::true]] was answered by the "SMWSQLStore" in 0.0072 seconds.

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

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	s_id,o_value	o_value	2	const	400	Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	specnext_wiki.t1.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Mnemonic (use uppercase)	Status	Addressing Mode 1	Addressing Mode 2	C	N	PV	H	Z	S	T-States
EXX	S	-	-	-	-	-	-	-	-	4
HALT	S	-	-	-	-	-	-	-	-	4
IM n	S	Immediate	-	-	-	-	-	-	-	8
IN (c)	U	Register	-	-	0	P	0	S	S	12
IN A, (n)	S	Accumulator	Immediate	-	-	-	-	-	-	11
IN r, (c)	S	Register	Register	-	0	P	0	S	S	12
INC (HL)	S	Indirect	-	-	0	!	S	S	S	11
INC (IXY+d)	S	Indexed	-	-	0	!	S	S	S	23
INC BC/DE/HL/SP	S	Register	-	-	-	-	-	-	-	6
INC IXY	S	Register	-	-	-	-	-	-	-	10
INC r	S	Register	-	-	0	!	S	S	S	4
IND	S	-	-	?	1	?	?	!	?	16
INDR	S	-	-	?	1	?	?	1	?	21x+16
INI	S	-	-	?	1	?	?	!	?	16
INIR	S	-	-	?	1	?	?	1	?	21x+16
JP (C)	E	Register	-	?	?	?	?	?	?	13
JP (HL)	S	Register	-	-	-	-	-	-	-	4
JP (IXY)	S	Register	-	-	-	-	-	-	-	8
JP Z/NZ/NC/C/PO/PE/P/M, nn	S	Address	-	-	-	-	-	-	-	10
JP nn	S	Address	-	-	-	-	-	-	-	10
JR C/NC/Z/NZ, nn	S	Immediate	-	-	-	-	-	-	-	12 ; 7 if not cc
JR nn	S	Immediate	-	-	-	-	-	-	-	12
LD (BC/DE), A	S	Indirect	Accumulator	-	-	-	-	-	-	7
LD (HL), n	S	Indirect	Immediate	-	-	-	-	-	-	10
LD (HL),r	S	Indirect	Register	-	-	-	-	-	-	7
LD (IXY+d), n	S	Indexed	Immediate	-	-	-	-	-	-	19
LD (IXY+d),r	S	Indexed	Register	-	-	-	-	-	-	19
LD (nn), A	S	Address	Accumulator	-	-	-	-	-	-	13
LD (nn), BC/DE/SP/IXY	S	Address	Register	-	-	-	-	-	-	20
LD (nn), HL	S	Address	Register	-	-	-	-	-	-	16
LD A, (BC/DE)	S	Accumulator	Indirect	-	-	-	-	-	-	7
LD A, (nn)	S	Accumulator	Address	-	-	-	-	-	-	13
LD A, I	S	Accumulator	Register	-	0	!	0	S	S	9
LD A, R	S	Accumulator	Register	-	0	!	0	S	S	9
LD BC/DE/HL/SP, nn	S	Register	Immediate	-	-	-	-	-	-	10
LD BC/DE/SP/IXY, (nn)	S	Register	Address	-	-	-	-	-	-	20
LD HL, (nn)	S	Register	Address	-	-	-	-	-	-	16
LD I, A	S	Register	Accumulator	-	-	-	-	-	-	9
LD IXY, nn	S	Register	Immediate	-	-	-	-	-	-	14
LD R, A	S	Register	Accumulator	-	-	-	-	-	-	9
LD SP, HL	S	Register	Register	-	-	-	-	-	-	6
LD SP, IXY	S	Register	Register	-	-	-	-	-	-	10
LD r, (HL)	S	Register	Indirect	-	-	-	-	-	-	7
LD r, (IXY+d)	S	Register	Indexed	-	-	-	-	-	-	19
LD r, r'	S	Register	Register	-	-	-	-	-	-	4
LD r,n	S	Register	Immediate	-	-	-	-	-	-	7
LDD	S	-	-	-	0	L	0	-	-	16
LDDR	S	-	-	-	0	0	0	-	-	21x+16
LDDRX	E	-	-	-	-	-	-	-	-	21/16
LDDX	E	-	-	-	-	-	-	-	-	16