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 'by products_name' at line 6
select count(p.products_id) as total from products p, products_to_categories p2c, categories c
where
p.products_status='1' and
c.categories_status='1' and
p.products_id = p2c.products_id and
p2c.categories_id = c.categories_idorder by products_name
