krJUPHBM/AghkI1tJ/mqITErV3mpJzATpua08lme8DgpTYh6EP7MmrlBqdRDk/9XO43NXnvMk+X5g/niq4iIk0ZG/eeTZv9CwpXWFY97iKUqLqgmBnJy4YV+HwFC+VbL6k9gVKhaW9B2GGcHi/vjPq/ARHNiJVmVrFRHYvwFOsMNMXo2ACKczPL8mU7cSRtLhEh2aknQdis9Y4LbUjnTMiGgugqo5PctLKjJWoOTtxGOuEMkyh76ZjweHjdCezO5ynCY6VLXY6lo2jux93FyZ4r4ftzkmjJ2U3d2OpUIpehPtWzznaXrZjkAPyBeyqF1DFW9uqaKwlZ0GzBbNQ1vVoEuD1HStOgMGmqSzY62PoRd/m9vXdO7wS4htOwb+24EZUbqTFhZo2lD8HcdnYUVhG0AeoTTyZ8swPPv+WWGqAueLdY3uEb9j4nOANwjK03Pv+s6StXxoFgCSk0R57GoVEF3D6fX1cp1d9dxymNp7b745STFMr6pL/xO6GXw4Syx8TOJSboRvYJFayMi1Asn5buxrHszGlg6RfwYypabfeah3BZHHjXYq12lTuTS4HC03hQ1sD0bvZ+dswJ0A4CZBb6s88ZuBFZAJXKcBDY4xcVZHe/YXKIMenKkJ3cNVQWY9PZQceT4H0jAwIc3HN2V2pXSAKmhQZlelUb3zy99UuPdLEapjwRncTygG4p4JQHsazOnf0dykuHkPsGcGxNwiUmeyIZLSFsr1HuK+tFHHG9ovWV3451O8uB6lq7zzOzzdYzol5MqGCwkqFTdLDQrEKSvvbAL84BisvjPstXKCGihJozByY/LJ5+K5m5VGT5cRH+r0IiCX+QeQRe0mHMsbA0+fbHQq8NEU3Edtlr/LtbUzBBsiXRlbFpOFGE8LbPFxdjm0xc7F7e79uZvkOlbCZI2ubvc/Jr/hdzPHsJBaLoxzqIqQxFroFrRJMGqVGhHa109nfLMmUDEyus6ZViLlZUoLMfvXFu8I/e5DMYTlXzGJo1A8Ap73YVmw7PzKJxe72sacuDOQSzzT5vant1Uj21a8c7qG7Ot7w9cCclWBSib0QmOeI4qifri9JX9GDOqlEDtiu2ip64YXBtHGDjQJ/FMQwWTSl+3nhW7tEy5rEp+jyk7W4R0HcS3gCO7h/kwnEs/vTr+fZmt4pwDNQ7kskmYjl677+hunTulVLz1s2zIe+mkIy2oIHsAQilvhQ1x3fINpPt/NIq33Pi6AUTEVeyFj61MBWtmjJ0KPlLB2W9WVGxnyg09OshWJ4948JD0vF8IThW+hjE7vvd+ekl9ItlMF/P7+xYWSDI9S2EJm8xnuzktYxh0bluF666YToBGGVD9iKK9NY4BhJi0OIw5UMX5iZ8yZuevkAGzH0Y=
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