-

select distinct s.products_id, p.products_id, p.manufacturers_id, s.specials_new_products_price, s.expires_date, s.status, p.products_model, p.products_tax_class_id, p.products_image, p.products_ups, pd.products_name, pd.products_eta, p.products_price, p.products_original_price, p.products_ordered, p.products_image, p.products_recently_viewed, p.products_date_added, p.products_quantity, p.products_free_return, p.products_stars from specials s, products p, products_description pd, products_to_categories p2c where s.status= '1' and p.products_status= '1' and p.products_id = s.products_id and pd.products_id = s.products_id and p2c.products_id = s.products_id and (p2c.categories_id = '577' or p2c.categories_id = '631' or p2c.categories_id = '634' or p2c.categories_id = '637' or p2c.categories_id = '624' or p2c.categories_id = '275' or p2c.categories_id = '277' or p2c.categories_id = '279' or p2c.categories_id = '654' or p2c.categories_id = '661' or p2c.categories_id = '749' or p2c.categories_id = '1424' or p2c.categories_id = '1425' or p2c.categories_id = '1426' or p2c.categories_id = '628' or p2c.categories_id = '278' or p2c.categories_id = '595' or p2c.categories_id = '629' or p2c.categories_id = '630' or p2c.categories_id = '635') and p.manufacturers_id = '100' and pd.language_id = '1' order by

[TEP STOP]