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
`r_smw_object_ids` AS t0
INNER JOIN
(`r_smw_object_ids` AS t2
INNER JOIN
`r_smw_fpt_mdat` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=302)
AND 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 | ref | PRIMARY, smw_id, smw_namespace | smw_namespace | 4 | const | 125 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t3 | ref | s_id | s_id | 4 | religioni36mysql1.t2.smw_id | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | religioni36mysql1.t2.smw_id | 1 | Using where |
Query-Depth:1
Alphabetic term, Anmerkung ort, Anmerkung von, Belongs to collection, Belongs to museum, Chapternumber, Cites term, Collection count, Defines term, Desc of term, Foaf:homepage, Foaf:knows, Foaf:name, Gemacht von, Glossar id, Has coordinates, Has showTitelLink to, Has sidepagelink to, Hat Frage, Hat anmerkung, Hat autor, Hat bildbeschreibung, Hat bildinfo, Hat bildquelle, Hat bildquellen domain, Hat bildquellenlink, Hat bildthema, Hat bildtitel, Hat copyrightinfo, Hat externe links2, Hat externen link, Hat externen link2, Hat genehmigung von, Hat liste mit externem link, Hat literatur autor, Hat literatur autor kurz, Hat literatur jahr, Hat literatur titel, Hat literatur titel kurz, Hat medium neu, Hat pruefungsfrage, Hat thema, Hat thema neu, Hat titel, Hat verweise, Hat vorlagen-id, Hat zugriff, Is archived image article, Is help article, Is image article