kgVLq2z+YULHGccctZNOwyltmv2P0gRZA7rE3+inf+B8aj6Mh2Ji/pK9RR0msx9Be6rU0njGFKRKfNNMovuQKJNcVfvBrmHcdiFwzBuCi3duG4Gcy/Bke6z67Fu9gDCzJsrolYalsslLa28csHC/L9Yjib2uJ3AJySjKMbMdWKsnO1DObqoQ/28+3bQjhGyLwgd0mNgZ9uWi4Z8VKOSVYKnyVCEYGZAdw1m9Oib80fZgjkJ09SSe9HArKmpCuiuJiRcSQ8Nsz7/l2I5423vlAp59F4bBZqIarvj7Do9c/mrLWkfxS6sY1243eLsP8J8SgeC0CSfbzUagPoBlDGllzGgSFMWzlu6rVKPmCBZubY4/k7olwfV+OF/zO8xiDKSBC8i2pFD2Umcp+H/4Skkd0cmG+PFeYpIT5+dVLsImIyPS5pmpXfN+P+bEn1+YVAZHwxjKXvexjd44zppn2Wemd57QBBDu9dQelCzDTiVjgAobuCruWapzMZzmNFSAlrDA0Au0SO/9zlpyhU7fYRbgT/INUF04UdhW/MvvSSXXmZUZB1jNddhYsTemzodHMJnzAAXHfhzmum+s+aoNwulB+/Y1susxVqz9PMFwMhckVxjkG3g8HLI8eieeiME51aW4Zvce3TvJEKsN/m2DVmQ1yIn9HFmkZzWByOETlcFcILfv9WYT68e1OQx8Hkl5YLK5OwzpFZcaF6OoHMEf6mUthlnQfgxh1ED4zm1/upMfXpomkzsG17WTOBPw5fHMYA7voh/cpjtIba7JXKv/Dk1j5sxH3YMbAlURcirq+s8/EWtMSYuCRbjrXJ2flyUf/sgSAIbHPmllUZtnLzly1AqB8MoU6yYYruKJ7XbfZdEIL6y62gCPXaADIp4HuZxJxlzS9RrHeoC0ugctf57vR+XhSagVToEg1X7gIPumNgjw2NpUY/1uEe+3Ce17EIL+sgxsObj34+mXr1h2qi34KHO4l1M4Gyz4x3qXvS1uW7BfYKRHSLchlcdwCnSH5fXMDl5nTkW4szZwW2vcotbhNWEdZZowuXofv2Bz6qWdL9YPR6Q7sDMk+Ne81LvUZ6GkBBCrfGR39nDJfqwidxYD7NBTSWweUTYASClXcxsNmYia+6+CjDQVPaUsdq8ZuLGttfHuBSo0mefDdYpTRCS2N74hvPdzwXkMCZRIzx3jMoC5lp3wD33rkfs9Zky7wI40fwyCIGODaCfp9P+2Q/qHTz8O0jcDub+D0ks1OPMdW0GPngNJOvHVIdmFVJG1cE001iZ1B5cCJ6jNhvUBvhyYjiq16oNoGXBDOM8r+QJgoCb8ArP/C6n/KbxtGMtpxvMn8PqzDvy7P1BYUStpCawmrqBiyB+LzrD3lEhYe65eFnI=
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