error:Query execution was interrupted
sql:SELECT te.webcd, te.brandcd, te.smallcd, te.itemnm, te.pretaxprice, te.pretaxsaleprice, te.itemid, sei.list_photo_flg, sei.price_type, datediff(now(), sei.display_term_from) as display_days, c1.colornm as colornm_1, c2.colornm as colornm_2, c3.colornm as colornm_3, p.patternnm, b.brandnm from t_stock ts left outer join shop_web_config swc on (ts.shopcd = swc.shop_code) left outer join t_exhibit te on (ts.webcd = te.webcd) inner join m_item mi on (left(te.webcd, 10) = mi.webcd) left outer join shop_item_ec_info sei on (left(te.webcd, 10) = sei.item_id) left outer join m_small s on (mi.largecd = s.largecd and mi.middlecd = s.middlecd and mi.smallcd = s.smallcd) left outer join m_brand b on (te.brandcd = b.brandcd) left outer join m_pattern p on (te.patterncd = p.patterncd) left outer join m_color c1 on (te.colorcd1 = c1.colorcd) left outer join m_color c2 on (te.colorcd2 = c2.colorcd) left outer join m_color c3 on (te.colorcd3 = c3.colorcd) where exists (select * from shop_item_ec_image where web_code = left(ts.webcd, 12) and image_type = 1) and exists (select * from shop_item_ec_image where web_code = left(ts.webcd, 12) and image_type = 2) and ts.shopcd = '3' and sei.display_flg = 1 and (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 te.brandcd = NULL and mi.middlecd = NULL order by sei.upd_date desc