- 브랜드
select * from shop_brand where ( br_user_yes = '0' ) and ( exists (select brand_uid from (select brand_uid from shop_goods a left outer join shop_category b on a.ca_id = b.catecode
where a.shop_state = 0
and a.isopen = 1
and (a.use_aff = 0 )
and find_in_set('ssline', a.use_hide) = 0
and find_in_set('ssline', b.catehide) = 0
and (ca_id like '%' or ca_id2 like '%' or ca_id3 like '%') and ( ( concat(replace(a.gname,' ',''),' ',replace(a.explan,' ',''),' ',a.maker,' ',a.model,' ',a.gcode,' ',a.standard) like '%표지판%' or find_in_set('표지판', a.keywords) >= 1 or ( concat(replace(a.gname,' ',''),' ',replace(a.explan,' ',''),' ',a.maker,' ',a.model,' ',a.gcode,' ',a.standard) like '%표지판%' ) ) or exists (select 1 from shop_goods_materials gm join shop_goods g on gm.gs_id2 = g.index_no where g.islist = '2' and ( concat(replace(g.gname,' ',''),' ',replace(g.explan,' ',''),' ',g.maker,' ',g.model,' ',g.gcode,' ',g.standard) like '%표지판%' or find_in_set('표지판', g.keywords) >= 1 or ( concat(replace(g.gname,' ',''),' ',replace(g.explan,' ',''),' ',g.maker,' ',g.model,' ',g.gcode,' ',g.standard) like '%표지판%' ) ) and gm.gs_id = a.index_no)) group by brand_uid ) a where 1=1 and brand_uid = br_id)) order by br_name limit 10
1317 : Query execution was interrupted
error file : /shop/search.php