1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(p.group_expire_date,now()) as d from products p, products_description pd where ' at line 1

select p.deposit_due_date, p.full_payment_due_date, p.is_group_buy, p.group_buy_status, p.group_expire_date, p.products_weight, pd.products_shop, p.products_id, pd.products_reviews, pd.products_name, pd.products_description, pd.products_specs, pd.products_geometry, pd.products_warranty, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.percentage_mode,cast TIMEDIFF(p.group_expire_date,now()) as d from products p, products_description pd where p.products_id = '13973' and pd.products_id = p.products_id and pd.language_id = '1'