mvhYu23iZ2iYRbDhDhk6ch2hyJk9r6zhDVO/j2hlz17jJ3BLkcrQKp3VU6gXqwyeiz8mzK4V6MtB3/wbBrJuLGsaaoSkni2z7GjW3Ikn17JWoqKpsWFyiErMc6awQV8pXraqNZEWZlnty27qs1/sL1lTNFpq58BtudoosiX/w0yS6q55P6NYGuUUeYCbOkvT+VK/QqQzjuFqK+AE0FJ8Sm4aJcrrC7/h5gBbOANOZA4WyJDG170hh2AQ16Ad+FPYJUtLbCeO5TrgxthejVmVqgy2Lbq5cvirRrWRXh+E68t6ngdU4/EBAAyhNXitBqrrCAd6Bn/xsxjwJ1veTmBOKzwWD6HPE58eOkJMe3DXZlRlrYrMGpSNQ2R4fuSDY/SGReabosrUkdX2hMF+UxyGKwNpSwrpx+aSmxrPbqoJN0n7F0JULbZxmNxSbDGKWyVR1KchTRRuOvaGWqV+PqwJxDtmT+Ncsgdh/nfGGN78GYfijQGcfZ1xDFEUnFI3Bd16OGa26xcjDP/b1M0x3XdoWs9OXTNT1Xt52uo9vmLb56c2IYzfiEav5rPJNGHmxnnazyzfPeVuRJ0+eutF0heqjQDCEIG1QxW0xO2Bu9H4jfn6cDSVDYT8BjYf6Lwg4O4FKrymZ7CuD1J5mt4Vg73yftgpE7e1QQfoxK6ItZr/gxmR9JWvnfNYSKOwb/BHye39smVG9zprJcb++5RoBcsoP2PzpuTObOkvYgRDH+SC2U3LaRHxUXICrmpoYvXZbErYSJvcNPMedVL5bc4DtpymV5giVHLQBKX6qIXYbxxrGGrNgAFTCmop2ir1oIzaVsY2pNzWh4muGhPB4BYZXSkZPz+0+7h4daGlCql27/NzsuNvaCJ6R3+Tl1q41pKiPGdPMhKSsQO1s1fhh5/q1iO6IvCjyG5vyaWbdWBsuBAYVF7IthI2iPTo0QAJThz2CXDidpCBj3t7bjaVBuRQE0YuDBr4c/sA7NREQ1sEWc+eOx1GGq1pANab1hwClwi22P84To8yCEppntTymlzBLgI/DgOVkC0CKHANOwhW1EdEAJuFs8jb9ThQov6xeuzTfArlz58P2kV6aQEPMrE5RUg2iZmORqKyu4FpxXFdvQYIjq5m/esAZk6fWvsVBJrWDuYIjDK5uAtnxWblMqVKzFfSYE99/op4l3eczIE2/mM71479BJBdwIcyqTMT33ovucGqYWoKe0D3gR00JzmuVQf+JCO7riwJpUEcKknJQkBdUlscZwuUqwAESeDP5FwhECuZwq7ntDsvLxT27p2BbXkEUZvYBYRMNKglVgh1nKkF174UlypPV7UrUitpMRBtMjfcLJkhAQWfXXir+QtbtpPQ0fbLU0auYcceF6gk6CU=
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