Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has headquarters::UK]] [[Has objectClass2::Group]]
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_blob` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='1348' AND t2.o_id='1088869'
AND (
(t5.o_hash='Group') AND t5.p_id='2398168')
)
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
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_smw_di_wikipage` AS t2
INNER JOIN
`mw_smw_di_blob` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='1348' AND t2.o_id='1088869'
AND (
(t5.o_hash='Group') AND t5.p_id='2398168')
)
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
0
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 | o_id_3 | 9 | const,const | 175 | Using temporary; Using filesort |
1 | SIMPLE | t5 | ref | s_id,p_id,s_id_2,o_hash | s_id | 8 | wikispooks.t2.s_id,const | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t2.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneA Group Headquartered Here | Description |
---|---|
15 (UK) Psychological Operations Group | A UK army psyop group. |
5Rights Foundation | Online censorship lobbyist, using the angle of "protecting the children". Secretive funding. |
Active Change Foundation | Spooky charity that worked closely with the Institute for Statecraft on "de-radicalisation" |
Adam Smith International | London-based consultancy charged with overseeing the overseas work of the Adam Smith Institute. Used by British intelligence services to train puppet police forces in the Middle East. |
Airwars | |
Amnesty International | "Effectively, Amnesty International and AIUSA function as tools for the imperialist, colonial and genocidal policies of the United States, Britain, and Israel." Revolving leadership door with US government. |
Ampleforth College | UK establishment day and boarding school with decades of sexual abuse and cover ups. |
Anglia Ruskin University | Has been named as one of the most upwardly mobile universities in the world<a href="#cite_note-1">[1]</a> |
Anti-Slavery International | |
ArmorGroup | One of the largest private security firms operating in Iraq |
Article 19 | |
Asda | |
Astutus Intelligence | A UK limited company started in 2015 by two Institute for Statecraft directors and a third man. Dissolved in 2019. |
BAE Systems | A global arms company, with interests also in civilian avionics and engineering. Its subsidiaries are also involved in providing intelligence, personnel and logistics support to US/UK military. |
BBC | A state propaganda apparatus disguised as a quasi-autonomous public service corporation. |
BBC/Verify | A BBC "fact checking service" |
BP | Multinational oil company implicated in the 1953 Iran Coup. |
Balli Group Plc | A privately held company with a subsidiary, Balli Aviation that in 2010 pleaded guilty to charges of illegally exporting Boeing aircraft to Iran, in breach of sanctions. |
Bangor University | Welsh University with economic problems |
Bank of England | |
Bank of Scotland | |
Behavioural Insights Team | UK government propaganda and manipulation outfit |
Bell Pottinger | Received $500 million from the US DOD to create a range of propaganda, including fake Al-Qaeda videos |
Board of Deputies of British Jews | |
Border and Immigration Agency | Defunct UK Government agency. |
Bournemouth University | Recognised for its work in the media industry |
British Aerospace | |
British Airways | The flag carrier airline of the United Kingdom |
British Council | The British government's cultural propaganda body. |
British Satellite Broadcasting | A London based satellite television company |
British South American Airways | A nationalised airline that existed in the 1940s that ceased operations after two mysterious aircraft disappearances |
British-American Tobacco | |
Cambridge Analytica | A big data mining company |
Cambridge University/St John's College | A Cambridge College which hosted the Bilderberg meeting |
Cambridge University/Trinity College | |
Campaign Against Antisemitism | |
Campaign Against Arms Trade | UK-based campaigning organisation working towards the abolition of the international arms trade. Was infiltrated by corporate spies. |
Canterbury Christ Church University | Anglican higher education institution |
Carlton Television | British media company led by Michael P. Green. Former prime minister David Cameron was director of corporate affairs there 1994-2001. |
Centre for Research into Post-Communist Economies | |
Chartered Management Institute | |
Charterhouse School | Regarded to be among the most prestigious schools in the world due to the school's history and influence |
City of London School | |
Civil Aviation Authority | Oversees and regulates civil aviation in the United Kingdom. |
Coalition for Peace Through Security | A spooky UK front group to try to oppose CND. |
Control Risks | A British "private security" company set up in 1975 by David Walker (SAS), comparable to Kroll Inc set up in New York in 1972 |
Cornerstone Group | A group of Conservative MPs. |
Coutts Bank | British private bank with exclusive customer base |
Criminal Cases Review Commission | |
CrisisCast | British company with close ties to the military providing realistic crisis actors. |