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 '00003%' ORDER BY  asc LIMIT 0, 100000<br/>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 'asc LIMIT 0, 100000' at line 1