error:Query execution was interrupted<br>
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 = 'H'   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()) ))) order by sei.upd_date desc<br>