g8ArxbjBVHVHX7O4fiGQV+d8AUeI855biU8KS+1pzUJMlhmajc3pmdyoMaUJ4VZtjZIuN4aQi0NKbrkfxICXjFgOmFUpgbgYehIdsPscHFBP2Sv2FB78rHmByqCqTTpBfkxVqZejmizmAAF+j4Tuvg0rBsz9zv37nGLtHRexqMa7pcVVCXOURcsR1FkM1i1+CeaUbke3qdV1AGpIHyRb4s8SLAVmz572+ynz950rd/wpb8Hk1MqAPDlis+1ZRtbgvHCSN242LScAj55Wku87u75Z7GQNDtfbUY7sWXll+pjPT1NAssNs7a0RP2EABG4hZ1mJ5xgM2YZYMgF+Bi+hZvXYusAsxpMQgUmV7g2QtXtsdOSouPoFFnM7xNR5Fj/xgi86B+moi4VTi0QkiloG9UmXpB+MU3Mt/lQZPFEVrCOE6chK380NYYG3ZC4EaKD6eEIaeLSqA62rVEeogXqDslZJMguvxTvx8fsaUqzQfsk8VTjF8YIuFAfKHEeT/XrjI8/1Y+SVSLF8u1hEdKJwojk5XhURdh40zZdYDZeqP7qgyBz9GIvhEqerMRMW/AsSI5W+LHxA6dQJw9OL21aDFV3ZvON0x/SO39uagvddMQuvhW3/YiamQyCj1lqBjgFW7UYHPzkDaipORkFhC/NJji4XmO9hAgrWFg3GtzRQW1NixhP6O7N1W0YMXsk307JnG1HNbwP7E9mZ4nyBctbLuiFq12+3C4bnrTUnGAYqRtZveKuYD1lz8lPYU5Vstjq5FPxYICgXfpH74PqeaBBPHeG2tKJ4lcnDDuPIAXkh3kQubr+8L4tPhi4qTPOR4lLBvNp23sbV0HXt2SzWdzjazHS2/InqwDEevFNBK5Myi7h6LYiuDwUg29zOW2egRQQY4HQp9I+PrdInRIGPSmBUvS6tpwLw8ilHsRykIK5X1NcS1zM0VslMl6meP1CJeIUz+LWwSgfNXlcm2k6YSru5TSo4kyN09xt2p8hEjobcvnuFOE2PO/nV9gmZhO7KJS6qn2UH8UgnZLiTYuK2FQsuUNpn4OaczH7tCyzZEJH+p+hxd+E/8rcspEKYXCbnL0ohLRPNL9h8C7zhbJWqo+YNP8ebn+nc3xLYRm02fYzgTnHomDVObWKL0XsRLUZwxOhHnC+/hLTRL/BYAd6Z0ilEWjCA8b7VwnLihk1pUB1MJkkphDHYY4aoewcLKhEOC0B2VOEgn5l3GUhOjXhIScpIx/g1qvJr370lwpv0TT0rr3xJ3WM/I0VcWdOG+bSyAEuSMzka0QTQLx+KM86SnItyqheW0VyoADbwRvfzEULaOw5i0+jp8tLJAQ9cTf4DXwpDdDyK7c3D+ZdmwNBl+cj0vX54vJnNp2FAMoSKgyQ=
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