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, 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
32
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
32
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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None
Concrete Block Making Machine - capacity 100 pieces per hour
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Convertible Bicycle Trailer for people - with shock absorber
Contains PDF Blueprints: No
Contains CAD Files: No
License: Practical Action
Copy of Zigzag solar water heater
Contains PDF Blueprints: No
Contains CAD Files: No
License: OHO e.V.
Cosi measure new
COSI Measure is an open source multipurpose 3-axis robot operating in a large volume, that can be equipped with e.g. field mapping probes for static or dynamic...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Open source imaging
Cover Crop Roller
This tool is used to roll standing annual cover crops and crimp the stem to prevent regrowth and create a heavy mulch in place that can be planted through using...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Farm Hack
Cross Flow Turbine
technical drawings and 3d models for a complete cross-flow turbine assembly. project published under license CC-BY-SA 4.0 This project was supported by the germ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Skat
Crown Cap Machine
Hand operated device for sealing bottle tops Project published under CERN-OHL Licence See: https://practicalaction.org/knowledge-centre/resources/crown-cork-mac...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Practical Action
CubeFactory2
The CubeFactory 2 is an autonomous and portable mini factory with own energy and material supply. It embeds three modules: a 3D-printer, a plastic recycler prod...
Contains PDF Blueprints: No
Contains CAD Files: No
License: TU Berlin
Cultiridger
The Cultiridger’s main components are a set of spring tines and a pair of discs. The tool was designed to create and maintain ridges, but it can also be used on...
Contains PDF Blueprints: No
Contains CAD Files: No
License: L'Atelier Paysan
Cutting shears
Detailed drawings for building a Metal cutting shears Project published under CC-BY-SA 4.0 license Project development: Reverse engineering without adviser (B1,...
Contains PDF Blueprints: No
Contains CAD Files: No
License: ApT
DIY Compound Microscope
Contains PDF Blueprints: No
Contains CAD Files: No
License: American Peace Corps
DIY Solar Water Heater
Reference: https://www.youtube.com/watch?v=qsBIs7nAQ54&feature=emb_imp_woyt High efficiency, DIY solar water heater panel with basic tools and materials. Includ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: OpenSourceLowTech
Darrieus Turbine Made of PVC Pipes
Contains PDF Blueprints: No
Contains CAD Files: No
License: Youtube MakerMan
Drill Press for Heavy Duty - Size 232 mm
Contains PDF Blueprints: No
Contains CAD Files: No
License: Popular Mechanics
Electric Saw for Small Metal Works
Contains PDF Blueprints: No
Contains CAD Files: No
License: copyright
Engineer's Level Made of 19 mm Tubing
Contains PDF Blueprints: No
Contains CAD Files: No
License: Thomas E. Riley
Engineers Level - practical and resistant
Contains PDF Blueprints: No
Contains CAD Files: No
License: Thomas E. Riley
Feeder for rabbits
Rabbit feeder of easy construction, with accessible materials. Original project by Rodale Press, published under CC-BY-SA 4.0 license.
Contains PDF Blueprints: No
Contains CAD Files: No
License: Rodale Press
Ferrocement Tank - 3500 Gallons
Contains PDF Blueprints: No
Contains CAD Files: No
License: E. H. Robinson
Fish Dryer Smoker
Contains PDF Blueprints: No
Contains CAD Files: No
License: International Labour Office
Fish Dryer-Smoker made with Metal Drum
Contains PDF Blueprints: No
Contains CAD Files: No
License: International Labour Office
Flamingo rope pump
The basic parts of a rope pump are the rising main and the rope with the pistons. The rising main is a pipe, usaly made of PVC, that hangs with one end in the g...
Contains PDF Blueprints: No
Contains CAD Files: No
License: WOT University Twente
Floating Dome Biodigestor
Contains PDF Blueprints: No
Contains CAD Files: No
License: Appropriate Infrastructure Development Group
Goat Milking Parlor
Goat milking station, easy to build, retractable in case of short parlor stalls.
Contains PDF Blueprints: No
Contains CAD Files: No
License: Rodale Press
Hammer Mill for Corn Processing
Contains PDF Blueprints: No
Contains CAD Files: No
License: Apt Abatec
Hand Operated Winnower
Contains PDF Blueprints: No
Contains CAD Files: No
License: Tropical Products Institut
Handcart - Height 1220 mm
Wikipedia: A hand truck, also known as a dolly, stack truck, trundler, box cart, sack barrow, cart, sack truck, two wheeler, or bag barrow, is an L-shaped box-m...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Unknown
Hay Manger for Rabbits
Contains PDF Blueprints: No
Contains CAD Files: No
License: Christian Veterinary Mission
Himalayan Water Wheel
Pelton type open impeller waterwheel for dynamo electric power generation (Grinder not included) Project published under CC-BY-SA 4.0 license This project was s...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Unicef
Hoe
A module attached to the cultiridger or used on its own directly mounted on the tractor; see below for the plans of a hoe used in market gardening Able to offer...
Contains PDF Blueprints: No
Contains CAD Files: No
License: L'Atelier Paysan
Homemade Concrete Mixer – 250 Watts
Contains PDF Blueprints: No
Contains CAD Files: No
License: Popular Science
Homestead Cart
Wikipedia: A hand truck, also known as a dolly, stack truck, trundler, box cart, sack barrow, cart, sack truck, two wheeler, or bag barrow, is an L-shaped box-m...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Unknown
Honey Extractor
This Honey Extractor is designed to fit a standard, 20 gallon hot dipped galvanized trash can. Drill or cut a hole as close to the bottom of the can as possible...
Contains PDF Blueprints: No
Contains CAD Files: No
License: Garden Way Research
Horizontal Shaft Turbine With Security Tail
Reference: https://www.youtube.com/watch?v=3ISx_n-zkFo
Contains PDF Blueprints: No
Contains CAD Files: No
License: Youtube Guenther Hacker
Hydraulic Ram for Pumping Water
Contains PDF Blueprints: No
Contains CAD Files: No
License: Practical Action