Jobs Board

SELECT job_jobs.job_id AS jid, job_jobs_attr.attr_value as company_title, jj.attr_value FROM job_jobs LEFT JOIN job_jobs_attr ON ( job_jobs.job_id = job_jobs_attr.job_id AND job_jobs_attr.attr_name = 'companytitle' ) LEFT JOIN job_jobs_attr AS jj ON ( job_jobs.job_id = jj.job_id AND jj.attr_name = 'companylogo' ) WHERE job_expiredate > '2018-04-23 06:23:45' AND (job_jobs.job_published = ('1')) AND job_jobs.job_id IN (49608,49162,49137,49823,49783,49756,49753,49621) ORDER BY field(job_jobs.job_id,49608,49162,49137,49823,49783,49756,49753,49621)LIMIT 0 , 6