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_di_wikipage` AS t2
INNER JOIN
`smw_object_ids` AS t5 ON t2.s_id=t5.smw_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id=745 AND t2.o_id=2400
AND (t5.smw_namespace=0)
)
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 | index_merge | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id,o_id_3 | 5,9 | 100 | Using intersect(o_id,o_id_3); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t5 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | atitdwiki_tale9.t2.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | atitdwiki_tale9.t2.s_id | 1 | Using where |
Query-Depth:1
Medium Construction Site, Medium House, Medium House, Megalopolis, Megalopolis Construction Site, Mine, Mine, Mirrored Pyramid, Mouldboard Plough, Night Sky Table, Plinth Construction Site, Pottery Wheel, Pottery Wheel, Ranch, Ranch, Ranching, Religious Construction Site, Rock Saw, Rock Saw, Scholar's Gem Cutting Table, Scholar's Gem Cutting Table, Sculpture, Sculpture, Single Sign, Single Sign, Skill/Beer Brewing Science/0, Skill/Beer Brewing Science/1, Skill/Beer Brewing Science/2, Skill/Beer Brewing Science/3, Small Aging Rack, Small Aging Rack, Small Construction Site, Small Construction Site, Small House, Small House, Small Sailboat, Small Sailboat, Stone Quarry, Stonework, Temporary Pyrotechnics Stadium Application, Tent, Tent, Test of the Covered Cartouche, Test of the Empty Hand, Test of the Hand of Ra, Triple Sign, Triple Sign, Vineyard, Vineyard, Water Well