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
80
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
80
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
- Castlewood Member
- Cave Hill Shale Member
- Cayugan Series
- Cedar Bluff Limestone Group
- Cedar Valley Limestone
- Cenozoic Erathem
- Chalfin Member
- Champlainian Series
- Chana Member
- Chapel Coal Member
- Chapin Soil
- Charter Member
- Chazyan Stage
- Cheltenham Clay Member
- Chesterian Series
- Chouteau Limestone
- Cincinnatian Series
- Clayton Formation
- Clear Creek Chert
- Clement Member
- 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
C cont.
- Cramer Limestone Member
- Crane Member
- Creal Springs Limestone Member
- Cretaceous System
- Croixan Series
- Crowleys Ridge Silt
- Curlew Limestone Member
- Cypress Sandstone
D
- Dane Member
- Danville Coal Member
- Davenport Member
- Davis Coal Member or Bed
- Davis Member
- Daysville Dolomite Member
- De Graff Coal Member
- De Long Coal Member
- Decorah Subgroup
- Defiance Member
- Degonia Sandstone
- Dekoven Coal Member or Bed
- 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
D cont.
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
- Excello Shale Member
- Exline Limestone Member
F