Other jobs of the type Other Research from Massey University

SELECT distinct j.id,j.worktype,j.featured_job,j.faculty,j.expiry_date,j.add_date,j.title, j.description, j.preview,j.advertiser,j.url,j.add_date,j.expiry_date FROM Jobs j,JobType jt ,Advertiser ad,JobLocation jl, Location loc where active=1 and add_date <= '2013-06-18' and expired!='1' and jt.jobid=j.id and j.advertiser = ad.id AND jl.jobid=j.id AND jl.locationid = loc.id AND ( (typeid=567) ) AND ( j.advertiser=227 ) AND ((jt.jobid=j.id) AND (typeid !=526 ))