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
55
OFFSET
50
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
55
OFFSET
50
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 59''' Conceptual model of Pangea during a glacial episode of the Pennsylvanian. From Cecil, C.B., F.T. Dulong, R.R. West, R. Stamm, B. Wardlaw, and N.T. Edgar, 2003b, Climate controls on the stratigraphy of a Middle Pennsylvanian cyclothem in North America, in C.B. Cecil and N.T. Edgar, eds., Climate controls on stratigraphy: SEPM Special Publication 77, p. 151–180. Copyright © 2003, used with permission of SEPM; permission conveyed through Copyright Clearance Center, Inc. ITCZ, intertropical convergence zone.
- '''Figure 60''' Conceptual model of Pangea during an interglacial episode of the Pennsylvanian. From Cecil, C.B., F.T. Dulong, R.R. West, R. Stamm, B. Wardlaw, and N.T. Edgar, 2003b, Climate controls on the stratigraphy of a Middle Pennsylvanian cyclothem in North America, in C.B. Cecil and N.T. Edgar, eds., Climate controls on stratigraphy: SEPM Special Publication 77, p. 151–180. Copyright © 2003, used with permission of SEPM; permission conveyed through Copyright Clearance Center, Inc. ITCZ, intertropical convergence zone.