Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has objectClass::Document]] [[Has author::Integrity Initiative]]
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.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='2398166' AND t2.o_id='2129'
AND (t5.p_id='2398297' AND t5.o_id='2157611')
)
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_wikipage` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='2398166' AND t2.o_id='2129'
AND (t5.p_id='2398297' AND t5.o_id='2157611')
)
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 | t5 | 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 | 93 | Using temporary; Using filesort |
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,wikispooks.t5.s_id | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t5.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneTitle | Document type | Publication date | Subject(s) | Description |
---|---|---|---|---|
Document:5 July Seminar; Potential guest list for discussion | spooky seminar invitation list | 26 February 2016 | Deep state Propaganda UK Integrity Initiative Spooky seminar | Seminar with a mix of media, academics and lots of spooks |
Document:ATA and YATA UK networks development | assessment Greg Rowett and networking | 26 December 2018 | Atlantic Treaty Association Greg Rowett Networking | Greg Rowett explaining how II has developed personal connections with Atlantic Treaty Association and Young Atlantic Treaty Association leaders from other nations, and been recognised and ratified as the UK chapter for both |
Document:An assessment of RT in the Middle East and North Africa: April 2018 | report | 26 December 2018 | An assessment of RT in the Middle East and North Africa: April 2018 | An assessment of RT in the Middle East and North Africa: April 2018 |
Document:Appendix A Ukraine Indicators and Warnings | Ukrainan view of Russian/separatist tactics and strategy | 26 February 2016 | Russia Ukraine Separatists | Ukrainian officers tells British colleagues their opinions |
Document:Bid for MoD Funding 2017-2018 | project proposal | 14 March 2017 | Propaganda Integrity Initiative II/C | "Creation of a Europe-wide network of groups who understand the danger of Russian active measures and who can pass the message on to their own decision-makers and public, often using material which we initiate" |
Document:Brief on Monitoring Moldovan 2019 Elections | Briefing | 26 December 2018 | Moldova Election Election monitoring Maia Sandu | "As a conclusion, it is absolutely important for foreign missions and observers to start monitoring the Moldovan elections already now, since elections are made long before the voting date!" |
Document:CND Gen list 2 | name list | 26 December 2018 | List of names and emails for CND Gen | list of names and email addresses of what seems to be intelligence workers/assets (CND is short for Christopher Nigel Donnelly) |
Document:CND Integrity Initiative visit to Oslo, 29-31 Aug 2016 | schedule | 26 December 2018 | Norway Aftenposten Institute for Defence Studies Northern Norway Barents Observer | Donnelly's travel itinerary to Oslo + meeting how to create cell in Norway |
Document:Chris Donnelly Recommendation for the Appointment or Extension of Tenure of an Honorary Colonel of a T/A Reserve Regional Unit | Recommendation for Extension of Tenure of an Honorary Colonel | 26 December 2018 | Chris Donnelly Specialist Group Military Intelligence | Recommendation for Extension of Tenure of an Honorary Colonel for Chris Donnelly working in Specialist Group Military Intelligence |
Document:Chris Donnelly Washington DC Schedule | schedule | 26 December 2018 | Wikipedia Washington DC | A schedule of c's meetings in Washington |
Document:CyberGuardian Cyber Security Education Programme for Children and Young People | brainwashing concept paper | 30 January 2016 | Hacking "Cyberwarfare" Brainwashing of children | II puts lots of thought into how the military can train British children for cyberwarfare. |
Document:DK15 2016 The Institute for Statecraft PC | Invoice | 26 December 2018 | Hungarian invoice to The Institute for Statecraft Integrity Initiative | |
Document:DK6 2016 PC The Institute for Statecraft | Invoice | 26 December 2018 | Hungarian invoice to The Institute for Statecraft Integrity Initiative | |
Document:Discernment: Why information statecraft matters | strategy document | 26 December 2018 | Censorship Brainwashing "Radicalisation" Information health | Musings on how to keep media dominance and control young minds |
Document:Discussion with Artur Gherman re the situation in Moldova, 28 01 2017 | Discussion | 26 December 2018 | Freemasonry Moldova Election | |
Document:Donnelly Workshop Sept 19 | workshop participants | 26 December 2018 | List of email addresses | |
Document:Euan Grant Contributions | Wikispooks Page | 8 May 2018 | Euan Grant Contributions | Euan Grant telling how he plans to offer completed packages of material to professional bodies, print and online press |
Document:Executive Summary Cyber Security Education Programme for Children and Young People | brainwashing concept paper executive summary | 26 February 2016 | Hacking "Cyberwarfare" Brainwashing of children | II sums up its thought on how the military can train British children for cyberwarfare |
Document:FCO Disinformation update: Salisbury and Syria | review | 26 December 2018 | Douma attack Skripal Affair "Russian Propaganda" | UK Foreign Office email, presumably to trusted pro-government journalists, with information as 'background for your own work'. Cliff notes on Douma, Skripal etc. |
Document:FCO US Integrity Initiative | sketching out a US II-network | 26 December 2018 | Request for US support | |
Document:Forward Thinking Report - The potential relevance of the Ukrainian National Reform Council to the Tunisian Transition | policy advice | 26 December 2018 | Ukraine "Arab Spring" Tunisia | making the Tunisian economy more like Ukraine's |
Document:Greek Cluster Meeting | cluster meeting | 25 June 2018 | The Greek cell ('cluster') conspires against the elected Syriza government. | |
Document:Greek Media and Information Literacy Week | media workshop | 28 November 2018 | The British covert propaganda outfit wants..."to familiarize readers/media users with basic principles and concepts so that they can judge and control...the online and printed content they read, share or create, so as to be able to distinguish news from misinformation, biased content, or propaganda". | |
Document:Gyori lorant acc invoice 00719-16-MFE | Prepayment request | 26 December 2018 | Meeting loots of spooks/propagandists in Washington | |
Document:II Report Greek Diplomatic Expulsions | press summary | 28 November 2018 | Summary of Greek comments after expulsion of Russian diplomats "with the constant advice of the American embassy". | |
Document:Independent journalism in hostile places or How to report Repressive Regimes and survive | review of proposal of joint event with private (?) company | 26 December 2018 | A spooky company called Foreign Desk Ltd suggest a joint event with the Integrity Initiative. The proposal has comments from II's Victor Madeira | |
Document:Institute for Statecraft & Center for Naval Analyses Joint Workshop | workshop summary | 22 June 2018 | Sweden Estonia Norway Poland Psyop Navy Nuclear weapon US/Marine Corps Zapad Information Warfare | Information Warfare Study Day hosted by British Navy. Candid opinions (with a NATO-flavor) on lots of military issues. |
Document:Institute for Statecraft Event China | event plan | 26 December 2018 | China | |
Document:Institute for Statecraft Event Nigeria | event planning | 26 December 2018 | Nigeria 77th Brigade Donald Duke | A strict security round table discussion with Donald Duke, very likely to be a candidate in the next presidential elections in Nigeria |
Document:Institute for Statecraft Production timetable March-June 2016 | list of Armenians suspected of being Russian propagandists | 26 December 2018 | Free University of Brussels Ofcom Armenia List of opponents List of suspected Russian propagandists | |
Document:Integrity 2018 Moldova Cluster (1) | strategy document | 26 December 2018 | Corporate media Strategy Plans Integrity Initiative/Cluster/Moldova | |
Document:Integrity France | report | 25 June 2018 | Propaganda France Integrity Initiative II/C | a partial list of II-France members. For complete list, see Integrity Initiative/Cluster/France |
Document:Integrity Initiative Budget for the 12 months ending 31 March 2019 | Budget and activity plan | 2 November 2018 | Propaganda Integrity Initiative II/C Political warfare Information Operation | Budget outlining how Integrity Initiative is going to control the information space, and influence policy-makers, specialists and media. |
Document:Integrity Initiative Serbian Cluster | budget | 26 December 2018 | Integrity Initiative/Cluster/Serbia | budget and activities of an Integrity Initiative influence network in Serbia |
Document:Integrity Initiative Staff Payments | payment list | 26 December 2018 | Salaries of British intelligence workers | salaries etc. of II staff members |
Document:Invoice Eduard Abrahamyan | invoice | 26 December 2018 | Eduard Abrahamyan | Invoice from Eduard Abrahamyan for work performed |
Document:Invoice for 2 articles by Dan Kaszeta | invoice | 26 December 2018 | Integrity Initiative articles | Invoice for 2 articles written by Dan Kaszeta for Integrity Initiative “Poison gas” and "Nerve agents and treatment” |
Document:Maritime Battle Staff Information Warfare (IW) Study Day | seminar description | 22 June 2018 | Netherlands Psyop DETER/DECEIVE | Information Warfare Study Day hosted by British Navy |
Document:Meeting Note Moscow Stock Exchange Forum | seminar description | 12 June 2017 | Gold Oil Aluminium Russian economy Economic warfare Arkady Dvorkovich Alexander Afanasiev Pavel Grachev Oleg Mukhamedshin Grain | II, probably Victor Madeira or Perry Fawcett, attended a Russian business forum in London |
Document:Meetings in Greece Feb 2017 | cluster meeting | 10 February 2017 | Greek II collaborators discussing how to reorient Greek public opinion. | |
Document:Moldova- suggested priorities for consideration by clusters and UK staff in light of recent and ongoing developments | Strategy Document | 26 December 2018 | Moldova II/C Making and spreading of outputs | |
Document:Nationbuilder People | name list | 26 December 2018 | List of media people | list of Nationbuilder people, ie journalists mostly in large media corporations |
Document:Notes from colleagues in the Baltic States who are monitoring Russia carefully | Wikispooks Page | 18 March 2018 | Skripal Affair Russia/Propaganda | A document from the Integrity Initiative Leak which asserts that "A criminal investigation [into the Skripal affair] alone will not throw these essential clues up, and is unlikely to yield sufficient judicial evidence We need to be looking at, and explaining, this attack from a political and military-intelligence perspective. That means educating our audience to understand how Russia sees this world as being at war." |
Document:Outline Concept paper for IfS US programme v6 28 08 2017 (003) | request for US support | 26 December 2018 | Integrity Initiative/Cluster | |
Document:Pitch for a long-Form TV series about Russia in the 1990s | media strategy planning | 26 December 2018 | Russia Media strategy TV-series | Pitch for creating a long-Form TV series about Russia in the 1990s |
Document:Post Trip Report Stratcom event 11-13th June 2018 | report | 26 December 2018 | Participants telling of several meeting with fellow information warriors in Riga | Participants telling of several meeting with fellow information warriors in Riga, esp. British and Dutch. Ad bureau Saatchi working for US State Dept. |
Document:Private List for Chris. (Possible Funders in Swittzerland) | name list | 26 December 2018 | List of cutouts | This is a list of cutouts, seemingly 'independent' 'philanthropic' foundations financing intelligence work |
Document:Private discussion with Gen Sir Richard Barrons | report | 26 December 2018 | Former leader of British forces Richard Barrons telling of his worries for Britain and the British forces | Former leader of British forces Richard Barrons sketching out military needs. "The 1st offset in the 1950s was through nuclear weapons. The 2nd was precision munitions in the 1980s. The 3rd offset today is to use information technologies to build new capabilities".."The Army understands the importance of information warfare and 77 Brigade is right" ..So we should them [our allies], especially the US, to tell us what is expected of us." |
Document:Production schedule 05 04 2016 | output report | 4 May 2016 | A list of written output from II staff, mostly for internal study use. | |
Document:Production timetable March-April 2016 | output planning report | 25 February 2016 | A list of planned written output from II staff, similar to Document:Production schedule 05 04 2016 |