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 E-mail me ESL jobs
Tell us about the job you want and we\'ll find it for you.
Your Name :
E-mail :
Preferred Country :
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


Starting from :
 
Position :
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


 
Note: If you wish to unsubscribe from this service, please send a blank e-mail with the title \'Unsubscribe E-mail Alert\' to: info@englishjobmaze.com
\"Advertise \"Advertise \"Subscribe \"Terms \"Privacy \"About \"Coptright \"Contact

\"Top \"Access \"Cool \"Post \"Teacher \"Job \"Current \"Contact \"Home\"