fkWTCoLnP22eMp3dw8E0nieHGcQDqKX9H/EzGULb9W0O5G7cKV5i8r3hmrr9E9ywHGMK6Yko011mPuT59WQAiDTDn0b+0mj7Mtdt+JOZuOJgkbb/c0gxp3UZ9u52FP9bTRkYLbJvMVsplzNj81TxIAaU437RmOdNlew+5B8qv5f8gUwsOJuYy0G3BLrqghlkaIEoO8f97wBchNSrMpePCGjOus4O0HFHsze8TcU8llxleiNFZVBaKWkC2qelineIn2uopbXsBje4XKupAgvKqka833GhTln0GuL1FlriNhllnh3/nMpM18sWx/4mBUQdofecggaPC06jpCwIput6D76KgPmuJ0R1HZ5p84oGUVyT6rP50r6pyLWHYmgssfUt91fBoVsHE9BeUJUisNBpEfJXxbv9j/a2lkcBMPK51M8OoNYnkpGPWaqk5/LSJN7+vkTguo7JMrmauGdQ/6RqkGLlUmZ8BjrA93Z4+WSwJCmGqlwu6paYVr1eNAIaLeapOj+rmfOLn8nOCMdDf1ZrAWeLp58mwL+VORDkPYd+vM1Z0pJujcycAMWgYLBi/Zz3rAQgVSB+VfB9FAu7fVUz62u2SPmUiC7cmkFEIk+tO5ELA4Ka3GBrghCP8/75ek/0g7vTonwkRj5dB45jjnTBosn6jeT0DKbxgyxs8rrVGvBWHq+yflZgUKMBaoOUN9fy9jl9R2gRrLhcqfLYE30/iJHFvFFd2apQH4zo3gyojFFLUXZ3Rn/X9zJF4F/JiRnFkLzdMjA3IKvj5pqeAej8F//VSMFg/oEcJzfi0I1bzYbSk2YFyqJ/YDV7FiLfMKvV/HP1/TAtKK0gGN12a0BDhUW6QhFMa3sbn5ImOA1gFKVGZ6z5Zoc/zfq4rpJKALeSdSG2WdwKQu5v7UrtAdB3PbrPiPjDwX+8m3/MNvivKqYHPahEqBTCdtv8yG6/82/K7K7YqKoBETM1FhHVYJ8m5mxHekRKlgU+5LmM1lLLv0Ee8Ycae1H5zHzRwktiaKAytZGdvbYP0U6oCd/EFL8G4Vt2h/CZ2Iv+4Et1mmQv8UcotskRRZzKagqZoiF+vfOtBP/9DXbJmKkktvHDzJUNOJ3Q7y0aHjHdYc9k8xI6iQWDgZTVY6GRFdNtkT+izjmkiwrfoRSAdmizMRx3vgqcRvbeA7Ae0fTm1iJ/tgHfQNP1kFv89JiP68kfY/NMs82carWwu31eEqqhFhHW9SEC9S4M6quDHkASHx4JaCoYmfDpMvezi/hE1FGHVztHoVsF3R79/AfgTK9bucTxtcq9c11KMga9HunqbQGyvJO7+m4CVeZyqe4E/mvMzlT6M+jOMLpf0NWPbaxFaYxyJ+kpZvzIj4qt2tC+4SteaIY=
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