Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Fitness, sports equipment]]
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 | 12 | 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) (603).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=603 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
DIY Leg Press (Garage Gym Ideas Under $30)
DIY
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY Making Treadmill Running Board From Scratch: Slick Surface Application. Part 3
Support Me & My Store Here For all your running/shoes needs https://www.fleetfeet.com/s/mobile# In this video I am applying a ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY Pallet Exercise Stepper
In this video, I'll show you how I've made an Exercise
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY Rowing Machine - PhilipB.org
DIY Rowing machine: Rowing Machine. Rowing machines are great, unfortunately the good ones are ridiculously expensive and they take up a lot of space.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY Rowing Machine for under $120
Yes, you read that right. Create your own
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY TREADMILL DESK. TREADMILL DESK - CERTIFICATION ...
A Treadmill Desk is a working desk built around a treadmill. A person using the treadmill desk walks slowly on the treadmill while continuing to perfo
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY Wooden LEG PRESS measurements - DIY gym - Fit at home
I've gotten many request on a cut list and dimensions on the
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY rowing machine 8 steps to your homemade rower
05.04.2019 · How to make a rowing machine? · 2 bolt hooks; · 2 hook screw; · 10 screw rings; · 4 spring washers of size M12; · 8 washers M12; · 8 hex
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY rowing machine with Odometer/Speedometer
Learn how to build your very own
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
DIY wooden LEG PRESS - fit at home
I've built a leg
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Diy Adjustable Weight Bench Prototype - Making gym bench
Hi. This is a gym
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Diy rowing machine metaspencer's collection of 7 rowing ideas
Openergo - Home - How to build a rowing machine ... An interesting open source project with lots of plans and resources on building rowing machines.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself - billiges Rudergerät - cheap rowing machine ;-)
Kettler Coach: http://amzn.to/2h7iPjb Schwarzenegger Arnold - Bodybuilding bible: http://amzn.to/1mxrs76 One possibility to ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself 3D Scanner (Arduino, 3D Printing, PCB Design, Stepper Motors, IR Sensing) - Super Make Something
Learn how to make a 3D scanner to digitize and clone objects around your house The STL files for the 3D scanner can be found ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself BLOG: do it yourself Weight Bench (5 position,Flat/Incline)
If you'd like to have a brand-new weight bench, but you don't want to spend a lot of money, then you might consider making one yourself. I decided to make a mul...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Bench Press How to make a weight bench
Follow us on Instagram: https://www.instagram.com/benjaminuyeda/ full build plans with dimensioned drawings here: ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Brushless DC hub Stepper Motor
Ett321 cal poly pomona this is video my team and i will be making a brushless dc motor from scratch. we are going to go over how ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Concrete Dumbbells: 9 Steps (with Pictures) - Instructables
By inAbout: I make useful low budget projects. I focus on home improvement, do it yourself gear and recycling topics.I made this 10 kg (23 lbs) dumbbell out of...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Delta Robot using stepper motors - 1st Demonstrator
This is a presentation showing an unfinished prototype of a self-built delta roboter. It's a hobbyist project whose focus laid on ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Do it yourself Dumbbell - Tho Carrion - Medium
This will secure the concrete and keep it from slipping off.Fill your mixing tub with the desired amount of concrete.Place in a corner to secure the cardboard o...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown