SELECT DISTINCT c.* FROM cms_module_products c INNER JOIN cms_module_products_prodtohier ph ON ph.product_id = c.id INNER JOIN cms_module_products_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' AND h.hierarchy like '00043.00099.00117.00122%' ORDER BY  asc LIMIT 0, 24<br/>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 'asc LIMIT 0, 24' at line 1