qNH1KH4NLv6Vit2YXG29gZVd23QdaWC78bX+2MmAWZrSeslvGMCtoSfTASFiOKdt/FiFtRrUUND++jdhbedwt7kYJifnSwfZS7AmIfhYsoLLnN6X9OAX+X8soz9Tl7kiURMC9ns4nbara3Fs98Wli/yHNGZDDdZ2pF6Y5VSF1pymeQPITkieJt6K+i39SILF18LgW2NEYnJgnIKREc7gv4QY6xaQgxyTDuOmfblGCsI3Vi5uZzYpLjQmlPWKdr0LS2Uu0LMo2EZacJRtIZyNRpAcv2Otk3x7k/iZAqxT9VlmmU1rl0xOZncaqwKkn1kye4VrM27uVbZIQXXRNQwppZeeFtZnKUg2uAClZTFXzpXEFlH9T0wR0HeJBx/gRH4dqoPmsIjwKuiFTxGorAiGKuZOIY/FBMJ4XqwjpWBV4BD2/3m5ubYi8QtPOBv5r5vp3bB3m08msE11KyChU/OD2vZAy1IAf7QdiB1QVRg/e8OIpw5Iw18H5w8ESHVEK0GOgvb+X6aQyjy7ckZhULm8SIQT52UN18CWFiJkbtWKrKu08/lDN7b2E4udIyz89W16qK95pcVG5NHLSitLdIe/pgsGhIljQ/C2l4AUD4HxIRbpJWsQxp5uzmIMXSRJx3I1prRz58r+vMiI17PzyOwsnA8hxVoDSDe9vxNxafSShRTkdLWOacR6uUTecjDvZIBteM7i83ztBhlbu8sDPo8h6J2M5xnbdz6txx+j8P37OqofQab+8X0ETYIJR1pXP9Tc0pZR83hO1r7N6MP3JIReFxEvQK1JDRYwQ5lh1a8HSIEiZdg4SjrbEUdYI/ceKP0kPgCf4eTpvFhFftAdaKVtK1P3PoXl7IrTBzVdcxfDedeR4JHU7ePdM/EOuZqCT7b6UghEKA4fkLn/hYi2u859DLBBJMLr08+iv27AfyvunpdfCCuSu0Kc9iXysxiUAqWdiie0XMaMb5IRXyGHF7mDVjrlr8yUWu+asE0Rap5jCc130sTxFGrX56fgTMk9iE4oZOoiv+chx74USzW342DrzwwSJISTp1EAjMAjKbP9jouSmaWpPAyoWCWY0LBgUQ0tENUQJrWqMbCv9QPEANVDgOLa5XEHTKKufeQmDLCHHW/bjNuwHRGreER17zKhmXRaPGtXe01duycZy8AIouSFOmZowf9Z4p1BbEYENcVJJklQUH3Rvl9uK2dDF/TZSPKgfyjhYnJYYZ/W6ynWDEL8s8Vj9n8lCe3RVvgagESBopTkHBWuQZ4S6T39dR5/NRWyAfB12opd0TQCf4XC06tLuO1FcwpUllzRob+oAgqUj0ArOfAlk271vOrTCQiUx1GoJf5s131Bee7iAYsXv+mEDHjhQyJlk9rjbP478O4=
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