Post an ESL Job

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

Singleton Select SQL:

select
  count(*) as top_10_count
from
  job_authorisation
where
  (job_auth_id <> 0) and
  (product_code = \"JOB-TOP-10\") and
  (job_authorisation_code = \"APPROVED\") and
  (\"2010-03-10\" BETWEEN job_authorisation_date AND job_auth_expiry_date)

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 '\"JOB-TOP-10\") and (job_authorisation_code = \"APPROVED\") and (\"2010-03-1' at line 7 Post an ESL Job

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

Name of Institution :

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

City :

Address :

Contact Person :

E-mail :

Telephone :

Fax :

Website :

Qualification required :

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_value

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

Job Description :

Salary :

Accommodation Paid ?

Flight Paid ?

Other info (Visa, etc)

Starting Date :