Semantic search
SQLStore debug output
ASK Query
[[Place.City.In county.In state::Texas]] [[Rtype::intercity bus||airporter]]
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_di_wikipage` AS t2
INNER JOIN
`wiki_t3` AS t3 ON t2.p_id=t3.id
INNER JOIN
(`wiki_smw_di_wikipage` AS t4
INNER JOIN
(`wiki_smw_di_wikipage` AS t6
INNER JOIN
`wiki_smw_di_wikipage` AS t8 ON t6.o_id=t8.s_id) ON t4.o_id=t6.s_id) ON t2.o_id=t4.s_id
INNER JOIN
`wiki_smw_di_blob` AS t11 ON t2.s_id=t11.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id='318791'
AND (t6.p_id='318798'
AND (t8.p_id='318799' AND t8.o_id='95559')
))
AND (
((t11.o_hash='intercity bus') OR (t11.o_hash='airporter')
) AND t11.p_id='318838')
)
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
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, t0.smw_sort
FROM
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_di_wikipage` AS t2
INNER JOIN
`wiki_t3` AS t3 ON t2.p_id=t3.id
INNER JOIN
(`wiki_smw_di_wikipage` AS t4
INNER JOIN
(`wiki_smw_di_wikipage` AS t6
INNER JOIN
`wiki_smw_di_wikipage` AS t8 ON t6.o_id=t8.s_id) ON t4.o_id=t6.s_id) ON t2.o_id=t4.s_id
INNER JOIN
`wiki_smw_di_blob` AS t11 ON t2.s_id=t11.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id='318791'
AND (t6.p_id='318798'
AND (t8.p_id='318799' AND t8.o_id='95559')
))
AND (
((t11.o_hash='intercity bus') OR (t11.o_hash='airporter')
) AND t11.p_id='318838')
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t11 | range | s_id,p_id,s_id_2,o_hash | p_id | 262 | 896 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | transitunlimited.t11.s_id | 1 | Using where |
1 | SIMPLE | t2 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 4 | transitunlimited.t11.s_id | 2 | Using where; Using index; Distinct |
1 | SIMPLE | t3 | ALL | PRIMARY | 3 | Using where; Distinct; Using join buffer (Block Nested Loop) | |||
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 8 | transitunlimited.t2.o_id,const | 2 | Using where; Using index; Distinct |
1 | SIMPLE | t6 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 8 | transitunlimited.t4.o_id,const | 2 | Using where; Using index; Distinct |
1 | SIMPLE | t8 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_2 | 9 | transitunlimited.t6.o_id,const | 1 | Using where; Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) ('318779').
SELECT s_id FROM `wiki_smw_fpt_subp` WHERE o_id='318779' LIMIT 1
Query Metrics
Query-Size:8Query-Depth:4
Errors and Warnings
NoneService to San Antonio, Amarillo. Ticket sales is available at this location. Current bus status
Service to Dallas, Houston. Ticket sales is available at this location. Current bus status
Service to Atlanta, New Orleans, Houston, Orlando, Miami. Ticket sales is available at this location. Current bus status
Service to Laredo, Harlingen. Ticket sales is available at this location. Current bus status
Service to Phoenix, Dallas, Amarillo, San Antonio. Ticket sales is available at this location. Current bus status
Service to Lubbock, El Paso. Ticket sales is available at this location. Current bus status
Service to Houston, Orlando, Miami. Ticket sales is available at this location. Current bus status
Service to Houston. Ticket sales is available at this location. Current bus status
Service to Dallas, Houston. Ticket sales is available at this location. Current bus status
Service to San Antonio. Ticket sales is available at this location. Current bus status
Service to Detroit, St Louis, Richmond, Nashville, Atlanta, Phoenix, Houston, Kansas City, Denver, Tulsa. Ticket sales is available at this location. Current bus status
Service to San Antonio, Del Rio. Ticket sales is available at this location. Current bus status
Service to Dallas, Kansas City, St. Louis. Ticket sales is available at this location. Current bus status
Service to Denver, Dallas. Ticket sales is available at this location. Current bus status
Service to Phoenix, Dallas, Los Angeles, Denver, Amarillo. Ticket sales is available at this location. Current bus status
Service to Amarillo, San Antonio. Ticket sales is available at this location. Current bus status
Service to San Antonio, Del Rio. Ticket sales is available at this location. Current bus status
Service to Amarillo, San Antonio. Ticket sales is available at this location. Current bus status
Service to Amarillo, El Paso. No ticket sales available at this location. Current bus status
Service to Phoenix, Houston. No ticket sales available at this location. Current bus status
Service to Phoenix, Houston, Okhlahoma City, Denver, Los Angeles. Ticket sales is available at this location. Current bus status
Service to Dallas, Kansas City, St. Louis. Ticket sales is available at this location. Current bus status
Service to San Antonio, Del Rio. No ticket sales available at this location. Current bus status
Service to Houston, Texarkana. No ticket sales available at this location. Current bus status
Service to Amarillo, El Paso. No ticket sales available at this location. Current bus status
Service to Laredo. Ticket sales is available at this location. Current bus status
Service to Dallas, Houston. Ticket sales is available at this location. Current bus status
Service to Atlanta, Orlando, Miami, Phoenix, Dallas, San Antonio, Corpus Christi, Texarkana. Ticket sales is available at this location. Current bus status
Service to Dallas, Houston. No ticket sales available at this location. Current bus status
Service to Phoenix, Houston. Ticket sales is available at this location. Current bus status
Service to Atlanta, Dallas. Ticket sales is available at this location. Current bus status
Service to Phoenix, Houston, Amarillo, San Antonio. Ticket sales is available at this location. Current bus status
Service to Houston, San Antonio. Ticket sales is available at this location. Current bus status
Service to Dallas, Atlanta, Houston, Texarkana. Ticket sales is available at this location. Current bus status
Service to Houston, Texarkana. Ticket sales is available at this location. Current bus status
Service to Houston, Texarkana. Ticket sales is available at this location. Current bus status
Service to Laredo - Harlingen. Ticket sales is available at this location. Current bus status
Service to Amarillo, Dallas, San Antonio, Denver. Ticket sales is available at this location. Current bus status
Service to Okhlahoma City, Kansas City. No ticket sales available at this location. Stops at Highland Lakes Chevron across the street. Current bus status
Service to Dallas, Tulsa. No ticket sales available at this location. Current bus status
Service to Laredo, Harlingen. Ticket sales is available at this location. Current bus status
Service to Dallas, Nashville, Detroit, Richmond. Ticket sales is available at this location. Current bus status
Service to Houston, Corpus Christi. Ticket sales is available at this location. Current bus status
Service to Amarillo, San Antonio. Ticket sales is available at this location. Current bus status
Service to Dallas, Atlanta, Houston, Texarkana. Ticket sales is available at this location. Current bus status
Service to Houston, Texarkana. Ticket sales is available at this location. Current bus status
Service to Dallas, Houston. Ticket sales is available at this location. Current bus status
Service to Phoenix, Dallas. Ticket sales is available at this location. Current bus status
Service to Phoenix, Dallas. Ticket sales is available at this location. Current bus status
Service to Dallas, Houston. Ticket sales is available at this location. Current bus status