DwhvdNfk628IcknsaNvNAN9Y4HdSdoGD3m4nupGfbHh5JjZFish07OVlZ1JnnQ23hJWrrRG68gMy8X4ygE7CQgMNClI5LvBQQy8EAC/ZAmmPtPxG2p6iYEY28tTu+GxuqX5NcnrJCZtnhZdF3BWvnOZ8LJkBLNu+TJalG84jKb2pPBhidf/TbBxEmRugCOKYp12aoIT+rS7Hx6mTjbqIFy6BpPKxH756dT7PuVnBj6VkyCkcMYqqetq5rUZcBqcPq/HpxhijdmzJQTsq29LjqqJvEaNeW4jQPiiDO1ysZrf+icgsxWtPXZseDRfyqx7knjpJcLzWf23BW56CPt/IWcbi0uJO6xHqUMoJ2OmM2GCABxCOsWJvXqyShkoqxSxyCuAywCXk9ozne2mcGtRPtfJd1Bwury+g4wLT3+PfN9b7zZWtugkICIAmzQocIoQhUWkX3reXcLa35SN6/LUX7+1jHOC7F+VWJm2NRlewxKOEfB6uNkWeJSpq9iQshBxihAvM16XZwbIWccu7mOBgUDzYKI0oxPBN9U3mccjBBZn8Fcd1v71rTRQQv4l0PQrw1LwpKJWStx0flWVEE4hAQ43BuwfZ5v8nYNCaxVXIG7Uoz4u8i7Y6styz4Z9d+Wm52IW1og0nCjQ5c5/o6xTWbQhLE1ap3Vn1/DwRjYGxRrXht57CDwjjkQSbGcYUv5kaQRlO9bWGOryQigHZ6rdpMyDjXxbsjMj8Ujh1NqVmIMiSRGWWwxDT4H7CQ5AIZWV4SMDJ7jtYhDO9rTSEN7FvNBaEfPaGoLGdyw/WIdnjsfu1ipgJ4AY0kMM8Jj0CQ6lS2AnEIgBGr1ucEdsCZ4VMr6vz37PSd785GneVOfYsS3htin4tfYGustloCAozVIL0NndrbssH4/aLRHyoByr4KWNwOB6rACguf4mzO2MLbFvWan+OSmbPPba6aBgA9BvKY2VYyUHCJvQQQJ3iEJq2TFYr9ArJx9WnpK/Hklhq7OhGJ/ozo8C9O61rxQpPiDi93VMtThN8Sjnq1NDkOy7S0rB88qhHV/iRIpBre4byCQrCjppvzaxiAkXHNT3vEctLhcqbc73XzR7xbIaX0Nk83INbzDvZ+hvOmZy6VeWkZ2tebb2kzS/BHrsMXiViHYAz09aR+4uRSay9JOOPi6/LnuuhOeLZz2+IKlyOPOLzMdEZciGaUKpdNyeOdEt3UbEsY1RJI7k0zaB5uqQOoqmHm7VD96SmiOPN2+PAihGtfQ3gO4SvHQ04Dnp7EDJHbLL9lLiZbOJjNEI8FPeRXsyGPIKroHavJXRz9spDUFNP75A/8LEBemt46nP/iELGJ1+cwafM3oBJCnUvpVQ8kzHa788068tYOHORUghlVj0=
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