7o2gHgeUcTs8tBoEf6tjhuIkCcMMDWN9cTubxdULNDmzVB8uJSqtic3438hlCBFgYruMk1FvEw0GJ/Y71oJj0tA1XcDJKEe9CTlMiLYWYuGPS5LtZ0sYi1KMkaOkYyDZMCc8rZccv9n1dYlWX0ScCOaQggdxbVu3PYsda4G1k+gPQYNIvzxp5oFaTLVXGKpoHKRMz+iqxld2/hFk+wgc3ZaC0zNXiuNgP+ZkfofeseqFGDJwyE2ePEwAUzI+QNfr9AOD06Kd1dox17BgpiIHxkPmQB0tQaum0rmqZKiuJpgMvhtk3e4gfZDGgx1Lf00Ig78KgXKOoMJ100Q6NyszurII4RNJjcOFlJ66xIXbFM+QQt5YAfXM/MOFtmIfbHCMbuqSajkkg97fFYg/By+v8Ww4fbTZ+wLk3Ic6fRPKxYzm8j/xQzePycamW0deb23W29zLmwpOsDAWM1bRQUWVp5TNYuTt1C1bwqoXxgIrhZTGOvlOHPqJK/56V/BD5zQpMXY9P0bK97LCWUHP6/BZzkBaDL+POpzre+OTjQ+OP+DhKT22o8iKB4GtoyqVZ7kgs+OGsJ4VR9ifj8Ut66kVSUSh2RCjvtTaUbfkyWNjt7iZXNY43ANf/8AaI+DvRyEwbD6WaWwTTIE6pTmgAYdqvH8a2RadI2WDneofe2xdRj+y5k+1TF8LhW56GDxmhGf+4x1Z7BI/eMFcwIRPIt2/1pIE2XMnR3iWa4mQmVBnFedsP293Phb1Gv+U8Inn+A5HUYqt4C7pFV/KOZ+GxnmM7EpS4Cx/EqE6GBIYLWcQPBWrb3I97XDIxJUBrRawb5B/RQTINmzLQojx9nHVKECeiqyfGHEnvt1ASXTHDs119RpLf1izIvSWmlmc0F6JUKwkK86lB30iFukLalmY8408kuneEn47KKrGUHys37yGcuHCmnMXE1Xeplx5R1BbQvrTOjKYHUzN+fmTuYw0XSXnOBfPmCF7jzvY2fVrofvaxbGNdsflBZ7rZlwMr+2+h6e4zII2jKfT3LGb7PApHWeRnZtWOIV+PYxL2KAfMfIKnOSrF7U7/BRnBcxKnRzElrOTYn+00nPOiZkWxx9wY9XG926w+/vXLlbgxZUCYrU9BN8MdxTbk5R0N/9vKH73uV/trZSm4JjCIStmoQhtHj69QgZyM9gcBQrw9qvyHSuvx+g5lAneb6GF1qbGYJUGU+2X2XTgOIlY0NW2OLNEP6fWpQ96WAxnXU0owheF10q3br9MA9C9fkh591GMP9O+HYHnKWfAky429IDRPQMayn8ZyZoq5XDKsAOVq5VskFPmuZutPJawORWj2deHNKO9o+L0uoI2Gg/NQoAeNm4EO7Ch2A82jc9O8LblqyXoATE=
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