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 = '35' or p2c.categories_id = '264' or p2c.categories_id = '266' or p2c.categories_id = '265' or p2c.categories_id = '194' or p2c.categories_id = '195' or p2c.categories_id = '196' or p2c.categories_id = '197' or p2c.categories_id = '198' or p2c.categories_id = '199' or p2c.categories_id = '200' or p2c.categories_id = '201' or p2c.categories_id = '202' or p2c.categories_id = '203' or p2c.categories_id = '204' or p2c.categories_id = '209' or p2c.categories_id = '212' or p2c.categories_id = '222' or p2c.categories_id = '223' or p2c.categories_id = '241' or p2c.categories_id = '268' or p2c.categories_id = '276' or p2c.categories_id = '279' or p2c.categories_id = '283' or p2c.categories_id = '286' or p2c.categories_id = '288' or p2c.categories_id = '289' or p2c.categories_id = '290' or p2c.categories_id = '294' or p2c.categories_id = '298' or p2c.categories_id = '479' or p2c.categories_id = '31' or p2c.categories_id = '34' or p2c.categories_id = '32' or p2c.categories_id = '33' or p2c.categories_id = '263' or p2c.categories_id = '262' or p2c.categories_id = '312' or p2c.categories_id = '186' or p2c.categories_id = '187' or p2c.categories_id = '188' or p2c.categories_id = '189' or p2c.categories_id = '190' or p2c.categories_id = '191' or p2c.categories_id = '192' or p2c.categories_id = '193' or p2c.categories_id = '210' or p2c.categories_id = '213' or p2c.categories_id = '217' or p2c.categories_id = '231' or p2c.categories_id = '232' or p2c.categories_id = '242' or p2c.categories_id = '255' or p2c.categories_id = '269' or p2c.categories_id = '270' or p2c.categories_id = '271' or p2c.categories_id = '273' or p2c.categories_id = '275' or p2c.categories_id = '278' or p2c.categories_id = '282' or p2c.categories_id = '284' or p2c.categories_id = '285' or p2c.categories_id = '539' or p2c.categories_id = '23' or p2c.categories_id = '24' or p2c.categories_id = '25' or p2c.categories_id = '26' or p2c.categories_id = '27' or p2c.categories_id = '28' or p2c.categories_id = '29' or p2c.categories_id = '30' or p2c.categories_id = '215' or p2c.categories_id = '303' or p2c.categories_id = '300' or p2c.categories_id = '299' or p2c.categories_id = '168' or p2c.categories_id = '169' or p2c.categories_id = '170' or p2c.categories_id = '171' or p2c.categories_id = '172' or p2c.categories_id = '173' or p2c.categories_id = '174' or p2c.categories_id = '175' or p2c.categories_id = '176' or p2c.categories_id = '177' or p2c.categories_id = '178' or p2c.categories_id = '179' or p2c.categories_id = '180' or p2c.categories_id = '181' or p2c.categories_id = '182' or p2c.categories_id = '183' or p2c.categories_id = '184' or p2c.categories_id = '185' or p2c.categories_id = '205' or p2c.categories_id = '206' or p2c.categories_id = '207' or p2c.categories_id = '208' or p2c.categories_id = '211' or p2c.categories_id = '216' or p2c.categories_id = '224' or p2c.categories_id = '225' or p2c.categories_id = '227' or p2c.categories_id = '228' or p2c.categories_id = '229' or p2c.categories_id = '230' or p2c.categories_id = '233' or p2c.categories_id = '238' or p2c.categories_id = '239' or p2c.categories_id = '240' or p2c.categories_id = '251' or p2c.categories_id = '252' or p2c.categories_id = '253' or p2c.categories_id = '254' or p2c.categories_id = '256' or p2c.categories_id = '257' or p2c.categories_id = '258' or p2c.categories_id = '259' or p2c.categories_id = '260' or p2c.categories_id = '267' or p2c.categories_id = '272' or p2c.categories_id = '274' or p2c.categories_id = '287' or p2c.categories_id = '292' or p2c.categories_id = '296' or p2c.categories_id = '297' or p2c.categories_id = '582' or p2c.categories_id = '22')order by p.products_date_added desc limit 24