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
16
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
16
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- Alexander Langer Foundation (30 April 2015 06:50:10)
- Allianz für den Rechtsstaat (29 May 2017 08:32:32)
- Alois Mock Institut (28 May 2017 16:03:47)
- Alternative Foundation (7 June 2015 12:08:36)
- American Economic Association (28 December 2012 07:16:43)
- American Enterprise Institute for Public Policy Research (3 November 2016 09:50:42)
- Americans for Tax Reform (22 January 2013 12:28:44)
- Amicus Europae Foundation (25 November 2018 20:35:18)
- Analytical Centre on Globalization and Regional Cooperation (ACGRC) (18 February 2013 17:38:05)
- Anders Chydenius Foundation (24 November 2014 14:03:40)
- Andes Libres (22 May 2017 08:34:58)
- Antall József Knowledge Centre (3 June 2015 17:35:37)
- Anton Tunega Foundation (27 May 2015 09:20:56)
- Arbejderbevaegelsens Erhvervsrad (3 May 2015 08:56:55)
- Arkansas Advocates for Children and Families (5 May 2021 17:55:26)
- Asian Institute of Policy Studies (6 December 2012 13:32:35)
- Asociacion Escuela Cristiana de Liderazgo (4 December 2013 11:25:19)
- Asociacion Nacional de Fomento Economico (2 March 2017 13:11:36)
- Asociacion de Consumidores Libres (8 June 2017 11:16:31)
- Association Culturelle Joseph Jacquemotte (5 June 2015 07:54:08)
- Association for Liberal Thinking (29 September 2016 17:54:38)
- Association for Modern Economy (10 November 2012 21:57:58)
- Association for the Development of the Romanian Social Forum (AD FSR) (1 May 2015 12:08:22)
- Association of Private Enterprise Education (22 January 2013 12:31:00)
- Associazione Bruno Trentin - ISF - IREF (3 May 2015 10:22:35)
- Atlantic Commission (Netherlands) (10 December 2012 10:57:51)
- Atlantik-Brücke e.V. (5 October 2016 14:00:59)
- Atlas Initiative für Recht und Freiheit e.V. (5 May 2020 13:21:01)
- Atlas Network (2 March 2017 13:21:06)
- Atvisa visuomene ir jos draugai (26 November 2014 17:03:00)
- Austrian Economics Center (24 September 2016 15:20:52)
- Austrian Institute for European Security Policy (1 June 2015 16:37:48)
- Avenir Suisse (19 December 2013 11:24:39)
- BEworks (25 June 2017 15:20:00)
- BVA Group - Nudge et Comportement (31 May 2017 11:01:19)
- Behavioral Economics Group (1 June 2017 10:04:23)
- Behavioral Science and Policy Association (14 August 2017 13:43:18)
- Behavioral Science and Policy Center (9 June 2017 13:45:01)
- Behavioural Economics Team of the Australian Government (9 June 2017 11:18:33)
- Behavioural Economics in Action at Rotman (BEAR) (17 August 2017 09:15:09)
- Behavioural Experiments in Health Network (31 May 2017 20:00:42)
- Behavioural Insights Team (9 June 2017 15:43:59)
- Behavioural Scientist (8 June 2017 20:41:39)
- Belarusian Institute for Strategic Studies (BISS) (17 June 2015 22:20:14)
- Berliner Institut für christliche Ethik und Politik (11 December 2014 13:45:29)
- Bertelsmann Foundation (21 October 2016 11:26:41)
- Bertil Ohlin Institute (22 June 2015 07:46:23)
- Bibliothek des Konservatismus (30 May 2017 12:53:59)
- Blaue Narzisse (29 May 2017 12:52:04)
- Bluegrass Institute for Public Policy Solutions (7 December 2012 07:55:07)