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
4
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
4
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
Arduino module with programmable camera
The OpenMV project is about creating low-cost, extensible, Python powered, machine vision modules and aims at becoming the “Arduino of Machine Vision“ The OpenM...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Assisted breathing with pressure-controlled system
The People’s Ventilator Project (PVP) is an open-source, low-cost pressure-control ventilator designed for minimal reliance on specialized medical parts to bett...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
BCN3D Sigma 3D Printer
Fully developed and tested project for the construction of a high performance, industrial quality Open Hardware 3D printer. OSH project
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Baby Incubator Simple and Effective
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bandsaw Wheel - Diameter 12 inch
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bar bender for thickness from 5 to 15 mm
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bed ridger
The bed ridger can be used instead of a plough to incorporate crop residue and green manures into the soil. The ridger can also be used to reshape a bed if it h...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bee Hive
Complete Beekeeping system developed by GARDEN WAY RESEARCH 1975 © Use any 3/4" soft wood such as pine, basswood or spruce Dimensions are all quite critical - t...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bee Hive Frame
This project shows a Lanqstroth hive and its parts The brood chamber provides space for eggs and brood although sometimes the queen will lay eggs in a few combs...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bee Smoker
DIY bee smoker, built with easy-to-locate materials
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bench Vice
This is a simple model for a workshop bench vice without casting parts and made of simple, welded parts. It can be made in any simple locksmith's shop or metal...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle Luggage Carrier for LPG Gas Cylinder
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Brick Making Machine CETA-RAM - for soil bricks
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
CNC plasma cutter
The GoodEnoughCNC Hybrid is a parametric bootstrap machine. Dimensions depend on the length of the profiles (Parameter L) and profile sizes. GoodEnoughCNC hybri...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Carla Cargo Crowd
Carla Cargo allows you to transport heavy loads quickly, environmentally friendly and without sitting in traffic. It can be combined with any regular bicycle or...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Charcoal Filter for Drinking Water DIY
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
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: unknown
Copy of Zigzag solar water heater
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
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: unknown
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: unknown
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: unknown
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: unknown
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: unknown
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: unknown
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: unknown
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: unknown
Darrieus Turbine Made of PVC Pipes
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Drill Press for Heavy Duty - Size 232 mm
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown