4C0Rvp1iau+GGvatflbThj0WFm1CuR8m+/jjmDDkKZKeq6942sDSmpTLcMhgvTRaWmyVVPfq706lEXTy4YM4xHod9Q4rqkwgkw1j7KrtklhMjdC13/FdFud/fEzl3BS9R6TB1SZ2EUg/SAVUnaUDBn7LUgWVRJ0ow77FBEaouRi37jBemU2Dph9uJsGNGfG83VHf6k8ekbKVYB6sgNhqETZaCVTAE0AoFRY+e+OlXJMunJduNJ5Z9WrW24y4sIk9us+ApKWCe4EPyvRIHaBDrGN5kzdUhlCyj22LCoSm8WBaW37hjqn8klQvAtTO/dTvpquGZb7k9q70s1kUD+p/YPxFwuBlnkhYYKAsenh9K36r7jDA18gbOD4ZXqOUIr5eKSc3d5mUPQLJnIz96aMX/TE3ENMAFIjYlNeTBV3ATXhUFPkTREEeekMu61rKt9u/ZH7dWxh6Rx6DnTuIPPBnj6Ij2O0jOgqFM1lxc33YezU1u/q3XbaENo1xC8K7QstTD9OUo1Xchtzwpn0hqVdm2bmQBg0AE/N0CNDqiwtp99PS4r9+l828ogZsYEPcEB9ffshkTptU16ZwAFWDGPXhTZRUSLNntKxU5KQOIPGB9TXCVSL5wKt61BLK8NO4/6hCF5pTpu674+Gyh+EEgPjKb3cIK7f+j40p+zkEeIvbj3u6Nw5rb1gKGwVV5i0T82uzjg+A/EL5nlz0eGu8B1asDf8vranq9o9naOIkeb2Na8xHsu4jaiKhXMUH0Mo5WRAssrP8E1tcLSNPWIBjg4m2xv0PNtnQVFfvWgUpjJqyCsSytnfDBTqnH22eAYYTmnK8WDkShNVQOnS2KRatii1+U0OTbCiGKAZvXss4w54S3G3Wcb1gnwBOvv3afof2qZd/EnBy//f84P0BDjeoDEq1mki3ONS2ZuioYUZVSG6OVrTpB14gEa1j2CgQoahxZjoga1vpqmdNJ8FnOIzXtennP7BzFs1X6eI6UZUunjdruHKquxONvrJnsfrgaYZCAXgvqSSEa3lT8QblcbIxn12BLYnWn2QWyRVLhCr2wXQdvf4X/IrMd1Xt6imz1QnljdTRCNNqHz9WlVeFOSzByGFXfEvRLOoFOrc+piyX9GqlojRHBcpo1cvRlEPivLaIpo3pRymfNI+s4aXeVbZ7oxpbOgQUAuILMl5+E9rvAo2umd/IiHMAtuyVGYLCu42MLck3XBL4eguIiUMsh/Gw5cuUb5tMqsVavVQrU/QP+mwxG3Ej44qYgio42XJpjf1WOL4tKrsa4GVFwKyc3C0lI6kN4z0jDZT8ufMsyHvhxl+M/UXsuWA5jcz6lasT7fmqRn3RZet0/q+klvjE258Ouy84Bu927teM/rVSdxGvraM=
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