Semantic search
SQLStore debug output
ASK Query
[[Volume::Volume 28]]
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='633' AND t1.o_id='706')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
255
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='633' AND t1.o_id='706')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
255
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 1004 | Using where; 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
NoneB
- Bartramia halleriana
- Bartramia ithyphylla
- Bartramia pomiformis
- Bartramia potosica
- Bartramia stricta
- Bartramia subulata
- Bartramiaceae
- Bestia
- Bestia longipes
- Brachelyma
- Brachelyma subulatum
- Brachymenium
- Brachymenium macrocarpum
- Brachymenium mexicanum
- Brachytheciaceae
- Brachytheciastrum
- Brachytheciastrum collinum
- Brachytheciastrum delicatulum
- Brachytheciastrum fendleri
- Brachytheciastrum leibergii
- Brachytheciastrum trachypodium
- Brachytheciastrum velutinum
- Brachytheciastrum velutinum var. salicinum
- Brachytheciastrum velutinum var. velutinum
- Brachythecium
- Brachythecium acuminatum
- Brachythecium acutum
- Brachythecium albicans
- Brachythecium asperrimum
- Brachythecium bolanderi
- Brachythecium boreale
- Brachythecium brandegeei
- Brachythecium campestre
- Brachythecium cirrosum
- Brachythecium coruscum
- Brachythecium erythrorrhizon
- Brachythecium erythrorrhizon var. alpinum
- Brachythecium erythrorrhizon var. erythrorrhizon
- Brachythecium frigidum
- Brachythecium jacuticum
- Brachythecium laetum
- Brachythecium rivulare
- Brachythecium rotaeanum
- Brachythecium ruderale
- Brachythecium rutabulum
- Brachythecium salebrosum
- Brachythecium turgidum
- Brachythecium udum
- Braunia
- Braunia andrieuxii
- Braunia secunda
- Brotherella
- Brotherella canadensis
- Brotherella henonii
- Brotherella recurvans
- Brotherella roellii
- Bryaceae
- Bryhnia
- Bryhnia graminicolor
- Bryhnia hultenii
- Bryhnia novae-angliae
- Bryoandersonia
- Bryoandersonia illecebra
- Bryocrumia
- Bryocrumia vivicolor
- Bryolawtonia
- Bryolawtonia vancouveriensis
- Bryum
- Bryum argenteum
- Bryum argenteum var. argenteum
- Bryum argenteum var. majus
- Bryum argenteum var. muticum
- Bryum blindii
- Bryum calobryoides
- Bryum chryseum
- Bryum lanatum
- Bryum oblongum
- Bryum veronense
- Buckiella
- Buckiella undulata
C
C cont.
- Calliergon
- Calliergon cordifolium
- Calliergon giganteum
- Calliergon megalophyllum
- Calliergon orbicularicordatum
- Calliergon richardsonii
- Calliergonaceae
- Calliergonella
- Calliergonella cuspidata
- Campyliadelphus
- Campyliadelphus chrysophyllus
- Campylium
- Campylium laxifolium
- Campylium longicuspis
- Campylium protensum
- Campylium stellatum
- Campylophyllum
- Campylophyllum halleri
- Campylophyllum hispidulum
- Campylophyllum sommerfeltii
- Catoscopiaceae
- Catoscopium
- Catoscopium nigritum
- Chryso-hypnum
- Chryso-hypnum diminutivum
- Cinclidium
- Cinclidium arcticum
- Cinclidium latifolium
- Cinclidium stygium
- Cinclidium subrotundum
- Cirriphyllum
- Cirriphyllum piliferum
- Claopodium
- Claopodium bolanderi
- Claopodium crispifolium
- Claopodium pellucinerve
- Claopodium whippleanum
- Clasmatodon
- Clasmatodon parvulus
- Climaciaceae
- Climacium
- Climacium americanum
- Climacium dendroides
- Conardia
- Conardia compacta
- Conostomum
- Conostomum tetragonum
- Cratoneuron
- Cratoneuron filicinum
- Cryphaea
- Cryphaea filiformis
- Cryphaea glomerata
- Cryphaea nervosa
- Cryphaea ravenelii
- Cryphaeaceae
- Ctenidium
- Ctenidium molluscum
- Ctenidium schofieldii
- Cyclodictyon
- Cyclodictyon varians
- Cyrto-hypnum
- Cyrto-hypnum involvens
- Cyrto-hypnum minutulum
- Cyrto-hypnum pygmaeum
- Cyrto-hypnum schistocalyx
- Cyrtomnium
- Cyrtomnium hymenophylloides
- Cyrtomnium hymenophyllum
D
D cont.
- Donrichardsia pringlei
- Drepanocladus
- Drepanocladus aduncus
- Drepanocladus arcticus
- Drepanocladus cardotii
- Drepanocladus latinervis
- Drepanocladus longifolius
- Drepanocladus polygamus
- Drepanocladus sordidus
- Drummondia
- Drummondia prorepens
E
- Echinophyllum
- Echinophyllum sachalinense
- Elodium
- Elodium blandowii
- Elodium elodioides
- Elodium paludosum
- Entodon
- Entodon beyrichii
- Entodon brevisetus
- Entodon challengeri
- Entodon cladorrhizans
- Entodon concinnus
- Entodon hampeanus
- Entodon macropodus
- Entodon schleicheri
- Entodon seductrix
- Entodon sullivantii
- Entodontaceae
- Entodontopsis
- Entodontopsis leucostega
- Epipterygium
- Epipterygium tozeri
- Eurhynchiastrum
- Eurhynchiastrum pulchellum
- Eurhynchiastrum pulchellum var. barnesii
- Eurhynchiastrum pulchellum var. pulchellum
F
- Fabronia
- Fabronia ciliaris
- Fabronia pusilla
- Fabroniaceae
- Fontinalaceae
- Fontinalis
- Fontinalis antipyretica
- Fontinalis dalecarlica
- Fontinalis howellii
- Fontinalis hypnoides
- Fontinalis neomexicana
- Fontinalis novae-angliae
- Fontinalis redfearnii
- Fontinalis sphagnifolia
- Fontinalis sullivantii
- Fontinalis welchiana
- Forsstroemia
- Forsstroemia producta
- Forsstroemia trichomitria
G
- Gemmabryum
- Gemmabryum apiculatum
- Gemmabryum badium
- Gemmabryum barnesii
- Gemmabryum caespiticium
- Gemmabryum californicum
- Gemmabryum coronatum
- Gemmabryum demaretianum
- Gemmabryum dichotomum
- Gemmabryum exile
- Gemmabryum gemmiferum
- Gemmabryum gemmilucens
- Gemmabryum klinggraeffii
- Gemmabryum kunzei
- Gemmabryum radiculosum
- Gemmabryum ruderale
- Gemmabryum sect. Caespitibryum
- Gemmabryum sect. Gemmabryum
- Gemmabryum sect. Tuberibryum
- Gemmabryum subapiculatum
- Gemmabryum tenuisetum
- Gemmabryum valparaisense
- Gemmabryum violaceum
- Gollania
- Gollania turgens
- Groutiella