Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Think Tank]]
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
`en_smw_object_ids` AS t0
INNER JOIN
`en_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=41618)
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
208
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
`en_smw_object_ids` AS t0
INNER JOIN
`en_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=41618)
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
208
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 932 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ttnr_wiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Croatian Statehood Foundation (ZHDZ) (22 May 2015 11:40:05)
- Cul:tra (30 April 2015 16:33:28)
- Cultural Association Punto Rosso (30 April 2015 14:43:36)
- Círculo Acton Chile (23 June 2016 10:12:42)
- Danish Nudging Network (8 June 2017 20:34:29)
- De Gasperi Foundation (27 May 2015 09:49:55)
- De Warande (13 December 2012 12:38:08)
- Defence Against Terrorism (23 April 2019 13:27:58)
- Degussa Sonne/Mond Goldhandel GmbH (11 May 2020 14:29:04)
- Democracia & Desarrollo Internacional (12 October 2016 08:31:49)
- Democracy Lab- Costa Rica (25 September 2016 09:27:40)
- Democracy in Africa Research Unit (South Africa) (2 May 2015 14:18:20)
- Democracía & Mercado (30 June 2016 12:06:44)
- Democratic Civic Association (DCA) (17 June 2015 23:22:09)
- Demos (LT) (29 April 2015 11:07:21)
- Desiderius-Erasmus-Stiftung (1 December 2018 10:47:31)
- Deutsche Bank Research (30 May 2017 11:42:40)
- Deutsche Gesellschaft für Auswärtige Politik (German Council on Foreign Affairs) (18 December 2012 10:34:56)
- Deutsches Institut für Urbanistik (11 December 2014 13:41:41)
- Deutsches Institut für Wirtschaftsforschung e.V. (30 November 2016 21:53:22)
- Deutschlandbewegung (31 May 2017 07:00:34)
- Die Familienunternehmer - ASU (9 June 2015 10:03:01)
- Die Freie Welt (29 May 2017 13:41:10)
- Diktio Network (25 February 2016 21:38:41)
- E.G. West Centre (18 February 2013 17:21:58)
- E2T2 Hellenic Conservatives and Reformists' Think Tank (16 January 2014 14:48:31)
- ECIPE (2 June 2015 07:57:55)
- ECONWATCH (16 April 2015 17:11:13)
- EIKE (25 November 2019 09:34:43)
- EIPF (28 December 2012 06:57:04)
- ESEADE (3 March 2014 13:22:33)
- Earhart Foundation (27 December 2012 14:16:52)
- EcoAustria (9 June 2015 10:09:23)
- Economic Freedom and Social Progress Association (25 December 2012 16:40:54)
- Economic Policy Institute (2 May 2015 16:17:53)
- Economic Policy Research Institute (EPRI) (17 June 2015 22:33:04)
- Economic and Social Research Center (23 June 2014 15:10:30)
- Economic and Social Research Institute (9 June 2017 18:40:06)
- Economica Institut für Wirtschaftsforschung (1 January 2013 10:36:57)
- Ecopolis Foundation (26 May 2015 20:56:35)
- EdChoice (30 March 2017 13:48:35)
- Edmund Burke Institute (3 January 2013 08:39:36)
- Eduardo Frei Stichting (2 May 2015 09:36:49)
- Education for Democracy Foundation (23 January 2013 01:12:10)
- Educational Initiative for Central and Eastern Europe (EICEE) (22 January 2013 12:22:39)
- Eigentümlich Frei (19 May 2020 13:17:51)
- Ein Prozent (29 May 2017 09:52:41)
- Einaudi Institute for Economics and Finance (9 June 2015 11:14:01)
- El Ojo Digital (23 June 2016 12:26:55)
- Energy Security (23 April 2019 13:28:37)