Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Victim of::Gun]]OR[[Has deathCause::~*Gun*]]
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
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_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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 94 | 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='2242576'
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 '%Gun%')
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneTitle | Description |
---|---|
Shinzō Abe | Japanese deep state actor and PM who aggressively re-militarised the country |
Hafizullah Amin | |
Anis Amri | Supposed perpetrator of the 2016 Berlin attack, termed "Not independently notable" by Wikipedia. |
Galip Balkar | Assassinated by Armenians while Turkish Ambassador to Yugoslavia |
Louis Barthou | |
Eddy Benavides | |
Charles-Victor Bracht | |
Jean de Broglie | The investigation into his 1976 assassination was soon classified as a military secret. |
Manuel Buendía | |
Mārtiņš Bunkus | Assassinated lawyer who had worked on suspect financial institutions in Riga |
Roland Carnaby | A senior spook who was shot by a Houston police officer following a high speed motor car chase and died of his wounds. |
Paul Castellano | "The Howard Hughes of the Mob" |
Sal Cincinelli | |
Kurt Cobain | Highly influential frontman of the rock band Nirvana |
Sam Cooke | Singer and Civil Rights activist. He was good friends with boxer Muhammad Ali and activist Malcolm X. Shot dead in Los Angeles motel, possibly as part of COINTELPRO. |
William Cooper | Announced around 10 weeks before 9/11 that "Whatever they're going to blame on Usama bin Laden - don't you believe it...They will soon do something outlandish to gain the support of the Sheeple".<a href="#cite_note-1">[1]</a> He was killed by the [[US Marshals Service]] less than two months after the event. |
Anastasio Somoza Debayle | Third generation "our son of a bitch" |
Richard Christian Dillard | American political staffer |
Silme Domingo | Assassinated labor activist, probably killed on orders of Ferdinand Marcos |
Denis Donaldson | Sinn Féin member exposed in December 2005 as an MI5 employee. Assassinated in 2006. |
Klaus Eberwein | A Haitian government official and businessman who was found dead with gunshot in head, a week before he was due to testify before the Haitian Senate’s Ethics and Anti-Corruption Commission. |
Kathy Ferguson | Co-defendant in the Paula Jones law suit against Bill Clinton. Died violently. |
Daniel Forestier | A DGSE agent who was assassinated in 2019 |
Francisco Ortiz Franco | Mexican journalist assassinated within months of starting to write about drug trafficking. |
Helric Fredou | A French policeman who reportedly shot himself just after the Charlie Hebdo attacks. |
Anastasio Somoza García | With the help of the US Marine Corps started a family dictatorship that maintained absolute control over Nicaragua for 42 years. |
Álvaro Gomez-Hurtado | Spooky Colombian diplomat who attended Le Cercle. Assassinated in 1995 |
François de Grossouvre | The spook in charge of Operation Gladio in France. |
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 |
Philip Haney | A DOHS whistleblower who suddenly died in February 2020 |
Frank Hegarty | IRA member recruited as British informer. Executed in 1986 with direct involvement of Martin McGuinness. |
Ernest Hemingway | American author hounded by the FBI |
Bill Hunter | A reported who investigated the JFK assassination. Shot dead by a policeman, reportedly accidentally. |
JFK | The last US president to effectively seek to promote the welfare of the US population. |
Kenneth Johannemann | A janitor at the World Trade Centre who saw explosions and rescued someone from the base of the buliding who had been burned by one. |
George F. Baker Jr | A "prominent socialite" shot dead in 1977. 1001 Club. His son was presumed dead after flying a small plane. |
Steve Kangas | A spook turned whistleblower who was one of the first political campaigners on the internet. Probably murdered by the US Deep state. |
Denis Kirejew | Ukrainian negotiator in early peace talks, shot for allegedly having shown pro-Russian tendencies. |
David Koresh | A cult leader shot dead in the Waco siege. |
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." |
Victor Kravchenko | |
Ivar Kreuger | Swedish match tycoon who was shot dead in a Paris hotel in 1932 |
Walter Krivitsky | A spook and defector |
Pedro Luis Díaz Lanz | Operation 40 pilot |
Maxim Lazovsky | Named as suspect in the 1999 Russian apartment bombings. Shot by unknown assassins. |
Thomas H. Lee | US businessman friend of Bill Clinton and Hillary Clinton. Gunshot to the head. |
Bing Liu | An assistant professor at the University of Pittsburgh School of Medicine, was found dead in his home in an apparent murder-suicide |
Anton Lubowski | Namibian anti-apartheid activist assassinated by South Africa's Civil Cooperation Bureau |
Darrell MacIntyre | A US Lawyer found dead in suspicious circumstances after he had been working on the "Iran-Contra" case. |
Mary Mahoney | White House intern murdered randomly just as she was to go public with her story of sexual harassment in the Clinton White House |