Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Renewable energies]]
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,idst4.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
LEFT OUTER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_object_ids` AS idst4 ON idst4.smw_id=t4.o_id) ON t0.smw_id=t4.s_id
AND (t4.p_id=48963)
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst4.smw_sort DESC , t0.smw_sort ASC
LIMIT
45
OFFSET
0
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,idst4.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
LEFT OUTER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_object_ids` AS idst4 ON idst4.smw_id=t4.o_id) ON t0.smw_id=t4.s_id
AND (t4.p_id=48963)
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst4.smw_sort DESC , t0.smw_sort ASC
LIMIT
45
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 35 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | oho_wiki_en.t2.id | 13 | Using index | |
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 | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, oho_wiki_en.t1.s_id | 1 | Using where | |
1 | SIMPLE | idst4 | eq_ref | PRIMARY, smw_id | PRIMARY | 4 | oho_wiki_en.t4.o_id | 1 |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (573).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=573 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
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: Yes
Contains CAD Files: Yes
License: CCBYSA40
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: Yes
Contains CAD Files: Yes
License: CCBYSA40
Darrieus Turbine - 2m combined
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Darrieus Turbine Made of PVC Pipes
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
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: Yes
Contains CAD Files: No
License: unknown
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: Yes
Contains CAD Files: Yes
License: CCBYSA40
Horizontal Shaft Turbine With Security Tail
Reference: https://www.youtube.com/watch?v=3ISx_n-zkFo
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Lattice Tower Mast for Wind Turbine
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Parabolic Solar Cooker with Aluminium Reflector
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Savonius Rotor of 1m Diameter
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Savonius Rotor with Two Blade Levels
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Sawdust Stove Made with a 20 L Tin Can
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Small water turbine
This project shows the construction plans for a small 5 kW water turbine based on the research of Dr. Mohammad Durali at MIT. According to the original developm...
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: COHL12
Solar Cooker - diameter 1.4m
Based on: https://www.youtube.com/watch?v=joJRrljm30g--
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Solar Food Dryer for Vegetables
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Solar Water Heater - Capacity 100L
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Solar Water Heater with Corrugated Metal Collector
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Solar Water Heater with Serpentine Collector
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Vertical Axis Sail Windmill - Diameter 3 m
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Wind Mill Pump
Plans and 3d models to build a DIY equipment to pump water using a Savonius turbine and a diaphragm pump. Original design by Brace Research Institute, published...
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Wind Turbine with Vertical Metal Drum Sails
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Windmill Blades - Diameter 1.5 to 3 m
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Windmill Blades - Diameters 60 to 120 mm
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Zigzag Solar water heater
Blueprints and instructions for the construction of a solar water heater Based on manual published by WOT. It may be helpful in constructing solar collectors an...
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: COHL12
Hydraulic ram water pump
The Breurram is a kind of hydraulic ram. The hydraulic ram is a pump, that uses water power topump water. The energy of a large mass of water with a limited hei...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Photovoltaic Panel reusable
Crystalline silicon solar panel that can be built, maintained and refurbished locally, leading to a lower levelized cost of electricity and higher sustainabilit...
Contains PDF Blueprints: No
Contains CAD Files: No
License: COHL
(DIY) HOW TO MAKE SIMPLE SOLAR COOKER very easily at home....
This video is about "(DIY) HOW TO MAKE SIMPLE SOLAR COOKER very easily at home...."SUBSCRIBE- https://www.youtube.com ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
(How 2) build hydroelectric power plant itself Fascination with technology
In this video we show you how you can build a hydroelectric power plant yourself. Have fun ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
(Review) DIY 5V 2A Solar Panel, Power Bank, USB Charge Voltage Controller Regulator Module 6V-20V
I wanted to see if this module was worth buying, I am using a 5V
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
0 Selected Savonius wind turbines
Selection and analysis of representative projects by category, for their development. Go to the following link: https://en.oho.wiki/wiki/Selected_Savonius_wind_...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
10+ Best Solar Dryer images solar, solar dehydrator, diy solar 2
Sep 4, 2016 - Explore Jacob West's board "Solar Dryer" on Pinterest. See more ideas about Solar, Solar dehydrator, Diy solar.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
10+ Best homemade wind turbine images wind, alternative energy ...
DIY Wind Turbine - Renewable Energy - MOTHER EARTH NEWS. Turn a car alternator into alternative energy by building this cheap and easy homemade wind .
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
102 - Tesla Turbine described by Tesla himself* - English version - Patent 1061206
Version 2 of the previous video (we improved the presentation) This video shows Tesla's own description* of the
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
12V Solar Island System - do it yourself Guide - 1-2-do ...
19.10.2013 For a year now I have the mini solar system. This year, I have received 100KW of electricity. I run my computer and the attached consumers. It consis...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown