Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has headquarters::France]] [[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='54642'
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='54642'
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 | 71 | 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
None| A Group Headquartered Here | Description |
|---|---|
| Agence France-Presse | The French-News-Agency is the world's oldest news organisation. |
| Airbus | Produces 50% of all jet aircraft in the world. Largest airliner manufacturer during the 2020s. Accused of bribery of multiple countries. Received a ban from a group of dozens of banks for "involvement in nuclear weapons production". |
| Atlantic Institute | Transatlantic think tank with similar goals to the Trilateral Commission, operational 1961-1988. |
| Avisa Partners | |
| Axa | French multinational insurance firm with Bilderberg contacts |
| BNP Paribas | World's 8th largest bank by total assets, paid the US Justice Department $8.97 billion after accusations of money laundering |
| Balenciaga | Fashion company which hit the headlines in November 2022 for hidden references to child abuse in its ads. |
| Bank of France | French central bank |
| Banque Worms | Influential French bank, especially at the beginning of the 20th century and during WW2. Major part of the deep state banking and industrial cartel the Synarchist movement |
| Bureau of Enquiry and Analysis for Civil Aviation Safety | French government agency responsible for investigating aviation accidents and incidents. A few skeletons in the closet. |
| CEPII | French economic think tank with lots of Bilderbergers. |
| Council of Europe | IGO. Cannot make laws, but makes treaties. Accused of institutional (revolving door) corruption. Appears to bribe European & transcontinental countries. |
| DGSE | French foreign intelligence agency |
| Dassault Group | French weapons and media corporation |
| ESSEC Business School | French prestigious business school |
| Elf Aquitaine | Elf was a centerpiece of French neocolonial practices in Africa: influence peddling, corruption, violence, political manipulation, etc. |
| European Commission of Human Rights | |
| Forbidden Stories | An "independent" NGO and media outlet financed by the usual cluster of deep state connected foundations. |
| France/Deep state | The French deep state, closely collaborating with Supranational Deep State policy since 2001. |
| France/Police | The French police |
| French Institute of International Relations | A "national think tank" founded by Thierry de Montbrial. |
| French-American Foundation | A long established and relatively public organ of the US to control French politics. |
| General Directorate for Internal Security | |
| High Council on Public Health (France) | Responsible for providing decision support to the Minister of Health. Its extraordinary recommendations have played a big role in the implementation of the Covid-19 deep event in France. |
| Institut Aspen France | corporate-dominated transatlantic influence network |
| Institut Montaigne | French deep state 'think tank' filled with multiple bilderbergers. |
| Interpol | International police group. Several of the presidents of Interpol have been exposed as part of large corruption affairs, or engaged in torture. |
| Jean-Jacques Rousseau Institute | Neoconservative French think tank |
| L'Oréal | |
| La Francophonie | The French Commonwealth of Nations |
| Le Figaro | French newspaper owned by the armaments manufacturer Dassault Group since 2004. |
| Le Monde | |
| Le Siècle | A long established "bipartisan" network in the French establishment. |
| Lille University of Science and Technology | Includes a number of specialized education and research units |
| Lycée Henri-IV | Considered one of the most demanding and prestigious secondary schools in France. |
| Lycée Louis-le-Grand | |
| Mines ParisTech | |
| Montpellier 2 University | |
| National Rally | A French political party |
| OECD | Dedicate itself to help "democracy" and a "good world economy". Originally started to fund Western Europe in the cold war. |
| OEEC | The Organisation for European Economic Co-operation |
| Pantheon-Assas University | University which is considered the top law school in France. |
| Pantheon-Sorbonne University | |
| Paris Diderot University | |
| Paris-Saclay University | Paris university with high research activity. Before 2020 known as University of Paris-Sud |
| Pasteur Institute | Studies biology, microorganisms, diseases and vaccines. This also includes biological warfare. |
| Publicis Groupe | French multinational advertising and public relations company |
| Resistance International | A spooky anti-communist anti-communist organisation that existed between 1983 and 1988 |
| Saint-Cyr | The French Army's officer training establishment |
| Sanofi | French Big Pharma company |
