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 '-15, 15' at line 20
SELECT DISTINCT
p.*,
pd.*,
m.*,
t2p.products_id,
tn.tag_name,
t2p.tag_id FROM t10_tag_to_product t2p
LEFT JOIN products_description pd
ON pd.products_id = t2p.products_id
LEFT JOIN products p
ON p.products_id = t2p.products_id
LEFT JOIN manufacturers m
ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN specials s
ON p.products_id = s.products_id
LEFT JOIN t10_tag_names tn
ON t2p.tag_id = tn.tag_id AND tn.language_id = 2
WHERE p.products_status=1
AND t2p.tag_id=96
AND pd.language_id=2 ORDER BY pd.products_name ASC LIMIT -15, 15
[XT SQL Error]