Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Recycling]]
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 | 26 | 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) (1090).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=1090 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
Do it yourself Cable Stripper Machine for Recycling Copper Wires.: 10 Steps ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Cable Stripper Part 2 Adjustable Pressure Slider Power Motor
Cable Stripper - wire stripper machine to recycling copper wires from cables. Step by step layout guide, including materials and ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Cable stripper Part 1 Main Base Bearings Bushing Base
Cable Stripper - wire stripper machine to recycling copper wires from cables. Don't miss Part 2 Adjustable Pressure Slider ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Hot Foil Chipboard at home with the GoPress and Hot Foil Machine do it yourself Invitations and cards
Do it Yourself Invitation TutorialSubscribe to our Channel -> https://www.youtube.com/c/eternalstationerymelbourne ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Paper Fire briquette press
Here is how I made a fire brick/briquette press to process junk mail into a usable resource. i have seen alot of way to make the ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Pneumatic PVC Can Crusher - Gizmoplans
Add to cartDescriptionAre you sick of having to crush all your cans with an old manual can crusher? Well I am, this is why I decide to design and build an air p...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself automatic cable cutter
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself free energy paper briquette press part 2
The second part and 1st draft paper briquette press maker, working but needs finishing touched. For burning in a wood burner for ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself manual can crusher (Andrew Wong)
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself paper log press
how to make a paper log.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself paper press and making paper briquettes
This is my first project i filmed, i am planning to make more. I hope you enjoy this video. if you have questions, just ask them in the ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself paper shredder
Multiple uses for your lawn mower - try paper shredding.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself ultrasonic welder press for plastics
This video shows a do it yourself ultrasonic welder press made from a basic drill press and a few parts lying around the workshop.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Dücker HF960 with Deutz F6l913 130HP wood chipper wood chipper self-made
First test run with the good engine Unfortunately, no thick wood.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Edge shredder working in construction and demolition waste in Birmingham Alabama
Created on March 29, 2012 using FlipShare.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Free Life Hacks Homemade Cable stripper
Free Life Hacks Homemade videos How to make videos.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Free do it yourself Can Crusher
This is a do it yourself can crusher I built for free. Like us on Facebook: ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
HOME CABLE PELADOR 2018 do it yourself AND CRAFTS. Edbarr0NE
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
HOMEMADE SUPER SIMPLE WIRE STRIPPER, Copper cable stripper, Strip wire
I made a super simple, easy to use, wire stripper. To help strip the insulation off copper wires. It's like money in the bank
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
HOW TO MAKE HYDRAULIC PRESS FROM CARDBOARD
So, today i will show you how to make powerfull hydraulic press from cardboard. You can use this do it yourself tutorial to make amazing ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown