SKt2J38zFmvvXvjO9fSgBmU5156zohBJet8tXXq8Yj/FOY/GGNsgI4m+HPi0Wtvanr2VIxPawZNqIRzD2L9nPuczsErwMbyte9sYDuZa1aC3dR5C3mqfTyIO5sbr4jsT71pkjI/27ygyUftVB4gag0nA6wiU+ZDVYHV19PXDHvDC6Oh2INt12n/KOVrOb7nMZU+gqNuxOPyzYeSIyruFkRN2+NbMvX3Q1O6BIuR8dAE2kdcJjmFpKTD4orS0b8qCYlknwIAwL88dJPya3/TDQRiiI5dbCDxDGZY0/oQPZIo6JB4ZczfrzRDq0WErRA86gaKmWkr8jenC81pvhd6Vfy3JLCEmwshJCUElBj57ce1SAzxLPah3/JQVZROj+G/WIWNs/Mm9spUIXozJ4xdGP6WlS6BoUZb437LIlUmLRE8fFblnxAN7Cnuh8BZ/8Y2JnLGKWdRBTF3CnxQOpvV5vK4ctDkc1MU2EkM43ITQNvqa9w21UBgQZqX4iTDU0mINNPsTprN2Sli8+PsvyMbAdAtSlh4EOakQnwEgvEuWhPxF3P2pTVOUpHHjUIIbiDavlARGoyBYaryBctI3lnwvX2imhICXTE4Zd6nG/NsnGogx7/rV9mxwqlIISmJBOy4ZG3sN/S6r5ap3ISuYpnqdzn+6YxABxENDVW2H+z7uQO6xJh44DBvgza+BLQ/hAcyOPaHDU9qdoS217l525AqVyMRV65xKPK8QSJO+HWy3IvP3f10SQK/qWArZu9kY41KnTYEWxy/bu57ni+HnN5w2Xrs8PWY3prtNvuBxZxcWudX02d+oQzoc3T9yXymzppc3MXLU4/9Ifor3BIVZbiVairAl/2h4+RP2FlbqaHqxhLfsM1C1sgvoihHyX9e9bs2fEljG++XfCTOFEZiybnr4xTlumX+ZNRzT3xkdjb9tNMEPlzMmq7vwEe+X1ygRPTjCiEclEr8E1Eoq00Jji7FQGFjH+szmBTKH9I0nBPzH2ksvVthh5+f7w4Y5thGiI73uhqTR6w2lctpzpaYiNgIUOaYnimHN/HcK09KvaYtW8/n8QAnvf5OIW/g5Iy9ZmMUel/TP4MShDt+rLemG2C2t6H0a6Q3w84PdQ6SRXzP8t2ZuA7Hm+6QbO5cpGXw5ad1+VvsZne9kpvdeaD2z5tpZO3TFyHy3KNbPjLKDxCPw9EfWERQBt3Co0n0xwGLHFEZcCUCHSoMOsKDTxYgol5r8aPgQH2rDx8S+kQV8TbGwEE9jjripgB2Jito4GpCRoqXJvWnW5BAgwjA3B+pylSe7ifEMzZ9/nK9Hpfcceu8vHI+4l7rCPB3NT6btLmBuA3zDLRjaSvijz7MdmLC+4mIY2zi8x0AQFwhtPbNaih4=
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