lMQKA0nhmxNdps80A4eiduNmWChzHICgaT2lHGJHuPqVr2EOfy9tHa/haEv877i1KTF2yvDP00DdWcuitznX4OLbk6RB1CdG2apKDkYx+9PYWFS3qRdAmlEp7HWjRO/FqPZ/flg6CuYoybhTnV8ugTaF79G52e0An85JuonHcpHw6p9mfcZyphMaLvIBLeQA+kuRGgVITwtiJzCI16sE/WV+Sw0lXLHGPwxndpKDreiadYcRp9evi7RkSqQIPkbTJJKCn7UywvlhrSlW33V77YPeC3Hnz42k9bc+uAZbfpU/IZkDDpc0ZRJTouF5Rk7nfaPuGZ+W0IrU/Z2Szk0Cx+24l5go9OfHjtsjlMrERPN3UgDwTsu74tgEdjsMV/N/HW5D7+BNqpSmNRFLTX8Rn2oEd3sWXXArqBGpXh4edgZJpnM7KXcTvEJkrIYr97VQxlFW5Pn5yPgEQX+H1mbYNL9Eh1ocWaD7kwyGuE6vOL2WO98QCu8HJDjU9KHSv2pFWcSg9u232y5HFbdg63lBuDmOwdt2uM7XSPLilx9/co1BeLOvl5lBOqW3nurK+H/uBaqkojSd1xcA2HwQSzWeMo91y0EsncVtVOvJFNOd4IAPw+9EanGrIbYZL4QdAb/1ZNluNKr2WcXDiDR6kljQmduTafbcP6LwwkaD7Z72cib3s+z7bmusGHDHCTwEqWpsPwqkNF8ih2oA8ompIRnPjn5V+NJ1k9+rk1Z6lj0LJng4khw/zKYyP0F1igagmjEgVq4PtS+LQDcXsiTz4Odi7tESC6ICoT0RKefHhBDuE0hVJV0c5tw7092sZNFZU32yZymGJl3twhix2nHjwj2BUHnU5e3Vc8xrel6KmS2OEufpvu+F3YtgSBh6/P42S4fxJLWig+YCRaulTGf1aYwEesPh3LJXt2kpyPtxjXPCqYlg3vvHVM0WP/ZY5SGa1gIehH8WRPs85GleHzsABdh9ML4CPj4fWyz8gTKz/10h1LjFTkv4IZZo3FYqfFaR6G8CHywg0tj8be36b6X1IPuRnpTSIa4EuGEts7a3uDliX3GpavDA6qdEH80XRz3bHF7btHzHzvqlEftEo3BzgGq4KTYBmvoSwQyath41HU1xyIWcAef1l8M7kicEslx5UMA+KQxzFASugPhE5DHhcwk1N42Cp0pa1eR+WL7iH24cgGlRORL9vyaCUj4Kdg3Yu3kryiKM6kKJnwcwGxz9ZYH5B2T/ACKnyD0jCYQ+M5XqQJTAFcSxeEy4ImJckJlvC1A8LPcTHX+bzEzC+FGH4KcIMo385KGtVHGgf8BKEK6A+c/sVq7CpyciNLZmRH/rn7LcverZyOx503SAyfQuFQtBu2FWn8MnotAcz7CK/E0=
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