Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Display image::+]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='168316')
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
1000
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='168316')
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
1000
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 | p_id | 4 | const | 51836 | 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 | Display image |
|---|---|
| Dean Acheson | File:Dean Acheson.jpg |
| Achille Lauro hijacking | File:Achille39.jpg |
| Theodore Achilles | File:Theodor achilles.png |
| Tendayi Achiume | File:Tendayi Achiume.jpg |
| Ann-Kristin Achleitner | File:Ann-Kristin and Paul Achleitner.jpeg |
| Paul Achleitner | File:Paul Achleitner.jpg |
| Achnacarry Agreement | File:Achnacarry Castle—Scotland.jpg |
| Josef Ackermann | File:Josef Ackermann.jpg |
| Ackworth School | Image:Ackworth School.png |
| Antony Acland | File:Garter robe Sir Antony Acland.jpg |
| Alexander Acosta | File:Alexander Acosta.jpg |
| Action Committee for the United States of Europe | File:Group.png |
| Action Council for Peace in the Balkans | File:Group.png |
| Action Counters Terrorism | File:ACT-Blue.png |
| Active Change Foundation | File:Group.png |
| Active Change Foundation/CEO | File:Hanif Qadir.jpg |
| Active Change Foundation/Director | File:Chris Donnelly.jpg |
| Active Measures Working Group | File:Group.png |
| Activist | File:Activist.png |
| Activist Post | File:Activist Post.jpg |
| Activist Teacher Blog | File:Website.png |
| Activity | File:Concept.png |
| Actor | File:Actor.svg |
| Ad hominem | File:Concept.png |
| Allan Adair | File:Person.png |
| Adam Smith International | File:Adam_Smith_International.png |
| Valdas Adamkus | File:Valdas Adamkus.jpg |
| Gerry Adams | File:Gerry_Adams.jpg |
| Iris Adams | File:Iris Adams.png |
| James Adams | File:James B. Adams.jpg |
| Jerome Adams | File:Jerome Adams 2019.jpg |
| John Bodkin Adams | File:John Bodkin Adams.jpg |
| John Adams | File:Person.png |
| Mike Adams | File:Mike Adams.jpg |
| Sherman Adams | File:GLSAAdams.jpg |
| Stanley Adams | File:Stanley Adams Roche.png |
| Clara Leach Adams-Ender | File:Person.png |
| Gautam Adani | File:Person.png |
| Adbusters | Image:Adbusters.jpg |
| Addict | File:screen addiction.jpg |
| David Addington | File:David Addington.jpg |
| Adelaide Club | File:Adelaide Club.JPG |
| Adelaide Establishment | File:Adelaide Club.JPG |
| Adelaide University | Image:University-of-Adelaide-Crest.png |
| Kenneth Adelman | File:Ken_Adelman.jpg |
| Adelphi University | Image:Adelphi University Seal.svg |
| Sheldon Adelson | File:Sheldon_Adelson.jpg |
| Konrad Adenauer | File:Konrad Adenauer.jpg |
| Debo Adesina | File:Person.png |
| Adessium Foundation | File:Group.png |
