+h3xO4bl4bGwlmfD5WL+1MTeslSnMlSo9KUsigydmEgFpzui0Vo3z/hOFnKMfVNXoXHuI4NlcVFKFtjXm7QJgbRE9+wgv/dUFe2cxEs3s7WN368wiCsaX9JqTZOFmL3ZzZQdOTRhePMjXcSI+eKj5AOJvMN3sA94kGx0j43ecJA9JDY4oGEXQNgsNJedCnpl6Zp8EfoTxv9mu6ElejlICl5ViVhcdqCsEZq3AkB7sh9DxJO19PlmCD7ab5j0D2YeJ+Hfndv6EexQz6jiBbAbfPcPgAlmBN6fEl6aa46aU0gh9F5L5wQb4HDYfXJEushi3vRh0sAZDS9yoDlaQmHdE1lNFNm2Dt+3yq0yl/4xr7LOIJ1TF4mczOdoYpJVLCv+Ie6Y+WEYIwwfNwe504A+fA/05ep4j8uBFpWjCOqzcpDfz7l8zWBlB7Kj1wZ1mGDjVOtQAQ2mmmmnAMHgViOMY+1LwTcB6+MRQBCCW7lfYfzj24Z5jZuwkfP/nQl5MUALLD2sGYxDzCm/OCiAdrERkPauRNH2uzItEi7Q5C5Goj4G7TndHB9KbyrXDiFVQsuLvmk68E1BQ+fblbKjIquNzguFm/5ZLzQhAMy5EDTIwGq5jP60pOsg+IQZ0t9GFOUPh6cN25UR16cW6VGV4xZbVStB2Z4lARAyGrEwzKuDKqiFu0gcI4nZMiuscFVw2pQw2NQnbAHMsKWuS19YQ+X6LNaLHZiTBgyzGwVjNrKXoxcPSmaBjco+NDKkw8G8ejQH1bsoSxDgg1jDQBl/zudNlMi7FdkbYm5Q2Gn4h3qHFX9BL/vaqpKM1ac3kkNoKsUPx0PyedTKYTctl6agWY7Rl23xX9S7MJUPUL8jUWs26X+dhB52Rf3pvjfdcwalxTXRMT3Szc6NVd6ucYwaWmF7fDR8+EX9ikCbcuVExa5qed0pDKiBUAUdl2IbXrXlEpmhnOh5RnuDFyB8PZUCxAujBk1IQMWjdHieEfJ5lxRrLAn8avI9wNnFnSfyDGHeDLgzAuZvos1vK41TW1Wu3wonJhCV2JqPcHASZsHo1eNrpyLlCwkqlleyrUzrl394kcsoVcZzf0Iis8ThuY+024Y7X5nryVvnzqcDFUMxJrHIImOXJrP+NornJ7eyRycUFDowWtVWABu2nE8vev7M0WKp4vL1Dpvbc8DNhIGtRssJnarZYbxIpiwyMfHXxASYQds013pgJSuSZV63S20brMYNq4/LwOuvzVVt0KY85TuKeaRcXwfMcJv+LJU4My/tGXKM76WPtlad0txRhOTVFp30ZCCxrl5U68s1nQyd6geS06iIvDFPjJq78hUFN4fHmPWzc8qPIrjpVs1Lm3mXYkddVGP72sik3+5+PhwXsOQ=
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