Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has objectClass::+]]
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_smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2398166')
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
750
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_smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2398166')
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
750
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ref | s_id,p_id,s_id_2,s_id_3 | p_id | 4 | const | 73056 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:1
Errors and Warnings
None| Page name | Has objectClass |
|---|---|
| 2011 Tucson shooting | Event |
| 2012 | Year |
| 2012 Benghazi attack | Event |
| 2013 | Year |
| 2013 Volgograd bombings | Event |
| 2014 | Year |
| 2014 Australia turboprop drug bust | Event |
| 2014 Clacton by-election | Event |
| 2014 Kunming Attack | Event |
| 2014 Norway terror threat | Event |
| 2014 Ukraine coup | Event |
| 2014 Ukraine coup#_7f64388f03bd81ccb8e4601c9031bebd | Quotation |
| 2014 Ukraine coup/ATO map 16 JUL 2014 | Event |
| 2014 Ukraine coup/Civil war | Event |
| 2014 Ukraine coup/Cultural genocide | Event |
| 2014 Ukraine coup/Forged antisemitic leaflets | Event |
| 2014 Ukraine coup/Geneva agreement | Event |
| 2014 Ukraine coup/Maidan snipers | Group |
| 2014 Ukraine coup/Odessa massacre | Event |
| 2014 Winter Olympics | Event |
| 2015 | Year |
| 2015 Bangkok bomb | Event |
| 2015 European refugee crisis | Event |
| 2015 Hawija bombing | Event |
| 2015 Russian Sukhoi Su-24 shootdown | Event |
| 2015 Sousse attacks | Event |
| 2015-11 Paris attacks | Event |
| 2016 | Year |
| 2016 Batley and Spen by-election | Event |
| 2016 Berlin attack | Event |
| 2016 Brussels Bombing | Event |
| 2016 Brussels Bombing/Media manipulation | Event |
| 2016 EU Referendum | Event |
| 2016 Hurriyah car bombing hoax | Event |
| 2016 Investigatory Powers Act | Concept |
| 2016 Investigatory Powers Act#_cf97b4793c06c07b16c99a537f26af84 | Quotation |
| 2016 Istanbul airport attack | Event |
| 2016 London mayoral election | Event |
| 2016 Magnanville stabbing | Event |
| 2016 Munich shooting | Event |
| 2016 Orlando nightclub shooting | Event |
| 2016 Richmond Park by-election | Event |
| 2016 Saumur Daesh Cell | Event |
| 2016 Sleaford by-election | Event |
| 2016 St Paul's by-election | Event |
| 2016 Turkish coup d'état attempt | Event |
| 2017 | Year |
| 2017 Barcelona attacks | Event |
| 2017 Copeland by-election | Event |
| 2017 Frinton by-election | Event |
