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
0
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 120 | 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 |
---|---|---|
Aachen | Symbolic city for the European Union, venue for 1980 Bilderberg. | |
Abu Dhabi | Capital city of United Arab Emirates. | |
Amman | Capital and main city of Jordan. | |
Amsterdam | Cocaine distributor to all sides in World War 1. Led the European illegal drug trade from the 1970s. | |
Ankara | Capital of Turkey | |
Antwerp | Large port and oil refinery city, world center for the diamond trade. | |
Athens | Capital and largest city of Greece. | |
Baghdad | ||
Baltimore | ||
Bangkok | The capital city of Thailand. | |
Barcelona | Part of Spain and capital of Catalonia. The Spanish deep state is trying to block independence attempts. | |
Basel | Swiss home to the BIS | |
Beijing | The capital of China. | |
Beirut | ||
Belfast | ||
Benghazi | ||
Berlin | Capital of Germany. | |
Bogotá | Capital of Colombia | |
Bonn | Before Germany was re-united, this was the capital city of West Germany | |
Boston | Capital and most populous city in Massachusetts, USA. | |
Brussels | Belgian capital, usually plays host to the Brussels Forum | |
Bucharest | Economic and political capital of Romania | |
Budapest | ||
Buenos Aires | Political, cultural and economic capital of Argentina. | |
Buffalo | ||
Cairo | The capital of Egypt | |
Cannes | ||
Cape Town | ||
Copenhagen | The capital of Denmark | |
Dallas | City in Texas forever linked to the assassination of JFK in 1963. | |
Deir al-Zor | City in eastern Syria, scene of a 2018 US/NATO airstrike to aid jihadist rebels besieging it. | |
Delhi | ||
Detroit | A city in which car ownership is reportedly risky. | |
Dresden | ||
Dubai | Has been ruled by the Al Maktoum family since 1833 | |
Dublin | Capital and largest city of the Republic of Ireland | |
East Jerusalem | ||
Edinburgh | Seventh most populous city in the UK and Capital of Scotland. | |
Florence | Has had the same wealthiest families for 600 years | |
Fort Hood | The most populous U.S. military installation in the world, the number and particularly the type of crimes reported in and around the facility is suspicious and has the hallmarks of either a black site or quite a chaotic base. | |
Frankfurt | Frankfurt is one of the major financial centers of the European continent. | |
Gaza | An enclave of Palestine in the south west corner of Israel | |
Geneva | ||
Glasgow | ||
Hamburg | North German city with deep state connections. | |
Hanoi | ||
Havana | ||
Helsinki | Capital and main city in Finland. | |
Hilversum | Small city. Location of the murder of Pim Fortuyn and a hijacking of the NOS-building. HQ of most Dutch TV-broadcasters. | |
Houston | Most populous city in Texas, fourth-most populous city in the United States. |