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
170
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
170
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
NoneE
- Esmond Till Member
- Establishment Member
- Everett Member
- Everton Dolomite
- Excello Shale Member
- Exline Limestone Member
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.
- Gila Limestone Member
- Gimlet Sandstone Member
- Girardeau Limestone
- Glasford Formation
- 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
H cont.
- Hannibal Shale
- Hanover Limestone Member
- Hardinsburg Sandstone
- Harkness Silt Member
- Harmattan Till Member
- Harmony Hill Shale Member
- Harrodsburg Limestone Member
- Hazel Green Member
- Hazelwood Member
- Hegeler Till Member
- Hely Member
- Hennepin Member
- Henry Formation
- Hermon Coal Member
- Herrin Coal Member
- Hillery Till Member
- Hoing Sandstone Member
- Holocene Series
- Hombergian Stage
- Houchin Creek Coal Member
- Howardton Limestone Member
- Hulick Till Member
- Hunton Limestone Megagroup
I
J