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
55
OFFSET
100
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
55
OFFSET
100
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 Crystal (Mar 28, 2001 18:06 prototype) | Game Boy | Anonymous | 28 March 2001 18:06:00 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Mar 6, 2001 prototype) | Game Boy | Anonymous | 6 March 2001 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Mar 7, 2001 prototype) | Game Boy | Anonymous | 7 March 2001 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Mar 8, 2001 prototype) | Game Boy | Anonymous | 8 March 2001 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Mar 9, 2001 prototype) | Game Boy | Anonymous | 9 March 2001 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 14, 2000 08:08 prototype) | Game Boy | Anonymous | 14 November 2000 08:08:00 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 14, 2000 20:08 prototype) | Game Boy | Anonymous | 14 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 15, 2000 prototype) | Game Boy | Anonymous | 15 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 16, 2000 prototype) | Game Boy | Anonymous | 16 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 20, 2000 prototype) | Game Boy | Anonymous | 20 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 21, 2000 prototype) | Game Boy | Anonymous | 21 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 28, 2000 prototype) | Game Boy | Anonymous | 28 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Crystal (Nov 29, 2000 prototype) | Game Boy | Anonymous | 29 November 2000 | JP Oct 17, 2000 US Apr 5, 2001 DE Jul 3, 2001 AUS Jul 10, 2001 FR Jul 31, 2001 ES Aug 24, 2001 IT Sep 4, 2001 | JP Dec 14, 2000 US Jul 29, 2001 AUS Sep 30, 2001 EU Nov 2, 2001 | |
Pokémon Diamond & Pearl (Aug 13, 2006 prototype) | Nintendo DS | Anonymous | 13 August 2006 15:29:52 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Aug 16, 2006 prototype) | Nintendo DS | Anonymous | 16 August 2006 14:05:52 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Aug 7, 2006 prototype) | Nintendo DS | Anonymous | 7 August 2006 15:29:52 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Aug 9, 2006 prototype) | Nintendo DS | Anonymous | 9 August 2006 18:20:02 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Dec 12, 2006 prototype) | Nintendo DS | Anonymous | 12 December 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Dec 8, 2006 prototype) | Nintendo DS | Anonymous | 8 December 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Feb 17, 2006 prototype) | Nintendo DS | Anonymous | 17 February 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Jul 13, 2006 prototype) | Nintendo DS | Anonymous | 13 July 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Jul 9, 2006 prototype) | Nintendo DS | Anonymous | 9 July 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Jun 23, 2006 prototype) | Nintendo DS | Anonymous | 23 June 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Jun 30, 2006 prototype) | Nintendo DS | Anonymous | 30 June 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Mar 17, 2006 prototype) | Nintendo DS | Anonymous | 17 March 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Mar 31, 2006 prototype) | Nintendo DS | Anonymous | 31 March 2006 | 24 July 2020 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Nov 14, 2006 prototype) | Nintendo DS | Anonymous | 14 November 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Nov 15, 2006 prototype) | Nintendo DS | Anonymous | 15 November 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Nov 20, 2006 prototype) | Nintendo DS | Anonymous | 20 November 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Nov 21, 2006 prototype) | Nintendo DS | Anonymous | 21 November 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Nov 24, 2006 prototype) | Nintendo DS | Anonymous | 24 November 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Nov 27, 2006 prototype) | Nintendo DS | Anonymous | 27 November 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Oct 31, 2006 11:27 prototype) | Nintendo DS | Anonymous | 31 October 2006 11:27:30 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Oct 31, 2006 17:23 prototype) | Nintendo DS | Anonymous | 31 October 2006 17:23:18 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Diamond & Pearl (Oct 5, 2006 prototype) | Nintendo DS | Anonymous | 5 October 2006 | 20 July 2021 | JP Aug 16, 2006 US Mar 15, 2007 UK May 10, 2007 EU Jun 4, 2007 KR Dec 18, 2007 | JP Sep 28, 2006 US Apr 22, 2007 AU Jun 21, 2007 EU Jul 27, 2007 KR Feb 14, 2008 |
Pokémon Fushigi DS (Oct 6, 2006 prototype) | Nintendo DS | Anonymous | 6 October 2006 | 20 July 2021 | ||
Pokémon Gold & Silver (Apr 24, 2000 prototype) | Game Boy | Anonymous | 24 April 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 (Apr 25, 2000 15:03 prototype) | Game Boy | Anonymous | 25 April 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 (Apr 25, 2000 23:17 prototype) | Game Boy | Anonymous | 25 April 2000 23:17:45 | 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 (Apr 26, 2000 prototype) | Game Boy | Anonymous | 26 April 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 (Apr 27, 2000 prototype) | Game Boy | Anonymous | 27 April 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 (Apr 28, 2000 prototype) | Game Boy | Anonymous | 28 April 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 (Dec 1, 2000 prototype) | Game Boy | Anonymous | 1 December 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 (Dec 11, 2000 prototype) | Game Boy | Anonymous | 11 December 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 (Dec 12, 2000 18:46 prototype) | Game Boy | Anonymous | 12 December 2000 18:41:06 | 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 (Dec 12, 2000 19:24 prototype) | Game Boy | Anonymous | 12 December 2000 19:24:00 | 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 (Dec 13, 2000 prototype) | Game Boy | Anonymous | 13 December 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 (Dec 14, 2000 prototype) | Game Boy | Anonymous | 14 December 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 (Dec 15, 2000 prototype) | Game Boy | Anonymous | 15 December 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 (Dec 18, 2000 13:03 prototype) | Game Boy | Anonymous | 18 December 2000 13:03:46 | 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 |