Singleton Select SQL:

SELECT 
  a.contact_id as contact_id,
  e_mail_address,
  user_name
FROM 
  user_authentication a
  left join contact c on (c.contact_id = a.contact_id)
  left join user_account u on (u.contact_id = a.contact_id)
WHERE 
  (ua_data = \"9d17a98e6931093ce69ed3dcd3447d57\") and
  (last_access_time >= DATE_SUB(NOW(), INTERVAL 30 MINUTE))

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"9d17a98e6931093ce69ed3dcd3447d57\") and (last_access_time >= DATE_SUB(NOW(),' at line 10 Post Your ESL Resume
First Name :
Family Name :
Gender : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"gender\"
order by
  spv_value

Age Group : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"ace_age_groups\"
order by
  spv_value

Nationality : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"ace_nationality\"
order by
  spv_value

Other nationality :
Country of residence : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"iso_country_3_letter\"
order by
  spv_short_desc

City :
E-mail :
Tel :
Current job : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"ace_job_type\"
order by
  spv_value

Other Languages :
Highest TESOL qual : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"ace_esl_qualification\"
order by
  spv_value

Other Quals : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"ace_other_qual\"
order by
  spv_short_desc

Teaching experience : 
select
  spv_short_desc, spv_value
from
  sys_picklist_value v
  left join sys_picklist l on (v.sys_picklist_id = l.sys_picklist_id)
where
  l.spl_short_desc = \"ace_esl_experience\"
order by
  spv_value

Specify :
Available from :
 
(Choose) User Name :
(Choose) Password :
Confirm Password :
  
\"Advertise \"Advertise \"Subscribe \"Terms \"Privacy \"About \"Coptright \"Contact \"Advertise \"Subscribe \"Contact
\"Post \"Home\" \"Job \"Job \"Find \"Cool \"Top \"Contact \"Access