ZLsTTkYPchYsDj+TGv9uaOVcNAb0zHmt2KF2WB+Y2kntaLfyTA2W/Hw65sXl1ow14Co2YAKKck9DFKO350bVXTvX9SN74OQMSrM3KdcvIorbCOY3GoW5wjEISqvY9bWuvV0hTGkvrWCXYwleRuWGGEqJuLpfaB2JcaCL3zNPNshL2hJXzXAi3bANae110nGVGJJKCS1sg34ECGsWz34+1VUQqE7D2jAF7B68QlhzGEb797fIASWoju/SWdI0Sv9Qv8+bXnMKuGI3ROaiPKZ8Wdi1SAFgRxTb57RXk6G+32vncbNN2B8htPy90ovtZtENPyvtKZi2y11hnLglzUzREpHZCCAvok4IhD75ycBlFRxLIFZ9jOJ+M269DiZFSJtXaRdsVaXJH1TYE0BgGcc6hadnpFZhdr3ghGOROUnuK+0FoVNx8VMBnMzL645djAEQKPA3SNRP5KATK80Gn8x8O8xo5aCFSjy6nIQflw+UaaNl1wo+GVlWJWMweHj11uKeFw2x1CPZuUXmaIU6AeUk612grpsjYLwGm7OqVYW8jdR7hQPNXT2dS5FDx966gNb+44EV7yVkrTjmoTM3swzKX6HHRV7XpDnGC/9eAMyC3ttkcosSD4i0VeaDLVfvdWzivvuCrteQzwPDGXH+iXgw6wVMNhvZV+0/lYhpcQ1X0YhFQ9KBYkR/wqWvmyQCSnc/UocrpSDBqvzeLGdqudZcoBVEecGLcDRH3FPR3bPoW8IQRmEShmw8yP4EWlecIyybaTCoCnKfxo1/aLKAGAt+S8da4+jzJf0WCQx1le3oJTUP7x5jf19lO610WwGFAEmQR+2lBa3Y6lpOEze5pf+LNpy7B4XOdBxuRIVDGKbNNRXeOyrufs0JUha/OstSmJbJ0jPpkbopy+g8j+q7j2tM2xXVtZay5vjNUbYD8VKJWR21C81FX2YskyxwmEVDysdLbO/KLNR5aZLh+VWtnxx2Bv5dHF5cNzNmf2+RViuG5ARHEo9kTD5TLLdFwP6dBfmCKocJK6cIm1dDy5qwWz8viPDZ9nW10MjmC/zInOP007ojRZAb/v6BChMFJjhrQBlfrknk4dCxY/iAbOBU5pO2n8XX021iVFIL21Fp6XhGq1o4UB1BC1dtn8Zl0ZBqAqSQwvo1AoprrbcyE/jcT+EikpBRJrhWDOHbiTf+sbzqsBAVpg2NN17xUoWFbO2blisveEKSgFHH/Gb6EP73MoUA+Kri2nVn9WOc5/Y0/P7N9LMUznnqFDX1NrxsIIAlv0ytk7emad8LrqTpoBTAemTR17COAwO4fU7lp6DHJkzY84AMN/AxWzBjAbxNyvsts9oGGL39E/Yps7M2fhyPaSVkHAPlFsXfD/+U/dv00I0=
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