iJapM3MXcbO0vDADas5K/2ILFsGr0NIfgntx9IIMt+XD7hYVmsEwfxWfAPnCDIzWCt3ftksq+6g3OUPGBCIXEBBSyxUm3fYiLWtRonDbxiRnx08CB3wpdTMSg0bs+mRmkldHrqXQ0OioteBfPowbszqDD2Ovb+J6HKDUzrDr9canBduy9i0qqHs9dTeEgu0THbQw3iwSfjeJA9CBjwjZXuJ83a7EodsaehwdbbKPl1dfYfdXMs2j3yAmWfi1X14uu0opwKj4ru0AOpzU4RCYw36nV/2JXhXLWDc1jGT4vQqaBxdqzkqwxGbrHfybdD+kPppPp3ULoTa2CYmPU7r4zIiYLf/4so6W0bkOSqMS+J/KcqQtjp+aC0YtzrQ5o482Yrp0ZZJGcwQfbebddBIhQ+KEjakFBoUdOgl4swspTIOjGLS1BgXKism3rzj1HQxTcstIoRKrpeP2PpJcigvF3c63NNP9YD+CGyQiLaKBlXQftyP7MgJ/LzB2HVk7ktayzVgmSzTmo1OaYLP4Dns/er1Tb/rulkzYhjstn+2vfVi5gNF+eEU4d1eyGlJL20VyzFbZUciumuKF4yMjnopVLFNMVs4ZYalI1xAiqY09roPPv6QDganaazFU4XEsQLrJhDdvRC9fZ664aOozYNxAWgKV7zkwtzCKz8LTGNngeioWQURSA9eGzkBInNVSILWMU3rGUaAZfxXlTdUs5NSERcKa4IOE1MONSFdXdI1lviHl7LmTwUendjJeAT7XYLx32utE5/awGKnVuol+fUiM8nIJGc4HyfUWuZXXHATz7ABPU4Ym6xsn8ICpGj+sDs8i8gYgO6NpsLu0/aRJGC3vVpvRFE1mqodzwtF6Xh3sNrRw0ZghSt+yONkhbSJp1R6CqDWiGjvMzNdRmGc2xrq1sKlsvlq0L/Lgt3lp40Iujp18QrtZ+i5BmglHsroJmAHm6TWTDFisIBYkUzoBPc0YoCTRZswrXmJVJPaD94pM/A1EnE3jhrijit3uPLP4ms7cq5pU/kV/pdtJOzSNx7+7uv1lgMYQg1stReKddhR+TpvHJmjCr1lH2IDnXh6dvlAC2151HEtOpW37FT7WR/S6QEwX7hSpQuw7WzN973zxVkOo65eTuFRRKeD2tkkHnWXzPQh4zjwwJKS44+QTE75Zmi6XLfnuZyOWdztudJsjLmLHkNjBIcnk6E8Lj8V6A1yCFit+JQ9CeLWFsx7NS+2c1Dk8A/LxR99/eteRB/6gSK5cp/BPG+ketgH98GwIrrhm08MDagIjg6FQ900iwDVCg/8/Sb9gSNBqTjyKTUqP3kmw9rkBKrffXp/47mZcGj03mBPQxVf2nsU/DilKoZr8Pt2J3TP2aoMWaHKb0ZU=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100