GHuft7Axv13ejmEBP0QoPpCDRpy81bRu+4yWq/uUzWFX7tRMeQXMd7dcR2D4Zgf8C1Iu3bQb0cCJ1AXVqI+bktVtiG/c690jylFDanNavy5/WrXgarcRIWDg73DTGiSMMfTbIkESrt3F+bqd1urdnIQy5kDJ/Wuuea8ipEw8dfNSdT+tTvxE+My+X3XqY0r4gxeisahDfVuyyWXpVxL7u/WcV2R/6TdrKm6WkBjf+PSMJGmzx3ufDyYdeMResdHUrL5bNPhDn/qOdO+qv6hSOBaCGru0GnWKu9EzKz2TK22u/DIKMg0XlagUp+7YBblB2THrXfrDSSz8sphsMStlZEnWxgNYXGDWKYbTyU07qgzem3PfEezEFP7owhUpUr//GyhYpYrF8qX2ecRkczkuSmzoBzt8x3Ttk1G/exE2UVEqbybbmEpJNTVOrqbjVvGd0UDdrKozU5zIKVNo0+ErAtGr+O1DwoOKG61HUl/KdF8u6sq3eJFamHmxtjY4+Szuh4BgYRP+A25F3jg+C/kp3ZKSg/NIjU3ElZVDXuy/3QKzeYkqiEbOx6wY7XF33wJllJy/EEy1/OZ7lhQn9prY/4eiOaficGmm/CArnx33Akrda+V94URRiekOyJskEuGUhHUcpewojYzlmFG1RFxKQWBlBlIINDBMzubS+gDWv/8WbjyKpD2BfGSd8oJwTRuaHMueeRyG/k/zmOqRZw//0aRhZRLGWZHWiJCq61h/R7+Dl2K6aGrv53FVzFHA5yb9nqrBeMJ2gh5wVPzjTJ+wOPaaufmWr+AQfZvwRuEf5trOUp50p1k8PY0eux8uq4CjBcl9pytcHH2vwAJxgP0wKhZDYvFMJFCtic7ErtCyPPZ0D5n5hedNFv4LYB6FthvBFhZIJqwr37HejwCG/1pno83kEa17efG5Z50JdeWC9qwopMbAXwoFb8TpkvIUnm7e9zeeB8LJAy/qiXe5wfj8meZDCXg5o76JAK0MMIq9UIbTbC62VVAqyqyi+OS+jecNRp/OoUIPibJlGLsq7tCz+lnVGhIFQxN36mV+hArFX9beNj3e26JvJHekPfuDlpXO2imIxruMOpLgFQH4Wl/W2s21TpkpLkNLXPFdWmn2G55pstP5z3CfUs3iTjCFkIYNZ1FG8M25YlKSSWpNuK/7bNRkU89d9jyaCSuNsjmJrN/wUc2VK1ia2pOuOx2bSUx3q8KKcxpNLlCJJWxzVot+3tn1D+/I5RW0tz+rDw/r5EnQRN8FBHMgxgE3lDol4E0imypmqTdif3lrWTvCvkpH46sriOzvG9KfwqRK7bNHIx0qWLGMyturW9KwRyFbAEwZYfYB5yhLy8YbayNdV8eDW0Cl1FjT3NXwZromJZc=
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