Semantic search
SQLStore debug output
ASK Query
[[Publication year::1990]]
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_di_time` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_sortkey='2447892.5') AND t1.p_id='14252')
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_di_time` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_sortkey='2447892.5') AND t1.p_id='14252')
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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,p_id,o_sortkey,p_id_2,s_id_2 | p_id | 13 | const,const | 88 | Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneBotrychium acuminatum, Botrychium pallidum, Botrychium pseudopinnatum, Botrychium spathulatum, Brickellia coulteri var. brachiata, Brickellia lemmonii var. conduplicata, Bryolawtonia, Bryolawtonia vancouveriensis, Carex albicans var. australis, Carex albicans var. emmonsii, Carex bromoides subsp. montana, Cistanthe ambigua, Cistanthe maritima, Cistanthe monandra, Cistanthe monosperma, Cistanthe parryi, Cistanthe pulchella, Cistanthe pygmaea, Cistanthe quadripetala, Cistanthe rosea