8BCzWOP8EmJ3qMjdxxUm4Dic9yG0JZGaX7l+aZP4n0UUq4GcHhMthezNTfm4/xul+lKBAkuazMksUFXvmGsF04ORcVN0UrjQndcjFI5jxXJ+27U6g6+iS10wSdXA1qKukVCEwo9776TBJt8qHqcxEQFH48tMHGw7V8xz5LIaRAX3xeKymQdpyO2S5+L7HSwS4FPEIvbFV92klNpl29lPakJA2vSt4cCsW2ZcqeGQM1sCDnHfp9Zk8F/1iH5NeZLgN3r77H7XYhoTMiXPoG9B9DHHW+S3TB+99+cMGs8rK+u9R6usUp4VtRZy69HArt1ZjFZeuyXJuT5V0g4CTehpZ4WQtlTUJPW1eiE2ycewIrk2W5dISLFE7rVP+eWvx03VKmG64jNDvvRDGL/lAcK0P0W3Gv5pSsTiC3zw8whvPdt04MQ+7/94KnfVIvMGbE9Em5psYABpRhz5BNu4BDs4ALzauKj2nfRile1I9QBa262/dSbjxOJA+oZcynUdz+MeProuRxig/Jqi3B4k2wPKSQIkMaS7IFGf7tMi1nGvt6jLB6fCoDmzMnxv334BbWcCCPk7eTJrO8TxhtCE9o6c28uvjVNrV6QQLVO3tqimsDfG3iXcHIA49budbFBdQuNRnf+h3NYHQANblluLmI92iMWgbl1sBip2NpllAIgQcYegDEi1CFAQN7WcDcMivwmPKv/wqmii/URmf248M9cgXlvBo5Q7FE6fW8TizWfY1gYs3jhRsEwyZYJSeltSYW/5yfbRzVlmqcenRYuhLxEVpEwEx/G9GP7PzgifaET3OnlybJ6whUkOhEds+Y/FKeiHVNs4IKvn4Fc6Rtt0uhxBb3jaZKmLERwZT91avShAXs+YYETh08+0++51bgGy2plKPw3wstf3kylZaZXcM4cWti3i+Kc3CJowZErF92J0PYu+eYNAXUeBFKRXGGPsNoeZuUDk4Jli6xRjvgXSeUqwa10q140dnz6dKA1B2PYE1t8lqCT5rEvP6W2lm+2ubfK/Ya5C2IyMmEYFmwJ1aU9qfRxHU2R+iupm2ZamsliCVEg2FUb6fqp5ZMom78aBKsRG1Ze5QfS5aAFhTfMZC0rQ++9UCYBJEjzNwhWvyyGJZpb0zV6OCd6kuTg2ZdZSH4L+G3Gh+3gMclHPppREVcc4ceEYp1NgX3qeGJCs3uYRpBdysumNm5/rnumKq5QYZTj+VoeUVCOHe/i4rDPunuprCNZxL4DYQgThjAepzjMr76T9hp95OJHpESp2uXzFHJT8fqBqaywIZz3VoQYJ33KfCtEw9axTPFWQ/b48CguViHSrP9KdYjqDv2bxg2uujoFd/Nwii4Av2p1UYSczgAyWT//h8yU5GNrvHRXiPCQ=
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