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
20
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
20
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
NoneA
B
- Babylon Sandstone Member
- Backbone Limestone
- Bailey Limestone
- Bankston Fork Limestone Member
- Banner Formation
- Batavia Member
- Batestown Member
- Battery Rock Sandstone Member
- Baylis Formation
- Beaver Bend Limestone Member
- Beech Creek Limestone
- Beecher Member
- Belgium Member
- Bernadotte Sandstone Member
- Berry Clay Member
- Bethel Sandstone
- Beverly Tongue
- Bevier Coal Member or Bed
- Bidwell Coal Member
- Big Clifty Sandstone Member
- Big Creek Shale Member
- Bilyeu Member
- Birds Member
- Blackriveran Stage
- Blanding Formation
- Blocher Shale
- Blodgett Member
- Blomeyer Member
- Bogota Limestone Member
- Boles Member
- Bond Formation
- Bonpas Limestone Member
B cont.
- Borden Siltstone
- Brainard Shale
- Brandon Bridge Member
- Breezy Hill Limestone Member
- Brereton Limestone Member
- Briar Hill Coal Member
- Brickeys Member
- Briton Member
- Brush Coal Member
- Buckhorn Member
- Buelter Member
- Bunje Limestone Member
- Burlington Limestone
- Burroughs Limestone Member
C
- Cahokia Alluvium
- Calhoun Coal Member
- Cambrian System
- Canadian Series
- Canteen member
- Canton Shale Member
- Cape Limestone
- Capron Till Member
- Carbondale Formation
- Cardiff coal bed
- Carlinville Limestone Member
- Caseyville Formation
- Castlewood Member
- Cave Hill Shale Member
- Cayugan Series
- Cedar Bluff Limestone Group
- Cedar Valley Limestone
- Cenozoic Erathem
- Chalfin Member
- Champlainian Series
C cont.
- 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
- Cramer Limestone Member
- Crane Member
- Creal Springs Limestone Member
- Cretaceous System
- Croixan Series
- Crowleys Ridge Silt