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, t4.o_sortkey
FROM
`en_smw_object_ids` AS t0
INNER JOIN
`en_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`en_smw_fpt_mdat` AS t4 ON t0.smw_id=t4.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
t4.o_sortkey DESC
LIMIT
105
OFFSET
108
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, t4.o_sortkey
FROM
`en_smw_object_ids` AS t0
INNER JOIN
`en_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`en_smw_fpt_mdat` AS t4 ON t0.smw_id=t4.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
t4.o_sortkey DESC
LIMIT
105
OFFSET
108
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 | |
1 | SIMPLE | t4 | ref | s_id | s_id | 4 | ttnr_wiki.t1.s_id | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Centre for Analysis of Risk and Regulation (CARR) (12 June 2017 20:53:36)
- The i-teams.org (11 June 2017 13:58:52)
- OECD - Observatory of Public Sector Innovation (11 June 2017 12:32:00)
- Roman Herzog Institut (11 June 2017 12:12:53)
- IZA - Institute of Labor Economics (9 June 2017 19:21:10)
- Economic and Social Research Institute (9 June 2017 18:40:06)
- Nudge.nl (9 June 2017 18:00:57)
- Norwegian Nudging Network, The (9 June 2017 17:54:01)
- Istituto Europeo per lo Studio del Comportamento Umano (9 June 2017 17:48:22)
- Nudge Italia (9 June 2017 17:31:27)
- Health Foundation, The (9 June 2017 16:07:12)
- Behavioural Insights Team (9 June 2017 15:43:59)
- Behavioral Science and Policy Center (9 June 2017 13:45:01)
- Institute for Government (UK) (9 June 2017 13:42:44)
- Mind, Behaviour, and Development Team (World Bank) (9 June 2017 11:36:30)
- Nudge Unit Greece (9 June 2017 11:20:22)
- Behavioural Economics Team of the Australian Government (9 June 2017 11:18:33)
- Social and Behavioral Sciences Team (Subcommittee) (9 June 2017 07:50:02)
- Forum for Reforms, Entrepreneurship and Sustainability (FORES) (9 June 2017 06:20:45)
- Swedish Nudging Network (9 June 2017 04:52:07)
- Behavioural Scientist (8 June 2017 20:41:39)
- Danish Nudging Network (8 June 2017 20:34:29)
- OECD - Behavioural Economics and Environmental Policy Design (8 June 2017 20:21:01)
- Public Policy Forum (8 June 2017 20:20:04)
- Mathematica Policy Research (8 June 2017 19:19:26)
- Joint Research Centre (8 June 2017 19:16:20)
- Harvard Behavioural Insights Group (8 June 2017 19:10:25)
- French Nudge Project (8 June 2017 19:00:38)
- OECD - Directorate for Public Governance (Regulatory Policy) (8 June 2017 18:41:08)
- Global Government Forum (8 June 2017 18:24:59)
- Ideas42 (8 June 2017 18:01:01)
- Corporacion Excelencia en la Justicia (8 June 2017 11:18:45)
- Instituto de Estudios Estrategicos e Internacionales (8 June 2017 11:17:26)
- Asociacion de Consumidores Libres (8 June 2017 11:16:31)
- IDEAL Instituto Desarrollo Ambiente y Libertad IDEAL Latinoamerica (8 June 2017 11:15:43)
- Centro Regional de Estrategias Economicas Sostenibles (8 June 2017 11:14:01)
- Centro de Economia, Sociedad y Empresa (ESE) (8 June 2017 11:03:05)
- Mexico Evalua (8 June 2017 10:42:43)
- Instituto de Desarrollo Empresarial y Accion Social IDEAS (8 June 2017 10:42:10)
- Accion Emprendedora (8 June 2017 10:41:40)
- Centro de Analisis para Politicas Publicas (8 June 2017 10:40:53)
- Liderazgo y Vision, A. C. (8 June 2017 10:39:52)
- Instituto de Ciencia, Economia, Educacion y Salud (8 June 2017 10:31:54)
- Instituto Liberal de Sao Paulo (8 June 2017 10:31:14)
- Lideres do Amanha (8 June 2017 10:29:28)
- Forma, Formacion y Accion (8 June 2017 10:28:54)
- Instituto de Formacao de Lideres (8 June 2017 10:28:14)
- Centro de Investigacion de Instituciones y Mercados de Argentina (8 June 2017 10:24:15)
- Gauche reformiste europeenne (8 June 2017 10:23:47)
- Fundacion Issos para la Libertad y el Desarrollo (8 June 2017 10:20:38)
- Fundacion para la Responsabilidad Intelectual (8 June 2017 10:16:15)
- Fundacion Chile Interactural (8 June 2017 10:13:29)
- Fundacion Instituto David Hume (8 June 2017 10:13:01)
- Fundacion Pensar Peru (8 June 2017 10:12:40)
- Fundacion Para el Desarrollo Integral de la Sociedad (8 June 2017 10:07:14)
- Fundacion Rafael del Pino (8 June 2017 10:06:24)
- Fundacion EQUO (8 June 2017 10:05:03)
- Fundacion Eleutera (8 June 2017 10:04:36)
- Fundacion Pensar (8 June 2017 10:04:04)
- Fundacion para el Progreso (8 June 2017 10:03:35)
- Fundacion Nueva Democracia (8 June 2017 10:03:06)
- Fundacion Nicaragüense para el Desarrollo Economico y Social (8 June 2017 10:02:41)
- Fundacion Libertad Paraguay (8 June 2017 10:02:09)
- Fundacion Jaime Guzman (8 June 2017 10:01:42)
- Fundacion Internacionalismo Democratico (8 June 2017 10:01:14)
- Fundacion Hayek Colombia (8 June 2017 10:00:26)
- Fundacion Global (8 June 2017 09:59:45)
- Fundacion Contemporanea (8 June 2017 09:59:23)
- Fundacion Civico Republicana (8 June 2017 09:58:54)
- Fundacion Bases (8 June 2017 09:58:21)
- Fundacion Libertad (8 June 2017 09:57:53)
- Fundacion Internacional para la Libertad (8 June 2017 09:56:52)
- Fundacion Salvadorena para el Desarrollo Economico y Social (8 June 2017 09:56:16)
- Fundacion Libertad - Panama (8 June 2017 09:55:18)
- Ifo Institut für Wirtschaftsforschung (6 June 2017 19:17:33)
- Politically Incorrect (6 June 2017 12:23:05)
- Junge Freiheit (5 June 2017 19:27:47)
- Centro de Implementacion de Politicas Publicas para la Equidad y el Crecimiento (5 June 2017 09:57:45)
- Zivile Koalition (1 June 2017 15:54:32)
- Wissensmanufaktur (1 June 2017 15:53:47)
- Stiftung Ja zum Leben (1 June 2017 15:51:06)
- Open Europe Berlin (1 June 2017 15:49:54)
- Institut für strategische Studien Berlin (1 June 2017 15:47:15)
- Institut für Demographie, Allgemeinwohl und Familie e.V. (1 June 2017 15:46:12)
- Förderstiftung konservative Bildung und Forschung (1 June 2017 15:45:06)
- Institut für Staatspolitik (1 June 2017 15:37:37)
- Union por la Libertad (1 June 2017 14:14:22)
- International Federation of Liberal Youth (1 June 2017 12:53:49)
- Interamerican Institute for Democracy (1 June 2017 12:44:06)
- Fundacion Iberoamerica Europa (1 June 2017 12:32:18)
- Centro de Estudios Libertad y Responsabilidad (1 June 2017 12:17:18)
- Fraser Institute (1 June 2017 12:12:32)
- Cato Institute (1 June 2017 12:10:50)
- Juan de Mariana Institute (1 June 2017 12:06:36)
- Caminos de la Libertad (1 June 2017 11:56:43)
- Central Innovation Hub (at the Privy Council) (1 June 2017 11:45:40)
- Fundacion Libertad y Progreso (1 June 2017 11:33:23)
- Behavioral Economics Group (1 June 2017 10:04:23)
- Behavioural Experiments in Health Network (31 May 2017 20:00:42)
- GovLab (NYU) (31 May 2017 19:49:43)