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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
LEFT OUTER JOIN
`smw_fpt_cdat` AS t5 ON t0.smw_id=t5.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
t5.o_sortkey DESC
LIMIT
45
OFFSET
0
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 | |
1 | SIMPLE | t5 | ref | s_id | s_id | 4 | oho_wiki_en.t1.s_id | 1 |
Query-Depth:1
Copy of Zigzag solar water heater Cylindrical Grinding machine Solar Cooker - diameter 1.4m Darrieus Turbine - 2m combined Solar Water Heater - Capacity 100L Trailer for bicycle based on Carla Cargo design Compact trailer for bicycle Clamp for corners White Rabbit C-clamp Vise Vice for drill press Pulley puller with 3 jaws Manual shearing machine for 3mm plate Bar bender for thickness from 5 to 15 mm Bench vice with 150mm jaw Angle grinder stand Stand for manual drill Manual folding Machine 1000mm-JJ Arduino module with programmable camera Assisted breathing with pressure-controlled system Concrete Block Making Machine - capacity 100 pieces per hour Wind Turbine with Vertical Metal Drum Sails Darrieus Turbine Made of PVC Pipes Horizontal Shaft Turbine With Security Tail Engineer's Level Made of 19 mm Tubing Manual Winnower for Grains Peanut Roaster - Capacity 60kg/hr Windmill Blades - Diameter 1.5 to 3 m Stationary Solar Fish Drier 37 m2 Potery Wheel with 5hp Motor Incubator for Babies - Warm and Humidified Piston lift Pump DTU Pipe Bending Tool Portable Wooden Chicken Coop with Built-In Nesting Boxes Raised Hutch of 3.5 m2 Whater Wheel Diameter 2m Savonius Rotor of 1m Diameter Segner Turbine for 4m Pit Radial Drill made from Auto Parts VentMon T 0.4 In-line Fan Test Device and Monitor