Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::Soldier]]OR[[Has posting::Soldier]]
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 | 550 | 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='3047'
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='3047'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NonePage name | Born | Died | Nationality | Summary | Description |
---|---|---|---|---|---|
Erik Bennett | 1928 | 28 January 2022 | UK | Spook Soldier | A secretive UK military advisor in Oman and a Cercle attendee. |
Russel Bentley | 1960 | April 2024 | US Russian | Soldier | American who went to Ukraine in 2014 to fight for the separatists in Donbas |
Alf Roar Berg | 17 April 1933 | 2022 | Norway | Spook Soldier | Leader of the Military Intelligence Service in the period 1988–1993. |
Brian Berletic | US | Author Researcher Soldier | Researcher, Writer, Commentator, banned from Twitter in 2022. | ||
Bernhard von Biesterfeld | 29 June 1911 | 1 December 2004 | Netherlands | Soldier Arms Dealer Pilot Deep politician | Nazi arms dealer. Alleged bodyguard of Hitler, early member of the SS, requested presidency under Hitler during WW2. An early leader of the Dutch Deep State, founded Dutch division of Operation Gladio named Inlichtingen en Operatiën, co-founded Bilderberg as Steering Committee chairman. Started 1001 Club, WWF, Rijkens Club. Linked to Klaas Bruinsma. |
Steve Bigelow | US | Whistleblower Soldier | US Air Force whistleblower who exposed MICC corruption. | ||
Andriy Biletsky | 5 August 1979 | Ukraine | Soldier Politician | Azov leader | |
Peter de la Billière | 29 April 1934 | Soldier | |||
James Bindenagel | US | Diplomat Soldier | US Chargé d'affaires to Germany from 1996 to 1997, | ||
Deborah Birx | 4 April 1956 | US | Soldier Military Deep state actor Epidemiologist | White House Coronavirus Response Coordinator under President Donald Trump from 2020 to 2021. Broke own rules on social gathering. | |
Eşref Bitlis | 1933 | 17 February 1993 | Turkey | Soldier | Turkish general who was assassinated by deep state as part of the Turkey/1993 Planned Military Coup |
Jan Björklund | 18 April 1962 | Sweden | Soldier Politician | Proponent of Swedish participation in 2003 Iraq war. Attended the 2009 Bilderberg as Sweden's Minister for Education, became Deputy Prime Minister of Sweden in 2010. | |
Svein Blindheim | 29 August 1916 | 17 March 2013 | Norway | Whistleblower Soldier | Resistance hero who later revealed Stay Behind activities, and was convicted to prison for it. |
Crispin Blunt | 15 July 1960 | UK | Soldier Politician | Sandhurst, Le Cercle, MP, Chair of the Foreign Affairs Select Committee | |
Tom Boardman | 12 January 1919 | 10 March 2003 | UK | Soldier Politician Financier | UK soldier politician banker who attended the 1986 Bilderberg |
Adrien Bocquet | France | Soldier | Aid worker who went to Ukraine and says he observed war crimes committed by the Azov battalion | ||
Howard Body | Soldier Deep state operative | A "senior executive at Porton Down" whose name appears on Document:CND Gen list 2, exposed by the Integrity Initiative/Leak/4. | |||
Derek Boorman | 30 September 1930 | UK | Spook Soldier | Senior British Army officer and Chief of Defence Intelligence 1985-1988. | |
Valerio Borghese | 6 June 1906 | 26 August 1974 | Italy | Spook Soldier Deep state operative | Organized a failed coup in Italy and was exiled. |
Juan Almeida Bosque | Cuba | Soldier Politician | |||
Victor Bout | 13 January 1967 | Russian | Spook Soldier Arms Dealer Translator Polyglot Businessperson | Russian accused of arms smuggling by the US, was jailed with help from a turned associate, allegedly, on orders of the CIA. | |
Robert R. Bowie | 24 August 1909 | 2 November 2013 | US | Spook Soldier Academic Deep state actor | Wrote item one of the agenda of the 1966 Bilderberg, on the need to reorganise NATO. |
Robert Bowman | 19 September 1934 | 22 August 2013 | US | Soldier Activist | US officer turned peace activist and 911 skeptic. |
Thomas Boyd-Carpenter | 16 June 1938 | UK | Soldier | ||
Omar Bradley | 12 February 1893 | 8 April 1981 | Soldier | ||
Edwin Bramall | 18 December 1923 | 12 November 2019 | UK | Soldier | |
Thomas Brand | 30 March 1900 | 17 October 1965 | UK | Soldier Financier | UK financier who attended the 1961 Bilderberg |
Philip Breedlove | 21 September 1955 | US | Soldier | Supreme Allied Commander Europe | |
Hamish de Bretton-Gordon | September 1963 | Author Soldier | UK soldier turned businessman and author | ||
Carsten Breuer | 1 December 1964 | Soldier | |||
Robin Brims | UK | Soldier | Major General, fellow of the Institute for Statecraft | ||
John Brinkerhoff | 1928 | 18 December 2020 | Soldier | US Army Colonel notable for his role in planning the REX-84 martial law exercise, along with Lieutenant-Colonel Oliver North. Some have linked him to 9/11. | |
Umberto Broccoli | 1895 | Italy | Spook Soldier | Italian officer and spook who was involved in the establishment of Gladio | |
John Browne | 17 October 1938 | UK | Soldier Politician Banker Businessperson | Spooky UK businessman, Morgan Stanley, Le Cercle, Chatham house ... | |
William Francis Buckley | 30 May 1928 | 3 June 1985 | Spook Soldier | CIA Station Chief in Beirut, captured by Hezbollah. | |
Smedley Butler | 30 July 1881 | 21 June 1940 | Whistleblower Soldier Activist | A US general who exposed the coup that financiers had planned for USA. | |
Alexander Butterfield | 6 April 1926 | Spook Soldier | The spook who installed the taping system for Richard Nixon. | ||
Pierre Buyoya | 24 November 1949 | 17 December 2020 | Burundi | Soldier Politician COVID-19/Premature death | Former Burundian president who died allegedly of COVID-19 after rejecting the official narrative about the disease |
Francisco Caamaño | 11 June 1932 | 16 February 1973 | Dominican Republic | Soldier Politician | Dominican soldier and politician who tried to change things. Captured and summarily executed with the assistance of the CIA. |
Trevor Cadieu | Soldier | NATO officer that acted as military advisor in Ukraine. | |||
Luigi Caligaris | 4 October 1931 | 17 October 2019 | Italy | Soldier Politician | Single Bilderberger Italian officer, later politician |
Gorden Sunderland Campbell | 5 July 1905 | US | Spook Soldier | ||
Ralph J. Canine | 9 November 1895 | 8 March 1969 | Spook Soldier | First director of the National Security Agency. | |
Umberto Cappuzzo | 30 April 1922 | 13 May 2014 | Italy | Soldier | Senior Italian military leader and Le Cercle attendee. |
George Carlin | 12 May 1937 | 22 June 2008 | Author Soldier Comedian | "One of the greatest political pundits in American history", a comedian who developed an interest in deep politics towards the end of his life. | |
Marshall Carter | 16 September 1909 | 18 February 1993 | Spook Soldier | Director of the National Security Agency from 1965 to 1969. | |
Nick Carter | 11 February 1959 | UK | Soldier Propagandist | Senior UK soldier concerned about Russian use of "Fake News". | |
Michael Carver | 24 April 1915 | 9 December 2001 | UK | Soldier | Senoir UK soldier |
Richard Carver | 24 April 1915 | 9 December 2001 | Soldier | ||
Christopher Cavoli | US | Soldier | Spooky US general and Supreme Allied Commander Europe since July 2022. His career shows an extensive specialization towards Russia. Attended 2023 Bilderberg meeting. |