Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Bicycle trailers]]
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
0
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 3 | 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) (1067).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=1067 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
Carla Cargo Crowd
Carla Cargo allows you to transport heavy loads quickly, environmentally friendly and without sitting in traffic. It can be combined with any regular bicycle or...
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Convertible Bicycle Trailer for people - with shock absorber
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
Trailer for bicycle based on Carla Cargo design
Contains PDF Blueprints: Yes
Contains CAD Files: Yes
License: CCBYSA40
$20 do it yourself Surfboard Bike Trailer
I wanted an easier way to carry my surfboard two miles to the beach, so I built a trailer that tows behind my bike. This video shows ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
????FIRST RIDE and NIGHT with 26kg DIY Ultralight BICYCLE CARAVAN (F5)
67 page build doc from KreAIR with materials list available : https://rene-kreher.de/dokumentation-fahrradwohnwagen-kreair/ ?An ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
????Floor plate and skeleton (F3) DIY BICYCLE CARAVAN build????
------------------------------------------------------------------------------------------------------ For all the fun of it, it takes a lot of time,
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
A do it yourself bike trailer for a narrow thaler - The ...
Paul Elkins fell for micro-camping in 2002 when he made the country in his cabover stealth camper. "Sure he could make something more affordable, this year he b...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Adjustabike Adjustable Bike DIY
Adjustabike is the concept of an open source build your own bike kit. It is made of standard aluminium tubes and custom attachments you can assemble the way you...
Contains PDF Blueprints: No
Contains CAD Files: Yes
License: CCBY40
Bamboo Bicycle Trailer : Design for disaster – aid, victims ...
12.02.2011 · Construction. The construction set consists of two wheels, hubs for attaching the wheels, a trailer coupling and tension ropes. In combin
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle Sidecar and Trailer Build...
Spent a couple of lovely sunny days building this. Did it because I wanted to see how a sidecar worked and how it felt to ride.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle Touring Trailer ( Radical Design Cyclone IV )
VISIT MY CHANNEL FOR MORE
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle Trailer Cyclone - The Expedition and Long Distance Bike Trailer Radical Design
The Bike Trailer Cyclone is the only trailer in the world to be converted into a lightweight duffel bag in seconds to be ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle camper build pt.1 (Paul Elkins plans)
My original project idea has finally begun, and now I bring you, the bike camper. (Yes the video is a day late). Songs: ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle camper trailer build update 4
Building a
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle caravan, do-it-yourself????????
With mattress, sink, LED,.... Chassis welded by myself and body built from screen printing plates. Everything else can ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle caravan: Build it yourself (blueprints ...
A caravan for bicycles is the curious do it yourself initiative (Do It Yourself) that Paul Elkins has developed. We just need a budget of $ 150. Paul Elkins's b...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle push trailer DIY
FSA250 - bicycle push trailer self-built by the Tüftler Frank .... Großsteinberg250 Watt motor, 2 x 12V battery, up to 25km / h ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle trailer - construction manual for do it yourself - 1-2-do.com ...
24.08.2015 I have had the desire to buy a bicycle trailer for some time now. Sure - you can buy something like that for cheap money, but if I want to drive a bi...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bicycle trailer conversion - construction manual for do it yourself - 1-2-do ...
14.01.2012 Since I like cycling for several days and always have everything with me on my travels and I do not want to use bicycle bags to stow away, there was...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown