Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Display date::+]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1021')
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
486
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1021')
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
486
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ref | s_id,p_id,s_id_2 | p_id | 4 | const | 34456 | Using temporary; Using filesort |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:1
Errors and Warnings
None| Page name | Display date |
|---|---|
| Hannes Androsch#_fe8c72ae55b9f031a1f881490abca826 | 1970 - 1981 |
| Marcia Angell#_8befc0dda7ca81dbf12e745848e1c061 | 1999 - June 2000 |
| Richard Angell#_068ba033fd70d17802b94ddf3841400b | November 2014 - Present |
| Joachim Angermeyer#_a6b2f038b22893b2e99b513afcd91126 | 1976 - 1980 |
| Elish Angiolini#_522c542f904480c68c49d1d5b4e1e044 | 12 October 2006 - 30 April 2011 |
| Elish Angiolini#_691fb45e1631a2504d89d3ecaa11d143 | September 2012 - Present |
| Elish Angiolini#_8dfc6961b5660e37d11d939986d27c5f | 28 November 2001 - 12 October 2006 |
| Dominique Anglade#_854aef0105dac9e7214edcd64446ab79 | October 11, 2017 - October 18, 2018 |
| Dominique Anglade#_9ff41c67a234329f3f5c9e47d66adb62 | May 11, 2020 - November 10, 2022 |
| Dominique Anglade#_cad6a1a169da375d5fc97635e17feff0 | May 11, 2020 - November 10, 2022 |
| Dominique Anglade#_eef155c1410ba7650f53bef04f7d0abc | November 9, 2015 - December 1, 2022 |
| Magdeleine Anglade#_2a2dd02ecceb1f6df6697d68c45dc802 | 6 October 1982 - 24 July 1989 |
| James Jesus Angleton#_3b6d403ca87ad3b945c8109904e08627 | 1954 - 1975 |
| Kofi Annan#_7763b47bc7ef1e5081499579b190e4eb | 1 January 1997 - 31 December 2006 |
| Kofi Annan#_da787538521bf1b86c6a9975739629bb | 23 February 2012 - 31 August 2012 |
| Tima Anselmi#_47f4708c0ca0971eb92091ac5404ca5a | 11 March 1978 - 4 August 1979 |
| Hubert Ansiaux#_633b3ae335c42012fe507fe21ee083f8 | 1957 - 1971 |
| Hubert Ansiaux#_97f9258de2719e8efb2870515673cbf0 | 1954 - 1957 |
| Hubert Ansiaux#_d0f977b5c52ab761c7fd44468618c7d6 | 1950 - 1955 |
| Harry Anslinger#_52617cc3bd08ec864563d5a9f3dc9a78 | August 12, 1930 - May 1962 |
| Frank Anthony#_ce93ff1b13b1660c0d24d1992f20b972 | 5 August 2020 - Present |
| Soraya Sáenz de Santamaría Antón#_556f8c931132bcac27a027f5bdfabe29 | 14 March 2004 - Present |
| Soraya Sáenz de Santamaría Antón#_5583c78ff72f7f9862989585cfdcad0d | 31 March 2008 - 13 December 2011 |
| Soraya Sáenz de Santamaría Antón#_5b61e27c9b3b91872c50949aa847207c | 26 November 2014 - 3 December 2014 |
| Soraya Sáenz de Santamaría Antón#_76bd1bf78ffc3dbcb988e911e26f39cd | 4 November 2016 - Present |
| Soraya Sáenz de Santamaría Antón#_7f962300516eeff9ae6511ed664aa0f8 | 22 December 2011 - Present |
| Soraya Sáenz de Santamaría Antón#_8394c63ff8a8a34bbbd65ec859f5f0b2 | 22 December 2011 - 7 June 2018 |
| Soraya Sáenz de Santamaría Antón#_a9cb4a026a62115b228d0dfe34bb2468 | 23 September 2014 - 29 September 2014 |
| Soraya Sáenz de Santamaría Antón#_b13ea633b1c0e1d60d5ea386a2563940 | 22 December 2011 - 4 November 2016 |
| Enrico Anzilotti#_0b9609e958fb9c82e0d11475f2394005 | 1957 - 24 July 1958 |
| Ertuğrul Apakan#_03dd363db5e8b098306c99e50118c0be | September 2009 - 2012 |
| Ertuğrul Apakan#_74747902eacfdaa25689f2a4d4c32f48 | January 2010 - December 31, 2010 |
| Ertuğrul Apakan#_827873386ef932d9e01164c56db9fef3 | 1 September 2010 - 30 September 2010 |
| Ertuğrul Apakan#_bc540a2e97a971d2202fbbccec625c53 | December 2006 - August 2009 |
| Matti Apunen#_6e09068ce1f69649acbcbbf401ea9d73 | 1 September 2019 - Present |
| Yasser Arafat#_639c7ae9b3109f93f2d60ede89a03d21 | 4 February 1969 - 29 October 2004 |
| Yasser Arafat#_84080582e0acc7aa5ed1d4af90a8a788 | 5 July 1994 - 11 November 2004 |
| Takis Arapoglou#_1665f3d6ff3e151490611c4610a77332 | 2004 - 2009 |
| Takis Arapoglou#_e247a8498ee9f5bcee12a89d24bf9352 | 14 May 2019 - Present |
| Ernesto Araújo#_56f52cd3933b18eb15bcf59da0be75cb | 1 January 2019 - 29 March 2021 |
| Louise Arbour#_31b7b576fcdde96440c70d3182bf54e2 | 1 July 2004 - 31 August 2008 |
| Louise Arbour#_dd3923f1505f45e07c8c464c31683dde | 9 March 2017 - Present |
| James Arbuthnot#_42836c329822916bd11c114d53583ef1 | 11 June 1987 - 8 April 1997 |
| James Arbuthnot#_47f1ecf93f0d12206cc5d8b1c4918a88 | 13 July 2005 - 14 May 2014 |
| James Arbuthnot#_82669f705d70aed51f6f8943d70859e0 | 6 November 2003 - 6 May 2005 |
| James Arbuthnot#_9a984f2040239b5aacdcd8523cb19baf | 6 July 1995 - 2 May 1997 |
| James Arbuthnot#_a1e9fb8c063920bdc60c458ed109467f | 1 October 2015 - Present |
| James Arbuthnot#_c9acd57ee11654a679899319dd740f22 | 5 December 2016 - Present |
| James Arbuthnot#_d3aa64c00a63a723c1f8006c8fdeed42 | 1 May 1997 - 30 March 2015 |
| James Arbuthnot#_f0a286e5035b4afd05da2fb0eff7b493 | 23 June 1997 - 18 September 2001 |
