YP44i29SWw7/fZ8ypL3zxVe103dtDtgxFrKDqZ/EwurD6QK9yCuuQ8UMPz9Y0bDWc9Ij4jUn9jCI1MKwG26j1mQ8H1H3a27JeLKzpD2g5f4q2E35/13f1dCBmxjvcFYVoBtN+zUanHe1ygRYflrbNyOB/5swSslT0fMZpStgkpHugipMW4JgtZFn7z4eiyQalB3RrU1j+dPheitDY+qTrKzwENtLYlW2kDzXc3BEbUEOktZofOxQ+RnVePsU/BkVgx0bLPqQ4Mab0N4ae4ddy7c6WODbqf0uwBs3NOmhqueMqYiObqqrLPhjaDZ2oGxCHVsrfjxM0G+tn+Lvo5Y9PbIxPKkHcsSiozZHk7MOPKFqH0KhB3jJawU0/jmUXDlOhEbGsICYwqvI6jK8dGhIxUbylHpvvxjCffiUXjJc2wuj/S5u8bFNIC30AQ+nbxQ/cGwwZGVrV9hxxiUDtzYds02YRuiCWg/ogn6Cnbw4qyc8yT70i+JF38pp1aBMAiJP5Lwz0k8lS8E6kkVo2TZnskKnkjl9ewml53Dqs8n3NRTqG/iEP3SDdkMpYCCYrRys/dZQqjuW85xSdu6uJ9RmWog4NaCJJB7phzemt/94ZkhRw3CWDkjcpxy3HouRgEw1J5DWkQJTh7JEnGKDasI/P60l/Lsz7QQNhei+dsNRAPGQDC40bcb71kEEAfmKpVOTShRBm3OZABfM92o+yWh1GjmO4agfNjcC+qNp8XbAFaY1Mqud/yWiYc61tSpQRyFS6Uob231s5JbJjSBilxIzQyV/kybBf/N2dskzD+Om7B3psxxYBp/2G8tY9qEgEJdpAIi2Q1K3OXGDoYk4ByNJlGd+Es5wSySsu62l+Gs+YXUYLWCJbL/gFMPamLYpiw/MKFq7oUu72+YQaQFP9rKIMF1vY62O57J2GQ0ucm1PGeUnADmLFuEYVGGKLlV4efN8D0x7ndNf99GzqJIrP8TmLCP7cpPMKIS2lLo2pP76PUR2uJIF9dHhN8InPfirWZFIol9ba/S3xAQrnbXKpGNV+gxRwOGSSpRLMETDcc6ZHfw5qB1EyR58Y+Ephu97hkLwXuIa2EpC33JkGMJaEs6chlzZvmnYHDidAfO/00IE/cFqJV/EQ77A6gXCUqXsTl6w6YCRkWyuVkiZBLq+P691aPecwSCIXgfPjEB82imiohtDqJuAznxrK9m6GuUvFylfZ5ILV7mLMms36/6mQlAcd0c58ezeiY3kf59KCQFuYkTXc64gaagwIf1MvfFNMI5IolS0FM+qh7kNmyfXrxjBmgptTC9VpsTEeJIZ9zwhkTTPLIqg3gec6cZMJcccPkgbRd65BOMUtIgb8cOG1CmcZwQTI7nK9h0eBlHpoAA=
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