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
25
OFFSET
40
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
25
OFFSET
40
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
18 Best do it yourself Solar Dehydrators - Homestead Survival
Make sure you like or to be updated every time we find a tutorial for innovative ways you can become self-sufficient on a budget.Removing moisture from food and...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
18 do it yourself Solar Cooker Plans - Homestead Survival
Make sure you like or to be updated every time we find a tutorial for innovative ways you can become self-sufficient on a budget.A solar cooker is a cheap and e...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
2 Savonius windmill self build...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
2 do it yourself Solar Dehydrators for Home Food Preservation - Off Grid World
Dehydration is a method of food preservation that inhibits the growth of microorganisms by removing water from the food, allowing foods to be stored for an exte...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
304 - Design and Development of Novel Solar Dryer for Drying of Wood
Baibhaw Kumar, Zoltan Szamosi Presented in: 8th International Renewable and Sustainable Energy Conference #IRSEC20 ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
4 do it yourself Cardboard Cookers - Solar Box ( Dish) Cooker Compilation - All Easy DIY's
4 do it yourself Cardboard Cookers All Easy DIY's. Compilation video shows the 4 types of cardboard ovens/stoves i've made. cost to make ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
7 Best Water wheel design images water wheel, water mill, wagon ... 2
Oct 22, 2014 - Explore Matthew Kneale's board "Water wheel design" on Pinterest. See more ideas about Water wheel, Water mill, Wagon planter.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
7 do it yourself Solar Dehydrators You Can Make at Home - True Activist
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
80+ Best Homemade Solar Cookers DIY images solar cooker, solar ... 2
Other Solar Cookers. Solar Fire is what we call the open-source family of technologies that share certain design criteria. Namely, glass mirror reflec
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
? Building a solar panel laminator (revised) - plans available ????
Check out my latest project: https://youtu.be/yXQnydST9fw Learn how to build this
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
? Plans hydroelectric plant in AutoCAD CAD (1.61 MB ...
Confirm the email on Google and try again. Your account is inactive. To request a reactivation you can contact us by email at.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
? pico Turbine pelton home made powerhouse complete information Waterwheel
Pelton turbine generating electric power Project development: Redesign together with project owner (A2, P1)
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
???? DIY Biogas digester low tech lifestyle
Toni shares his low-tech lifestyle and
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
A Home-Sized Water Wheel - Do It Yourself - MOTHER EARTH NEWS
If you're stuck trying to get some water from point "A" to point "B", you may just find that a water wheel is the easiest practical situation to build. Septembe...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
A homemade wind turbine for power generation incunabulum.de
A blog with a weird name Description of the construction of a small windmill, which can also be used to generate electricity. A windmill - but this time right N...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
A simple Solar Collector design - DIYData.com
The total amount of solar radiation falling on each square meter in the UK is around 1000kWh per year - of this, it should be possible to collect between 25% an...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Aluminum Downspout Hot Air Solar Collector Construction
Detailed descriptions of the construction of two aluminum downspout hot air solar collectors. The original was built by me, Scott ... Project development: Redes...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Arduino MPPT Solar Charge Controller 19 - Season Two Plans
Plans for this season's work on the MuPPeT solar test rig. A look at Ralph's implementation of this project in Tacloban City, the ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
BEST DIY SOLAR FOOD DEHYDRATOR DRYER for PRESERVING FOOD WithOut ELECTRICITY INCREASING LONG TERM 2
Increasing long term food storage ability with the best diy Project development: Reverse engineering without adviser (B1, P1)
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
BUILD WIND TURBINE from the... barrel ?
Step by step tutorial on how to build a solar panel
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown