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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=48963 AND t1.o_id=40547)
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
20
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 208 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | oho_wiki_en.t1.s_id | 1 | Using where |
Query-Depth:1
Blacksmiths Bellows Brick Making Machine CETA-RAM - for soil bricks C-clamp Vise CNC plasma cutter Cabinet Food Dryer Carla Cargo Crowd Charcoal Filter for Drinking Water DIY Chicken House Circular Table Saw Clamp for corners Coconut Drier Compact trailer for bicycle Concrete Block Making Machine - capacity 100 pieces per hour Convertible Bicycle Trailer for people - with shock absorber Copy of Zigzag solar water heater Corn mill Cosi measure new Cover Crop Roller Cross Flow Turbine Crosskage roller Crown Cap Machine CubeFactory2 Cultiridger Cutting shears Cylindrical Grinding machine DIY Compound Microscope DIY Solar Water Heater DTU Handpump Darrieus Turbine - 2m combined Darrieus Turbine Made of PVC Pipes Donkey Cart Donkey Cart Frame Drill Press for Heavy Duty - Size 232 mm Dual Purpose Weeder Electric Saw for Small Metal Works Engineer's Level Made of 19 mm Tubing Engineers Level - practical and resistant Feeder for rabbits Fence Making Machine Ferrocement Tank - 3500 Gallons Fish Dryer Smoker Fish Dryer-Smoker made with Metal Drum Flamingo rope pump Flat Bottom Boat Flat Bottom Boat Scow-Type Floating Dome Biodigestor Forge Blower Goat Milking Parlor Groundnut Huller Hammer Mill for Corn Processing