Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::City]]OR[[Has posting::City]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_t1` AS t1 ON t0.smw_id=t1.id
WHERE
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 | ALL | PRIMARY | 123 | Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t2.s_id FROM `mw_smw_di_wikipage` AS t2 WHERE t2.p_id='654' AND t2.o_id='832196'
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t5.s_id FROM `mw_smw_di_wikipage` AS t5 WHERE t5.p_id='1464816' AND t5.o_id='832196'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NonePage name | Location | Description |
---|---|---|
Islamabad | ||
Istanbul | Turkey's economic, cultural and historic center and a world metropolis | |
Jakarta | ||
Jerusalem | Bombed to the ground 2 times, besieged 23 times, captured by force 44 times and attacked 6 other times as well, Jerusalem surely proves there's no accounting for taste. | |
Johannesburg | ||
Kiev | Capital city of Ukraine | |
Kursk | ||
Leeds | Industrial power house during the British Empire. Nowadays not so much. | |
Lisbon | The capital of Portugal | |
Liverpool | ||
Liège | East Belgian city notorious for peculiar events since the 1980s. Just bad luck? | |
London | Capital city of the UK | |
Los Angeles | ||
Luxembourg City | ||
Maastricht | Dutch city wedged between Germany and Belgium | |
Madrid | Capital city of Spain | |
Manchester | ||
Mariupol | ||
Marseilles | ||
Melbourne | ||
Mexico City | ||
Miami | ||
Milan | ||
Montreal | Historically the commercial capital of Canada | |
Moscow | ||
Munich | Germany Bavaria | |
Muscat | The capital of the British puppet state of Oman. | |
Nairobi | ||
Nashville | Capital city of Tennessee | |
New Orleans | Socio-Ethnically cleansed after 2005 Hurricane Katrina. | |
New York | Very large American city. Location of 9-11. Has the largest Jewish population of any city in the world. | |
Nice | France | |
Odessa | ||
Oklahoma | ||
Oslo | ||
Ottawa | ||
Paris | The city of romance has faced a lot of hate apparently from jihadist "terrorists" in the 2000s | |
Philadelphia | ||
Phoenix | Capital and most populous city in the American state of Arizona | |
Prague | Capital of the Czech republic | |
Rafah | Palestine Southern Gaza Strip | |
Ramallah | ||
Rome | ||
Rotterdam | Dutch Industrial capital, cocaine drug kingpins during World War 1, bombed in World War 2, police running drug cartels from port since Dutch PMs became Bilderberg visitors - which was biggest port in the world for over 40 years. | |
Saint Petersburg | Second largest city in Russia | |
Salzburg | ||
San Diego | City in Southern California with large military presence. | |
San Francisco | US California | |
Saratoga Springs | Resort in upstate New York State, half-way to Canada. Significant deep state organized crime activities. | |
Seoul |