aGByLeS8ZlZPdsx/JficAmNfBb7v5c9V9ADYLeGoedVKWqjwYMj1UksELYGlRoD1rDZnSDjUr2LJE9J4K3z1+F6Uxq46ZlNOVO813CBSvNoGAzLm30FSDt9z6AxLQP8LPimHQztwyaqKU2iaNwfl/p8D1z68KJK83dGLxJuIOORsFkBNKSTpZLWJSFVchm4PYoQ4l9obc12mQvIlpEOK+iGwi4VHQjXG9k58EclsyNCYvf/SCkj3kdhQIP2JqPE5z4uw8Zzoz5fNxOmxwWQr49l46jfawWYl4Td90WtEVVCsH1el/luXPZRvVwtjWDagiuPhAVaGX23JzFfCd+a/Ft3Aw90XXW5QNxGlYFz+WZidvv0jr0UPzelImSaWFChIWN+QnUI4aN9pnrzq7mekjunyh11lImU6IajExyy23GDqEfIzTUgxNNlwUXBBW14hf093buQKG5UAfj8HZwgn7DFJc3cJVsmBkFT0eQCLE1APED6X8Hlyt5ql9TcBKG8o6bUAivwbaD5ecFwYhtvEZymnDAVl4DqBovuQjG3A+99qy/j3STvjWl68Ft7IjDfVrtqAeFEmiv7UGxwhb3g+9a1ReYqAhvGPPsB5q1ohg97OVeDoOoH+1roepDoD8Lho4NlLChjFuhQzAK7LzYQwLFIIWdBxgskKrY6B7AzwemwwS+Tx1BVvXj+y4y4gmqd/rIHqco5t45JXmPnw3AyUphc/ansN93qwdJtXWSqnoIwY/X89eGaUEJJHUrUvE7qClAts3nb+MMEaDVXR5n18FniT6mq+mV2UaxZ3LqyZU5qDRMaAxqeOp4j71wa0eMBmNe7AEgr4PwA9texmDpNCB7LDKpn3LW65trzbPl3aUWqp6dV1xuS02KXkdNTEtzt0cWAs6Pm5KffMLAIWdQadDfPDx7yL4Z0ZMFNkINQsf3AmMEu2c0rzbKLKi2eWEuoSYUPITTFg/i39NY80Z/B7v/urlj50/Uh3mTWKsjKjKQc0APE32fvZ4U85i5dYmHoim6d4CshtJaRnqecjnHpyiPlrFWG4fx+gDglmFULrJGn2LdvKj9WnWBVkMniLUgm6Kfei3YA5UVFDbkMbAsGeIGVhAmXfouiFRK3hUj4C+88UkIelP2LtPDhV1jgNSVGYY8ZOaJK2uvkL7hTi+EVBm9AD7q5pt8Gslrz317/q2MRPzPfMrubuqFHtVeL0o/nyB6vi64cNcLbwaO82ejO62i/9sD+oEOtqrI0gSWdzxpDUrcJBD9m/sDTRK8mAoqBXw4rOAuLm0K9dikebFruZ2RybMmwvtjVLI25a0nLZ7gWej4TeLhwNBi2mqlqFD4oqi03QYo1oE1rvRN290HjEFYdWKJg08RNMeL5wN1s=
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