rF2mpdMdMqIEIMZm8virmKZHfQfQ6Vmm+b8wEDOLUaRHab3oya0fWMF1nAZZfrcZizpg1vtrDs91ngsVQbOID/hyWAmUdekaubLxxrV/i7mbFxHOSXyq2UqSJC8mFeJWLQl22OQcuKPZ0k3Utts0TI3qXZKFY1buFJyTOgglk6Ha6SdVOJXu/Rgw8mWYvlDEFSrw7KvpLzCrNtxydRgIxctAWhocy4lSlLwhU7m/C+MUVVMKxFyxDQnVZpu7hjD2KRWIXsyJvaO0bfixa4Ugl2qX+9d6JIGQT4nG0AEUJ1LF8BGpE3XzM41eIEforToGd5EhD8DSV12FNyGD7X65YvmRSdZSpnI5TRMi7sDnEWXtR8BmT2Nc0CLO92HHIRvrtVORRsX10/BQAieOWQHwA+HZ6ppcKoqLDzCawt1UUaS22hnSyyFccODTH6zHWtz76uIYLuBoDr25fdBnStWI/0jIxXG7h8Lcf2q6zvnpSxgTK6Hk5qKP1YtbupOkBPa4QY5GjJnyp4QaRWlpUb0LQPJRwam06V8LTOtmbm9ekUFDc3KC6XUPHOZ1PnOCbHVc9a2+Sq0oFvyZ9TI23QIQT0Y63SdUFtJsLtiF8ZvhyHojOWdBMj8j1Lz4EbGyG0asp20hZNbybhsVESUq6mdT3SH1jZBNnGQSlf/Dp2lZkEFK/bVm62jllmPs4acgDoKk48fUb41vnAqr0lFn9EeTOQSzZfXWvKyq+HE2YCOJLV4E4ooARDoJblCZ+vcqTrfsGoFYRzkmuie7rFhsXok2QNddaMbGxf02eUO9uirQ2Mi6O651tiqJGU8hO3YOUn3GyDbv/bh5+XF6ygg2ARNTEvDpWRufdpyHhmb2dhzEXDwJ8gVxZIcOB+/CE4nI03nkaxUuOMTZN+DJZNdKhA4G2ehz8+zhpzenejP5w39R50JgW4qjrlnJflMb2Scr9Zy+NBJZPcFdNOIEwtgU0CjnnUMMnJ5FkE/dsf9+wEcLX5swbb5nD1RHogJnRoNzMMGiLvqy3qMr7fjh4WbG6Zk0Otd3AOOPf1K4iFpZkIva5YJ43GuBtN5iRLNS9xr7Lfg4gGRbKxs1a7/oUA4vbXnW30l1QOk0ClXMj04dZZQS63eLcLXGjW9W2f9TaUiNHMVyfXgdrLDXy0cNZBKnHs/b7X4PzkPLNX5EX1u24VSy43S48Kk++gBswmxcQFbem4LK7/yl8pWgi/aM+ZEgw/5NzBNmgSMRkhrqniIiQrzaAtI/4XEpsDWwS8Y7w6ujlA4kUe5j3r1XqWdK+e3rHAmS7wxqWqKS3lFy/W9O6Tvj/hwIq/LQ2kBUcsIKmDhDcCCkqhV/VvNkc8ZCCoy66BsAb9nTknHxBsBkgGkiIqY=
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