Semantic search
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 t2 ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=8997)
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
50
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 227 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where |
Query-Depth:0
Design3D date, Design3D design, Design3D finishDate, Design3D idea, Design3D name, Design3D page, Design3D result, Design3D stl, Extension name, Extension purpose, Extension since, Extension url, Extension wiki, Fixme done, Fixme todo, GlossaryEntry description, GlossaryEntry lang, GlossaryEntry master, GlossaryEntry references, GlossaryEntry responsible, GlossaryEntry since, GlossaryEntry state, Import comment, Import cpu, Import days, Import end, Import os, Import ram, Import start, Import state, Import target, Import triples, Import url, OCRDocument id, OCRDocument name, OCRDocument nextpage, OCRDocument page, OCRDocument pages, OCRDocument pdfname, OCRDocument previouspage, OsProject date, OsProject id, OsProject owner, OsProject since, OsProject state, OsProject title, OsProject until, OsProject url, OsProject version, PID description