select  ar_id from shop_artikel_neu left join shop_hersteller on herst_liefnr = ar_hersteller WHERE ((ar_nr_neu LIKE '%78550090002%') AND ar_archiv <> 'Y' AND (herst_active = 1 OR herst_liefnr = 'K70960'))