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
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 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
100
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
NoneC
- Clermont Shale Member
- Clore Formation
- Coffeen Limestone Member
- Coggan Member
- Cohn Coal Member
- Colchester Coal Member
- Conant Limestone Member
- Cooper Limestone Member
- Copperas Creek Sandstone Member
- Cora Limestone Member
- Coralville Member
- County Line (Alburnett) silt
- Covel Conglomerate Bed
- Coxville Sandstone Member
- Cramer Limestone Member
- Crane Member
- Creal Springs Limestone Member
- Cretaceous System
- Croixan Series
- Crowleys Ridge Silt
- Curlew Limestone Member
- Cypress Sandstone
D
D cont.
- Delafield Member
- Delavan Member
- Delwood Coal Member
- Dement Member
- Derby-Doerun Member
- Desmoinesian Series
- 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
E cont.
- Eocene Series
- Equality Formation
- 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