Semantic search
SQLStore debug output
ASK Query
[[Taxon rank::genus]]
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='genus') AND t1.p_id='618')
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
500
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='genus') AND t1.p_id='618')
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
500
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 | 2425 | 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
- Chlorocrambe
- Chlorogalum
- Chloropyron
- Chondrilla
- Chorisiva
- Chorispora
- Chorizanthe
- Chromolaena
- Chrysactinia
- Chrysanthemoides
- Chryso-hypnum
- Chrysobalanus
- Chrysogonum
- Chrysolepis
- Chrysoma
- Chrysophyllum
- Chrysopogon
- Chrysopsis
- Chrysosplenium
- Chrysothamnus
- Chylismia
- Chylismiella
- Cichorium
- Cienfuegosia
- Cimicifuga
- Cinclidium
- Cinna
- Cinnamomum
- Circaea
- Cirriphyllum
- Cirsium
- Cissampelos
- Cissus
- Cistanthe
- Cistus
- Citrullus
- Cladanthus
- Cladium
- Cladoraphis
- Claopodium
- Clappia
- Clarkia
- Clasmatodon
- Claytonia
- Cleistes
- Cleistocarpidium
- Clematis
- Cleome
- Cleomella
- Cleoserrata
- Clethra
- Cliftonia
- Climacium
- Clintonia
- Clusia
- Cnidoscolus
- Coccinia
- Coccoloba
- Coccothrinax
- Cocculus
- Cochlearia
- Cocos
- Codriophorus
- Coeloglossum
- Coelophragmus
- Coelorachis
- Coincya
- Coix
- Coleanthus
- Coleogyne
- Collinsia
- Colocasia
- Colubrina
- Columbiadoria
- Comandra
- Comarostaphylis
- Comarum
- Combretum
- Commelina
- Commicarpus
- Comptonia
- Conardia
- Condalia
- Conicosia
C cont.
- Conimitella
- Conocarpus
- Conoclinium
- Conopholis
- Conostomum
- Conringia
- Consolea
- Consolida
- Constancea
- Convallaria
- Conyza
- Coptis
- Corallorhiza
- Corchorus
- Cordylanthus
- Corema
- Coreocarpus
- Coreopsis
- Corethrogyne
- Corispermum
- Cornus
- Corrigiola
- Cortaderia
- Corydalis
- Corylus
- Corynephorus
- Coryphantha
- Coscinodon
- Cosmos
- Cota
- Cotoneaster
- Cottea
- Cottsia
- Cotula
- Cotyledon
- Crambe
- Cranichis
- Crassula
- Crataegus
- Cratoneuron
- Crepis
- Crinum
- Crocanthemum
- Crocidium
- Crocosmia
- Croomia
- Croptilon
- Crossidium
- Crossopetalum
- Crossosoma
- Croton
- Crumia
- Crupina
- Cryphaea
- Crypsis
- Cryptogramma
- Ctenidium
- Ctenitis
- Ctenium
- Ctenolepis
- Cucumis
- Cucurbita
- Cuniculotinus
- Cuphea
- Cupressus
- Curcuma
- Cusickiella
- Cutandia
- Cyanthillium
- Cyclachaena
- Cyclanthera
- Cyclodictyon
- Cycloloma
- Cyclopogon
- Cydonia
- Cylindropuntia
- Cymbalaria
- Cymbopogon
- Cymophyllus
- Cynara
- Cynodon
- Cynodontium
- Cynophalla
- Cynosurus
C cont.
- Cyperus
- Cyphomeris
- Cypripedium
- Cypselea
- Cyrilla
- Cyrto-hypnum
- Cyrtomium
- Cyrtomnium
- Cyrtopodium
- Cystopteris
D
- Dacryophyllum
- Dactylis
- Dactyloctenium
- Dactylorhiza
- Dalechampia
- Daltonia
- Damasonium
- Danthonia
- Daphne
- Darlingtonia
- Darmera
- Dasiphora
- Dasistoma
- Dasylirion
- Dasyochloa
- Dasypyrum
- Datisca
- Decodon
- Decumaria
- Dedeckera
- Deeringothamnus
- Deinandra
- Deiregyne
- Delairea
- Delosperma
- Delphinium
- Dendroalsia
- Dendromecon
- Dendrophylax
- Dennstaedtia
- Deparia
- Deschampsia
- Descurainia
- Desmazeria
- Deutzia
- Diamorpha
- Dianella
- Dianthus
- Diapensia
- Diaperia
- Diarrhena
- Dicentra
- Dichaetophora
- Dichanthelium
- Dichanthium
- Dichelostemma
- Dichelyma
- Dichodontium
- Dichromanthus
- Dicoria
- Dicranella
- Dicranocarpus
- Dicranodontium
- Dicranopteris
- Dicranostegia
- Dicranoweisia
- Dicranum
- Didiplis
- Didymodon
- Dieteria
- Digitalis
- Digitaria
- Dimeresia
- Dimorphocarpa
- Dimorphotheca
- Dinebra
- Dionaea
- Dioscorea
- Diospyros
- Diphasiastrum
- Diphylleia
- Diphyscium