Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:People]]
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_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
0
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_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 10 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | wiki.t2.id | 3 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (32463).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=32463 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None'
- 'ba' lag lhun grub rab brtan
- 'ba' ra ba ngag dbang ye shes
- 'bre shes rab 'bar
- 'bri gung lo tsA ba ma Ni ka shrI
- 'bri gung skyob pa 'jig rten mgon po
- 'bri gung spyan snga shes rab 'byung gnas
- 'bro lo tsA ba shes rab grags pa
- 'brog mi dpal gyi ye shes
- 'brog mi lo tsA ba
- 'brom ston pa
- 'bru 'jam dbyangs grags pa
- 'brug pa kun legs
- 'chad kha ba
- 'dar 'phyar ba rin chen bzang po
- 'dul 'dzin grags pa rgyal mtshan
- 'gos chos grub
- 'gos khug pa lhas btsas
' cont.
- 'gos lo tsA ba gzhon nu dpal
- 'gro 'dul las 'phro gling pa
- 'gro mgon chos rgyal 'phags pa
- 'gro mgon ras chen
- 'gyur med 'phrin las chos sgron
- 'gyur med 'phrin las rnam rgyal
- 'gyur med bde chen
- 'gyur med bstan rgyas
- 'gyur med gzhan phan lhun grub
- 'gyur med mchog grub
- 'gyur med pad+ma bstan 'dzin
- 'gyur med pad+ma dbang rgyal
- 'gyur med tshe dbang bstan 'phel
- 'gyur med tshul khrims
- 'gyur med yid bzhin legs grub
- 'ja' tshon snying po
- 'jad pa slob dpon ston skyabs
' cont.
- 'jag chen byams pa dpal
- 'jag chung blo gros dpal
- 'jag chung kun dga' dpal bzang
- 'jam dbyangs bla ma
- 'jam dbyangs blo gter dbang po
- 'jam dbyangs bzhad pa'i rdo rje
- 'jam dbyangs chos kyi blo gros
- 'jam dbyangs chos rje bkra shis dpal ldan
- 'jam dbyangs kun dga' rnam rgyal
- 'jam dbyangs mgon po
- 'jam dbyangs mkhyen brtse chos kyi blo gros
- 'jam dbyangs mkhyen brtse'i dbang phyug
- 'jam dbyangs mkhyen brtse'i dbang po
- 'jam dbyangs nam mkha' rgyal mtshan
- 'jam dbyangs rin chen rgyal mtshan
- 'jam dbyangs ye shes mtha' yas