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, t4.o_sortkey
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
INNER JOIN
`smw_fpt_mdat` AS t4 ON t0.smw_id=t4.s_id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
505
OFFSET
50
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
`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
INNER JOIN
`smw_fpt_mdat` AS t4 ON t0.smw_id=t4.s_id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
505
OFFSET
50
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 | t4 | ref | s_id | s_id | 4 | htyp_mw.t1.s_id | 1 | 100.00 | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | htyp_mw.t1.s_id | 1 | 83.76 | 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>. |
---|---|
The Netherlands | 14 February 2009 23:49:04 |
New York, NY | 4 February 2009 16:06:47 |
Fayetteville, NC | 13 October 2008 11:57:07 |
Ann Arbor, MI | 27 September 2008 13:56:34 |
Farmersville, TX | 27 September 2008 13:56:26 |
Mexico | 13 September 2008 00:35:53 |
Luna | 13 September 2008 00:34:00 |
Japan | 13 September 2008 00:29:21 |
Jalisco | 13 September 2008 00:28:22 |
Jupiter | 13 September 2008 00:26:12 |
Germany | 13 September 2008 00:24:51 |
Eris | 13 September 2008 00:23:53 |
District of Columbia | 13 September 2008 00:22:38 |
Cabo San Lucas, Baja California Sur | 13 September 2008 00:20:13 |
Dallas, TX | 29 August 2008 07:11:57 |
Gatlinburg, TN | 29 August 2008 07:11:28 |
Winston-Salem, NC | 29 August 2008 07:11:00 |
Emerald Isle, NC | 29 August 2008 07:08:52 |
Massachusetts | 21 August 2008 20:08:44 |
Apex, NC | 21 August 2008 20:08:35 |
Norway | 4 August 2008 13:04:26 |
Galveston, TX | 3 August 2008 01:26:56 |
San Diego, CA | 23 April 2008 22:11:00 |
Atlantic Beach, NC | 3 March 2008 01:16:15 |
Myrtle Beach, SC | 14 February 2008 03:43:29 |
American Tobacco Campus | 11 November 2007 02:32:50 |
Georgia (US) | 5 November 2007 02:16:44 |
the Hollywood sign | 29 October 2007 17:11:46 |
Utrecht | 28 October 2007 14:36:45 |
Efland, NC | 28 October 2007 14:36:04 |
Arkansas | 28 October 2007 14:28:43 |
Virginia | 16 October 2007 19:05:04 |
Belgium | 15 October 2007 15:01:18 |
Nigeria | 15 October 2007 14:56:29 |
Bangladesh | 15 October 2007 14:54:54 |
Morocco | 15 October 2007 14:54:09 |
Sweden | 15 October 2007 14:54:07 |
Oklahoma | 14 October 2007 01:31:40 |
Arizona | 14 October 2007 01:29:50 |
Nineveh, NY | 12 October 2007 18:29:18 |
RTP, NC | 25 September 2007 11:10:30 |
Michigan | 8 September 2007 20:54:53 |
Greensboro, NC | 3 September 2007 18:33:03 |
Redwood City, CA | 23 July 2007 01:31:22 |
Indian Beach, NC | 18 July 2007 20:56:49 |
Morehead City, NC | 17 July 2007 21:56:43 |
Figure Eight Island | 17 July 2007 20:59:56 |
Boston, MA | 5 April 2007 22:27:09 |
Switzerland | 4 April 2007 12:57:20 |
Ohio | 1 April 2007 21:44:18 |
Morrisville, NC | 20 March 2007 21:40:30 |
China | 14 February 2007 20:55:08 |
United Kingdom | 27 January 2007 19:09:29 |
Slovenia | 24 January 2007 14:13:44 |
Spain | 24 January 2007 14:11:29 |
Hereford, AZ | 19 January 2007 14:38:26 |
Lago de Atitlán | 10 January 2007 20:59:28 |
Lago de Atitlán | 10 January 2007 20:59:28 |
Guatemala | 10 January 2007 20:57:27 |
Panajachel | 10 January 2007 13:51:54 |
America | 3 January 2007 02:52:03 |
Wilmington, NC | 31 December 2006 19:14:33 |
Middle East | 21 December 2006 19:10:39 |
Israel | 6 December 2006 21:29:56 |
Iraq | 27 November 2006 20:59:33 |
South Dakota | 18 November 2006 14:01:32 |
Malaysia | 15 November 2006 21:27:59 |
Elizabeth City, NC | 23 October 2006 17:00:19 |
Washington, NC | 13 October 2006 19:55:59 |
New Mexico | 12 October 2006 16:36:06 |
England | 4 October 2006 23:29:14 |
Santiago Atitlán | 19 August 2006 13:23:28 |
Santiago Atitlán | 19 August 2006 13:23:28 |
Washington | 19 August 2006 12:52:15 |
Tennessee | 16 August 2006 13:54:01 |
Northport, AL | 20 July 2006 11:51:48 |
Alabama | 20 July 2006 11:47:40 |
South Carolina | 15 June 2006 21:01:26 |
Danielsville, GA | 3 June 2006 12:26:12 |
Kingston, PA | 22 May 2006 21:56:22 |
Pennsylvania | 22 May 2006 21:53:01 |
Indiana | 9 May 2006 18:18:14 |
Athens, WV | 8 April 2006 15:06:58 |
Richmond, IN | 7 April 2006 21:50:59 |
Tonalá, Jalisco | 26 March 2006 19:04:27 |
Tonalá, Jalisco | 26 March 2006 19:04:27 |
Providence, RI | 26 March 2006 18:51:53 |
Belarus | 18 March 2006 19:17:35 |
Atlanta, GA | 5 March 2006 17:20:51 |
Alaska | 17 February 2006 16:00:06 |
Puerto Vallarta, Jalisco | 3 December 2005 17:46:35 |
Guadalajara, Jalisco | 3 December 2005 17:45:42 |
Guanajuato, Guanajuato | 3 December 2005 17:43:04 |
Baja California Sur | 3 December 2005 17:32:52 |
Canton, NC | 23 November 2005 22:15:19 |
Salisbury, NC | 19 November 2005 17:33:43 |
Guanajuato | 17 October 2005 20:18:12 |
Keene, NH | 10 October 2005 16:38:48 |
Chicago, IL | 9 October 2005 20:48:39 |
Cary, NC | 9 October 2005 19:59:41 |
Bainbridge, NY | 9 October 2005 19:53:02 |
Sierra Vista, AZ | 9 October 2005 19:27:55 |
Kennewick, WA | 9 October 2005 17:41:02 |