|
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 '' at line 8
select count(distinct p.products_id) as total FROM products p
LEFT JOIN products_description pd on pd.products_id = p.products_id and pd.language_id = '1'
LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN products_to_categories ptc ON (p.products_id = ptc.products_id)
LEFT JOIN categories c ON (ptc.categories_id = c.categories_id)
LEFT JOIN categories_description cd ON (c.categories_id = cd.categories_id and cd.language_id = '1')
WHERE p.products_status = '1'
AND ptc.categories_id =
[TEP STOP]
| 
