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 '20~%' and pcoll.products_collection_id = cg.products_collection_id and c.catego' at line 1
in:
[select distinct c.categories_id, cd.categories_name, cg.master_categories_id from categories c, categories_description cd, products cg, products_collection pcoll, (SELECT DISTINCT master_categories_id FROM (SELECT 1-s.specials_new_products_price/p.products_price as discount, p.products_id, p.products_sx_id, p.master_categories_id, COUNT(DISTINCT products_sx_id),IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price FROM products p left join specials s on p.products_id = s.products_id GROUP BY products_sx_id) psx WHERE psx.discount > 0.4) jx where c.categories_id=cd.categories_id and cg.master_categories_id=c.categories_id and jx.master_categories_id=c.categories_id and pcoll.products_collection LIKE '%~Beast \\'20~%' and pcoll.products_collection_id = cg.products_collection_id and c.categories_id IN(2,3,4,5,6,7,9,10,11,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27) and cd.language_id='1' and c.categories_status='1' order by c.sort_order,cd.categories_id]
