Jas6yNUmfRIwxR7bGUlJ9H3Dao9yzT97UA1c5nara8yykDC37pMQ0G4aE1CL+ZwqmDS6Jk5MWT5ZV97IbC0LtyA5KOmWjXcH08TQBxUxW9pfMaUpEaii9kYvewrA1Jj5g8FWNR6YmUKv4AU2OzoTxPB9YP2kWOairUkLJavGZeFE3Gg3srP+ADHzBu8LagKbkHf8NshqvQkJdpNn5p423B6bXa5lzMHBIOkZ1hYtVc9B+lW1SICtMQm3JksVfpnMm+GGh9TFKAqytgQekug21CXBe5AXYw/d7IRf0ksFleY1+YdWZGioOc03AWhy/B1tXF2g0pqquk6yL8gMAnVYS7zdbP9JkEB2A97trDNFwmWq88NuJiNyU8fx921X4fAwEqgvZafZGTa78F7nOtZXzUygiSQBv9X8bLdNl8+zEpzJrnUXcOvokxBROYqMHXIwvXLbu0cAFd1qZ9hinQnCdRnCZ6FqLeicaKZvZ8zw+DlivIy+tuVelwPeqjDrHMHAxXIYWsFz9U0nx4F1ZIwYPtSXFaomkQpHRWgMv6/Dd2pQrUQbdMh94jOpqM7a7FqwCU5oCRU9YYrrfDs/PaXRFEGF6/jcrEwOBsuYcoP3k/cN1Mrnc5EYVoy87yQjm3/togkvUAKWGzDNT5nQuSVfO8j7I4mXG6MIUoc9/hqFR5wiww5D5cJ0yQE6t46IKJ85mT1RAHETbQ0gn457bUQCk4jK3m4ET1gpRqhhCSA2V9Ij0sjx6hISEpnAzQQ49fQ1dVc2KMrVFLczs3ZjJ/begOgVxoqhCTclydhKdx0KiQNygCCL2yhuPb+K9Kptsig8Y14ie+aDh1Y6amtK6ZH+OJpiCCueDEy+vWzGvo5nQZBignY9Hvh4dHA0Fnyy3uK9+Se9ZmQ8XwMl+xigLsUZBJx5m72j2OOJL1aEmLS7n3ZEs7/WSR1yXUqrsKg7kFJO7fGkdKiJO+3+9kBiKpxZjDbM5er/Eic5rCn13R1F8U0WXyOyted8MiHX3FcDu1zraHDQ+5UbxIyCZVRgYodETDnFLyH435yaqFIfSdUECm5UnjO2zg+0lHL8Y60CGfe/vZiDHEvsiJAgcg+aBKgPghQ27wtz3uNw1qUqGp9firRtSV2koSqTAihZEnpTkkalIo2Cwg5c2q9lqGfEvg7v2PmqhoT04hPRv99RlgUW7AakZ3bHbEijz94cmz4AgTbZbauHXhGUlkhUvcS8DU32nO8bFPKYdFL3eQ7rv6jMw20FnDCdlRUkL0l2dBQ6UI0ZVH/wqo2MgIbMOb6blqkJEzS64jX6nzY0CMhg8mv1pbY9qfxJgCMlr972ZKzJzBXmbLvpnRXRmYFSAfoFbMhKYLgUkosIpUbvo/WR0yM=
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