Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Has origin lot::2018 Nintendo data breach]]
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=4757 AND t1.o_id=96693)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
200
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=4757 AND t1.o_id=96693)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
200
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | const | 322 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | hp_wiki_new.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneSystem | Released by | Build date | File release date | Final build date | Retail release date | |
---|---|---|---|---|---|---|
Pokémon Gold & Silver (Jun 8, 2000 prototype) | Game Boy | Anonymous | 8 June 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (Jun 9, 2000 16:24 prototype) | Game Boy | Anonymous | 8 June 2000 16:24:54 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (Jun 9, 2000 22:32 prototype) | Game Boy | Anonymous | 8 June 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 1, 2000 prototype) | Game Boy | Anonymous | 1 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 10, 2000 prototype) | Game Boy | Anonymous | 10 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 12, 2000 prototype) | Game Boy | Anonymous | 12 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 15, 2000 prototype) | Game Boy | Anonymous | 15 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 16, 2000 prototype) | Game Boy | Anonymous | 16 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 18, 2000 prototype) | Game Boy | Anonymous | 18 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 19, 2000 prototype) | Game Boy | Anonymous | 19 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 2, 2000 prototype) | Game Boy | Anonymous | 2 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 23, 2000 prototype) | Game Boy | Anonymous | 23 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 24, 2000 prototype) | Game Boy | Anonymous | 24 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 26, 2000 prototype) | Game Boy | Anonymous | 26 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 29, 2000 prototype) | Game Boy | Anonymous | 29 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 31, 2000 prototype) | Game Boy | Anonymous | 31 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (May 9, 2000 prototype) | Game Boy | Anonymous | 9 May 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (Nov 10, 2000 prototype) | Game Boy | Anonymous | 10 November 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (Nov 13, 2000 prototype) | Game Boy | Anonymous | 13 November 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 | |
Pokémon Gold & Silver (Nov 14, 2000 prototype) | Game Boy | Anonymous | 14 November 2000 | JP Oct 17, 1999 US Jul 7, 2000 FR Dec 19, 2000 DE Jan 9, 2001 IT Jan 30, 2001 ES Feb 7, 2001 KR Dec 29, 2001 | JP Nov 21, 1999 AUS Oct 13, 2000 US Oct 13, 2000 EU Apr 6, 2001 KR Apr 24, 2002 |