Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Wood splitting machines 2]]
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=976)
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
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 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=976)
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
25
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 | 71 | 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
Log splitter 325 kg lift table self-made for back-friendly working
Conversion of an old lifting table to a flattenable lifting table for large logs with hydraulic drive. The log splitter ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter Binderberger with self-made crane
Log splitter Binderberger with self-made crane.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter To build wood splitters The beginning is made IHC 633 Mr. Moto
My equipment: Helmet for logging: Caberg Konda http://amzn.to/2zgbxW8 * My "good" helmet: Shoei Gt-Air ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter build 14 episode REPAIR more
In this episode, we build a wood splitter that requires neither electricity nor an external drive. And the best thing is you guys ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter do it yourself 108 SA Part 1
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter for excavators self-made 80 cm beech
Dredge splitter Homemade Log splitter Mini excavator columns.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter own, lying
home-built pruning machine.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-built hydraulic lying 15 tons
Klaus March 25, 2011 / Last update: December 17, 2014 Before one decides to the step of the wood splitter Eigenbau, one should consider that it also uses splitt...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-made
Log splitter self-made.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-made - Brilliant way to cut wood on
Homemade Log Splitter - Brilliant way to cut wood on do not forget to subscribe and share / subscribe and share ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-made 23 to.
Eigenbau log splitter - simple electr. Control - 23to. Splitting force for the flow must be pressed a switch, the ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-made 3
my new firewood splitter (self-made) in use.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-made 4
Eigenbau log splitter splitting cross.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter self-made for excavators
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Log splitter, standing, homemade Part 2
now with log lifter.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
My electroless self-made log splitter self-made.
Sodale, except for the installation of the coming 6 tons stamp jacks with only 18.5 cm minimum overall height, (so ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
My self-made 10 tons wood splitter Wood splitter self made
As my electric 4 ton wood splitter is in the bucket and with its 4 tons splitting power for bigger tinkered pieces of wood ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
New invention machines, top 10 most amazing firewood cutting machine, wood splitter homemade
new invention machines, top 10 most amazing firewood cutting machine, wood splitter homemade.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
New invention machines, top 10 most amazing firewood cutting machine, wood splitter homemade 2
After watching this videos you say no problem for make firewood for you home, new invention of wood splitter machine around the ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown