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 '00004%' AND  EXISTS( SELECT * FROM cms_module_products_hierarchy filterh,cms_module_products_prodtohier filterph
			WHERE filterh.hierarchy LIKE 'rapid-food-safety-equipment%' AND filterph.product_id = c.id AND filterph.hierarchy_id=filterh.id) 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 2