Semantic search
SQLStore debug output
ASK Query
[[Author::Lawrence K. Magrath]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Lawrence K. Magrath') AND t1.p_id='625')
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
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Lawrence K. Magrath') AND t1.p_id='625')
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,p_id,s_id_2,o_hash | p_id | 262 | const,const | 97 | Using index condition; 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
NoneC
- Calopogon
- Calopogon barbatus
- Calopogon multiflorus
- Calopogon oklahomensis
- Calopogon pallidus
- Calopogon tuberosus
- Calopogon tuberosus var. simpsonii
- Calopogon tuberosus var. tuberosus
- Corallorhiza
- Corallorhiza bentleyi
- Corallorhiza maculata
- Corallorhiza maculata var. maculata
- Corallorhiza maculata var. occidentalis
- Corallorhiza mertensiana
- Corallorhiza odontorhiza
- Corallorhiza odontorhiza var. odontorhiza
- Corallorhiza odontorhiza var. pringlei
C cont.
- Corallorhiza striata
- Corallorhiza striata var. striata
- Corallorhiza striata var. vreelandii
- Corallorhiza trifida
- Corallorhiza wisteriana
H
- Hexalectris
- Hexalectris grandiflora
- Hexalectris nitida
- Hexalectris revoluta
- Hexalectris spicata
- Hexalectris spicata var. arizonica
- Hexalectris spicata var. spicata
- Hexalectris warnockii
L
L cont.
- Listera
- Listera auriculata
- Listera australis
- Listera borealis
- Listera caurina
- Listera convallarioides
- Listera cordata
- Listera cordata var. cordata
- Listera cordata var. nephrophylla
- Listera ovata
- Listera smallii
M