mainlogo-pure-jobs

Job seeker advice

Articles, tips and other resources to help you find a job faster!

Read our blog


Need a new resume?

Get a professional resume written by experts and win more interviews.

Resume writting

Refine search

Jobs Statistics

Total Employers: 50411
Total Jobs: 178843
Total Active Jobs: 178843
Win more interviews
 
@job_title @long_desc @is_active y
SELECT DISTINCT a.id, a.job_title, a.employer_id, a.state, a.publish_date, a.city, a.is_featured, a.logic_melon_job, a.job_source, a.jobs8_ApplicationURL, a.manage_applicant, a.ext_apply_url, SUBSTRING(a.long_desc, 1, 250) as short_desc, a.short_desc as short_desc2, c.country,c.id AS countryid,d.id id_employer,d.comp_name,d.show_comp_name,if(now() < a.hotjob_expire, true, false) is_hot FROM #__jbjobs_job a LEFT JOIN #__jbjobs_country c ON a.id_country = c.id LEFT JOIN #__jbjobs_employer d ON a.employer_id = d.user_id WHERE (a.job_title LIKE '%%' OR a.short_desc LIKE '%%' OR a.long_desc LIKE '%%') AND a.is_active='y' AND a.publish_date <= '2014-09-30' AND expire_date >= '2014-09-30' AND expire_date <> '0000-00-00 00:00:00' ORDER BY a.job_source , is_hot DESC, a.is_featured DESC, a.publish_date DESC, a.id DESC LIMIT 0,20

Sponsored links

You are now being logged in using your Facebook credentials