Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has objectClass::Event]] [[Start::≥2014]] [[Start::<<2015]] OR [[Has objectClass::Event]] [[Start::<<2014]] [[End::≥2014]]
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 | 116 | 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 t3.s_id FROM `mw_smw_di_wikipage` AS t3 INNER JOIN `mw_smw_di_time` AS t6 ON t3.s_id=t6.s_id INNER JOIN `mw_smw_di_time` AS t8 ON t3.s_id=t8.s_id WHERE t3.p_id='2398166' AND t3.o_id='2087' AND ((t6.o_sortkey>='2456658.5') AND t6.p_id='2398177') AND ((t8.o_sortkey<'2457023.5') AND t8.p_id='2398177')
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t11.s_id FROM `mw_smw_di_wikipage` AS t11 INNER JOIN `mw_smw_di_time` AS t14 ON t11.s_id=t14.s_id INNER JOIN `mw_smw_di_time` AS t16 ON t11.s_id=t16.s_id WHERE t11.p_id='2398166' AND t11.o_id='2087' AND ((t14.o_sortkey<'2456658.5') AND t14.p_id='2398177') AND ((t16.o_sortkey>='2456658.5') AND t16.p_id='2398181')
Query Metrics
Query-Size:12Query-Depth:1
Errors and Warnings
None| Event |
|---|
| Gamergate controversy |
| Gaza War 2014 |
| Hedges v. Obama |
| Igor Kolomoisky/Threat |
| International Criminal Tribunal for Rwanda |
| Iraq Inquiry |
| Joe Biden/Pledges support for Yatsenyuk |
| Julian Assange/Imprisonment |
| Junta admits NAF gains |
| Kiev Junta announces ATO |
| Kiev in breach of UNSCR 2166 |
| Kiev pulling back |
| Kiev says shot down |
| Kiev suspends crash-site truce |
| Kiev to resume truce if asked |
| Lavrov on Kiev ATC tapes |
| Lavrov pushes disclosure again |
| Le Cercle/2014 (London) |
| Malay team at crash site 2nd visit |
| Malaysia Airlines Flight 17 |
| Malaysia Airlines Flight 17/ATC lost contact confirmed |
| Malaysia Airlines Flight 17/Black-boxes/Arrival in UK |
| Malaysia Airlines Flight 17/Criminal Investigation |
| Malaysia Airlines Flight 17/First altitude change |
| Malaysia Airlines Flight 17/First reports of crash |
| Malaysia Airlines Flight 17/Investigation/Censorship agreement |
| Malaysia Airlines Flight 17/Last ADS-B contact |
| Malaysia Airlines Flight 17/Leaves departure gate |
| Malaysia Airlines Flight 17/Russia's questions to Ukraine |
| Malaysia Airlines Flight 17/Takeoff |
| Malaysia Airlines Flight 370 |
| Malaysia wants ATC tapes |
| Massacre in Odessa |
| Mil SitRep for MH17 area |
| Munich Security Conference/2014 |
| NATO suspends co-operation with Russia |
| Obama warns Yanukovitch |
| Poroshenko dissolves parliament |
| Poroshenko inauguration |
| Prosecution Report 12 Sep |
| Putin as bad as Stalin? |
| Putin visits Crimea |
| RUE MH17 report |
| Report of Junta using civilian planes as cover |
| Russian ATA questions |
| Russian embassy attack |
| Russian military info revealed |
| SBU siezes Ukraine ATC tapes |
| Saleh v. Bush |
| Scottish Referendum |
