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 = \"d76fe61f13b993a1dea3412aceb8c951\") 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 '\"d76fe61f13b993a1dea3412aceb8c951\") and (last_access_time >= DATE_SUB(NOW(),' at line 10 Subscribe to English Job Maze newsletter
\"Access


Subscribe to the free EJM newsletter and receive regular news, ESL/EFL job search hints, and lots more!
\"Find \"Post \"Home\" \"Cool \"Top \"Job \"Job \"Contact \"Access

Your Name :
E-mail :
Current 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

In the next edition of the EJM newsletter...
       

1.
2.
3.
4.
5.
6.
7.

   TESL/TEFL Hotspots: the next 5 \'in\' destinations
WWW.ENGLISHMAZE.COM - a Revolution in Online Learning?
Professional Development: TESL/TEFL Career Pathways
Featured Destination: Estonia
Exam Profile: Cambridge Proficiency (CPE)
Featured School
Our TESL/TEFL predictions for 2005...
       

... and much more !

We welcome any contributions you might like to add to the above topics, and invite you to send us any comments you have about this edition of the English Job Maze newsletter ejmnews@englishjobmaze.com
\"Advertise \"Advertise \"Terms \"Privacy \"About \"Coptright \"Contact \"EJM \"Job \"Job \"Find \"Cool \"CV \"Top \"Contact \"Post