Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Savonius wind turbines]]
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 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
(t1.o_id=49668)
AND 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
55
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 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
(t1.o_id=49668)
AND 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
55
OFFSET
40
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 54 | Using index; 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 | 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
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
Savonius rotor self-construction 2
Autumn: 8-10 wind forces- SPS speed control- All nice
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Savonius rotor self-made
What do others do better than us? https://plus.google.com/collection/gnPHU among the fans of the Frankfurt Garden ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Savonius rotor self-made (in use)
Over small generator 4 super bright, white LED's are operated. Low speeds or low wind speeds ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Savonius rotor self-made VAWT
As an idea for a training project by the instructor (me) called into life and implemented by my trainees and me into action.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Savonius wind turbine
DIY vertical axis wind turbine Savonius type Project development: Redesign together with project owner (A2, P1)
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Savonius wind turbine construction
First part of a
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Savonius wind turbine self-made part 1 rotor test
Feedback and suggestions are welcome. The generator and a frame are under construction and will be ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Small wind turbine with recycled materials. Savonius construction
Small 200 W Vertical Axis
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Vertical wind turbine with Savonius rotor - do-it-yourself / HD
Here you can see the prototype of my
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
WANNDA Green Stream Savonius wind turbine homemade
Music: TDCC -Sun (RICD remix) Wannda loves Mother Earth That's why we have green power in all our events ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Wind Turbine, Vertical Wind Turbine Build Part 2 Reupload
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Wind turbine, Vertical wind turbine build yourself, tinker wind turbine, Weltenbummler TV
Weltenbummler tinker for self-sufficiency, Weltenbummler TV would like to remain independent and tinkering now in the new ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Wind turbine, vertical wind wheel build yourself Part 3
Weltenbummler tinker for self-sufficiency, Weltenbummler TV would like to remain independent and tinkering now in the new ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Zoetrope 2
Project development: Reverse engineering with adviser (B2, P2)
Contains PDF Blueprints: No
Contains CAD Files: Yes
License: CCBYSA40