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
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=677
AND (
(t4.o_hash='Baseball') AND t4.p_id=577)
)
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
100
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 | 329 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t4 | ref | s_id, o_hash, s_id_2, p_id | s_id | 8 | protoballbetadb.t2.s_id, const | 1 | 5.00 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | protoballbetadb.t2.s_id | 1 | 50.00 | Using where |
Query-Depth:1
Playground Ball, Podex, Poisoned Ball, Prelleries, Puddox, or Puddock, Reversible Baseball, Rigoball, Round Ball, Round Cat, Round Town (Round Town Ball), Rounders - Britain, Rounders -- Hungary, Roundsies, Roundstakes, Rownes, Run-Around, Rundbold, Russian Baseball, Schlagball, Single-Wicket Cricket, Six Man Baseball, Sixteen-Inch Softball (No-Glove Softball), Skirt Ball, Slaball, Slap Ball -- Brooklyn, Slavonic Long Ball, Soak Ball, Sockey, Softball, Softball Cricket, Speilinn, Spoonie Hoosie, Squares, Stickball, Stones, Stonyhurst Cricket, Stoolball, Straight Town, Stub One, Sun and Planet, Target Ball, Targette, Ten Position Baseball, Tennisball, The Union Hall Game of Ball, Thor-ball, Three Out All Out, Three-Base Ball, Three-Cornered Cat, Thèque