error:Query execution was interrupted
sql:SELECT DISTINCT ts.shopcd, te.webcd, ts.salelimit, coalesce(tws.web_sale_count, 0) as web_sale_count , te.itemnm, te.transsize, te.patterncd, te.colorcd1, te.colorcd2, te.colorcd3, te.sizecd, te.brandcd, mi.largecd, mi.middlecd, mi.smallcd, te.delivery, ts.pretaxprice, ts.pretaxsaleprice, ts.price, ts.saleprice, ts.webrate, mp.patternnm, mc1.colornm as colornm_1, mc2.colornm as colornm_2, mc3.colornm as colornm_3, mb.brandnm, mb.brandreading, ml.largenm, mm.middlenm, ms.smallnm, msz.sizenm, mb.ordernum as b_ordernum, ml.ordernum as l_ordernum, mm.ordernum as m_ordernum, ms.ordernum as s_ordernum, swc.new_days, swc.list_type, swc.list_soldout_display_flg, sei.display_flg, sei.display_term_from, sei.display_term_to, sei.display_term_time_from, sei.display_term_time_to , sei.explanation, sei.sup_explanation, sei.keyword , sei.zero_display, sei.zero_display_days, sei.negotiation, sei.cart_flg, sei.deliv_date_shitei, sei.list_photo_flg, sei.detail_flg, sei.price_type, datediff(now(), sei.display_term_from) as display_days, datediff(now(), te.zerodate) as zerodate_past_days, img.image_no, img2.image_no as image_no2 from t_exhibit te inner join m_item mi on (left(te.webcd, 10) = mi.webcd) left join t_stock ts on (ts.webcd = te.webcd) left outer join shop_web_config swc on swc.shop_code = '3' left outer join ( select webcd, sum(salequantity) as web_sale_count from t_websale where delflg = 1 group by webcd ) tws on (ts.webcd = tws.webcd) left outer join shop_item_ec_image img on ( left(te.webcd, 10) = img.web_code and img.image_type=1 and img.image_no = 1 ) left outer join shop_item_ec_image img2 on ( left(te.webcd, 12) = img2.web_code and img2.image_type=1 and img2.image_no = 1 ) left outer join m_pattern mp on (te.patterncd = mp.patterncd) left outer join m_size msz on (te.sizecd = msz.sizecd) left outer join m_color mc1 on (te.colorcd1 = mc1.colorcd) left outer join m_color mc2 on (te.colorcd2 = mc2.colorcd) left outer join m_color mc3 on (te.colorcd3 = mc3.colorcd) left outer join m_brand mb on (te.brandcd = mb.brandcd) left outer join m_large ml on (mi.largecd = ml.largecd) left outer join m_middle mm on (mi.largecd = mm.largecd and mi.middlecd = mm.middlecd) left outer join m_small ms on (mi.largecd = ms.largecd and mi.middlecd = ms.middlecd and mi.smallcd = ms.smallcd) left outer join shop_item_ec_info sei on (left(te.webcd, 10) = sei.item_id) where ( exists (select * from shop_item_ec_image where web_code = left(te.webcd, 10) and image_type = 1) or exists (select * from shop_item_ec_image where web_code = left(te.webcd, 12) and image_type = 1) ) and ( exists (select * from shop_item_ec_image where web_code = left(te.webcd, 10) and image_type = 2) or exists (select * from shop_item_ec_image where web_code = left(te.webcd, 12) and image_type = 2) ) and ts.shopcd = '3' and sei.display_flg = '1' and ( sei.display_flg = '0' or ( ( sei.display_term_from < DATE(NOW()) or ( sei.display_term_from = DATE(NOW()) and ( sei.display_term_time_from IS NULL or sei.display_term_time_from <= TIME(NOW()) ) ) ) and ( sei.display_term_to > DATE(NOW()) or ( sei.display_term_to = DATE(now()) and ( sei.display_term_time_to IS NULL or sei.display_term_time_to >= TIME(NOW()) ) ) ) ) ) and swc.shop_code is not null and swc.list_type_flg != 0 and swc.list_count_flg != 0 and swc.list_type != 0 and swc.list_count != 0 and ( te.zerodate is null or (sei.zero_display = 1 ) or ( te.zerodate is not null and (sei.zero_display = 2 or sei.zero_display = 3) and datediff(now(), te.zerodate) < sei.zero_display_days) ) and ( ifnull(ts.salelimit, 0) - ifnull(tws.web_sale_count, 0) > 0 or (sei.zero_display = 1) or ( ifnull(ts.salelimit, 0) - ifnull(tws.web_sale_count, 0) <= 0 and (sei.zero_display = 2 or sei.zero_display = 3) and sei.zero_display_days > 0 ) ) and te.itemid = '0' and (te.webcd like 'W21B27002501%') order by sei.upd_date desc LIMIT 1