3PM7vdvhPLbYrZj3WRJCrcai6HGgkYQxHnPLLv9sNYh3Oj3Q2EhWzsLIw5zgmdVjkFhfzVG4hV28TzvhyKgxW/A4/Sq+knSq+tDehQyGZ8jm8m4o65mTHxDBRvmQuoqJZlKh1mlXaJU2X2CEZ9uLEtb1CDJmLo9Iz8hSTfgnMyP7cYa79WVS89BAXGnRRC6xNkqM8NN6A4YxmbPSSN2ppv0MJL0rEWU69F0ekRt2QEFqUbthdOXtEcMaIGJx3GcVEtkBD9l+25nakXsSwQynVtZgRMrM8XjYhI1XRJ7X0JJ0LrFvlQGINDbPcoBxsWK6f6jATnD3h4l8fUUpSvKRpNeWh61E4U/06sYhIfJOM+9Qm5v5NJuK2tpK8askfLz3YTwk/6fstjqz4CrmRL+1E3Ozvdn5j6KGKW8x1hfCfzMIiPvFSJ0PdykL73JJqhysw4VPEiqivfnzxShj2nDvZdETYaob6QVYA+3oh8EGCxyJFjYBINm2sJaVozfYDhvmHS4i/9kC3M90Henwdj4Mwgdhoiusy8cOspm5tgc0Kgu8FhB2+xNEaI2Jl3lao7PQdUukBxb/Om5s8x78yFlxFiAeE0w+XRgjKdc/0CBbhwTqfwIMgNKFmF8fbAznyQgjzsG/x74pG68V/l+TzANV0dRl+FZsBoYVz9IQLn3BDJlOzhpJM2rLM5HFWWWKhq7eW8dx9VbTcjDVnbPyEXCI85STVsJ7SY/Ab6dO6GQu5OpF3N0jJiwMJFt1zgmWtLBMoXLV6g6aRrGNxe3xquJk3uZmSVlsZ3S8yKGzlvcCne7uAANMaH7ZQl8hvfv7Jc2VP7mHzDBKeAlZNwG6IbrkvP/BpId4dD5jN6P7eAYKOwp6QS2e60ewdkNGGHfg26b//yP5kugpPtbczrNI9EUhPML2kf1bdPNfC8eLrHrzjZV1MzL9yNiegU5Ol3X2ZAw8xDLTkWpRLtaSy+Hf77bwAIPQHXFaEiyDr2fw7KR8eQXZVRvHAM/+8p2I1U6ZmGHnFqG/MNn6p/Sh/bHzjVtFtJGsGnWeTefdW8qQmw1axLITEkyR/fWtB/Aszku+WHlOnBcWylbzKyc+C6ZxNb7cka2SCXD16gHGdsZnso/3MgtyK3uLGQdSvIZEXD3lLldX9E9TTqkZ4YmFz+tC/c0EaR+KQKsPmK0rniB0dHnC01UIlNSJ0nmWl8QpYPVcdsIV5E5XMNK5P83d3PpDW1fygp4KQQvPzHBRS5bjhguDgLoSd+PxUk9XSRoZEJ/FQdAN7RKVYSezotNOmSVHNqpz6Z9dmO84arrlrM73KOaphQBd2Dow0Rf29DlpRQ+VS+n0TZibC1adRGMkwqL4TsmzFusuH2aIjhDwk+OvDH0=
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