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_blob` AS t2 ON t0.smw_id=t2.s_id
WHERE
(t2.p_id=2746)
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, p_id, s_id_2 | p_id | 4 | const | 129 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ceurwswiki.t2.s_id | 1 | Using where |
Query-Depth:0
Vol-3194/paper27, Vol-3194/paper28, Vol-3194/paper29, Vol-3194/paper3, Vol-3194/paper30, Vol-3194/paper31, Vol-3194/paper32, Vol-3194/paper33, Vol-3194/paper34, Vol-3194/paper35, Vol-3194/paper36, Vol-3194/paper37, Vol-3194/paper38, Vol-3194/paper39, Vol-3194/paper4, Vol-3194/paper40, Vol-3194/paper41, Vol-3194/paper42, Vol-3194/paper43, Vol-3194/paper44, Vol-3194/paper45, Vol-3194/paper46, Vol-3194/paper47, Vol-3194/paper48, Vol-3194/paper49, Vol-3194/paper5, Vol-3194/paper50, Vol-3194/paper51, Vol-3194/paper52, Vol-3194/paper53, Vol-3194/paper54, Vol-3194/paper55, Vol-3194/paper56, Vol-3194/paper57, Vol-3194/paper58, Vol-3194/paper59, Vol-3194/paper6, Vol-3194/paper60, Vol-3194/paper61, Vol-3194/paper62, Vol-3194/paper63, Vol-3194/paper64, Vol-3194/paper65, Vol-3194/paper66, Vol-3194/paper67, Vol-3194/paper68, Vol-3194/paper69, Vol-3194/paper7, Vol-3194/paper70, Vol-3194/paper71