xjUvFIoCH+rRRZBsJb3up82YgoqRqdrrZP9ILcod+OXfWUgMe2hh/Vfvwz5cdkutmnDUT5fgF2iMBmJPgLhl29Qf3AYNeGX2NZlNeF5Z1XJAkoXPjadfXkLA0b8dTgUlzL3KiPmdrdHqyWOL+r+WGOcZyOz10BNNA995UMXdHloOoH3eMjqKHP9CJa0fmLbvC9Eg2XL2LjMz7cg99lwil7tSTj63r8pTs0oNTSi4KZQ4DGZ0INlUt1qYiennKYESgkMbvtgMcEUlGNOqpY/G+vn37CmYo2eoOJZAhHdabbWGZ0Xx2PwvA8o4QkMxCeRYhdbxB0wWnBu/MROu4xmc/g51N3QGzy86in8Jqpt0qTOz757n5BkueUL0MYmx6YMJ2ZN9GE8nej69+0+Tw098OVGYLq8Kr/aFY7fe6jntKJbYz9DC1n3Jn2z6tiAhTsJotNCj+XFMjGaXrpv+u5mDKqH4g+xE659/HypDFf1Kg1mjSnRM1ACRH2SqQtcxZUTaodRDLzLPE25641pU6YgUCjS0Wepn4Fd6aBdhc2593gnobyTICojy3q3helL5UsZ3xLo1xC01Wnhe/fzCyHnLivyllLtPmL0aeAYEKqHm3+p2FOkpe5j1rGGq969b3AB1igDZyh0A47ycxgUo/m0u/rO14niXcJBSqKhpMkg17F5nkWYmHoAhRRbZinVKy7WmZzaerTCCxDtfTdisLFt/blOw1WK12jjdh7NtCivxMOqHPKTCqZGZjMT0y31KCsMIva50qYTUhAh1FCnrcvboE+wN5zs9l8V5qC0m7HFZ7xeuA1xij/uV1848tH/NL8ED8E1tSDA7KhC5RIES9NXe2VVygQZcEi+KF25t04+sxlzEPRiXIuaWpU+JTnXwjOIe41bm3fvghXHQWvPYFVfH6sfvOoC69nzf8dBaYFwX0WMdBoSSH8OirVf76VSduNtOdwLqh01JfKs8kF+NMgdDFru/mCilDgAPe2+C0e6KsAVlFp4wvRCcB/oD0kqCCirrt9DZsKCHWHtg6zxq9fruAIW7dqdxc27hzXR0P7um9s4aVFa3w4Z66Grb9/AhXx8LYEkPrrS7K/4w8TA4dtvROPlO7KMWo6paupSN21bG4GsOyiw+y+NykryRJ5NAVNFjSM7s1B+FbTxXHcTPkK/1HjC91HC9t68cGfp5Os23HAaUvvvievRZ2iLjNVJAFSIJryivXXMobZnxxdCbiA8EYA1JIiHQR1d4fluQl7QLsye703VsP4ARBV9VMYYy69quUQyxmOrnlcFSrwpiarsrhmLwUAYFAwEpw79KZkz/vyJlSHPPalmiRRb0SE1l+OWsVLGBMZUu82ItP1cJ2vqpwXaqZ2W6mgVnnSG53VQ=
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