Query failed:

select a.*,
b.`other_keyword`,b.`index_pic`,b.`store_head`,b.`store_run`,b.`store_about`,b.`store_service`,b.`store_news`,
b.`store_info`,b.`store_work_record`,b.`index_pic`,b.`main_item`,b.`store_info_title`,b.`web_background`,b.`web_bg`,b.`web_back_status`,b.`web_banner`
,b.`store_head2`,b.`store_head3`,b.`store_head4`,b.`store_head5`,b.`speed_web_is`,b.`web_num`,b.`line`,b.`skype`,b.`is_shop`,b.`web_banner_height`,b.`distribution`,b.`web_fans_group`,b.`is_mobile`,b.`m_store_about`,b.`m_store_service`,b.`m_store_news`,b.`m_store_info`,b.`m_store_work_record`,b.`line_link`,b.`is_pro_send`,b.`web_logo`,b.`m_index_pic`,
c.`transport_is`,c.`transport_price`,c.`bank_name`,c.`bank_id`,c.`bank_account`,c.`bank_user`,c.`shop_ps`,c.`transport_limit_price`,c.`pay_method` as shop_pay_method,d.`name` as city_name,e.`name` as area_name  
	from `fortunetea_mem` as a left join `fortunetea_store` as b on a.`useno`=b.`useno`   
							 left join `fortunetea_store_shop_set` as c on a.`useno`=c.`useno`
							 left join `fortunetea_area` as d on a.`city`=d.`id`
							 left join `fortunetea_area` as e on a.`area`=e.`id`	 
	where a.`useno`='fortunetea' 
23: Out of resources when opening file './IT005_yk_db09/fortunetea_store_shop_set.MYD' (Errcode: 24 - Too many open files)