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 'get, ls.end_time, ls.ls_price FROM products p ' at line 6

SELECT p.products_id, p.products_price, p.products_tax_class_id, p.products_image, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_name, ls.start_time, DATE_FORMAT(ls.start_time,'%d.%m.%Y') as gst, DATE_FORMAT(ls.end_time,'%d.%m.%Y') as get, ls.end_time, ls.ls_price FROM products p INNER JOIN products_description pd ON p.products_id = pd.products_id INNER JOIN live_shopping ls ON ls.products_id = p.products_id WHERE (TIMESTAMP(ls.start_time, '00:00:00') >= DATE_SUB(NOW(), INTERVAL 1 DAY) AND TIMESTAMP(ls.start_time, '00:00:00') <= DATE_ADD(NOW(), INTERVAL 0 DAY)) AND pd.language_id = '2' ORDER BY ls.end_time DESC LIMIT 1

[XT SQL Error]