SELECT p.*,IF(WAWI_AKTION=1 AND WAWI_AKTION_VON<=CURDATE() AND WAWI_AKTION_BIS>=CURDATE(),WAWI_AKTION_PREIS,WAWI_PREIS) 'WAWI_PREIS',WAWI_PREIS 'DEF_PREIS',CASE WHEN CONCAT(ECO_BILDPFAD,LIVE_BILD_EIGEN)='' THEN '/images/295elber/dummy.png' ELSE IF(LIVE_BILD_EIGEN='',ECO_BILDPFAD,CONCAT('/aboimg/295elber/',LIVE_BILD_EIGEN)) END 'BILD' FROM produkte_live p JOIN shop_wg_alter ON(swa_prod_index=WAWI_PROD_INDEX AND WAWI_SHOP_ID=swa_shop_id) JOIN navigation ON (swa_nid=n_id AND n_shopid=swa_shop_id) WHERE WAWI_SHOP_ID='295elber' AND WAWI_MARKE_KURZ ='ERH' AND LIVE_ONLINE=1 AND !(WAWI_FUNKTION & 1140) ORDER BY n_rang_prodlist ASC,n_ebene,n_rang DESC,LIVE_ORDER DESC,name ASC