Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Victim of::Assassination]]OR[[Has deathCause::~*Assassination*]]
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
55
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
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 215 | 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='1626' AND t2.o_id='2653'
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t5.s_id FROM `mw_smw_di_wikipage` AS t5 INNER JOIN `mw_smw_object_ids` AS t7 ON t5.o_id=t7.smw_id WHERE t5.p_id='758' AND (t7.smw_sortkey LIKE '%Assassination%')
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneTitle | Date | Cause(s) | Official Story | Description |
---|---|---|---|---|
Beverly Eckert | The outspoken wife of a 9/11 victim who refused to accept the 9-11/Compensation fund and forcefully stating "My silence cannot be bought". | |||
Jeffrey Epstein | Billionaire who flew famous people on the Lolita Express to lavish parties on one a private island, which the locals dubbed "Orgy Island" or "Padeophile Island". A compulsive pedophile, he was convicted in 2008, given a cushy plea deal by use of deep state pressure. However, after this declared illegal in February 2019, after which people attempted to distance themselves from him. Re-arrested in June 2019, he was reportedly found dead of a "suicide" in prison although questions remain about this. | |||
Pablo Escobar | Drug kingpin who ran the Medellín drug cartel for the CIA. | |||
Cats Falck | Swedish journalist found dead after investigation arms trade. Lacklustre police investigation of death. | |||
Franz Ferdinand | The archduke whose assassination is widely cited as the proximate cause of World War I. | |||
Mario Ferraro | Italian spook who was assassinated in 1995 | |||
Pat Finucane | Catholic Belfast solicitor killed by loyalist paramilitaries on 12 February 1989 | |||
Joseph Fontanet | Associate of Antoine Pinay. Assassinated in 1980. | |||
Daniel Forestier | A DGSE agent who was assassinated in 2019 | |||
Pim Fortuyn | An assassinated Dutch politician | |||
Francisco Ortiz Franco | Mexican journalist assassinated within months of starting to write about drug trafficking. | |||
Muammar Gaddafi | ||||
Jorge Eliécer Gaitán | Colombian presidential candidate assassinated by the CIA in 1948 | |||
Daphne Caruana Galizia | The Maltese journalist and blogger who exposed the Panama Papers. Assassinated in 2017 by a car bomb | |||
Indira Gandhi | Le Cercle | |||
James Garfield | A US president who was assassinated | |||
Jeff German | Murdered journalist in Las Vegas | |||
Shukri Ghanem | ||||
Maurice Gibson | Judge killed by the IRA. | |||
Álvaro Gomez-Hurtado | Spooky Colombian diplomat who attended Le Cercle. Assassinated in 1995 | |||
John Francis Green | A member of the North Armagh Brigade of the Provisional IRA killed by death squad with links to British state forces | |||
Walter Guinness | Lord Moyne. An Anglo-Irish politician and businessman. Was Minister of State in UN Mandate Palestine in 1944 when he was assassinated by members of Lehi | |||
Jacob de Haan | An assassinated Dutch Zionist. | |||
Fred Hampton | Black rights activist, assassinated aged 21 | |||
Philip Haney | A DOHS whistleblower who suddenly died in February 2020 | |||
Chris Hani | Fierce opponent of the South African apartheid government, assassinated on 10 April 1993. | |||
Rafic Hariri | ||||
Michael Hastings | American journalist, author, contributing editor to Rolling Stone and reporter for BuzzFeed. | |||
Frank Hegarty | IRA member recruited as British informer. Executed in 1986 with direct involvement of Martin McGuinness. | |||
Alfred Herrhausen | Multi Bilderberg, Chairman of Deutsche Bank. Promoted the cancellation of unpayable debt. Assassinated in 1989 "in a military operation of a complexity without precedent" | |||
Roy Den Hollander | A "crazed gunman" who reportedly shot at the son and husband of Esther Salas, killing the former. | |||
Bill Hunter | A reported who investigated the JFK assassination. Shot dead by a policeman, reportedly accidentally. | |||
Iccho Itoh | Mayor of Nagasaki who denounced the use of nuclear weapons as a violation of international law in the Hague. Assassinated | |||
JFK | The last US president to effectively seek to promote the welfare of the US population. | |||
Kim Jae-gyu | As head of the KCIA he assassinated his boss, the South Korean president, Park Chung-hee | |||
Natacha Jaitt | Assassinated model who became a whistleblower for child sex abuse by Argentina's elite class | |||
Barry Jennings | A key 9/11 witness whose testimony contradicted the 9/11 report. He was reported dead without further explanation, aged 53. No death certificate is available on the internet, the cause of death is unknown & his entire family went missing without explanation at the same time. | |||
Danny Jowenko | Controlled demolition expert who was famously interviewed about the destruction of WTC7, later suddenly died | |||
Meir Kahane | A cofounder of the Jewish Defense League and founder of the Israeli political party Kach, he was assassinated in New York in 1990. | |||
Arjen Kamphuis | Dutch IT-expert with a Wikileaks connection. He disappeared during a trip in Norway in 2018. | |||
Liaquat Ali Khan | Pakistan's first and longest serving Prime Minister, murdered Afghan nationalist, or according to some theories, by the USA in order to facilitate their access to oil. | |||
Jamal Khashoggi | assassinated journalist | |||
Dorothy Kilgallen | A famous journalist who became interested in the JFK assassination and who died in highly suspicious circumstances of a drug overdose | |||
Paul Klebnikov | US journalist who was shot dead for his reporting in Russia. | |||
Huseyin Kocadağ | The former Istanbul Deputy police Chief killed in the Susurluk car crash | |||
Yoshio Kodama | ||||
Andrei Kozlov | On the Friday before he was assassinated, stated at a banking conference that "Those who have been found out laundering criminal money should probably be barred from staying in the banking profession for life. Such people disgrace the banking system." | |||
Kim Ku | An assassinated Korean politician -possibly by the Counterintelligence Corps or their stooge Syngman Rhee. | |||
Otakhon Latifi | Tajik Peace making politician. Assassinated in 1998 | |||
Maxim Lazovsky | Named as suspect in the 1999 Russian apartment bombings. Shot by unknown assassins. |