Semantic search
Jump to navigation
Jump to search
Query-Depth:0INDEX
Debug output SQLStore
ASK Query
[[Category:Cenozoic Erathem||Mesozoic Erathem||Paleozoic Erathem||Precambrian]]
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 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_id=885 OR t1.o_id=920 OR t1.o_id=896 OR t1.o_id=1545)
)
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
140
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 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_id=885 OR t1.o_id=920 OR t1.o_id=896 OR t1.o_id=1545)
)
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
140
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | range | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | 588 | Using where; Using index; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ilstratwiki_ILSTRAT.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneD
- Devonian System
- Dix Limestone Member
- Dolton Member
- Downeys Bluff Limestone
- Dresbachian Stage
- Drummond Member
- Dubuque Formation
- Duncan Mills Member
- Dunleith Formation
- Dutch Creek Sandstone Member
- Dutchtown Limestone
- Dykersburg Shale Member
E
- Eagle Point Member
- Eastern Granite-Rhyolite Province (Basement)
- Eau Claire Formation
- Edenian Stage
- Edgewood Formation
- Effingham Limestone Member
- Eldena Member
- Elgin Shale Member
- Elm Member
- Elmhurst Sandstone Member
- Elviran Stage
- Elwood Formation
- Embayment Megagroup
- Eminence Formation
- Energy Shale Member
- Enion Formation
- Eocene Series
- Equality Formation
- Esmond Till Member
- Establishment Member
- Everett Member
- Everton Dolomite
E cont.
F
- Fairplay Member
- Farmdale Soil
- Farmington Shale Member
- Fern Glen Formation
- Finnie Sandstone Member
- Flannigan Coal Member
- Flat Creek Coal Member
- Ford Station Limestone Member
- Forreston Member
- Fort Atkinson Limstone
- Fort Payne Formation
- Fox Valley Member
- Fraileys Shale
- Francis Creek Shale Member
- Franconia Formation
- Franconian Stage
- Fredonia Limestone Member
- Friendsville Coal Member
- Fults Member
G
G cont.
- Glen Dean Limestone
- Glen Park Formation
- Glenburn Till Member
- Glencoe Member
- Glenhaven Member
- Glenwood Formation
- Golconda Group
- Gordonville Member
- Goreville Limestone Member
- Grand Detour Formation
- Grand Tower Limestone
- Granger Sandstone Member
- Grassy Creek Shale
- Grassy Knob Chert
- Grayslake Peat
- Greenbush Coal Member or Bed
- Greenup Limestone Member
- Grigg tongue
- Grindstaff Sandstone Member
- Grove Church Shale
- Grover Gravel
- Gulfian Series
- Gunn Member
- Gunter Sandstone
- Guttenberg Formation
H