Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Heaters]]
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=813)
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
45
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=813)
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
45
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 | 47 | 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
Hydrosonic water heater plans - do it yourself heat pump water heater
hydrosonic water heater plans - do it yourself heat pump water heater Get it: http://www.niche-finder.net/get-hydrosonic-waterheater Make ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Rocket Stove Water Heater Plans
Proving to my wife rocket stoves work
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Rocket stove water heater plans
plans for rocket stove water heater, still testing and kicking a few ideas around.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Room Heater - How to make DC Room Heater - Homemade Space Heater
This is a 12 volt electric heater, Infrared heater project, it consumes only 250 watt of power and provide suitable amount of heat ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Solar Air Heater - The "Screen Absorber" Solar Air Heater - Easy do it yourself (full instructions)
Homemade Solar Air Heater - The "Screen Absorber" Solar Air Heater. Easy DIY. Produces temps near 140F (with outdoor air in ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Step by step to build a homemade water heater ...
25 January, 2018 By means of this device, the sun's radiation is used to heat some substance, in this way, the water can be heated for domestic or industrial us...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Super Water Heater 200 Ltrs Homemade 2018
more videos https://www.youtube.com/c/hackr®"Welcome to - "HACKR" - Homemade and Electronic Experiments Channel ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown