Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::Deep state functionary]]OR[[Has posting::Deep state functionary]]
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
0
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 280 | 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='225695'
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='225695'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None Page name | Type | Date | Author(s) | Subject(s) | Description |
---|---|---|---|---|---|
Tony Abbott | "The delicate balance between freedom and security may have to shift"... | ||||
Theodore Achilles | Very closely connected to the creation NATO | ||||
Alexander Acosta | The US lawyer whose approval of a plea deal with Jeffrey Epstein avoided a public trial after being told that “Epstein was above his pay grade.” | ||||
Richard Alderman | |||||
Myles Ambrose | Richard Nixon's first drug czar | ||||
Daniel Andrews | Politician who came to prominence during the COVID-19 deep event. | ||||
Kirill Androsov | Russian financier, businessman, YGL, 2008-2010 Deputy chief of staff to Vladimir Putin | ||||
Saskia ten Asbroek | Bilderberg Executive Secretary | ||||
Jessica Ashooh | "Hawkish young mandarin hothoused at elite universities and in the halls of state power" | ||||
Roberto Azevêdo | WTO Director-General 2013-2020 | ||||
Audrey Azoulay | French deep state functionary and UNESCO Director-General | ||||
Hans van Baalen | "A Dutch pirate and a villain" | ||||
Kemi Badenoch | Rising Tory cabinet minister | ||||
James Baker | US DSO, many deep state connections from the Atlantic Council to the US-Azerbaijan Chamber of Commerce | ||||
Édouard Balladur | A panelist of the session on The Public Sector And Economic Growth at the 1987 Bilderberg as French Minister of Finance | ||||
Maja Banck-Polderman | Bilderberg Executive Secretary. Attended 7 Bilderbergs | ||||
John Baring | Director of the Bank of England, attended 3 Bilderbergs in the 1980s | ||||
Bernard Barker | A soldier/spook involved both in the assassination of JFK and the Watergate coup. | ||||
Zanny Minton Beddoes | Financial journalist, Bilderberger, IMF economist under Jeffrey Sachs | ||||
Richard Ben-Veniste | A lawyer who has taken various legal roles for the US deep state, including securing the Watergate coup. | ||||
Marc Benioff | US Internet billionaire, bought Time Magazine | ||||
Frederic Bennett | Parliamentary Private Secretary to Reginald Maudling, Privy Counsellor, Bilderberg Steering committee | ||||
Bernard Berelson | |||||
Arnold Bergstraesser | German political scientist who headed some deep state groups in the 1950s and 1960s | ||||
Wayne Lee Berman | US Businessman with deep political connections. | ||||
Jeff Bezos | World's richest man. Founded Amazon, grandson of a DARPA co-founder | ||||
Hans Binnendijk | Dutch born academic and US deep state functionary, a member of Atlantic Council and RAND corporation, deeply involved with NATO. | ||||
Çevik Bir | Turkish general who organized 1997 'soft' coup. | ||||
Richard Blee | |||||
Orlando Bosch | Convicted assassin, Operation 40 member, released by special order of George H. W. Bush after a petition from Jeb Bush | ||||
Donna Brazile | |||||
Willy Bretscher | Influential Swiss editor for many decades | ||||
Graham Brookie | "Former U.S. government advisor on homeland security and counterterrorism" connected to the Integrity Initiative/Institute for Statecraft complex | ||||
Gordon Brown | UK deep state functionary. Prime Minister from 2007-2010. WHO ambassador for Global Health Financing from 2021 | ||||
Mark Malloch Brown | George Soros-protegé | ||||
Gro Harlem Brundtland | Deep state/WHO connected Prime Minister/DG, concerned about "too much freedom of speech" | ||||
Thomas Buberl | German poly-Bilderberg money manager, WEF AGMs, WEF YGL 2008 | ||||
Whitey Bulger | MKULTRA connected US Crime boss assassinated in prison aged 89 | ||||
Ellsworth Bunker | Cold War hawk, diplomatic troubleshooter | ||||
Sylvia Burwell | Bill and Melinda Gates Foundation executive and US Secretary Health, first Bilderberg meeting in 2018. | ||||
Stephen Cambone | Pentagon official and henchman of Donald Rumsfeld. Allowed "loosening the standards of detainee treatment" (i.e. torture) during interrogations. Project for the New American Century. | ||||
John Carbaugh | Cercle attendee linked to political double dealing, arms deals and Iran-Contra. | ||||
Melvin Carraway | Acting Administrator of The Transportation Security Administration removed from office after a report found agents failed to find fake explosives and weapons in internal tests. | ||||
Kaspar Cassani | Chairman and president of the IBM World Trade Corporation. Attended the 1985 Bilderberg. | ||||
Jack Caulfield | |||||
Ahmed Chalabi | "A crafty, avuncular Iraqi exile beloved by Washington's neoconservatives" who attended the 2006 Bilderberg a month after quitting as Deputy Prime Minister of Iraq. | ||||
Olivier Chevrillon | French media CEO and civil servant | ||||
Alan Clark | Bullingdon Club, Le Cercle, Minister for Defence Procurement... | ||||
Jay Clayton | |||||
David Clementi | Former Governor of the Bank of England and BBC chairman. |