5y0ekQBNPzlmFfOwsdc9CYzMeh1ZxWwthwzinDvUSNBwGYuMLVFrHcVX5zdHH1bytKXo1lzKU9sNdjlqP7Wc98Z2StXbASuwr89cuOSoPG4hvoGJivZQjzB8s7vb3ZwFmDHt/49blMbXm4eGGh2C6JjQbgizIumSq22+MRvvedYINyB9cvncCEgjksSKigLHdd+K8s1nhgqAvhrUBVuadNZOXyPFCtU3pXN7K5RnKpAHhE6nIb4v+XBr75v70c3G26GjDyMrLa87955Zcd9dkl/nV9GcQxgTyvU21ZuUxRl2+Sfcih/Vze5ugfJ7sSHi0cPDcsVE+jMRWSZBMKG1eLzEMMh9EAs4r4kg/jvz8PGcGaZ49IAXFE2mqvjmr46Mt8XxQQp1vW1jmz+s1wLeWikqnL4TLbNApk6r1whSUR/tXo2fjhm2/vswA0AbSEWxCZRh7dP5bWXybTrsc6oYsCGLMV7uVFWCclyRnnGbdZoGn9cP0E62C+OB0/XN7i+n0yXK8OUhaHdf1TJRaxBLJjW3fQ94dEnWdXaJKD1g694Kox6YGmSarZAP41emHRzh6WZMgSuMMKvHitPORK51sFyummFTpks8LDywMAu5aC8TTT5QoYJv6Afg/PPTOhuKX7oE2zJOtoj1SegPS8EI4I/ik+nkd6TnGcY2sqDp1ehQ/Yuh6kORr435DvPryT3ZRyKf6Qm175vDS6Ce5lWra3Ltn7RRXySyz2tnM9UbGG/frj/nBdB4unAAlLREhZMZcD86ta8cR7FgXg1Trl5DtRu5fXsbaeBIw/r/fQxci+59G4NZDFNrXC8Z28PzxViy21bhHKLb1iVDdSBpmaRB/KZHQ/BrGp9EH87cO0xlxgcqpHoTiqd708VkijtF+1bskmnUdMKHd77Xm3sYpQRHEZ3Kvr14W8ZKOcWySgARJZfa4YpJ4rxSY6QaULQLApxPrixCswgb//ygg6ZkgtyTSof+dSdkZiK/kl/CJkHd2IrE7/wknlFU0QH32vL5doAwxlPRu6E5zrOwI4cr3XqX+nw2EdmyVExfnG4PfsRn0VF46RQi34Z7+CaC7dBWMU5asG0GcRxspGCDWfMB3eVpkkWXX8tIfSC/wD+NG/lq0MMfBWKte3jlUFwo+a6W6pxigwFkvwDrUYYG2ph47N3LpMw78hbC7KWSPxSaUius1VdjrnwB+mWr3vqVAYxGt28stR81caBHzSzl7JVRzaPndJLiLYSwwIZrvZazpwpcnrGRC93TqMLqMkZRVbkmSFSYwYIvY1UILiu1GmT72rdCB1RvIOV12cZcJVX3GYwpOrV3Xal3ETyI486oREw09NjKZXnOjkI9lOF+UCYszbAsa1VWwjK4/ipGwmcwBvE=
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