1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-51, 51' at line 28
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 = 1
WHERE
p.products_status = '1'
AND
t2p.tag_id = 40
AND
pd.language_id = '1'
ORDER BY pd.products_name ASC
LIMIT -51, 51
[XT SQL Error]