Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::Politician]]OR[[Has posting::Politician]]
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
25
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
25
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 2833 | 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='4602'
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='4602'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None Page name | Born | Died | Summary | Description |
---|---|---|---|---|
Joaquín Almunia | 17 June 1948 | Politician | Spanish politician, European Commissioner for 10 years, 6 Bilderbergs | |
Laura Alonso | 23 December 1972 | Politician | ||
Fuat Alpkartal | 1902 | April 1978 | Spook Soldier Politician | A Turkish officer with strong ties to the Turkish intelligence community and a former Military Attaché in Washington. Attended the 1959 Bilderberg. |
Renato Altissimo | 4 October 1940 | 17 April 2015 | Politician | Italian politician |
Peter Altmaier | 18 June 1958 | Politician Lawyer | German politician who was Head of the Chancellery 2013-2018. | |
Anne Aly | 29 March 1967 | Politician Academic | Australian MP and terror expert | |
Luís Amado | 17 September 1953 | Politician | Portuguese politician who attended the 2012 Bilderberg | |
Joaquim do Amaral | 13 April 1945 | Politician Engineer | Portuguese politician who attended the 1999 Bilderberg. Party-supported candidate for President in 2001, losing to fellow Bilderberger Jorge Sampaio. | |
Julian Amery | 27 March 1919 | 3 September 1996 | Spook Politician Deep politician | MI6, deep politician who chaired Le Cercle for several years. |
Leo Amery | 22 November 1873 | 16 September 1955 | Politician Deep state actor | UK historian and deep state actor, chief lieutenant of Alfred Milner |
David Amess | 26 March 1952 | 15 October 2021 | Politician COVID-19/Premature death | British parliamentarian and COVID-19 dissident who was fatally stabbed in October 2021. He had criticised Big Pharma, the COVID 19/Lockdowns, mandatory face masks, and vaccine passports. |
Hafizullah Amin | 1 August 1929 | 27 December 1979 | Politician | |
Idi Amin | Soldier Politician | |||
Valerie Amos | 13 March 1954 | Politician | British Labour politician | |
Michael Ancram | 7 July 1945 | Politician Deep politician | Likely took over from Norman Lamont as European chair of Le Cercle. | |
K. B. Andersen | 1 December 1914 | 23 March 1984 | Politician | Danish Minister of Education and Minister of Foreign Affairs, triple Bilderberger |
Poul Nyboe Andersen | 23 November 1913 | 5 November 2004 | Politician Economist | Danish economist and politician. Member of the Trilateral Commission. His daughter is former national bank director Bodil Nyboe Andersen. |
Joe Anderson | 24 January 1958 | Politician | Mayor of Liverpool (2012 to 2021) | |
Lee Anderson | 6 January 1967 | Politician Broadcaster | ||
Robert Anderson | 4 June 1910 | 14 August 1989 | Politician Businessperson | Le Cercle, Bilderberg, |