Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Victim of::Assassination]] [[Constitutes::Politician]]
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='1626' AND t2.o_id='2653'
AND (t5.p_id='654' AND t5.o_id='4602')
)
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
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_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='1626' AND t2.o_id='2653'
AND (t5.p_id='654' AND t5.o_id='4602')
)
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
50
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 | 209 | Using temporary; Using filesort |
1 | SIMPLE | t5 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | p_id | 8 | const,wikispooks.t2.s_id | 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
NoneWikispooks page | Born | Died | Summary | Description |
---|---|---|---|---|
Fidél Pálffy | 6 May 1895 | 2 March 1946 | Politician | Hungarian agriculture minister, executed in 1946 |
RFK | 20 November 1925 | 6 June 1968 | Politician JFK/Assassination/Premature death | Brother of murdered US president John F. Kennedy, Robert had been his Attorney General and wanted to become US President himself so he could uncover his brothers killers. Assassinated. |
Yitzhak Rabin | 1 March 1922 | 4 November 1995 | Soldier Politician | Prime Minister of Israel, assassinated in office in 1995 |
Walther Rathenau | 29 September 1867 | 24 June 1922 | Journalist Politician Businessman | German Foreign Minister assassinated in office after signing the Treaty of Rapallo with the USSR. |
Claro M. Recto | 8 February 1890 | 2 October 1960 | Politician | Filipino politician possibly killed by the CIA |
Haruo Remeliik | 1 June 1933 | 30 June 1985 | Politician | The 1st President of Palau, assassinated in 1985 |
Detlev Rohwedder | 6 October 1932 | 1 April 1991 | Politician Businessperson | German politician, Bilderberg, assassinated. |
Ali Abdullah Saleh | 21 March 1947 | 4 December 2017 | Soldier Politician | President of Yemen 1990-2012, assassinated 2017 |
Lal Bahadur Shastri | 2 October 1904 | 11 January 1966 | Politician | Indian Prime Minister possibly assassinated by the CIA. |
Władysław Sikorski | 20 May 1881 | 4 July 1943 | Politician | Died in suspicious plane crash near Gibraltar |
Ivan Stambolić | 5 November 1936 | 25 August 2000 | Politician | Retired Serbian politician killed for murky motives |
Omar Torrijos | 13 February 1929 | 31 July 1981 | Politician | Leader of Panama who refused to compromise the interests of the Panamanians. Assassinated |
Boris Trajkovski | 25 June 1956 | 26 February 2004 | Politician | |
Denis Voronenkov | 10 April 1971 | 23 March 2017 | Politician | A vocal critic of Vladimir Putin. Assassinated in 2017. |
Paul Wellstone | 21 July 1944 | 25 October 2002 | Politician | An outspoken critic of the Iraq War, most certainly killed by the cabal. |
Sergei Yushenkov | 27 June 1950 | 17 April 2003 | Politician Russian apartment bombings/Premature death | A member of the ill-fated Kovalev Commission who was assassinated. |
Fatin Rüştü Zorlu | 20 April 1910 | 16 September 1961 | Diplomat Politician | Turkish diplomat and politician executed after the 1960 Turkish coup d'état, along with two other politicians. |
Jacobo Árbenz | 14 September 1913 | 27 January 1971 | Soldier Politician | A democratically elected President of Guatemala whom the CIA liquidated due to his land redistribution policy |
Zoran Đinđić | 1 August 1952 | 12 March 2003 | Politician | Prime Minister of Serbia. Assassinated, not necessarily by his opponents: "the moor has done his duty. The moor can go".... |