|
Login / Register |
SELECT distinct
j.id,
j.faculty,
j.expiry_date,
j.add_date,
j.worktype,
j.title,
j.description,
j.preview,
j.advertiser,
j.url,
j.featured_job,
j.add_date,
j.expiry_date
FROM
Jobs j JOIN
JobType jt
ON j.id=jt.jobid JOIN
Type t ON jt.typeid=t.id WHERE t.image_slug='general_appointments' AND j.expired!=1 AND active = 1 AND priority_listing=0 GROUP BY j.id order by id desc, add_date desc LIMIT 0, 10
|
|
|
|
|
|
|
|
|
