Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Page creator::User:Automatic category creator]]
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=4245 AND t1.o_id=85191)
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
30
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=4245 AND t1.o_id=85191)
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
30
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 | 2791 | 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
None- A Boy and His Blob prototypes
- A Bug's Life assets
- A Bug's Life prototypes
- A Kingdom for Keflings prototypes
- A World of Keflings prototypes
- A-Team prototypes
- A.J.'s World of Discovery prototypes
- A.S.P. Air Strike Patrol prototypes
- AMF Bowling prototypes
- ATV 3: Lawless prototypes
- Aardman Intro (Tech Demo) prototypes
- Aardman Intro prototypes
- Abomination: The Nemesis Project prototypes
- Absolute X prototypes
- Accidentally included with the game's DLC, released in 2011 lot prototypes
- Ace Combat 6: Fires of Liberation prototypes
- Ace Combat Advance prototypes
- Ace Combat Assault Horizon prototypes
- Ace Combat: Assault Horizon prototypes
- Aces of the Galaxy prototypes
- Actionauts prototypes
- Active Life: Explorer prototypes
- Active Life: Magical Carnival prototypes
- Adian no Tsue prototypes
- Advanced Dungeons & Dragons: Heroes of the Lance prototypes
- Advanced Dungeons & Dragons: Hillsfar prototypes
- Advent Rising prototypes
- Adventure Island II prototypes
- Adventure Time: Hey Ice King! Why’d you steal our garbage?!! prototypes
- Adventures of Dr. Franken prototypes
- Adventures to Go! prototypes
- Aegis Wing prototypes
- Aero the Acro-Bat prototypes
- Aero-Cross prototypes
- AeroWings 2: Airstrike assets
- Afro Samurai prototypes
- After Burner Climax prototypes
- Age of Booty prototypes
- Age of Empires 2 - Age of Kings prototypes
- Age of Empires prototypes
- Age of Empires: The Rise of Rome prototypes
- Air Sea Battle prototypes
- Air Zonk prototypes
- AirForce Delta prototypes
- AirMech Arena prototypes
- Airburst prototypes
- Airlock prototypes
- Akuji: The Heartless prototypes
- Aladdin in Nasira's Revenge assets
- Alan Wake prototypes