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 = \"fca674f1feed0023670e03ec0b9f0f90\") 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 '\"fca674f1feed0023670e03ec0b9f0f90\") and (last_access_time >= DATE_SUB(NOW(),' at line 10

SQL File Execution Error

File Name: 'sql/session/delete_session_jsc.sql'
SQL:
delete from session_job_selection_criteria
where 
  session_id = \"fca674f1feed0023670e03ec0b9f0f90\"

MySQL Error: 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 '\"fca674f1feed0023670e03ec0b9f0f90\"' at line 3

SQL File Execution Error

File Name: 'sql/session/insert_session_jsc.sql'
SQL:
insert into session_job_selection_criteria
  (
  session_id,
  job_type_code,
  job_start_date,
  job_country_code
  )
values
  (
  \"fca674f1feed0023670e03ec0b9f0f90\",
  \"\",
  IF(\"\"=\"\" or \"\"=\"0000-00-00\", NULL, \"\"),
  \"\"
  )

MySQL Error: 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 '\"fca674f1feed0023670e03ec0b9f0f90\", \"\", IF(\"\"=\"\" or \"\"=\"0000-00-0' at line 10

Singleton Select SQL:

select
  count(*) as job_count
from
  session_job_selection
where
 session_id = \"fca674f1feed0023670e03ec0b9f0f90\"

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 '\"fca674f1feed0023670e03ec0b9f0f90\"' at line 6

Singleton Select SQL:

select
  count(*) as job_count
from
  job j left join job_authorisation ja on (j.job_id = ja.job_id)
where
  (
  (j.lapse_date is null) and
  (ja.job_authorisation_code <> \"VOID\")
	and (CURRENT_DATE between ja.job_authorisation_date and ja.job_auth_expiry_date)
  ) and
  (
  ((job_country_code like \"%\") or (job_country_code regexp \"%\")) and
  (job_type_code    like \"%\") and
  (job_starting_date between \"0000-00-00\" and \"3000-12-31\")
  )


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 '\"VOID\") and (CURRENT_DATE between ja.job_authorisation_date and ja.job_auth_e' at line 8

Singleton Select SQL:

select
  max(page) as max_page
from
  session_job_selection
where
 session_id = \"fca674f1feed0023670e03ec0b9f0f90\"

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 '\"fca674f1feed0023670e03ec0b9f0f90\"' at line 6

Singleton Select SQL:

select
  count(*) as job_count
from
  session_job_selection
where
 session_id = \"fca674f1feed0023670e03ec0b9f0f90\"

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 '\"fca674f1feed0023670e03ec0b9f0f90\"' at line 6

SQL File Execution Error

File Name: 'sql/session/select_session_job_list.sql'
SQL:
select
  j.job_id as job_id,
  job_auth_id,
  DATE_FORMAT(job_authorisation_date, \"%e %b\") as job_authorisation_date,
  v1.spv_short_desc as job_title,
  v2.spv_short_desc as job_country,
  job_locality,
  DATE_FORMAT(job_starting_date, \"%b %y\") as job_starting_date,
  job_auth_no_of_views,
  product_code,
  organisation_name
from
  session_job_selection sjs 
  left join job j on (j.job_id = sjs.job_id)
  left join job_authorisation ja on (j.job_id = ja.job_id) 
  left join contact c on (c.contact_id = j.contact_id)
  left join organisation o on (o.organisation_id = c.organisation_id)
  left join sys_picklist_value v1 on 
    ((v1.spv_value = j.job_type_code) and (v1.sys_picklist_id = 9))
  left join sys_picklist_value v2 on 
    ((v2.spv_value = j.job_country_code) and (v2.sys_picklist_id = 5))
where
  (sjs.session_id = \"fca674f1feed0023670e03ec0b9f0f90\") and
  (sjs.page   = 1)
order by
  ja.job_authorisation_date DESC, job_title, job_country


MySQL Error: 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 '\"%e %b\") as job_authorisation_date, v1.spv_short_desc as job_title, v2.spv' at line 4
Find an ESL Job
\"Current\"Contact
  Country   Starting date   Job title
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


 
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


0 of posted jobs Page:  1   
 
Posted
Country
City
Job Title
Starting
Company
Views
 \"Access  \"E-mail  \"Check
\"Advertise \"A \"English \"Disclaimer\" \"Subscribe \"Privacy \"About \"Copyright
\"Home \"Find \"Current \"Job \"Access \"Cool \"Top