Semantic search
SQLStore debug output
ASK Query
[[Authority::Linnaeus]]
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='Linnaeus') AND t1.p_id='14244')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
2
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='Linnaeus') AND t1.p_id='14244')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
2
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 | 1751 | 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
None- Acalypha virginica
- Achillea
- Achillea alpina
- Achillea millefolium
- Achillea nobilis
- Achillea ptarmica
- Achyranthes
- Achyranthes aspera
- Achyranthes aspera var. aspera
- Aconitum
- Aconitum uncinatum
- Acorus
- Acorus calamus
- Acrostichum
- Acrostichum aureum
- Actaea
- Adelia
- Adiantum
- Adiantum capillus-veneris
- Adiantum pedatum
- Adonis
- Adonis aestivalis
- Adonis annua
- Adonis vernalis
- Agave
- Agave americana
- Agave americana subsp. americana
- Agave americana var. americana
- Ageratum
- Ageratum conyzoides
- Agrimonia
- Agrostemma
- Agrostemma githago
- Agrostemma githago var. githago
- Alcea
- Alcea rosea
- Alchemilla
- Alchemilla alpina
- Aletris
- Aletris farinosa
- Alisma
- Alisma plantago-aquatica
- Allionia
- Allionia incarnata
- Allionia incarnata var. incarnata
- Allium
- Allium ampeloprasum
- Allium canadense
- Allium canadense var. canadense
- Allium cepa
- Allium fistulosum
- Allium nigrum
- Allium oleraceum
- Allium paniculatum
- Allium paniculatum var. paniculatum
- Allium rotundum
- Allium sativum
- Allium sativum var. sativum
- Allium schoenoprasum
- Allium triquetrum
- Allium victorialis
- Allium vineale
- Aloe
- Alstroemeria
- Althaea
- Althaea cannabina
- Althaea hirsuta
- Althaea officinalis
- Alyssum
- Amaranthus
- Amaranthus albus
- Amaranthus blitum
- Amaranthus caudatus
- Amaranthus cruentus
- Amaranthus deflexus
- Amaranthus graecizans
- Amaranthus hybridus
- Amaranthus hypochondriacus
- Amaranthus polygonoides
- Amaranthus retroflexus
- Amaranthus spinosus
- Amaranthus subg. Amaranthus
- Amaranthus tricolor
- Amaranthus viridis
- Ambrosia
- Ambrosia artemisiifolia
- Ambrosia trifida
- Ammannia
- Ammannia latifolia
- Anagallis
- Anagallis arvensis
- Anagallis monelli
- Andromeda
- Andromeda polifolia
- Andromeda polifolia var. polifolia
- Androsace
- Androsace elongata
- Androsace septentrionalis
- Anemone
- Anemone canadensis