bRBOa7yNRZed/UORa92bNbOZXUTkn02tiTSVATeRx4PUIlaRxUFB6YfvPJp+vZ7ew83Oq7wZfxcnN3S+n3rbW8Dkd+DxHm5HqSiL20CydbV2IhDgmJspRQ6k0d5ZYuAi+fhZiRBz3Hav/Q9yrLUa33lheptnNLSIKkH6qxRMl8k3MNVDxHzoMhq0GPPKsQI1DiA/saGBwZcTrqmwSHN/W/29k6G6FeaxU3K2eVFYRdbjME1bUGKiBBIxrJ+f0S3WIJ7vVr439us85xi4aNB4Lu8oBgVFftWlfnnseuCcoNVOP0KiDxwjW+hPQlj1fVprOtTdAgk+LhPLtMlf7Oxm1iXwTJJDlPpBWEW+G+ik2hMCwDORl6lXJX+3EJPIUwxBh/AvKJDV8dcWtnv7X5T4Q5x61nY5mh7YyxyYeRu7u4ui5PFnOVn9WQ7mIgePwBtkzMcOVx6yVuuPbQaNxmrxLls+ZENvzqp1lmtqUm2iiapxVsNA3FaQLEP6BzCnJdKRSZuN7OVuelN9SIM7YIMoWUsXr2YKC6Z1kg6FEa5LUTT6ICVnfWfEplMJwFb8Psg3aScrKNTlF4SnXU9URsyO10zXvXnJ4t0cGPyDvbFC3fXfwxzuz4PSxY4YqfCPCgcXNTlIVdRSGyOD0ueBKfh9sVd8n1Lh3/Ms9OQAOK3c/1BLhpzlqrHnBUxSXV4yM3LoTXYE92zURZEXkc8mLfsP9MKmeOicNnwLiwJtcvdHcxn8MiDM9CEwNpF19LT+bSGrOXNf3rQufwzTDotw2FPMBv1+A340JpS7At8utXS0WMwPn73Emxetl6ote529QAudmO2GX8k3tqm/t/wWzZucPwbCT8Xhy3rUMbFJaFFveKc6tZmg57y9C5YBrFWd11BXZgKxF4ddWsboTEZ2Hn+bgWJ+pTpMo+J+HwtRbq8hF3dl3vWE+CBswbVzt1Xm14TTc7xOj6Vp5s6D+KvXdi1xA1GxtMdryj9a0LBGGx496LOqLnrnno2hY0Et81zFgOY7GU24dpQy8epvpH8UMXaTM83z511NgW8f16TTWchYMSuH8L2/9xs1jpx29XCZ0PwfHUH6i+HdR7ggT6DDDnnxJFfwMTIbVS5BdVTdAVQCGMR3xG6cLbOVEWFSrcewPOVgDYbhAkax2eoW2KClt+L2r6Zvk5Pu7NkBNMfIEV9d1kua8sDfRHoHe8vBnDhuK3Fk/lBEc+m7IiU42967Ip6prbNuKWDBf+5COUuvht/3aEKedMIaT3E6lqHqUdK759AwlMlNTuzr0uS4Y5uIreDQLxwZgpsG8/ZSJJpmmj32oJtZKm2FxQ3QtbwrsL1ZOp/aykw8NxWzvlPOtECz6oZmtfr8UE35I7c0EHh9DYQ=
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