Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has author::+]]
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='2398297')
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2398297')
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,s_id_3 | p_id | 4 | const | 5133 | 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
NonePage name | Has author |
---|---|
Document:Crown Agents | Dean Andromidas |
Document:Cruel Britannia - A Secret History of Torture | Nicholas Mercer |
Document:Cryptome’s searing critique of Snowden Inc | Tim Shorrock |
Document:CyberGuardian Cyber Security Education Programme for Children and Young People | Integrity Initiative |
Document:DEFUSE project funding rejection letter | DARPA |
Document:DK15 2016 The Institute for Statecraft PC | Integrity Initiative Political Capital Kfr |
Document:DK6 2016 PC The Institute for Statecraft | Integrity Initiative Political Capital Kfr |
Document:DR Congo - The Heart of Western Darkness | Asad Ismi |
Document:Dag Hammarskjöld - US, UK and South Africa still withholding crucial information | Ludwig De Braeckeleer |
Document:Dag Hammarskjöld's plane may have been shot down, ambassador warned | Julian Borger |
Document:Daily NATO War Crimes in Libya | Stephen Lendman |
Document:David Cameron in the Knesset. March 2014 | Francis Carr Begbie |
Document:David Cameron's 'counter extremism' experts work with far-right Donald Trump sympathisers | Nafeez Mosaddeq Ahmed |
Document:David Cameron's Jewish roots | Martin Iqbal |
Document:David Irving and the Aktion Reinhardt Camps | Jürgen Graf |
Document:David Kelly Post-Mortem Report | N. C. A. Hunt |
Document:De Beers to abandon cartel | Dan Atkinson |
Document:Deagel forecasts - explanation, thoughts and reflections | Deagel |
Document:Deagel forecasts - updated disclaimer September 2020 | Deagel |
Document:Deal or No Deal, Iran's Stock Keeps Rising | Sharmine Narwani |
Document:Dear Tom, about this Trotsky thing….. | Jeff Goulding |
Document:Death Wish 2023 | Craig Murray |
Document:December 2016 Papal Letter | Cardinal Raymond Burke Jorge Mario Bergoglio |
Document:Deception and distraction strategies relating to the John F Kennedy Assassination | Garrick Alder |
Document:Declaration of the Latvian Antiglobalists | 'The Latvian AntiGlobalists' |
Document:Decoding Edward Jay Epstein's 'LEGEND' | Robin Ramsay |
Document:Deconstructing Nuclear Experts | Chris Busby |
Document:Defend Freedom of Expression – Support Mark Hirst | Tommy Sheridan |
Document:Defending the UN Charter by Use of the Veto | Ronda Hauben |
Document:Democratic State v Deep State | Ola Tunander |
Document:Depopulation of the Chagos Islands 1965-73 | Mark Curtis |
Document:Depravity Redefined - Selling US Slaughter in Syria | 'Tony Cartalucci' |
Document:Destroying Syria | Philip Giraldi |
Document:Determined on war - questions neither Bush nor Blair would answer | Tony Benn |
Document:Diane Abbott – 2019 Speech on Julian Assange | Diane Abbott |
Document:Did Canadian taxpayers foot Islamic State’s recruitment bill | Tony Gosling |
Document:Did Corbyn leak the Labour GE2017 manifesto | SKWAWKBOX |
Document:Did German bungling lead to Pan Am 103? | Gavin Hewitt |
Document:Did POLICE turn Bristol ‘Kill the Bill’ protest into a riot? | Mike Sivier |
Document:Did SA spies bomb UN boss’ plane? | De Wet Potgieter |
Document:Did the White House Help Plan the Syrian Chemical Attack | Yossef Bodansky |
Document:Dikgang Moseneke to join bench of judges in Israel-Hamas world court case | Kgaugelo Masweneng |
Document:Dimitri Khalezov Interview | Daniel Estulin Dimitri Khalezov |
Document:Diplomatic Protection, the case of Nazanin Zaghari-Ratcliffe | Oliver Miles |
Document:Discernment: Why information statecraft matters | Integrity Initiative Chris Donnelly |
Document:Discussion with Artur Gherman re the situation in Moldova, 28 01 2017 | Integrity Initiative |
Document:Dishonesty and the Science-Policy Interface | Chris Busby |
Document:Dissident British ex-diplomat Craig Murray indicted for blog posts in Kafkaesque case | Ben Norton |
Document:Domestic Covert Ops for Socialists and Progressives | Michael B. Green |
Document:Domestic Determinants of Russia’s anti-Western Campaign | Hannes Adomeit |