Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[-Has member::Le Cercle]] [[Constitutes::+]]
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 t2
INNER JOIN
`mw_smw_di_wikipage` AS t5 ON t2.o_id=t5.s_id) ON t0.smw_id=t2.o_id
WHERE
(t2.p_id='1140' AND t2.s_id='26662'
AND (t5.p_id='654')
)
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
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_smw_di_wikipage` AS t2
INNER JOIN
`mw_smw_di_wikipage` AS t5 ON t2.o_id=t5.s_id) ON t0.smw_id=t2.o_id
WHERE
(t2.p_id='1140' AND t2.s_id='26662'
AND (t5.p_id='654')
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | p_id | 8 | const,const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t5 | ref | s_id,p_id,s_id_2,s_id_3 | s_id | 8 | wikispooks.t2.o_id,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t2.o_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneMember | Description |
---|---|
Margaret Carlisle | Legislative aide to Iran-contra insider, James McClure. Le Cercle |
Anthony Cavendish | "Leading member" of Le Cercle. |
Paul Channon | US-born UK politician who attended and was involved in the Arms-to-Iraq deal together with fellow Cercle members Jonathan Aitken and Alan Clark. |
James W. Cicconi | George H. W. Bush connected insider. |
Alan Clark | Bullingdon Club, Le Cercle, Minister for Defence Procurement... |
Marcel Clement | |
Robert Close | Belgian Anti-Communist spook who attended Le Cercle. |
William Colby | CIA boss who maybe became too loose-mouthed, died in suspicious circumstances |
Etienne Copel | Former chief of France's air force, Le Cercle. |
Miles Costick | |
James Critchfield | Senior CIA spook who handled Reinhard Gehlen. Then Near East Division Chief from 1959 to 1969 where he arranged a coup in Iraq. Le Cercle |
Brian Crozier | Arch espionage insider who founded his own intelligence agency |
Alexandre Ribeiro da Cunha | A Portuguese diplomat who went to a meeting of Le Cercle in US in December 1973. |
Hans van Dalsen | |
Florimond Damman | A Belgian deep state operative who was closely involved with Le Cercle. |
Armand de Decker | Belgian lawyer politician who attended Le Cercle |
Jack Dellal | UK property developer, Le Cercle |
Jean-François Deniau | A diplomat who wrote the foreword of the Treaty of Rome. Le Cercle |
Laura Jordan Dietrich | A spooky US government insider |
Paul Dietrich | Spook, Cercle visitor |
Hans-Lothar Domröse | Senior German Army officer. He is believed to have visited Le Cercle in 1983. |
Yves-Marc Dubois | Possible head of the Vatican intelligence service. Attended Le Cercle. |
Alan Duncan | Called Julian Assange a “miserable little worm” in Parliament. UK visitor to Le Cercle. As UK Minister, Alan Duncan organised the oil blockade of Libya in 2011. |
Lee Edwards | Anti-communist advisor for Nixon and others. Cercle attendee. |
Iain Elliot | Associate Director of Radio Liberty and also worked in other intelligence-connected organizations. Attended 3 meetings of Le Cercle |
Nicholas Elliott | A key spook with a wide range of connections. |
Philipp Vander Elst | |
Fritz Ermarth | Le Cercle. CIA. RAND |
Edwin J. Feulner | |
Charles Fincham | Le Cercle. |
Brand Fourie | "One of the most remarkable diplomats South Africa ever produced" |
Wyche Fowler | |
William François | French economist who attended at least two Cercle meetings |
Louis Freeh | "A legacy of corruption..." |
Charles Freeman | Long time president of the Middle East Policy Council. Close relations to Saudi Arabia and Iran. Le Cercle, Bilderberg |
Yegor Gaidar | |
Pierre Gallois | "Father of the French atom bomb", Bilderberg, Le Cercle |
Indira Gandhi | Le Cercle |
Marie-France Garaud | |
Mark Garnier | UK MP who attended Le Cercle in Washington DC in 2018 |
Monique Garnier-Lançon | Deep state operative whose papers lead to a major exposure of Le Cercle. French convenor of Le Cercle in the first half of the 1980s. |
Robert Gascoyne-Cecil | Bilderberg, Le Cercle, The Other Club, Ditchley Governor |
Jean-Claude Gaudin | Mayor of Marseille for 25 years, Knight of Malta, Le Cercle... |
Reinhard Gehlen | Head of the Gehlen Organisation under Adolf Hitler, smoothly transitioned post war to head of the BND |
Conrad Gerber | Close friend of Ted Shackley |
Frans Alphons Maria Alting von Geusau | A Dutch diplomat and scholar in international law. Von Geusau was also an advisor to the Dutch government from 1968 to 1998. |
James Goldsmith | an Anglo-French billionaire financier and businessman, possible deep state operative. |
Enrique Gomez-Hurtado | Cercle regular. "One of the best bootlicker[s] of Bush" |
Álvaro Gomez-Hurtado | Spooky Colombian diplomat who attended Le Cercle. Assassinated in 1995 |
Philip Goodhart | UK deep state actor. Attended Le Cercle. |