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
250
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
250
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- 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)
- Entscheidung für´s Leben (29 May 2017 08:54:16)
- Espaces Marx (1 May 2015 08:19:34)
- Estat.cz (9 June 2015 11:21:26)
- Estudantes Pela Liberdade (10 December 2013 12:52:33)
- Estudiantes por la Libertad (23 June 2016 12:41:53)
- Etopia (26 May 2015 21:02:56)
- Eudoxa (21 February 2014 12:03:43)
- Eurolib Network (2 June 2015 11:45:39)
- Europa Institut (22 January 2013 12:25:32)
- EuropaNova (25 February 2016 19:50:52)
- Europartenaires (5 May 2015 06:29:26)
- Europe of Citizens Foundation (17 June 2015 23:23:05)
- European Academy for Democracy (27 May 2015 11:54:04)
- European Academy of Yuste (5 December 2012 12:32:56)
- European Alternatives (25 February 2016 19:52:58)
- European Center of Austrian Economics Foundation (14 April 2015 11:07:01)
- European Coalition for Economic Growth (20 March 2013 12:58:42)
- European Committee For A Constructive Tomorrow (29 October 2018 13:14:08)
- European Council on Foreign Relations (5 December 2012 13:16:35)
- European Dignity Watch (30 May 2017 13:03:52)
- European Energy Institute (4 January 2013 09:05:44)
- European Enterprise Institute (5 June 2020 22:54:59)
- European Forum for Democracy and Solidarity (3 June 2015 12:43:20)
- European Ideas Network (EIN) (20 November 2014 14:05:17)
- European Institute for Climate and Energy (20 November 2012 13:13:26)
- European Law Institute (13 December 2012 09:37:49)
- European Liberal Forum (22 June 2015 08:02:07)
- European Liberal Youth (LYMEC) (3 June 2015 17:26:09)
- European Network of Political Foudations (4 December 2012 07:00:28)
- European Network of Political Foundation (ENoP) (22 January 2013 09:51:10)
- European Policy Center (6 December 2014 10:19:05)
- European Policy Forum (5 December 2014 20:50:22)
- European Policy Information Center (16 October 2016 21:21:52)
- European Renewal (16 June 2017 07:19:44)
- Europäisches Institut für Klima und Energie (10 December 2012 09:30:27)
- Evropska Akademie pro Demokracii (2 May 2015 09:42:11)
- Explosive Ordnance Disposal (23 April 2019 13:15:05)
- F.A.Hayek Foundation (Slovakia) (5 December 2012 08:22:26)
- F.A.Hayek Foundation Bratislava (7 December 2012 09:08:00)
- FEMAN (30 April 2015 12:14:15)
- FIEL - Fundacion de Investigaciones Economicas Latinoamericanas (9 May 2017 14:28:36)
- Federalismo y Libertad (6 April 2017 09:15:34)