I have figured it out....
I just had to add distinct to the sql command....
Changed
$products_query = tep_db_query("select s.specials_new_products_price, p.products_id, .....
To
$products_query = tep_db_query("select distinct s.specials_new_products_price, p.products_id, .....
Thanks