ZpJX7L+eLQhl4bklR0sTnnrzRh8XLzX0fz6KSorz0KnfVKik2Pvjj/SRcL+NiYk/x0sgeOJWalK0aMulueOncoLaI3HdEVDkaqC2ssgBzqIJxtZr2FPRIq0VVdGSn+FY15cfLvMz/pW28LzZraii2Pz9lRFtgeBZLuCL8KChlTPXpFXqaXAPJLzcelmCnD2x93QM34nwpRZrSFGg3Qu9KzJe5jzBl3HvCaVSdLolXpMt8PB+8UsPLVovcc+1elYgLK6FcsnupmpytKAXz/4O970h45DYSqdjhoHaqr7hbfYx6vh4VlcV+VlxO9Zsbgi3b9DnDHeNZNrcmhY0l5QU6InLN9mKHEl5uhm4T6MKaKWW7Csco9IqJ2y3ZnJmT1iiKwgUT9OsUMkf3XBD29u0nawc/JVsVLDK05K6RbmPiKUFU7zBFeWFiI2rKagpgnQtBAWiT+NSFFIRpvLLuUu3QOKDwariclh69yMJofLL0oQmde28nyfBKA1DBw/yr2JjN3YTm0Bum+F03D4H4NpAI0zvy4HxKzFX379Rmjrnr4lBGtmKLomSqcY+2/7PAeMBP86hAKpi917sZ800JTilS0WLx9J1FFSZQ3FbiuEXSJMh9x5MepSDNf+lpQByITaSf+gQrfZBFJlhDvtG4HF/ISS40amX12J24H/LU2PK/Cbmx9BSBnxS7w6grdTLYXerbxmqa8lOHRgZ+F0Mc7QjRAMwHAWYm8aIkqHn0Hfntuxs/q9zqUxj4UKoL40HvpLcMZTHrIN+5UjPzSNuOY+vMfZhwndtW86H+H0+P/QuHeZrFb08AN7ww/iFRtNoxUFUqhNwX+sDcIwF/wShOoWKr2+aBmunGvKA7EO/Y8q4ETuGMHUnu+cFE6/iP6hTr7km+f7Wum6FG2InR5Hby6vf7K/9vhFVySpwH2kXDveWRbzciUQzGZqAd70MNC8j6gShGmUHIvDhvwa+vUKHHGdRzhr59AGMJD8dLCsGRji/9iH8ywpMAo0DbNS/OaRYPRwI+yWPwk+yfLjIhijmrM4I4A02vUTaPINc+coAFNy5xHrTbugko9/sk4lu7L3OiLQYNFj10k63/lcy3tBiI7yPYAJXfzBzAdBu8dH/39wNZZt4Y6tZwkgBQwOhHcVBlD9hw2wQ+pKMovyz9/MAlolWQUz7N2GCM/btVa9NPgE5JRY6wdhQHjj9OOG1zbdCaq7tQEI80TWn1mWh8AAPO14hhs2Ff9aFkEyoqX+QySOzkMCoJJKLecuBco5NMXwaEODagM/a8Y6LvCX69t0tY/+CT2fuCP6Oyk4mE5YLWKNuXKf80+/7VDhjN41lnU4O7tEOu1H3Pn9UQ33rcfzQ2ZFxz44y+2vTCUB1G5YWCIo=
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