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: 77869
Total Jobs: 329856
Total Active Jobs: 329856
Win more interviews
 
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, b.id id_spec,b.specialization,c.country,c.id AS countryid,d.id id_employer,d.comp_name,d.show_comp_name,e.id id_exp,e.exp_name,jc.category,jc.id id_jobcateg,if(now() < a.hotjob_expire, true, false) is_hot FROM #__jbjobs_job a LEFT JOIN #__jbjobs_job_spec b ON a.id_job_spec = b.id LEFT JOIN #__jbjobs_job_categ jc ON jc.id = b.id_category LEFT JOIN #__jbjobs_country c ON a.id_country = c.id LEFT JOIN #__jbjobs_employer d ON a.employer_id = d.user_id LEFT JOIN #__jbjobs_job_exp e ON a.id_job_exp = e.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-07-28' AND expire_date >= '2014-07-28' 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

Sponsored links

You are now being logged in using your Facebook credentials