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))

SQL File Execution Error

delete from session_job_selection_criteria
where 
  session_id = \"fca674f1feed0023670e03ec0b9f0f90\"

SQL File Execution Error

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, \"\"),
  \"\"
  )

Singleton Select SQL:

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

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\")
  )

Singleton Select SQL:

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

Singleton Select SQL:

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

SQL File Execution Error

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

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 - Month -Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec   - Year -2010 2011 2012 2013 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