* replace full join by a conditional statement in jobs query