fyZf/xBR3cMH/iqus/oc81WznheiOXiGbeXOjTyd3xPjGj7A18w2G2EJ2PuIDuymlJFEtE8NaOVIq3DjDdxFoKsGcHXIv44piBSkKLURWDQ28ALe1dEyAu217zp/gavJImcFG3ijGvKcNAnP4DYA+d9dliafE9a6IT2TqOI9eMu2qGkb36RsfW8cACEuQ8BhfUrX63gRhsuz831zb53Av03oplPWuTyyozfTqdSuO0LNDnufiLX+3Ww2/xdOxvteutLw2lwff6ZGNMvg53wuLZ4edCgwvnmME+CUCae9CkgBFEpnX/cw9P1XXstcRLWaWNX46keFdNgdEKVwXUgF0sVYYpFIT+RcJ7pB2kv7S5w+/IER4JDy0RJ5HZ6ZRZYW1jn0/iwuxcetVyTejISVquxQqffI0+yqiuWDgFjHO/nA8rWX3RIIs8kZBMltDOkvQ0KenuZTU9h2M3Is5MWKmBK8bo+wqNdk/Ago1EMnOXeAV/ZhOU/pDnrtmKf9eYEoetGUZyWCtdjfqf3o60vNUt6wKqy/AwCdXDoH9lOBGIQd3+hjfNR8VG0//ACBEJPDlaccqVv0WG6L3Q2SuHa9vTP+PA7dqbWPqfIUOX1209m+qaRTu9kA2w8wHUOiNtk7V2/2uOx7q73ZEkx1ZuWjO0WPR/encza0oAVpX5JMHG2KomnFSDJgfxfGwL+RkZUT2LNB4ymMcEFnRPUTMvtHriB1sJDBI3P68ThL1xdWuKXOZTgGhNayQ6Zo83bxL3u+k4MfV0ks6bMQ1PxVgVRljF0CDf8E7ClAJ2RSNfyX3Blkpt0yNgJmwZwUgUOFNxnQHekqU4zj/aeFYAOWbbWGiEHIEGSSut9in0HW3X0mMPSdyE3TM01g5eIM9wh20IJeR0l1HrlUvj+45rs3u02DNhJZn2orQITk4LnAH+hdfPs2OGRDzsbZkDr0IfSb1DW2tdPaVYabvO36YNTJsaSRFZj1z2ZPBrMsva6SAN0LpX6AqECziMe6uKOPTFNsInEnDpMbAbWIs9ZaHVVUtZiRf4nyZuWnmoEysd+4rIJxsEDx5eEvcGOs5E/hTpeujrfhN26G1qVyqFqX4PdN4nD7AbZbwMUjr+XBpFSLiOpdLjeNzeYUwrpbvBuCxOm3Cbd3n56SNn7qUHQSR+j/lalJ5/MleDPr2lrXG8vncWzSXNRX1RzC8NSKrGwbNdjNy0MQc2X1AmyACqvsj3tyU4lGU+s6OQdNV/sWOMRAkmfuZokK9MpSLsu/R3uFiHIynp5cfP/URknEGXY+m9vlTQwjQKMLRmlbkS8xI4wh2mUpRoGecE8ltZyZ/llAldK43E00pVAMUqpfjfHHipGk6x5fhBgx82GjeUtTNDKRGr0=
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