MySQL error: 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 ' pd.products_name' at line 8
SELECT DISTINCT @rownum:=@rownum+1 rownum,p.products_model, pd.products_name, p.products_weight, p.products_quantity, p.products_date_added, p.products_image, p.products_quality,
p.products_id,
p.products_image FROM products p,
products_description pd WHERE p.products_status = '1'
AND pd.products_id = p.products_id
AND pd.language_id = '1'
AND p.products_group_access LIKE '%G%'
AND DATE_SUB(CURDATE(),INTERVAL 360 DAY) <= p.products_date_addedfinal_price , pd.products_name
