SELECT b.*
 FROM ss_banners_categories b 
 LEFT JOIN ss_banners_categories_link c 
 ON b.id=c.bannerID 
 LEFT JOIN ss_banners_categories_link2 f 
 ON b.id=f.bannerID 
 WHERE b.enabled = 1 AND b.discount > 0 AND c.categoryID = '114' AND f.firmID = '248' AND b.price<50890 
 ORDER BY b.pos ASC, b.price ASC, b.discount DESC