N/e0yaL6R7f87xkCeAWUO62GIbmdciBQIbbMcnzgeXas+KQpM9J7yCrtjcINVAgBbsnB2PvoYjAmfOd79SiUkd0y31dmKLBpS8taikNbz/wCHZO4xan/Dna+aKC+lXfaJly4tvkflKxdUDuCuuMzquhXI8ZO4P6Tl7I2U06FJHjacGaSNNDvNUvYozI0tt5KuqWkn1zKcb9u1SmmEWmMwi4PLtyHhQ6/MifhiP1F52/SGMWTs5Ksq53lyo1X5PUZB59n2xfqS6FNg7hP1OK09gc88AgylzZdFFojA8twKmKdJXe1QwfzJajwb1LFarVGX/V5GIdBzFbOOlde/U57B6Ygcvk/WKFVg2/+/Gr1+dM+pxGXLyXZiplK94OS22Kc9cIvWhtb/weYl9t3xOdgvY2P+jpfyZVdlSP+3BGejgg7uFL724Ig6JkdD1wASzcnJJivfsihOiWx/eO4LAqfC3oTx7sej3Yl3eFwEsRP23Z+xWcOERm78xOHshmEpR9h0n5KszJ6Fk8dLlxdBRkVMhAkUuykQpD3h56ZTv9ST53+Z2VE9zkwLEHMhfzrXJASBhaNftnODkVvXVjrYVEDUelWNRUCYHmtfMaMQkQEwLJ/ZBnKNUInsmUJYcrD9K1PIg+ENnVyXEmnMQ2V8x1qSWM9uROwdsno0aUybThkfQ69ac0NzQCyZOebbyTzyPwr1OODxKtcQME+Nr2c000zotzgz9dgGy38MEB0/eWMAJrFb2pkn4Em0E7r6c35YKEKtTcQXDp7iDz7NWxvbzhVfWCtDTVGV8pPE2/EREH/bif5MvluYeKeKqlingC+B7Y/0K3epNFTamQwGOIFFbW3pRxN5saNK1N7FUi6YKAyA4s03u/NAFdk6Kqhl6EI4OvXlrXz5A4UnG2vCek/674Wind2n3FWOqfakOXynefX7XSgZqC+NV8wqvKAq9EpbNiJpGRNL6pSTWO4K+CsfxaJu3GSjYzfrsfqMzQMZGrRWUpFed505pu0K0VpQ0yPL5jiRUo1djo5FN88CO6AigetY92i4Z2a3u/MM+4H9Mp5nDL1UPUSjNWrpp8dXnyp5g0KhftpapFKWWEgvn4i9k0StSsSnaxUl24spSJ+uUIkVAOrK4gfUlvZ9WcxYiqZnzgDBkpcJPjK7cPmnxhF7jiAZ9dN86nMPc8P3nXTZWFlXAL+zsTdkfNmERF/82i5jN7APmOoCLbPJuPSQOBnsDG0015A23Sj0Twa/Ovb+ngj6X6ppQsfY2mPQIgURSuVVnrsHnmF9XyZv7HsXuGXZ3Eb/pAdtjziZZgDMK/zHrpPpIOm2cTP06ikNGMERUNP3YnzOiRQ4RlmLM3twnV4TTO3+wtmwXpFqg3+IikFcQM=
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