5vd5NxZcLu1cT59kSP28I4l1u071Fmtl+Pdj2ceJMkrbWODvXkWxBxGM6HR7JBCLZumgAU8aremQTpgSoIhJVwRa2dtVea/jWJje2dbNLn7jmZhqSDxvFnDoxBuXCAM/HWsi03qg0ETqfu5voOtJpJt6RNJtFStxPipBflpDCAIbQkJALu9sNOTanLu0mUX6ebEGGFu7Md2YJG3PcbrqReIftRW1ZA0AAp2lkOs3qyTQiAx70ZLWA/4SHUlJhEzGaYlrEmFeGgynfoTYDQk2njWRZEcmMJ4iMh9V9BZpv6oPFufWpyn/cYfdQap80k6YhSe+vdVQEHd7ivst4FSKFMuEKzXpXPibmspzp6hi+jV1Gxlk5/YbxG/MX8T4ZeMtelWrfjHD7ENXVlNO8Sg8vKzMgdSHzEzJIBi/SB3bDI0Ohu2MiI9YFwYPLeG+rChbd8aJ6xhKJxxK5q5jS9o4Jxv+WvabPTyZjoH4MYntDPqT+ln7t9nS1HSayp+CRLz4csUCgu8Qi6PfOUQYSGC/JfwyCu2/0hIIOZdLEfGnIVy1BuObhQ8uB1Q6+omsQJU5O5kZccy7MMQC+5Qsq53Gj7zRv4G/vGuTPGfFaAOh+92DvsBB0f1pdd8bz7wokwY28qCzmijb2L5mDarFJzb84PVKtGo0LHA496O0XJBZGJC1DfqLKPWpAY/T+yLkHnscRTNBHGrnMmcvg8j221ydDLEl2A4WXygxu4vg0LYa1FpDCgdLr2fyP0jmUjxpEkbGCA5K7d8pEQQGYGxbNp5DFZoxjqGxKN277A9ftSvmYzSmo35lBXB2mmKR58OKPFRW53IdM8ZiFNlx6h/F4BmGKnWmjEf2rdp/fqr1gfUMu6GxGDNYrG7wvG0R3CgLipN1p1rdR5/yQwDN3AvfO7yMmxJqpBo6rnCsZCQed0cyHenOaq8vR1Sr5R5JkkibsOBvLAaifnMAdPNIhyckQOyXa0zC2LE6QflSCIU9a7zNkzy3xMKauUg1yT4LC0A1aBQjJk0JK40og/6bTVoN2V2YacBKmoZn4zVbsD0xeOVxarvoQRiELsSyYupkZXEhCVdN42egqGXxx9Y5+gzMBJC7KtC4rLhOxf+qdDHZaYUOiTISJt06M2yXpRNL5sJuDhs1OMgMrUayRjQPnSwrrxrzMZ6RROY4f5LccAbkazZQHv1gm/gy/stbTxupG0kUNMddXVvT4jH8T5oEIz8XKxJEZSmcotn0MUfP/3J55lhUT47zhW5q77pPfA3nAibqIXZMGcEM97J56DHx9JprLFGSJaCDBrpvMF/MVXmZxdvAV7ogXvqL6ISbJrMU+5gREZuHc2lyEQbHzsHUvK42eOJX2l+RTdsnqw/DizlRjdU=
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