#Ab sofort ZH Buchegg & ZH City wieder 5 Tage geöffnet.
select marke
FROM bf_stock_sale
where online = 1
and 'Bike' = 'Bike'
union
SELECT marke
FROM `ebike_serie` s, ebike_modelle m, ebike_variationen v
where s.serie_id = m.serie_id
and m.model_id = v.model_id
and (jahrgang < 2017 or sale/preis < .75)
and sale <> 0
and s.active = 1
and m.active = 1
and v.active = 1
and type= 'Bike'
and serieurl <> 'flyer_outlet'
order by 1 -Table 'svcrm.bf_stock_sale' doesn't exist