Semantic search
Jump to navigation
Jump to search
Query-Depth:1Sep 04, 2022: 18 Wheeler: American Pro Trucker (Nov 12, 2001 prototype) by Laurent Jun 03, 2024: 1992 Winter CES by Sep 13, 2022: 2 Games in 1: The SpongeBob SquarePants Movie / Battle for Bikini Bottom (Nov 10, 2005 prototype) by Forest of Illusion Jun 03, 2024: 2002 World Cup PK (Design Documents) by Maxzhou88 Jun 03, 2024: 2002 World Cup PK (PAL prototype) by Maxzhou88 Oct 25, 2018: 2010 FIFA World Cup South Africa (Feb 10, 2010 German and French prototype) by Jun 03, 2024: 2010 FIFA World Cup South Africa (Feb 10, 2010 Italian and Spanish prototype) by Apr 26, 2008: 2010: The Graphic Action Game (Nov 9, 1984 prototype) by Alex Handy Apr 26, 2008: 2010: The Graphic Action Game (RV44 prototype) by Alex Handy Jun 03, 2024: 2018 Nintendo data breach by Mar 06, 2021: 2097 ROM Pack II by Revenant Jun 03, 2024: 24: The Game (Jan 10, 2006 prototype) by ImJustATester Mar 30, 2020: 25 to Life (Dec 8, 2005 prototype) by CVLT OF OSIRIS Jun 03, 2024: 25 to Life (May 24, 2005 prototype) by Jun 03, 2024: 3 Jigen Kakutou Ballz (Prototype) by Feb 05, 2014: 3-D Genesis (prototype) by Atarimania Nov 26, 2004: 3-D Rubik's Cube (prototype) by AtariAge Dec 01, 2014: 3-D Zapper (Dec 15, 1982 prototype) by Scott Stilphen Dec 01, 2014: 3-D Zapper (prototype 2) by Scott Stilphen Oct 23, 2020: 3D Challenge (Tech Demo) (E3 prototype) by Forest of Illusion Jun 03, 2024: 3D Pinball: Space Cadet (Apr 26, 1995 prototype) by Jun 03, 2024: 3D Pinball: Space Cadet (July 3, 1995 prototype) by MrPinball64 Jun 03, 2024: 3D Pinball: Space Cadet (June 12, 1995 prototype) by Unknown warez scene group Jun 03, 2024: 3D Pinball: Space Cadet (June 16, 1995 prototype) by Gravity Jun 03, 2024: 3D Pinball: Space Cadet (June 27, 1995 prototype) by BetaArchive Jun 03, 2024: 3D Pinball: Space Cadet (May 12, 1995 prototype) by Pirates With Attitudes Jun 03, 2024: 3D Pinball: Space Cadet (May 26, 1995 prototype) by Mindcrash Sep 09, 2020: 3D Pocket Pool (Prototype) by Anonymous Jun 03, 2024: 3D Realms by Jul 08, 2022: 3D Ultra Mini Golf (Mar 17, 2007 prototype) by ObscureGamers Jul 08, 2022: 3D Ultra MiniGolf Adventures 2 (Jul 23, 2010 prototype) by ObscureGamers Jun 03, 2024: 4 in 1 (Feb 19, 1987 prototype) by Jun 03, 2024: 40 Winks (Oct 7, 1999 prototype) by Gorgyrip Jun 03, 2024: 4Chan by Mar 16, 2019: 7 Sins (Sep 29, 2004 prototype) by CVLT OF OSIRIS May 11, 2020: 8 Kings (Aug 7, 2003 prototype) by EskMaemo May 11, 2023: 8 Kings (Jun 5, 2003 prototype) by EskMaemo Nov 18, 2023: 8 Kings (May 9, 2003 prototype) by EskMaemo May 11, 2023: 8 Kings (Nov 18, 2003 prototype) by EskMaemo May 11, 2023: 8 Kings (Oct 23, 2003 prototype) by EskMaemo Jun 03, 2024: 8 in 1 (Nov 16, 1992 prototype) by Feb 06, 2024: 8Ball Allstars (Aug 15, 2008 Pool prototype) by Rob G722 Feb 06, 2024: 8Ball Allstars (Feb 11, 2008 prototype) by Rob G722 Feb 06, 2024: 8Ball Allstars (Feb 26, 2008 prototype) by Rob G722 Oct 18, 1995: 90 Minutes: European Prime Goal (prototype) by ANTHROX, SWAT Jun 03, 2024: ? by Aug 07, 2022: A Boy and His Blob (Jul 21, 2005 prototype) by Gaming Alexandria Aug 07, 2022: A Boy and His Blob (May 16, 2005 prototype) by Gaming Alexandria Oct 31, 2021: A Bug's Life (Nov 18, 1998 prototype) by ObscureGamers Jun 03, 2024: A Die Hard X360 Collector by
Debug output SQLStore
ASK Query
[[:+]] [[Page creator::!Drx]] [[Page creator::!Evilhamwizard]] [[Page creator::!Hidden Palace]] [[Page creator::!Sazpaimon]]
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_object_ids` AS t2
INNER JOIN
(`smw_di_wikipage` AS t3
INNER JOIN
`smw_object_ids` AS t5 ON t3.o_id=t5.smw_id) ON t2.smw_id=t3.s_id
INNER JOIN
(`smw_di_wikipage` AS t6
INNER JOIN
`smw_object_ids` AS t8 ON t6.o_id=t8.smw_id) ON t2.smw_id=t6.s_id
INNER JOIN
(`smw_di_wikipage` AS t9
INNER JOIN
`smw_object_ids` AS t11 ON t9.o_id=t11.smw_id) ON t2.smw_id=t9.s_id
INNER JOIN
(`smw_di_wikipage` AS t12
INNER JOIN
`smw_object_ids` AS t14 ON t12.o_id=t14.smw_id) ON t2.smw_id=t12.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (t3.p_id=4245
AND (t5.smw_sortkey!='Drx')
)
AND (t6.p_id=4245
AND (t8.smw_sortkey!='Evilhamwizard')
)
AND (t9.p_id=4245
AND (t11.smw_sortkey!='Hidden Palace')
)
AND (t12.p_id=4245
AND (t14.smw_sortkey!='Sazpaimon')
))
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
19
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_object_ids` AS t2
INNER JOIN
(`smw_di_wikipage` AS t3
INNER JOIN
`smw_object_ids` AS t5 ON t3.o_id=t5.smw_id) ON t2.smw_id=t3.s_id
INNER JOIN
(`smw_di_wikipage` AS t6
INNER JOIN
`smw_object_ids` AS t8 ON t6.o_id=t8.smw_id) ON t2.smw_id=t6.s_id
INNER JOIN
(`smw_di_wikipage` AS t9
INNER JOIN
`smw_object_ids` AS t11 ON t9.o_id=t11.smw_id) ON t2.smw_id=t9.s_id
INNER JOIN
(`smw_di_wikipage` AS t12
INNER JOIN
`smw_object_ids` AS t14 ON t12.o_id=t14.smw_id) ON t2.smw_id=t12.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (t3.p_id=4245
AND (t5.smw_sortkey!='Drx')
)
AND (t6.p_id=4245
AND (t8.smw_sortkey!='Evilhamwizard')
)
AND (t9.p_id=4245
AND (t11.smw_sortkey!='Hidden Palace')
)
AND (t12.p_id=4245
AND (t14.smw_sortkey!='Sazpaimon')
))
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
19
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 4 | const | 50517 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t6 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t9 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t12 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t8 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | hp_wiki_new.t6.o_id | 1 | Using where | |
1 | SIMPLE | t11 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | hp_wiki_new.t9.o_id | 1 | Using where | |
1 | SIMPLE | t14 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | hp_wiki_new.t12.o_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t5 | ref | PRIMARY, smw_id, smw_sortkey | smw_id | 4 | hp_wiki_new.t3.o_id | 1 | Using where; Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:9Query-Depth:1
Errors and Warnings
None