Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[ContainsPdfDrawings::Yes]]
SQL Query
SELECT DISTINCT
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
55
OFFSET
62
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
55
OFFSET
62
SQL Explain
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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None
Thickness Sander with 476 mm Width
Contains PDF Blueprints: No
Contains CAD Files: No
License: Pat Hawley's
Seed Cleaner - for Repeated Seed Sorting
Contains PDF Blueprints: No
Contains CAD Files: No
License: The Real Seed Collection Ltd
Homemade Concrete Mixer – 250 Watts
Contains PDF Blueprints: No
Contains CAD Files: No
License: Popular Science
Motorized Hacksaw with 186W motor
Contains PDF Blueprints: No
Contains CAD Files: No
License: Carl S. Bates
Scooter with Fat-tire with 6 hp Engine
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Vertical Axis Sail Windmill - Diameter 3 m
Contains PDF Blueprints: No
Contains CAD Files: No
License: Low Energy Systems
Ferrocement Tank - 3500 Gallons
Contains PDF Blueprints: No
Contains CAD Files: No
License: E. H. Robinson
Bandsaw Wheel - Diameter 12 inch
Contains PDF Blueprints: No
Contains CAD Files: No
License: John A. Hoffmann
Tall Bandsaw Rollerboard
Contains PDF Blueprints: No
Contains CAD Files: No
License: JTenEyck Woodworker
Threadle Pump - Head 3-8 m
Contains PDF Blueprints: No
Contains CAD Files: No
License: University of Warwick, DTU
DIY Compound Microscope
Contains PDF Blueprints: No
Contains CAD Files: No
License: American Peace Corps
Snow Sled with 10 hp Outboard Motor
Contains PDF Blueprints: No
Contains CAD Files: No
License: Harold W. Grube
Sawdust Stove Made with a 20 L Tin Can
Contains PDF Blueprints: No
Contains CAD Files: No
License: Vita
Tubular Plastic Biodigester
Contains PDF Blueprints: No
Contains CAD Files: No
License: University of Aarhus
Rope Pump with Depth Adjustable
Contains PDF Blueprints: No
Contains CAD Files: No
License: Appropedia
Pit for Waste Disposal in Rural Areas
Contains PDF Blueprints: No
Contains CAD Files: No
License: World Health Organization
Power Thresher for Rice and Wheat
Contains PDF Blueprints: No
Contains CAD Files: No
License: Practical Action
Welding Gun - Multifunctional and DIY
Contains PDF Blueprints: No
Contains CAD Files: No
License: Phillip M. Wilson
Sand Blasting Machine Made of 6 Inch Pipe
Contains PDF Blueprints: No
Contains CAD Files: No
License: Channing B. Mould
Rice Threshing Machine - Pedal Driven
Contains PDF Blueprints: No
Contains CAD Files: No
License: Vita
Drill Press for Heavy Duty - Size 232 mm
Contains PDF Blueprints: No
Contains CAD Files: No
License: Popular Mechanics
Manual Fuel Briquette Press
Contains PDF Blueprints: No
Contains CAD Files: No
License: Practical Action
Solar Water Heater with Corrugated Metal Collector
Contains PDF Blueprints: No
Contains CAD Files: No
License: Ecotope Group
Solar Water Heater with Serpentine Collector
Contains PDF Blueprints: No
Contains CAD Files: No
License: Appropriate Infrastructure Development Group
Floating Dome Biodigestor
Contains PDF Blueprints: No
Contains CAD Files: No
License: Appropriate Infrastructure Development Group
Cabinet Food Dryer
Contains PDF Blueprints: No
Contains CAD Files: No
License: Brace Research Institute
Solar Food Dryer for Vegetables
Contains PDF Blueprints: No
Contains CAD Files: No
License: Arnold + Maria Valdez
Table for Wood Router with Storage Spaces
Contains PDF Blueprints: No
Contains CAD Files: No
License: Guido Henn
Charcoal Filter for Drinking Water DIY
Contains PDF Blueprints: No
Contains CAD Files: No
License: WHO, InternationalReference Center for Community Water Supply
Stand for Inspection Microscope
Contains PDF Blueprints: No
Contains CAD Files: No
License: Dan Maloney
Solar Wax Melter
Contains PDF Blueprints: No
Contains CAD Files: No
License: University of California
Press to produce homemade vegetable oil
Contains PDF Blueprints: No
Contains CAD Files: No
License: Joshua & Kaia Tickell
Hand Operated Winnower
Contains PDF Blueprints: No
Contains CAD Files: No
License: Tropical Products Institut
Hammer Mill for Corn Processing
Contains PDF Blueprints: No
Contains CAD Files: No
License: Apt Abatec
Engineers Level - practical and resistant
Contains PDF Blueprints: No
Contains CAD Files: No
License: Thomas E. Riley
Electric Saw for Small Metal Works
Contains PDF Blueprints: No
Contains CAD Files: No
License: copyright
Brick Making Machine CETA-RAM - for soil bricks
Contains PDF Blueprints: No
Contains CAD Files: No
License: Centro de Experimentación en Tecnología Apropiada
Blacksmiths Bellows
Contains PDF Blueprints: No
Contains CAD Files: No
License: University of Technology LAE Papua New Guinea
Axial Flow Turbine 25kW
Contains PDF Blueprints: No
Contains CAD Files: No
License: Practical Action