Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:Trails]] [[Trailhead location::+]]
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 t2
INNER JOIN
`smw_di_coords` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=2190
AND (t4.p_id=511)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
100
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 t2
INNER JOIN
`smw_di_coords` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=2190
AND (t4.p_id=511)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 150 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t4 | ref | s_id, p_id | s_id | 8 | tehcc748_wikidb.t2.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | tehcc748_wikidb.t2.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneTrails | Trail Distance | City | Hike Time | Difficulty |
---|---|---|---|---|
Pine Trail | 0.0843 mi0.136 km <br /> | Kingsport | 0.167 Hours0.0104 Days <br />10 Min <br /> | Easy |
Point Lookout Trail | 1.9 mi3.058 km <br /> | Morristown | 1.5 Hours0.0938 Days <br />90 Min <br /> | Medium |
Pretty Ridge Trail | 1.716 mi2.762 km <br /> | Kingsport | 1.5 Hours0.0938 Days <br />90 Min <br /> | Hard |
Raider's Run Trail | 0.9 mi1.448 km <br /> | Marion | 0.5 Hours0.0313 Days <br />30 Min <br /> | Medium |
Rattlesnake Ridge | 3.524 mi5.671 km <br /> | Erwin | 6 Hours0.375 Days <br />360 Min <br /> | Hard |
Raven Rock | 0.965 mi1.553 km <br /> | Roan Mountain | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Ridge Crest Trail | 0.7 mi1.127 km <br /> | Morristown | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Ridge Ranger Trail | Jonesborough | {{{Difficulty Rating}}} | ||
Ridge Top (Roan Mountain State Park) | 0.229 mi0.368 km <br /> | Roan Mountain | 0.5 Hours0.0313 Days <br />30 Min <br /> | Easy |
Ridge Top (Warriors Path State Park) | 0.48 mi0.772 km <br /> | Kingsport | 0.5 Hours0.0313 Days <br />30 Min <br /> | Hard |
River Mountain Road | 3.205 mi5.158 km <br /> | Kingsport | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Riverbank | 0.24 mi0.386 km <br /> | Kingsport | 0.25 Hours0.0156 Days <br />15 Min <br /> | Easy |
Riverbend Park Path | 1.15 mi1.851 km <br /> | Kingsport | Easy | |
Riverfront Park Path | {{{Difficulty Rating}}} | |||
Riverside | 0.574 mi0.923 km <br /> | Roan Mountain | 1 Hours0.0625 Days <br />60 Min <br /> | Easy |
Road to Recycling Trail | 1.2 mi1.931 km <br /> | Morristown | 0.5 Hours0.0313 Days <br />30 Min <br /> | Easy |
Roaring Branch Trail | 3.868 mi6.225 km <br /> | Big Stone Gap | 7 Hours0.438 Days <br />420 Min <br /> | Hard |
Rock City | 0.5 mi0.805 km <br /> | Kingsport | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Rock Creek Falls | 1.49 mi2.398 km <br /> | Erwin | 3 Hours0.188 Days <br />180 Min <br /> | Easy |
Rogers Ridge Horse Trail | 6.811 mi10.961 km <br /> | Laurel Bloomery | 9 Hours0.563 Days <br />540 Min <br /> | Medium |
Seven Sinkholes Trail | 0.6 mi0.966 km <br /> | Morristown | 0.333 Hours0.0208 Days <br />20 Min <br /> | Easy |
Sill Branch | 0.56 mi0.901 km <br /> | Erwin | 1 Hours0.0625 Days <br />60 Min <br /> | Easy |
Sill Branch South | 1.39 mi2.237 km <br /> | Erwin | 0.75 Hours0.0469 Days <br />45 Min <br /> | Medium |
Sinking Waters | 1.75 mi2.816 km <br /> | Kingsport | 1 Hours0.0625 Days <br />60 Min <br /> | Easy |
Spivey Gap to Big Bald | 7.5 mi12.07 km <br /> | Erwin | 8 Hours0.5 Days <br />480 Min <br /> | Hard |
Spivey Gap to Nolichucky River | 11.2 mi18.025 km <br /> | Erwin | 5 Hours0.313 Days <br />300 Min <br /> | Medium |
Squibb Creek Falls | 2.525 mi4.064 km <br /> | Chuckey | 2.5 Hours0.156 Days <br />150 Min <br /> | Medium |
Summit Trail (Elk Knob) | 1.829 mi2.943 km <br /> | Todd | 2 Hours0.125 Days <br />120 Min <br /> | Medium |
Sweet Gum Trail | 0.0303 mi0.0488 km <br /> | Kingsport | 1.5 Hours0.0938 Days <br />90 Min <br /> | Easy |
TN91 to US421 | 6.5 mi10.461 km <br /> | Erwin | 5.3 Hours0.331 Days <br />318 Min <br /> | Medium |
Table Rock Summit Trail | 0.382 mi0.615 km <br /> | Linville | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Tanawha Trail | 12.53 mi20.165 km <br /> | Blowing Rock | 7 Hours0.438 Days <br />420 Min <br /> | Hard |
The Noggin Trail | 0.57 mi0.917 km <br /> | Johnson City | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Three Top Mountain | 1.99 mi3.203 km <br /> | Creston | 4 Hours0.25 Days <br />240 Min <br /> | Hard |
Tom Gray | 0.467 mi0.751 km <br /> | Roan Mountain | 0.5 Hours0.0313 Days <br />30 Min <br /> | Easy |
Tower Ridge Trail | 0.77 mi1.239 km <br /> | Johnson City | 1 Hours0.0625 Days <br />60 Min <br /> | Medium |
Towhee Trail | 0.0953 mi0.153 km <br /> | Kingsport | 1.5 Hours0.0938 Days <br />90 Min <br /> | Easy |
Turkey Trot | 0.409 mi0.658 km <br /> | Roan Mountain | 0.333 Hours0.0208 Days <br />20 Min <br /> | Medium |
US19E to Dennis Cove Rd | 23.19 mi37.321 km <br /> | Roan Mountain | 10.25 Hours0.641 Days <br />615 Min <br /> | Medium |
US421 to Damascus | 11.3 mi18.186 km <br /> | Erwin | 5 Hours0.313 Days <br />300 Min <br /> | Medium |
Virginia Creeper Trail | 34.67 mi55.796 km <br /> | Damascus | 2 Hours0.125 Days <br />120 Min <br /> | Medium |
Vista Trail | 0.4 mi0.644 km <br /> | Marion | 2 Hours0.125 Days <br />120 Min <br /> | Hard |
Wahoo | 1.72 mi2.768 km <br /> | Kingsport | 1.5 Hours0.0938 Days <br />90 Min <br /> | Medium |
White House Cliffs Trail | 0.946 mi1.522 km <br /> | Erwin | 2 Hours0.125 Days <br />120 Min <br /> | Medium |
White Rock Trail | 1.79 mi2.881 km <br /> | Johnson City | 1.5 Hours0.0938 Days <br />90 Min <br /> | Medium |
Whitetail Alternate | 0.2 mi0.322 km <br /> | Kingsport | 0.25 Hours0.0156 Days <br />15 Min <br /> | Medium |
Whitetail Loop | 2.306 mi3.711 km <br /> | Kingsport | 2.5 Hours0.156 Days <br />150 Min <br /> | Medium |
Wilbur Dam Rd to TN91 | 16.1 mi25.91 km <br /> | Elizabethton | 13.25 Hours0.828 Days <br />795 Min <br /> | Medium |
Woodland Ridge | 0.78 mi1.255 km <br /> | Kingsport | 0.75 Hours0.0469 Days <br />45 Min <br /> | Medium |
Zipline | 0.353 mi0.568 km <br /> | Kingsport | 0.5 Hours0.0313 Days <br />30 Min <br /> | Easy |