Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:Circular 605]] [[Page used::Galatia Channel:Figures]] [[Has image::Yes]] [[Image no::~*Figure*]]
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 t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_wikipage` AS t7 ON t2.s_id=t7.s_id
INNER JOIN
(`smw_di_wikipage` AS t10
INNER JOIN
`smw_object_ids` AS t12 ON t10.o_id=t12.smw_id) ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3080
AND (t4.p_id=3113 AND t4.o_id=3098)
AND (t7.p_id=3109 AND t7.o_id=3110)
AND (t10.p_id=3111
AND (t12.smw_sortkey LIKE '%Figure%')
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
0
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 t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_wikipage` AS t7 ON t2.s_id=t7.s_id
INNER JOIN
(`smw_di_wikipage` AS t10
INNER JOIN
`smw_object_ids` AS t12 ON t10.o_id=t12.smw_id) ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3080
AND (t4.p_id=3113 AND t4.o_id=3098)
AND (t7.p_id=3109 AND t7.o_id=3110)
AND (t10.p_id=3111
AND (t12.smw_sortkey LIKE '%Figure%')
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 110 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t4 | ref|filter | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id|o_id | 8|5 | const, ilstratwiki_ILSTRAT.t2.s_id | 1 (6%) | Using where; Using rowid filter | |
1 | SIMPLE | t10 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, ilstratwiki_ILSTRAT.t2.s_id | 1 | Using where | |
1 | SIMPLE | t7 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | s_id_3 | 13 | ilstratwiki_ILSTRAT.t2.s_id, const, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ilstratwiki_ILSTRAT.t2.s_id | 1 | Using where | |
1 | SIMPLE | t12 | ref | PRIMARY, smw_id | smw_id | 4 | ilstratwiki_ILSTRAT.t10.o_id | 1 | Using where; Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
None- '''Figure 5a''' Wireline log illustrating the typical response of key units. (a) Electric log of Carter Oil No. 1 Beers well in sec. 28, T8S, R4E, Williamson County, Illinois (county no. 2107). B, Brereton Limestone; H, Herrin Coal; Sp, Springfield Coal; Han, Hanover Limestone; HC, Houchin Creek Coal; SV, Survant Coal; MQ, Mecca Quarry Shale; C, Colchester Coal. (b) Gamma-ray–resistivity log of Peabody Natural Gas No. 2 Short, in sec. 14, T7S, R7E, Hamilton County (county no. 25375).
- '''Figure 5b''' Wireline log illustrating the typical response of key units. (a) Electric log of Carter Oil No. 1 Beers well in sec. 28, T8S, R4E, Williamson County, Illinois (county no. 2107). B, Brereton Limestone; H, Herrin Coal; Sp, Springfield Coal; Han, Hanover Limestone; HC, Houchin Creek Coal; SV, Survant Coal; MQ, Mecca Quarry Shale; C, Colchester Coal. (b) Gamma-ray–resistivity log of Peabody Natural Gas No. 2 Short, in sec. 14, T7S, R7E, Hamilton County (county no. 25375).
- '''Figure 13''' Photographs showing the ragged, erosive contact between the light-colored siltstone of the Dykersburg Member and the underlying coaly shale of the Galatia Member in the channel crossing at the Galatia Mine, Saline County, Illinois. (a) View of the east wall of the entry. Coaly shale of the Galatia Member grades laterally northward (left, out of view) to shaly Springfield Coal. The pick is approximately 2 ft (60 cm) long. (b) Close-up view on the west wall of the entry. The heart of the Galatia channel is south (left) of view. Notice how erosion undercut the clay below layers of tough, fibrous peat.
- '''Figure 15''' Photograph showing rhythmic lamination in sandy facies of the Dykersburg Member in American Coal’s Millennium Mine, Saline County, Illinois. Enlarged view at right. Reprinted from Palaeogeography, Palaeoclimatology, Palaeoecology, v. 487, p. 74, W.A. DiMichele, S.D. Elrick, and W.J. Nelson, Vegetational zonation in a swamp forest, Middle Pennsylvanian, Illinois Basin, U.S.A., indicates niche differentiation in a wetland plant community. Copyright 2017, with permission from Elsevier.