Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:places]]
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
30
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
30
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 2 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | htyp_mw.t2.id | 6 | 100.00 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | htyp_mw.t1.s_id | 1 | 83.77 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (6533).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=6533 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneArticle | Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. |
---|---|
Danielsville, GA | 3 June 2006 12:26:12 |
District of Columbia | 13 September 2008 00:22:38 |
Duke Forest | 29 August 2011 19:52:50 |
Durham Centre | 30 June 2013 16:10:16 |
Durham Farmers' Market | 12 July 2014 15:08:21 |
Earth | 21 February 2015 02:35:06 |
Earth orbit | 6 July 2015 00:43:56 |
Efland, NC | 28 October 2007 14:36:04 |
Elizabeth City, NC | 23 October 2006 17:00:19 |
Emerald Isle, NC | 29 August 2008 07:08:52 |
England | 4 October 2006 23:29:14 |
Eris | 13 September 2008 00:23:53 |
Farmersville, TX | 27 September 2008 13:56:26 |
Fayetteville, NC | 13 October 2008 11:57:07 |
Figure Eight Island | 17 July 2007 20:59:56 |
Florida | 25 July 2010 20:03:27 |
Galveston, TX | 3 August 2008 01:26:56 |
Gatlinburg, TN | 29 August 2008 07:11:28 |
Georgia (US) | 5 November 2007 02:16:44 |
Germany | 13 September 2008 00:24:51 |
Greenland | 18 June 2022 20:02:37 |
Greensboro, NC | 3 September 2007 18:33:03 |
Guadalajara, Jalisco | 3 December 2005 17:45:42 |
Guanajuato | 17 October 2005 20:18:12 |
Guanajuato, Guanajuato | 3 December 2005 17:43:04 |
Guatemala | 10 January 2007 20:57:27 |
Hereford, AZ | 19 January 2007 14:38:26 |
Hungary | 16 January 2013 21:08:01 |
Illinois | 13 August 2010 11:30:07 |
India | 11 July 2014 12:53:03 |
Indian Beach, NC | 18 July 2007 20:56:49 |
Indiana | 9 May 2006 18:18:14 |
Iraq | 27 November 2006 20:59:33 |
Israel | 6 December 2006 21:29:56 |
Jalisco | 13 September 2008 00:28:22 |
Japan | 13 September 2008 00:29:21 |
Jupiter | 13 September 2008 00:26:12 |
Keene, NH | 10 October 2005 16:38:48 |
Kennewick, WA | 9 October 2005 17:41:02 |
Kingston, PA | 22 May 2006 21:56:22 |
Lago de Atitlán | 10 January 2007 20:59:28 |
Lago de Atitlán | 10 January 2007 20:59:28 |
Luna | 13 September 2008 00:34:00 |
Malaysia | 15 November 2006 21:27:59 |
Mars | 28 September 2015 19:47:52 |
Massachusetts | 21 August 2008 20:08:44 |
Mexico | 13 September 2008 00:35:53 |
Michigan | 8 September 2007 20:54:53 |
Middle East | 21 December 2006 19:10:39 |
Morehead City, NC | 17 July 2007 21:56:43 |