Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Bicycles]]
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 | 10 | 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) (1063).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=1063 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
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
Bike Trailer BUILD
In this one I cut up my old bike
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike caravan build part 3 - Problems with the door?
Body made of aluminum tubes and double web plates. Are the problems with the door to be solved ? Materials used ? New ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike caravan under 150EUR bike caravan build yourself
The material: 15mm victory plate 1250 x 2500 mm truck tarpaulin white screws wheels from a unicycle drawbar steel ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike of the week: do it yourself project "Die Maschine" by IBC-User ...
Then it goes on to the frame construction - different tubes and cylinders are the starting material for my dream. The frame is made of steel, the bellcranks etc...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike trailer build yourself - Götzis - market town Götzis
Info The bike has many advantages: it is light, agile, healthy, communicative, affordable, durable and resource efficient. If you want to transport larger goods...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike trailer build yourself 1 Video of 2. Video 743 Locksmith Oldorf
This is my first bicycle trailer, it will be after a Schubanhänger which is equipped with a 24 volt electric motor ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike trailer do it yourself Build Plan: Cargo bike itself ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bike under steam, a homemade
A steam bicycle, presented at the 10th International Steam Meeting 2013 AGRONEUM Alt Schwerin Now the steam bike is driving ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Bikesport Micro-Camper Tows Behind a Bike Full Plans
This is a demo of a new design called the Bikesport Micro-Camper. This is a small lightweight camper that can be pushed like a ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Biketrailer bicycle trailer single-trailer one wheel trailer transport trailer homemade homemade
Bike trailers, bicycle trailers, homemade, single-trailer, one wheel trailer, trailer, homemade,
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Blueprint For Bicycle Trailers Sleeping - homesecurity.press
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown