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 g.id=i.parent_id left join shp_groups g1 on g1.id=g.parent_id left join shp_groups g2 on g2.id=g1.parent_id left join shp_groups g3 on g3.id=g2.parent_id left join shp_groups g4 on g4.id=g3.parent_id join shp_items_titles it on it.item_id=i.id left join shp_items_groups ig on i.id=ig.item_id 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 ig.item_id=i.id 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 s.id=i.id and IF(i.always_available='y',1,IFNULL(s.available,0)+fgetStockAll(i.id,s.size_id))>0 )>0) or i.item_brand_id<>192 )*/ order by IFNULL(ig.sort,i.sort) desc Outdoor&Travel Wear

WANDERN / TREKKING / REISEN