Semantische Suche
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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_fpt_inst` AS t1
INNER JOIN
`mw_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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 67 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | k113882_demxikon.t2.id | 19 | 100.00 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | k113882_demxikon.t1.s_id | 1 | 85.75 | Using where |
- Temporary table t2
Recursively computed hierarchy for element(s) (10363).
SELECT s_id FROM `mw_smw_fpt_subc` WHERE o_id=10363 LIMIT 1
Query-Depth:0
A'mando Suarez, Aala'na, Aalf, Aana, Abebe, Abel, Abhimonda, Abn el Gurk Ben Amar Chat Ibn Lot Fuddel der Sechste, Abn el Saad Ben Gadiir, Abraham Crosby, Acarn'sil'olenar, Achmaz, Ackh'esser, Ackh'man, Adalind, Adam Pschorr, Adam van Larven, Adolf Hitler, Adolfo Darnell, Adoor, Adora Diaz, Agat'ol, Agnetis, Agua Mala, Ahmed Yasit, Ahne, Ai, Aidan Wingfield, Aiko Tsuyoshi, Airin, Aja, Akemi, Akina Tsuyoshi, Akiro Noctis, Aksela, Akuma Tanako, Alanie, Alastar, Albert Beggar, Albert Morte, Albo Saklid, Alca, Alcam von Asmark, Aldous, Alec Smart, Aleeksander, Aleister Crowley, Alejandro de Javier, Alekksa, Aleksej Iwanow