Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has groupType::Commercial]]
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='1125' AND t1.o_id='15386')
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1125' AND t1.o_id='15386')
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 | 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 | 88 | 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
NoneWikispooks page | Date | Logo | WWW | Description |
---|---|---|---|---|
7-Seas Global Intelligence | http://www.7-seas.net | |||
Acanchi | http://www.acanchi.com | |||
Alcan | ||||
ArmorGroup | http://www.g4s.com/ | One of the largest private security firms operating in Iraq | ||
ArmorGroup/North America | ||||
Armscor | http://www.armscor.co.za | Apartheid South Africa arms production an procurement company. Major node for SA and Western deep state activities. | ||
Associated Press | http://www.ap.org/ | Very important hub of corporate media | ||
BAE Systems | http://www.baesystems.com/ | 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. | ||
Bank of Credit and Commerce International | http://www.bcci.info/ | The "Bank of Crooks and Criminals International", as some nicknamed it, was a bank set up to facilitate large scale, global money laundering, mainly to support a range of black operations by intelligence agencies. | ||
Bank of England | http://www.bankofengland.co.uk | |||
Barrick Gold | http://www.barrick.com | |||
Baxter International | http://www.Baxter.com/ | A multi-billion dollar transnational corporation which is of interest as regards emerging diseases and vaccines. | ||
Benador Associates | http://www.benadorassociates.com | |||
BlackRock | https://www.blackrock.com/ | Who owns a piece of everything? They do! | ||
Booz Allen Hamilton | http://www.boozallen.com/ | A for-profit part of the US Deep State. | ||
Brazzaville Foundation | http://www.brazzavillefoundation.org | |||
Britam Defence Ltd | http://www.britamdefence.com | A "risk management and training consultancy" that was the subject of a high profile 2013 data leak. | ||
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 | |||
C13 Associates | http://c13associates.co.uk | |||
CNN | http://www.cnn.com | "Deep State TV network and master of fake news", experienced a precipitous decline in popularity since about 2019 | ||
Carlyle Group | http://carlyle.com | A "private global investment firm" with around 1400 employees which has become the world's second largest private capital firm. Close connections to the deep state are suspected. | ||
Champollion | http://www.champollion.co.uk | |||
Comverse | http://www.cmvt.com | American Tech company which does most of its research and development in Israel. | ||
Control Risks | http://www.controlrisks.com | A British "private security" company set up in 1975 by David Walker (SAS), comparable to Kroll Inc set up in New York in 1972 | ||
Corporate media | The corporate media refers to itself as 'mainstream' in an effort to marginalize so-called "alternative" media. While some instances (e.g. BBC) are not strictly commercial, all the corporate media is hierarchically structured, so a very small number of editors can censor or modify its output. | |||
DMG Information | ||||
Defence Evaluation and Research Agency | http://www.dera.gov.uk | |||
Defence Export Services Organisation | ||||
Defence Public Affairs Consultants | ||||
Defence Strategy & Solutions LLP | http://www.defencestrategy.com | |||
Denver International Airport | Big Airport in the United States which has several "conspiracy theories" connected to it. | |||
Dresser Industries | http://www.dresser.com/ | Texas oil an gas sector supplier | ||
El Al | https://www.elal.com/en/Israel/Pages/default.aspx | An airliner flying from Central Israel, with several prolific incidents and covert operations ordered by the Deep State. | ||
Encounter Books | ||||
Executive Outcomes | A private military contractor which offered "Security management" and "full-service risk management consulting". It operated during the 1990s and boasted 500 military advisers and over 3000 military personnel, largely drawn from the South African Civil Cooperation Bureau. | |||
G4S Secure Solutions | http://www.g4s.com/us | A British/American multinational security services company with deep ties to the US government and military complex | ||
GPW | http://www.gpwltd.com | A firm of corporate investigators | ||
General Atomics | http://www.ga.com/ | Part of the military-industrial complex, much more than nuclear. | ||
GeoMiliTech Consultants Corporation | ||||
Global Strategies Group | http://www.globalgroup.com | |||
Huffman Aviation | Florida spooky flying school with connections to both CIA drug trafficking and 9-11. | |||
IGO | Highly influential and powerful organizations that legally go beyond borders. IGOs have come very close to forming an actual "new world order" in the 2000s. | |||
Investigative Group International | ||||
J.P. Morgan & Co. | ||||
JPMorgan Chase | http://www.jpmorganchase.com | A multinational banking and financial services holding company. Deep state power for more than a century. | ||
Janusian Security Risk Management | ||||
Kroll Inc. | http://www.kroll.com | The “CIA of Wall Street” | ||
Lehman Brothers | https://www.archive.barclays.com/items/show/5403 | The bank which collapsed in 2008, resulting - according to the official narrative - in the Global Financial Crisis. | ||
Lockheed | "Nobody is doing a better job of arming the world than Lockheed-Martin" |