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
758
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
758
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- Osrodek Mysli Politycznej (16 June 2017 07:33:21)
- Pacific Research Institute (24 November 2016 14:07:20)
- Peru Liberal (22 April 2016 16:19:25)
- Peruventures (3 May 2017 08:35:00)
- Peruvian Institute of Free Enterprise (4 December 2012 13:51:14)
- Peutinger Collegium (10 December 2012 09:57:16)
- Philadelphia Society (27 December 2012 17:13:00)
- Philanthropy Roundtable (17 December 2012 16:02:39)
- Plenum der Ökonomen (30 May 2017 15:14:19)
- Poder Limitado (2 June 2015 15:34:57)
- Poesia y Politica (27 April 2016 12:47:26)
- Poesía y Política (26 April 2016 14:25:34)
- Policy Exchange (10 June 2015 07:21:31)
- Policy Network (18 May 2015 18:38:13)
- Polish Institute for International Relations (1 January 2013 11:54:34)
- Polish Institute of Foreign Affairs (10 December 2012 17:53:03)
- Polish-American Foundation for Economic Research and Education (22 January 2013 20:21:36)
- Politeia (17 June 2015 23:15:05)
- Political Theology (22 January 2013 09:14:20)
- Politically Incorrect (6 June 2017 12:23:05)
- Politicas Públicas para la Libertad (25 May 2016 12:46:06)
- Politische Akademie der ÖVP (PolAk) (3 June 2015 07:56:18)
- Prague Twenty (5 December 2012 07:47:48)
- Press Freedom Monitoring Centre (2 January 2013 10:17:02)
- Principios Republicanos para una Sociedad Abierta (7 July 2016 12:54:39)
- Pro Patria Institute (28 May 2015 07:30:04)
- ProMarktwirtschaft (21 May 2017 14:55:49)
- Prof.mr. B.M. Teldersstichting (22 June 2015 10:50:07)
- Progress Foundation (8 December 2014 11:11:24)
- Progress Institute for Social Democracy (3 June 2015 13:26:53)
- Progressive Thought Institute (3 June 2015 14:31:37)
- Progressive Vision (23 January 2013 14:46:05)
- Project for democratic union (25 February 2016 21:08:04)
- Prometheus - Das Freiheitsinstitut (8 December 2014 15:11:15)
- Public Choice Society (28 December 2012 07:17:33)
- Public Policy Forum (8 June 2017 20:20:04)
- Publixphere (25 February 2016 21:01:38)
- Quid Novi (28 May 2017 17:09:46)
- RAND Corporation (18 December 2014 15:07:24)
- Raggruppamento Europa Sociale (23 January 2013 14:49:04)
- Ratio Institute (3 June 2015 09:55:35)
- Re-Public (29 April 2015 10:00:28)
- Re:publik (5 October 2016 15:02:26)
- Reason Foundation (6 December 2012 13:11:02)
- Reason Public Policy Institute (26 April 2016 14:44:46)
- Red Liberal de America Latina - RELIAL (3 May 2017 08:50:07)
- Reform (19 June 2015 08:20:40)
- Reform Scotland (3 June 2015 11:35:16)
- Republican Confederation of Entrepreneurship (22 January 2013 20:22:39)
- Republikon Scientific, Educational and Research Foundation (22 June 2015 10:53:50)