Semantic search
SQLStore debug output
ASK Query
[[Author::Nancy R. Morin]]
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='Nancy R. Morin') 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
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Nancy R. Morin') 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
50
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 | 184 | 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
NoneL
- Linum australe var. glandulosum
- Linum berlandieri
- Linum berlandieri var. berlandieri
- Linum berlandieri var. filifolium
- Linum bienne
- Linum carteri
- Linum carteri var. carteri
- Linum carteri var. smallii
- Linum catharticum
- Linum compactum
- Linum elongatum
- Linum floridanum
- Linum floridanum var. chrysocarpum
- Linum floridanum var. floridanum
- Linum grandiflorum
- Linum harperi
- Linum hudsonioides
L cont.
- Linum imbricatum
- Linum intercursum
- Linum kingii
- Linum lewisii
- Linum lewisii var. alpicola
- Linum lewisii var. lepagei
- Linum lewisii var. lewisii
- Linum lundellii
- Linum macrocarpum
- Linum medium
- Linum medium var. medium
- Linum medium var. texanum
- Linum neomexicanum
- Linum perenne
- Linum pratense
- Linum puberulum
- Linum rigidum
L cont.
- Linum rigidum var. rigidum
- Linum rigidum var. simulans
- Linum rupestre
- Linum schiedeanum
- Linum sect. Cathartolinum
- Linum sect. Linopsis
- Linum sect. Linum
- Linum striatum
- Linum subteres
- Linum sulcatum
- Linum trigynum
- Linum usitatissimum
- Linum vernale
- Linum virginianum
- Linum westii
P