Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::Report]]OR[[Has posting::Report]]
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 | 195 | 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='2398240'
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='2398240'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NonePage name | Description |
---|---|
Document:UK Intelligence And Security Report, 2003 | A compendious summary of the UK Intelligence And Security agencies, including people, events and places. |
Document:UN expert says "collective persecution" of Julian Assange must end now | “In 20 years of work with victims of war, violence and political persecution I have never seen a group of democratic States ganging up to deliberately isolate, demonise and abuse a single individual for such a long time and with so little regard for human dignity and the rule of law,” Professor Melzer said. “The collective persecution of Julian Assange must end here and now!" |
Document:Why Isn’t Everyone In Favour of Taxing Financial Speculation? | Bernie Sanders wants to tax stock trades at a rate of 0.5 percent (a trade of $1,000 would cost $5), and bond trades at 0.1 percent. The tax would reduce incentives for high-speed trading, insider deal-making, and short-term financial betting. Sanders’ 0.5 percent tax could thereby finance public investments that enlarge the economic pie rather than merely rearrange its slices – like tuition-free public education. |
Dodgy Dossier | A concoction of lies which successfully eased the UK public's reluctance to enter the Iraq War - notwithstanding its exposure as lied by David Kelly. |
File:02 08 07 ipcc stockwell.pdf | Stockwell two, the second report into the handling and dissemination of information by the Metropolitan Police Service to the Press, following the killing of Jean Charles de Menezes. |
File:2005 03 01 PUB Intelligence and Security Committee Report.pdf | |
File:2010 07 14 PUB Binyam Mohamed Civil Case - Claimaints Skeleton Argument.pdf | |
File:2010 07 15 PUB Binyam Mohamed Civil Case- Exhibit LC6.pdf | |
File:2010 07 15 PUB Binyam Mohamed Civil Case- Exhibit LC7.pdf | |
File:9-11-9 the Vicsim Report.pdf | A report alleging inconsistencies, repetitions and photo-fakery of much of the reporting and memorial sites for the victims of the 9/11 attacks. |
File:A Global Chronology of Incidents of Chemical, Biological, Radioactive and Nuclear Attacks 1950-2005.pdf | A summary of Chemical, Biological, Radioactive and Nuclear Attacks, from 1950 - 2005, giving the number of injuries and fatalities, and other information (if known) on the perpetrators and motives. |
File:A Tale of Three Atrocities.pdf | The report suggests that three ostensibly unconnected flight sabotages may in fact be connected. The main focus is the Pan American Airlines Flight 103, downed over Lockerbie in December 1988. It suggested that the CIA facilitated the Lockerbie atrocity by Iranian operatives as a quid-pro-quo for the downing of the Iranian airliner some 5 months earlier. |
File:A case to answer.pdf | An Amnesty International report on the 40 month long detention and rendition of Khaled al-Maqtari, a 25 year old Saudi national at the time of his arrest in Fallujah, Iraq in January 2004. |
File:A-Z ClimateRealityCheck.pdf | This Climate Depot special report categorizes and indexes the full range of climate developments in a handy A-Z reference guide. The A-Z report includes key facts, peer-reviewed studies and the latest data and developments with links for further reading, on an exhaustive range of man-made global warming claims. |
File:A.HRC.14.24.Add6.pdf | The UN Special Rapporteur reports on "targeted killings" by states. |
File:AdamMinetaClarkePaper.pdf | Norman Mineta and Richard Clarke Contradict the 9/11 Commission Report |
File:Alison Chabloz appeal adjourned - re-arrested on leaving court.pdf | First person summary of an appeal against conviction hearing in Derby Crown Court on Friday 10 January 2020, together with the re-arrest and questioning of the defendant on leaving court following the hearing adjournment |
File:Anonymous-Operation Want.pdf | A report into the finances of the Wallenberg family as they relate to a proposal to create an additional seat on the NASDAQ OMX Group Board of Directors which is currently (2 April 2011) awaiting SEC approval. |
File:Armyvisitstoschools.pdf | A report about the recruiting activities and practices of the British army in the nations schools. It shows that emphasis is placed on schools in disadvantaged areas and discusses the reasons for this |
File:Baxterinternationalinc investigation pharmafraud 2011.pdf | 'Pharma-watch' report of their investigation into the ethical and business practices of pharmaceuticals company Baxter International |
File:Bilderberg-Conference-Report-1961.pdf | A summary of the 1961 Bilderberg meeting that took place from 21 April 1961 - 23 April 1961 at St-Castin, Quebec, Canada |
File:Bilderberg-history-1956.pdf | |
File:Bilderberg-meeting-report-1957.pdf | |
File:Bilderberg-meeting-report-1958.pdf | A summary of the 1958 Bilderberg meeting that took place from September 18-20 at the Çinar Hotel in Yeşilköy, Istanbul, Turkey. |
File:Bilderberg-meeting-report-1962.pdf | A summary of the 1962 Bilderberg meeting in Saltsjöbaden, Sweden. |
File:Bilderberg-meetings-report-1955.pdf | A summary of the 1955 Bilderberg meeting that took place from September 23-25 at the Grand Hotel Sonnenbichl in Garmisch-Partenkirchen, West Germany. |
File:Bilderberg-meetings-report-1958.pdf | A summary of the 1958 Bilderberg meeting that took place from 13-15 September 1958 in Buxton, England |
File:Bilderberg-meetings-report-1960.pdf | A summary of the 1960 Bilderberg meeting that took place from May 28-29 at the Palace Hotel in Bürgenstock, Nidwalden, Switzerland. |
File:Bilderberg-meetings-report-1963.pdf | A summary of the 1963 Bilderberg meeting that took place from May 29-31 in Cannes, France. |
File:Bilderberg-meetings-report-1980.pdf | A summary of the 1980 Bilderberg meeting that took place from April 18-20 at the Dorint Sofitel Quellenhof in Aachen, Germany. |
File:Birth Defects In Iraq.pdf | |
File:Bitcoin-FBI.pdf | |
File:Bloody Vengeance in Sirte.pdf | A harrowing report on the final days of Muammar Gaddafi, notable less for its background analysis of the 2011 NATO sponsored Libyan conflict, or its recommendations which are standard fare but pointedly fail to even mention Foreign/NATO culpability which is assumed to have been legitimate, but rather for an authoritative account of just one small instance of the raw barbarity which NATO played such a major part in enabling - under the banner of 'Humanitarian Intervention'. |
File:British Bases in Cyprus and Signals Intelligence.pdf | |
File:CIA Shannon Report 9 2 09.pdf | |
File:Cannabis comparative risk assessment.pdf | Comparative risk assessment of alcohol, tobacco, cannabis and other illicit drugs using the margin of exposure approach |
File:Carter-Ruck Syria Report.pdf | A text-book example of the how and why of demonising one's enemies. A widely reported shock-horror document is 'leaked' just prior to a conference, the outcome of which is regarded as crucial to Western global policy interests. |
File:Children in Military Custody.pdf | |
File:Church Committee - Congo.pdf | An investigation into CIA involvement in the murder of Patrice Lumumba. |
File:Containment of Soviet underground nuclear explosions.pdf | |
File:CoryBreenBuchanan.pdf | |
File:CoryFinucane.pdf | |
File:CoryGibson.pdf | |
File:CoryHamill.pdf | |
File:CoryNelson.pdf | |
File:CoryWright.pdf | |
File:Council of Europe Kosovo Report.pdf | |
File:Critical Technology Assessment.pdf | US Institute for Defense Analysis assessment of the technologies of Israel and NATO nations - including nuclear weapons capailities. Declassified in March 2015 with all but the Israeli sections remaining redacted. |
File:DIA-287.pdf | A declassified DIA document which clearly demonstrates that the rise of ISIS in the Middle East was planned and facilitated by the US Government - as later admitted by DIA director Michael T. Flynn. |
File:Damage.pdf | Investigation into media treatment of the inquest into the killing of three IRA members in Gibraltar on 6 March 1988 |