pCKage30UtyT7L0T/ySR0q7+qYH+HvpITzaGa0hLlImvItJ9YNNeVCbT9jtC9JBbdZIEvG5ZywXBTDxK5DoTVXy172m83FGWfP7Ztf4g6aT4H9aREcdfr9H8wLADmtopkHgrd/kwPffjoEvFR7WERBlA4xEg1x0HuJzKvPsGqBN8lmoSfrfuYnxJXZ/AdZ4Y2RCUk3HtPxobUIVAkvo7ePZ9rWdyIgyLVT7XnfOCM+7msyBtiDlvS/sbZKPVkpJEBZx70j5uVJ2ANFnSfLA334I83qahdX2e0/vhJ2A8V0BW5V9ESgKBvStn5NEdLr/HP//vhnyCwDdmqunotaat/GGHXEX41TGcU7tVkCaweuVHJB9dUm4CAJmSSV7j3ExhWGdbNgn3g+rvSmnwl3Asvb5LCsIpk8JKdO0xZDKwskTcfbHkvLYrgsJIbNt0syTlTavF3i8vyngh1K2aQFvTC9nFsBLc9f0ADyXklL8qDL9szYbA9AZSRqcJ52pQqNL7RNkziwmL7My1HBnG1ddzOeAMJpc1riLF9jQx3cTEDbInkMZgL2CSQrCkIszkkKjcd/UVTjLo7VylK+ugHjXydF21487zKGLA3OvowPIU9E9xDV5IiBOC9cnniQixGBVk3nRdu1DrF8o4mfFyLwtYfLqFKtT9MLbKevSZLjz8jR1rz4UJx6sE7ReJ52yovtnel94Iy8CXFRPbgb/XGmxW5NLA5+UANvOS1xJ33ihI+q8cEK/8RS/CAzqL+F9opx+MBmE2Ht/79qLZcNDgRFTZQUOsQEXdBvF2Ja/QvLU9/Hsi/TM0ZsLZjjGocIwv8QxY0Aill/qD+rCztCXAg82HNXH5kVJKrQocNDX45kk9lQvXPqEtk4b6CwmUhXd/x2n1L8rj4wSHsNT9YA0hVzkhVWErNF7KAfP36swWxFywVyTFtoqGWgJVFF1zmGoM931M6EXA0mWVNQA8WEO7l05SfVMOmzUO1rsewUC7zXZsFCSqbjcNtfqmDEnzlIJJ772r1sUe4Gd6ExcXUABNZgvUvadiZ1S3RQLYyPRYm8A/uqCzu6E0zNMw+3l98mxYNHVkvIW05w2PA+uKgskPH01Epddb4wDHbNdAVOl9cRD84MdyaSUpGDVHwOyDC5ieae1ng7tPmoqsZJZTEk4y5MwPdRg2KTr6UD++a27rb60WQASNgTbtGH1GuJ413E3O8oG/g0wOUV/HxjxmUsgOib0Lrb970YtXji6E4+g5gHZJ8HhokZI73G/rYlOo83dDNoz6IsFi3noMGCGGI03jUfhncfmqFErVcmITnNjUNe+3QZZ12qBKCTj4kHYIdVqYISdx5+9xUj4bwEbgfYo+RRPNJP0KGoJu6WeKvoJ4vnM=
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