select distinct p.products_id,p.products_model , p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and (p2c.categories_id = '52' or p2c.categories_id = '327' or p2c.categories_id = '377' or p2c.categories_id = '214' or p2c.categories_id = '328' or p2c.categories_id = '329' or p2c.categories_id = '330' or p2c.categories_id = '331' or p2c.categories_id = '332' or p2c.categories_id = '333' or p2c.categories_id = '334' or p2c.categories_id = '335' or p2c.categories_id = '349' or p2c.categories_id = '371' or p2c.categories_id = '372' or p2c.categories_id = '373' or p2c.categories_id = '374' or p2c.categories_id = '375' or p2c.categories_id = '480' or p2c.categories_id = '620' or p2c.categories_id = '518' or p2c.categories_id = '520' or p2c.categories_id = '522' or p2c.categories_id = '613' or p2c.categories_id = '91' or p2c.categories_id = '92' or p2c.categories_id = '93' or p2c.categories_id = '527' or p2c.categories_id = '528' or p2c.categories_id = '530' or p2c.categories_id = '531' or p2c.categories_id = '532' or p2c.categories_id = '615' or p2c.categories_id = '94' or p2c.categories_id = '95' or p2c.categories_id = '97' or p2c.categories_id = '98' or p2c.categories_id = '99' or p2c.categories_id = '100' or p2c.categories_id = '101' or p2c.categories_id = '301' or p2c.categories_id = '622' or p2c.categories_id = '243' or p2c.categories_id = '244' or p2c.categories_id = '245' or p2c.categories_id = '246' or p2c.categories_id = '247' or p2c.categories_id = '248' or p2c.categories_id = '249' or p2c.categories_id = '250' or p2c.categories_id = '261' or p2c.categories_id = '378' or p2c.categories_id = '293' or p2c.categories_id = '321' or p2c.categories_id = '322' or p2c.categories_id = '324' or p2c.categories_id = '337' or p2c.categories_id = '338' or p2c.categories_id = '339' or p2c.categories_id = '340' or p2c.categories_id = '341' or p2c.categories_id = '342' or p2c.categories_id = '343' or p2c.categories_id = '344' or p2c.categories_id = '345' or p2c.categories_id = '346' or p2c.categories_id = '347' or p2c.categories_id = '348' or p2c.categories_id = '369' or p2c.categories_id = '350' or p2c.categories_id = '234' or p2c.categories_id = '351' or p2c.categories_id = '352' or p2c.categories_id = '353' or p2c.categories_id = '354' or p2c.categories_id = '355' or p2c.categories_id = '356' or p2c.categories_id = '357' or p2c.categories_id = '358' or p2c.categories_id = '359' or p2c.categories_id = '360' or p2c.categories_id = '361' or p2c.categories_id = '362' or p2c.categories_id = '363' or p2c.categories_id = '364' or p2c.categories_id = '365' or p2c.categories_id = '366' or p2c.categories_id = '367' or p2c.categories_id = '368' or p2c.categories_id = '489' or p2c.categories_id = '490' or p2c.categories_id = '519' or p2c.categories_id = '521' or p2c.categories_id = '624' or p2c.categories_id = '370' or p2c.categories_id = '376' or p2c.categories_id = '469' or p2c.categories_id = '577' or p2c.categories_id = '545' or p2c.categories_id = '546' or p2c.categories_id = '547' or p2c.categories_id = '548' or p2c.categories_id = '549' or p2c.categories_id = '550' or p2c.categories_id = '581' or p2c.categories_id = '470' or p2c.categories_id = '575' or p2c.categories_id = '525' or p2c.categories_id = '523' or p2c.categories_id = '529' or p2c.categories_id = '534' or p2c.categories_id = '544' or p2c.categories_id = '585' or p2c.categories_id = '587' or p2c.categories_id = '619' or p2c.categories_id = '614' or p2c.categories_id = '617' or p2c.categories_id = '51')order by p.products_date_added desc limit 24