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 ') where ((i.parent_id in () or ig.parent_id in () ) or exists (selec' at line 16
select i.*, g.title parent_title, it.title, CONCAT(REPLACE(it.title,'/',' '),'.html') title4url, g.description parent_description , CONCAT(IFNULL(CONCAT(g4.title, '/'),'') , IFNULL(CONCAT(g3.title,'/'),'') , IFNULL(CONCAT(g2.title,'/'),'') , IFNULL(CONCAT(g1.title,'/'),'') , IFNULL(CONCAT(g.title,'/'),'') ) parent_url from shp_items_v i join shp_groups g on left join shp_groups g1 on left join shp_groups g2 on left join shp_groups g3 on left join shp_groups g4 on join shp_items_titles it on left join shp_items_groups ig on and ig.parent_id in () where ((i.parent_id in () or ig.parent_id in () ) or exists (select null from shp_items_groups ig where and ig.parent_id in ()) or (323 in () and IFNULL(i.item_discount,0) and i.discount_folder=323)) /* and ( (i.item_brand_id=192 and (select count(*) from shp_sizes s where and IF(i.always_available='y',1,IFNULL(s.available,0)+fgetStockAll(,s.size_id))>0 )>0) or i.item_brand_id<>192 )*/ order by IFNULL(ig.sort,i.sort) desc Outdoor&Travel Wear