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
100
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
100
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
NoneText | MainNamePhon | MainNameTib | MainNameWylie | EmanationOf |
---|---|---|---|---|
Abé, R. | Ryūichi Abé | |||
Achard, J-L. | ||||
Acharya Vajrayudha | Acharya Vajrayudha | སློབ་དཔོན་རྡོ་རྗེ་གོ་ཆ་ | Acharya Vajrayudha | |
Acharya, D. | ||||
Achok Rinpoche | ||||
Acri, A. | ||||
Acutt, M. | ||||
Adam, M. | ||||
Adams, M. | Miranda Adams | |||
Adams, V. | ||||
Adcock, C. | ||||
Adeu Rinpoche | Adeu Rinpoche | |||
Agarwal, S. | Satya P. Agarwal | |||
Agarwal, U. | Urmila Agarwal | |||
Agate, M. | Marc Agate | |||
Agostini, G. | ||||
Aguilar, O. | ||||
Agócs, T. | Tamás Agócs | |||
Ahbel-Rappe, S. | Sara Ahbel-Rappe | |||
Ahmad, Z. | ||||
Ahmadinia, D. | ||||
Aiken, B. | ||||
Aiming, Z. | ||||
Airaksinen, P. | Pekka Airaksinen | |||
Aitken, D. | Daniel Timothy Aitken | |||
Aitken, R. | Robert Baker Aitken | |||
Ajahn Brahm | Ven. Ajahn Brahm | |||
Akester, M. | ||||
Akong, Chöjé | ||||
Albachten, Ö. | ||||
Albahari, M. | Miri Albahari | |||
Aldenderfer, M. | ||||
Alexander Csoma de Kőrös Translation Group | Alexander Csoma de Kőrös Translation Group | |||
Alfonsa, F. | ||||
Allan, N. | ||||
Allchin, R. | ||||
Alldritt, L. | Leslie D. Alldritt | |||
Allen, E. | ||||
Allen, M. | ||||
Allen, R. | ||||
Alleton, V. | ||||
Allinger, E. | ||||
Allione, T. | Tsultrim Allione | |||
Allon, M. | ||||
Allès, E. | ||||
Almberg, E. | ||||
Almogi, O. | ||||
Alper, A. | ||||
Altman, D. | ||||
Altner, D. |