Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Submitted by::Rich Arpi]]
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_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2926 AND t1.o_id=9105)
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
0
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_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2926 AND t1.o_id=9105)
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 66 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | protoballdb.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- Arctic Base Ball Club of St. Cloud
- Austin Base Ball Club
- Bemidji Base Ball Club
- Blue Earth City Base Ball Club
- Cass Base Ball Club of Brainerd
- Central Base Ball Club of St. Paul
- Champion Base Ball Club of Winona
- Crescent Club of Red Wing
- Detroit Lakes Base Ball Club
- Duluth Base Ball Club
- Eagles Base Ball Club of Wabasha
- Excelsior Club of Fort Snelling of St. Paul
- Fairgrounds, Minneapolis
- Frontier BBC of Mankato
- Gopher Base Ball Club of Owatonna
- Gopher State Base Ball Club of Rochester
- Grand Rapids Base Ball Club
- Hibbing Base Ball Club
- High school Club of Moorhead
- Lower Town Base Ball Club of St. Paul
- Marshall Base Ball Club
- Minneapolis Base Ball Club
- Minneapolis Brown Stockings
- Minneapolis Brown Stockings v Fargo, Dakota Territory on 28 June 1883
- Minneapolis Brown Stockings v Grand Forks, Dakota Territory on 4 July 1883
- Minnehaha Base Ball Club of Northfield
- Minnesota Chiefs Club of Stillwater
- Minnesota Chiefs Club of Stillwater v Minneapolis Brown Stockings on 8 August 1883
- Minnesota Chiefs Club of Stillwater v Red Caps Club of St. Paul on 7 October 1883
- Moorhead High School v Fargo High School on 7 June 1884
- Nininger Base Ball Club
- Nininger Base Ball Club v inter-squad on 15 August 1857
- Nininger Base Ball Club v inter-squad on 8 August 1857
- North Star Base Ball Club of St. Paul
- North Star Base Ball Club of St. Paul v Crescent Club of Red Wing on 21 June 1867
- North Star Base Ball Club of St. Paul v Davis & Webb on 13 May 1865
- North Star Base Ball Club of St. Paul v Excelsior Club of Fort Snelling of St. Paul on 18 May 1865
- North Star Base Ball Club of St. Paul v Frontier BBC of Mankato on 10 July 1867
- North Star Base Ball Club of St. Paul v Minneapolis Base Ball Club on 24 May 1867
- North Star Base Ball Club of St. Paul v Vermillion Base Ball Club of Hastings on 1 July 1865
- North Star Base Ball Club of St. Paul v Vermillion Base Ball Club of Hastings on 20 September 1865
- Olympic Club of St. Paul v Olympic Club of St. Paul on 28 May 1859
- Olympic Club of St. Paul v Olympic Club of St. Paul on 31 May 1859
- Olympics Base Ball Club of St. Paul
- Red Caps Club of St. Paul
- Red Caps Club of St. Paul v Former Red Caps (Alumni) on 2 May 1877
- Red Caps Club of St. Paul v Grand Forks, Dakota Territory on 5 July 1883
- Red Wing Base Ball Club
- Reds Base Ball Club of International Falls
- Redwood Falls Base Ball Club
- Seabury Base Ball Club of Faribault
- Shoo Flys Base Ball Club of New Ulm (near)
- Sooner Base Ball Club of Alexandria
- St. Croix Base Ball Club of Stillwater
- St. Peter Base Ball Club
- Thief River Falls Base Ball Club
- Tower Baseball Club
- Two Harbors Base Ball Club
- Union Base Ball Club of Lake City
- Upper Town Base Ball Club of St. Paul
- Upper Town Base Ball Club of St. Paul v Lower Town Base Ball Club of St. Paul on 15 August 1859
- Vermilion Base Ball Club of Ely
- Vermillion Base Ball Club of Hastings
- Virginia Baseball Club
- White Earth Base Ball Club of White Earth Objiwe Nation
- Worthington Base Ball Club