Semantic search
SQLStore debug output
ASK Query
[[Author::James L. Reveal]]
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='James L. Reveal') 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
550
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='James L. Reveal') 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
550
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 | 842 | 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
NoneE
- Eriogonum twisselmannii
- Eriogonum umbellatum
- Eriogonum umbellatum var. ahartii
- Eriogonum umbellatum var. argus
- Eriogonum umbellatum var. aureum
- Eriogonum umbellatum var. bahiiforme
- Eriogonum umbellatum var. canifolium
- Eriogonum umbellatum var. chlorothamnus
- Eriogonum umbellatum var. cladophorum
- Eriogonum umbellatum var. cognatum
- Eriogonum umbellatum var. covillei
- Eriogonum umbellatum var. desereticum
- Eriogonum umbellatum var. devestivum
- Eriogonum umbellatum var. dichrocephalum
- Eriogonum umbellatum var. dumosum
- Eriogonum umbellatum var. ellipticum
- Eriogonum umbellatum var. furcosum
E cont.
- Eriogonum umbellatum var. glaberrimum
- Eriogonum umbellatum var. goodmanii
- Eriogonum umbellatum var. haussknechtii
- Eriogonum umbellatum var. humistratum
- Eriogonum umbellatum var. hypoleium
- Eriogonum umbellatum var. juniporinum
- Eriogonum umbellatum var. lautum
- Eriogonum umbellatum var. majus
- Eriogonum umbellatum var. minus
- Eriogonum umbellatum var. modocense
- Eriogonum umbellatum var. mohavense
- Eriogonum umbellatum var. munzii
- Eriogonum umbellatum var. nelsoniorum
- Eriogonum umbellatum var. nevadense
- Eriogonum umbellatum var. polyanthum
- Eriogonum umbellatum var. porteri
- Eriogonum umbellatum var. ramulosum
E cont.
- Eriogonum umbellatum var. sandbergii
- Eriogonum umbellatum var. smallianum
- Eriogonum umbellatum var. speciosum
- Eriogonum umbellatum var. stragulum
- Eriogonum umbellatum var. subaridum
- Eriogonum umbellatum var. torreyanum
- Eriogonum umbellatum var. umbellatum
- Eriogonum umbellatum var. vernum
- Eriogonum umbellatum var. versicolor
- Eriogonum ursinum
- Eriogonum ursinum var. erubescens
- Eriogonum ursinum var. ursinum
- Eriogonum vestitum
- Eriogonum villiflorum
- Eriogonum vimineum
- Eriogonum viridescens