3nQ64AwfFMrBIQlAPIBr6CoK4TuH6N+HKsoVD7bFdBZxkhhEwPBVof9uhXFAQMSWuRfG7gQH7SQDla7VhGBNE4g0+5g7+6SxsH1omdYdqgFEbyiUOTdNnZVpKl7+3PpJmHaoSJT2pi9/CrMDm7edoxwjz0BMLwMXWSrQ9o4KuTEssNH1Z8l2HDaGGEO9LyeMNc9Kv/2u16kxyIawZNv4ecajnD9Cu6DLcIKNe/ceK1FboBUd6TYEbF2kyGogwfEaL/Tlx1NID1Fdm+TFZjE/zw1Nevx3IXgIjjt0RlEb5OiTdGLLqylvKN9UxrzoLgSAP3OHufSemG2GQdZovEEdT9sPwIisdvuiYvEksgb6LPL4NBlqbJjk+uAnL9eNSH7IJbO37C8BH6QNg/vdFTcYG+shWd53LlgkUh/3NVeI6mo9nF9mI+wv+VOj4sTQHuBpU5eVQUEzaIDNs8UIMsoZFOSWoDzbB3EijBW2Wyv/D7IO8GB+xNOnb8oorEh+g8mZ/6PM3bQb5H26EpwE3c6+G9p5WsJcomOEeMUp4mExEk0p11sGSZ3khMsdRDUUlWPetEwuLijcxAGnyMDXX23mxSs2wfz/sjZkfAs45OEAZ86K4QLxk0zdv0FFF+MdPzerhI6r2Zzk9ACx3xvy+Nkdydps72Zj3qcsqihkkRDHxWyMW1ekYxYn9r+CI1BUu9UPWijCoegcDBvs6eCcaTBWeNMmh5LxzK+r3w6IM7uYD12sSFgBDqiG5vsAR0lD/0q/52LljCl2xUDVI2IxjRyUsHQUlk+oU8BOOxgO4Ffps91zRYqswz18YVMzg767AP3G5v7TeLYRTKvlkDWcfQR/RWxYVKqZYPC4M+eCn57/DLjxDiEv44woSSgyOkSzBddTq96qbH9z3TwfNeDvyiOcVx9pW0CL9lwrX+O0KryxTVLno8yzqxQ3QLOBdPAesOsiIc0ZOsQArkdZfgDAbWsbE4ohVcG46M74RyPD451x85wAJA/nMIS/49LvTuWWLhBLPnpbFhoh28GhJGLcki66tEeKjhijgWRxtSe+z9/sLtiDLU0H/GCPB4YPsQJBOsfCC7vKFSRlUMzmTUPGF68fsutcF3nq68oefxD1+C+khYMVrvMkQPpquD74cZMMDMq5HEQFf9+LA/TzvTJGyzIQS+MG77IymM9PvEQPJh5u7tO73unBZ0SSCUkJgtnpqZOtG0zj+UsivpnkBcdy4sUf+A75Dny6shUKX5mORq+PEOAfpntpaVqfINZMzjTqdvcs0Z2ts4++EXJiRn5b6IT2UD0XRd61nd4OTSOr8Dq27UuvTUBRPljyWM6rVbCoWDKO5bdeE3ECy5IMvjmGZqjkecHPtVhspvqlW2oGviQ=
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