SELECT 
  a.school_id,
  a.school_name,
  a.school_eng,
  a.school_cate,
  a.school_area,
  a.address,
  a.province_id,
  a.zipcode,
  a.phone,
  a.fax,
  a.email,
  a.lineid,
  a.facebook,  
  a.facebook_id,  
  a.url,  
  a.website,  
  a.page_views,  
  a.counter,  
  a.register_date,  
  a.modify_date,    
  a.schooltype_id,  
  (Select b.province_name from m_province b Where a.province_id = b.province_id) AS province_name,
  (Select c.amphur_name from m_amphur c Where a.amphur_index = c.amphur_index) AS amphur_name,
  (Select d.tumbol_name from m_tumbol d Where a.tumbol_index = d.tumbol_index) AS tumbol_name,
  e.s_webboard, 
  e.s_guestbook, 
  e.s_guestbook_allow,
  e.s_intro, 
  e.package_id  
FROM
  m_school a, m_member e
WHERE
  a.school_id = '48100705'  AND (a.school_id=e.school_id)