SELECT lf08v2_hersteller.herstellernr, lf08v2_hersteller.herstellername, lf08v2_fahrradarten.bezeichnung FROM lf08v2_hersteller JOIN lf08v2_fahrradarten ORDER BY `lf08v2_hersteller`.`herstellernr` ASC;
Ausgabe
| Herstellernummer |
Herstellername |
Bezeichnung |
| 1 |
Kettler |
Spezialrad |
| 1 |
Kettler |
Tandem |
| 1 |
Kettler |
Rennrad |
| 1 |
Kettler |
Mountainbike |
| 1 |
Kettler |
Trekkingrad |
| 1 |
Kettler |
Jugendrad |
| 1 |
Kettler |
Kinderrad |
| 2 |
Bianci |
Spezialrad |
| 2 |
Bianci |
Tandem |
| 2 |
Bianci |
Rennrad |
| 2 |
Bianci |
Mountainbike |
| 2 |
Bianci |
Trekkingrad |
| 2 |
Bianci |
Jugendrad |
| 2 |
Bianci |
Kinderrad |
| 3 |
Fishbone |
Spezialrad |
| 3 |
Fishbone |
Tandem |
| 3 |
Fishbone |
Rennrad |
| 3 |
Fishbone |
Mountainbike |
| 3 |
Fishbone |
Trekkingrad |
| 3 |
Fishbone |
Jugendrad |
| 3 |
Fishbone |
Kinderrad |
| 4 |
Scott |
Spezialrad |
| 4 |
Scott |
Tandem |
| 4 |
Scott |
Rennrad |
| 4 |
Scott |
Mountainbike |
| 4 |
Scott |
Trekkingrad |
| 4 |
Scott |
Jugendrad |
| 4 |
Scott |
Kinderrad |
| 5 |
Yazoo |
Spezialrad |
| 5 |
Yazoo |
Tandem |
| 5 |
Yazoo |
Rennrad |
| 5 |
Yazoo |
Mountainbike |
| 5 |
Yazoo |
Trekkingrad |
| 5 |
Yazoo |
Jugendrad |
| 5 |
Yazoo |
Kinderrad |
| 6 |
Arcona |
Spezialrad |
| 6 |
Arcona |
Tandem |
| 6 |
Arcona |
Rennrad |
| 6 |
Arcona |
Mountainbike |
| 6 |
Arcona |
Trekkingrad |
| 6 |
Arcona |
Jugendrad |
| 6 |
Arcona |
Kinderrad |
| 7 |
BBF |
Spezialrad |
| 7 |
BBF |
Tandem |
| 7 |
BBF |
Rennrad |
| 7 |
BBF |
Mountainbike |
| 7 |
BBF |
Trekkingrad |
| 7 |
BBF |
Jugendrad |
| 7 |
BBF |
Kinderrad |
| 8 |
Cateye |
Spezialrad |
| 8 |
Cateye |
Tandem |
| 8 |
Cateye |
Rennrad |
| 8 |
Cateye |
Mountainbike |
| 8 |
Cateye |
Trekkingrad |
| 8 |
Cateye |
Jugendrad |
| 8 |
Cateye |
Kinderrad |
| 9 |
Bulls |
Mountainbike |
| 9 |
Bulls |
Trekkingrad |
| 9 |
Bulls |
Jugendrad |
| 9 |
Bulls |
Kinderrad |
| 9 |
Bulls |
Spezialrad |
| 9 |
Bulls |
Tandem |
| 9 |
Bulls |
Rennrad |
| 10 |
Dahon |
Spezialrad |
| 10 |
Dahon |
Tandem |
| 10 |
Dahon |
Rennrad |
| 10 |
Dahon |
Mountainbike |
| 10 |
Dahon |
Trekkingrad |
| 10 |
Dahon |
Jugendrad |
| 10 |
Dahon |
Kinderrad |
| 11 |
Centano |
Spezialrad |
| 11 |
Centano |
Tandem |
| 11 |
Centano |
Rennrad |
| 11 |
Centano |
Mountainbike |
| 11 |
Centano |
Trekkingrad |
| 11 |
Centano |
Jugendrad |
| 11 |
Centano |
Kinderrad |
| 12 |
Ergon |
Spezialrad |
| 12 |
Ergon |
Tandem |
| 12 |
Ergon |
Rennrad |
| 12 |
Ergon |
Mountainbike |
| 12 |
Ergon |
Trekkingrad |
| 12 |
Ergon |
Jugendrad |
| 12 |
Ergon |
Kinderrad |
| 13 |
Flyke |
Spezialrad |
| 13 |
Flyke |
Tandem |
| 13 |
Flyke |
Rennrad |
| 13 |
Flyke |
Mountainbike |
| 13 |
Flyke |
Trekkingrad |
| 13 |
Flyke |
Jugendrad |
| 13 |
Flyke |
Kinderrad |
| 14 |
GIANT |
Kinderrad |
| 14 |
GIANT |
Spezialrad |
| 14 |
GIANT |
Tandem |
| 14 |
GIANT |
Rennrad |
| 14 |
GIANT |
Mountainbike |
| 14 |
GIANT |
Trekkingrad |
| 14 |
GIANT |
Jugendrad |
| 15 |
Hercules |
Spezialrad |
| 15 |
Hercules |
Tandem |
| 15 |
Hercules |
Rennrad |
| 15 |
Hercules |
Mountainbike |
| 15 |
Hercules |
Trekkingrad |
| 15 |
Hercules |
Jugendrad |
| 15 |
Hercules |
Kinderrad |
| 16 |
KTM Bikes |
Spezialrad |
| 16 |
KTM Bikes |
Tandem |
| 16 |
KTM Bikes |
Rennrad |
| 16 |
KTM Bikes |
Mountainbike |
| 16 |
KTM Bikes |
Trekkingrad |
| 16 |
KTM Bikes |
Jugendrad |
| 16 |
KTM Bikes |
Kinderrad |
| 17 |
Puky |
Spezialrad |
| 17 |
Puky |
Tandem |
| 17 |
Puky |
Rennrad |
| 17 |
Puky |
Mountainbike |
| 17 |
Puky |
Trekkingrad |
| 17 |
Puky |
Jugendrad |
| 17 |
Puky |
Kinderrad |
| 18 |
Rmer |
Rennrad |
| 18 |
Rmer |
Mountainbike |
| 18 |
Rmer |
Trekkingrad |
| 18 |
Rmer |
Jugendrad |
| 18 |
Rmer |
Kinderrad |
| 18 |
Rmer |
Spezialrad |
| 18 |
Rmer |
Tandem |
| 19 |
Schwalbe |
Spezialrad |
| 19 |
Schwalbe |
Tandem |
| 19 |
Schwalbe |
Rennrad |
| 19 |
Schwalbe |
Mountainbike |
| 19 |
Schwalbe |
Trekkingrad |
| 19 |
Schwalbe |
Jugendrad |
| 19 |
Schwalbe |
Kinderrad |
| 20 |
Panther |
Spezialrad |
| 20 |
Panther |
Tandem |
| 20 |
Panther |
Rennrad |
| 20 |
Panther |
Mountainbike |
| 20 |
Panther |
Trekkingrad |
| 20 |
Panther |
Jugendrad |
| 20 |
Panther |
Kinderrad |
| 21 |
Cube |
Spezialrad |
| 21 |
Cube |
Tandem |
| 21 |
Cube |
Rennrad |
| 21 |
Cube |
Mountainbike |
| 21 |
Cube |
Trekkingrad |
| 21 |
Cube |
Jugendrad |
| 21 |
Cube |
Kinderrad |
| 22 |
Comus |
Spezialrad |
| 22 |
Comus |
Tandem |
| 22 |
Comus |
Rennrad |
| 22 |
Comus |
Mountainbike |
| 22 |
Comus |
Trekkingrad |
| 22 |
Comus |
Jugendrad |
| 22 |
Comus |
Kinderrad |
| 23 |
Koga-Miyata |
Jugendrad |
| 23 |
Koga-Miyata |
Kinderrad |
| 23 |
Koga-Miyata |
Spezialrad |
| 23 |
Koga-Miyata |
Tandem |
| 23 |
Koga-Miyata |
Rennrad |
| 23 |
Koga-Miyata |
Mountainbike |
| 23 |
Koga-Miyata |
Trekkingrad |
| 24 |
Maxcycles |
Spezialrad |
| 24 |
Maxcycles |
Tandem |
| 24 |
Maxcycles |
Rennrad |
| 24 |
Maxcycles |
Mountainbike |
| 24 |
Maxcycles |
Trekkingrad |
| 24 |
Maxcycles |
Jugendrad |
| 24 |
Maxcycles |
Kinderrad |