mzSLQOPnLSOpMmps/Gvz64X0nO4NPCMrtuaFNXSwY4QPtQ6tqP7mhOx9vyQU6VkHbz6/iaXU4K+PdZalmsV9qe6Weyo+zfUFr5MnI4S7uijvkBnwSaCjIm3CRZuOJej84U8gNuqhx4UdkeU0FmXcPaTIMwcTtUFh9jlkAkdpDC3oAv19zJRHbBKN9R3hfJ6bkh9ACi8Q7SjONNcntT7onZILc/FcL4HImoIBRbXGMZgpgNi8lFGkhoRcjBm0zagaFoS9SEkEBFeIvMiuRcir6cXHVkwOSAh8BLuM41liDoLRo5parxgDZvuOOR97EyTnd+MBx+KS3W4/gaazjEVH6byrG5QQ/U3YIiEqBDcWqpMMhdNjRU4J/jj105ZsgMJwWnngxDGuLB2g9cPJegCOwkI4vnk3VBNL6QKxjW2Ln1webgyPJV1lxiVM6MdFNVPi+G3WXJkEI40msc8nwZDfyfsFrMmrkxr6EU5xt9zMC3VNkZELwxCFXkMUS4s9XZniYR+6e1HTKpT3mtiAkluxD8of2OPBZr4gaZ4dQWDKPHdIlPiUsoNvuScIb1bq1HUzrHxcKWGG2N9XDpPdV/cIBu3KrRfRHysnRT5lVB1qsANNuLRdp3M+8HsHbE1Urp9aTwPdTd/xy+Tcr5ZuEGbc9xnObFzdnIxs4VaHJHHMnMgPF96wVOC+SrlblH1s/C8d93TtPYf/9n1AmDFsiQNSAMa8lnvMGkNdjdMtwvMDsxQQk0R5KIL0bnXPjmRSmWLEbrQwxDkwsIEUxGBmd+DshQ0In6c27nNwcw81SAAlsecREOm8Ygazy3jWS3MJzRWvwHj7nzW92qw38lkKCvr2k7LHPPMp4iwgz3HkrRtGSkON9E3FrwycAWQActnqaBH4u3+EpQpVQajRdo9VGZrJmctW+n9FErFRFN2dswK+F5LBQKWrWOYyP7mv3H+jGulFq/fwt4kdX2zDlpPbaq+yGd0frKcphjPIA5cBULlPbHtw0pCUmyV+r8AEacEawAm2ePAgs01TelKdy/0VUYsql85wfd4rmkkOLV5T3hiRRnGyAsnS1nzrwe9No5lOkEd7ZC1RMVZ/RZaKgJHKdsjIzQ+PLnBQW5Ge6d1siezbN7XP2IoJtPcCGwrVy6uKnnKH97KG7o8wLmlF8hwhUeu2RX6ZfhATiXFxbPvweN2+72Cm6f87xk7A7/AE/wDySjii1ni5E1I0V4WBIVAh+xEqJusXhu+h27lpsolYeS2clFrJaJnIrH6QGYM7+Sj0aNewYFgZJi0/5/nlKjFc/3w8Z7liYqfyR0it+08U4yWJSVeANPsdOaGhLPjCHkHfYTS47P2VpTXLl/iwYuCVHXnhOgP9qRnrWbvdNGn/qUo=
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