OlUJUM7H57wTZvYjv6gPTePo6NcK4Y6w6m7s0l/qgMp1rGRsgrN4+daDd5nD5W4r+6KSI8xrNZvl0MWua0osjpS4aR2gST4N133RRNvlZFZP9e2VFTUhkkjqz+zAzot/Cy1OMpke/HlJPN6KHR3Oc5N2rVrj1Rcn2Ie1w6dUOHGocqqManI6H5rnSPQPu3lbBdWEGC73gQIKVI0BY6++ErBRRorXW0ERF1rKlOCvq7dUAT1PSWbsCjEj89EOyIRjoAbPhejClkxd13ge6f8o3pxQAxX0xnytBjBbaXdOenDj6jVkl7r8u/Bxse3rh/PZOEDkLbb4o9SO1g1q6sxrV2VpzpkcNm0rnZCsRO6oSgHflTN5+P7jFdDNABp0SrQP/hbndOg5MR/lFcgsIahCwq0LfGfPgxtQrFxDvFkxQscAo0KNpXSKD1LYzUzmp+pjSA8HmjQiQVYVIP6l8AcKQfnEZTgQl4ThUr52+WdgZL2lrG74L9awOZscUiuL3qyq0rxtQWjTvyJ6K/fv6QGHbyKic8O66brcpOVJUY45kDjT8Yg0DSN9Rnk7O/DoR6TuD15sSZSptanbaTz3z+44thK79szsa5P5KHdStYqdNHwB2Qeqqoj7pMQ3OfrQwRHT31qG4dJfHMRLCfbw1wneXm4VfMusLXP62P3aNwV5C3e27Bs3ATWAuYjSTf7j58wNJiPPCqez9tnzZ4hGx7wrVN2WJ10twomQO3fpGMyB8n8xReVlPOpxWBpm546WgtI9Ycfl0MViAoQ3+LhWHr042fgKsDLKh62YRU6Uvi6e7i8pFrovFXgA94qkP/fra2eFcFoJThK4LrEJPYxK6zHfNBE75m8a5tk+HIkT+e7X08ISODjM+d1InZpMsfkQgVHZm6vO4T0Dl6y09JrTfBNg4+x29WNXzu/fcV38S/UgtUUzMR4IreYbujfrBTEv9ztS8ftFFias7eaqTkPm6/Td+C7/o10Nf7K5WghPgfpdQ5CM6/30oWgr00M9nIuc0Uofm2YfiUiGgs1ruktjhkp4Md+IrJsoWOB/kxX6PQItDW968LpXbPAjOXO0gKEGTgL+gxC5M8EXSc0PcTmpE5en3KM8Hvy85hlwQjz7BOGZUsRJac1tq7FxcYCMvOT5GQ7BJj/f/BOQrjNPIy0is0dnS+L82fU/oqgPQNC4FXnIIjh9TuQEFIDIZJMHJEm97iSjzlNy8KaLjRWzuGCTIV8XWba/1wS2nymJd2abNrkbQIutEWQk6mf2ANx4/GW+ludARbLpA91YNU7a/Z6KmF4kW2P7CrFy/wBPG6VCLKfLFe2vrtBrgDsUPqIHJzpexpkwvjx5cLK+79hICoN3T/ONO+totZUo91oH88o0mTI=
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