Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has nationality::UK]]
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='514679' AND t1.o_id='1088869')
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='514679' AND t1.o_id='1088869')
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 | t1 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id_3 | 9 | const,const | 1598 | 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:2Query-Depth:1
Errors and Warnings
NoneTitle | Born | Died | Description |
---|---|---|---|
Eric Ashby | 24 August 1904 | 22 October 1992 | Celebrated and much travelled UK academic who advised the 1970 Bilderberg on "The Environmental Problem". |
Michael Ashcroft | 4 March 1946 | Billionaire former deputy chairman of the Conservative Party | |
Paddy Ashdown | 24 February 1941 | 22 December 2018 | Chatham House President for 10 years. MI6 operative and UK politician |
Catherine Ashton | 20 March 1956 | A woman with zero qualification or experience of foreign affairs who, in 2009, was made 'High representative for Foreign Affairs and Security policy' in a deal which finally recognised that the position was NOT going to be given to Tony Blair | |
Richard Ashworth | 17 September 1947 | A member of the European Parliament | |
John Aspinall | 11 June 1926 | 29 June 2000 | British zoo owner and gaming club host, and part of the Clermont Set |
Ralph Assheton | 24 February 1901 | 1984 | Lord Clitheroe, Chairman of the Conservative Party in the 1940s, attended 2 Bilderbergs in the 1950s. |
Nicholas Paul Astbury | 1971 | British diplomat who has worked in several areas of interest to the deep state (drugs, regime changes etc). | |
David Astor | 5 March 1912 | 7 December 2001 | The Observer Editor for over 25 years, attended 2 Bilderbergs in the 1950s |
Nancy Astor | 19 May 1879 | 2 May 1964 | The first woman to take her seat in Parliament, a key member of the Cliveden Set |
Waldorf Astor | 19 May 1879 | 30 September 1952 | Multi-millionaire UK deep politician, Chair of Chatham House ... |
Haroon Rashid Aswat | 1979 | UK citizen of Indian origin with alleged ties to Al Qaeda and also possibly a clandestine agent of UK intelligence. | |
Humphrey Atkins | 12 August 1922 | 4 October 1996 | British politician and a member of the Conservative Party described as "Maggie's Poodle" |
David Attenborough | 8 May 1926 | Best known as a nature documentary maker, his views on overpopulation are very influential in powerful circles. | |
Clement Attlee | 3 January 1883 | 8 October 1967 | |
Crispin Aubrey | 3 January 1946 | 28 September 2012 | Journalist defendant in the 1978 ABC Trial |
Nadhmi Auchi | 11 June 1937 | Cercle-connected fraudster | |
James Austin | Young member of the Institute for Statecraft | ||
Graham Avery | February 1945 | UK businessman, Chief Adviser for Enlargement, European Community | |
A.J. Ayer | 29 October 1910 | 27 June 1989 | British spook and later Oxford professor |
Dawood Azami | Spooky BBC journalist and editor. Selected as Young Global Leader by the World Economic Forum. | ||
Shaukat Aziz | 6 March 1949 | Tri-national Citibank executive with "close ties" to the US deep state. Parachuted in to become Prime Minister of Pakistan. Cercle member. | |
Tim Baber | |||
Willy Bach | 25 December 1946 | Minister of State for Defence Procurement, a position connected to the deep state, 2001-2005. | |
David Baddiel | 28 May 1964 | ||
Kemi Badenoch | 2 January 1980 | Rising Tory cabinet minister | |
Abe Bailey | 6 November 1864 | 10 August 1940 | South African diamond and gold tycoon, politician, financier and cricketer. |
John Baird | 27 April 1874 | 20 August 1941 | |
Frank Baker | 27 January 1961 | UK diplomat and ambassador | |
Mike Baker | 22 June 1961 | Worked in the CIA for 17 years as a covert field operations officer, specializing in counterterrorism, counternarcotics and counterinsurgency operations. | |
Norman Baker | 26 July 1957 | MP convinced that David Kelly was murdered. | |
Steve Baker | 6 June 1971 | Tory MP who pushed gene-based Covid jabs on pregnant women. | |
John Baker-White | 12 August 1902 | 10 December 1988 | UK spooky politician & propagandist |
Stanley Baldwin | 3 August 1867 | 14 December 1947 | |
Arthur Balfour | 25 July 1848 | 19 March 1930 | |
James Ball | UK journalist and author who worked for the Integrity Initiative | ||
Joseph Ball | 1 September 1885 | 10 July 1961 | British spook who forged the Zinoviev Letter to bring down the first British Labour Party government in 1924. "Ball also had a keen understanding of the dark arts of political manipulation, a readiness to use all means at his disposal and an ability to keep himself out of the limelight... he knew how to lie and how to keep a secret." |
Peter Ball | 14 February 1932 | 21 June 2019 | UK/VIPaedophile bishop and friend of Charles Windsor |
Ed Balls | 25 February 1967 | UK politician. 7 Bilderbergs | |
Arron Banks | March 1966 | British businessman and political donor | |
Matthew Bannister | WEF/Global Leaders for Tomorrow/1999, at the time when he was responsible for all non-news programme-making on English television, radio and online, and in the running for new BBC Director General. | ||
Willem Baralt | November 1968 | Director of World For Libya, suspected deep state operative | |
Stephen Barclay | 3 May 1972 | British Conservative MP and former Minister | |
Brian Barder | 20 June 1934 | 19 September 2017 | British diplomat, author, blogger and civil liberties advocate |
John Baring | 2 November 1928 | Director of the Bank of England, attended 3 Bilderbergs in the 1980s | |
Rowland Baring | 28 July 1918 | 16 March 1991 | |
Thomas Baring | 22 January 1826 | 15 November 1904 | |
Michelle Barlow | 1970 | 23 March 2021 | British woman who died from the Oxford–AstraZeneca COVID-19/Vaccine. |
Harry Barnes | 22 July 1936 | ||
Emma Barnett | 5 February 1985 |