NotPage_115!!select t1.*,t2.id as cid,t2.corp_name,t2.corp_namek,t2.corp_zip,t2.corp_pref,t2.corp_city,t2.corp_town,t2.corp_addr,t2.corp_googlemap,t2.corp_logo,t2.corp_search1,t2.corp_lat,t2.corp_lng,t2.corp_link_title1,t2.corp_link_title2,t2.corp_link_title3,t2.corp_link_url1,t2.corp_link_url2,t2.corp_link_url3,t2.corp_pr1,t2.corp_pr2,t2.corp_pr3,t2.corp_pr3,t2.corp_all_entry,t2.corp_only_entry,t2.corp_other_entry,t3.app_school_flg from job_fairs t1,corporations t2,applications t3 where t1.corp_id=t2.id and t3.corp_id=t2.id and t1.id=2212 and t1.jobf_type='0' and t1.open_flg='0' and t2.open_flg!='1' limit 1