Ac+OtcWmS87yVIuUVfP6p5ChtxfiUbzWHJZZqJVmyAQyCCUPql/QA/+WinW+Q+qEwJRrUblhATHh+NNr4laiIH15bOVHHjdzZwKf2s934neBFbp2W+ghsor0LeFg9XCxaa+6OTNwH9ErXiuswCSEGgf/GRpxor7Nsoej7nLU0mGuZ61Tuihxfv6lmGkcoxi2fbLeLx/RKz7vj3qTRjI3C9VUt63PDnLRSgCJqq8Y8ldI9VKu366ZArkzfaTvkvi91CoPU7pUy/Z9HQCSfQ0XcVgx+pGz28Sf1hVTLTMH2A3xfs4VjR52nNyjLkLYTEWH0e8mA25w/LdPnXVO5WFGjG+n9ao9rTR531tTGEeJO64XcRK25nJ8/1W73QllxbzKUggeGKcNS8tWk481N5xHLxvD0A4xVApJtpg1foKEwQQxXC3CWihu6BWwXz5o5bEdNnvckLvLdkYk75aoL67bZdzFlvPgdVnSdxXqGZIiT1VNBYfLL1ogUfT57ufiK0GUl1/tJLhiBQrZk1oF2hFYuQ4PMFO6njTjNp2hbkicaSd0pj/dWrZWH3HGntD3PtAOJkpSEp/fvJCQMBxdBYwgJBs7HA02qoVdbwSrQF1YtG4ys36v7f97HePYvpafkBMyqsz4G+xslgzZLQPtjeZkn53IWM+VKruGg39iyQSF9wyytC/WYrMcNv3EbmAR1A+dRraTzaEI1Fnq+PX7BMkKcEOwjjQFb93j15lf2Z9SY4YGA4gIzQmXnn2xYmk+2G1qOYemR5pPMheSrllKZVfX381ySwofOl7PyTSzzRcH1/l/R5T9Qp2nMAH5oTicGsvXYIXxn/I5/xG9FOL/dOcbCxkyJeMx5YI3srpPyl/2Mx/VihO6zV0hNfWoGvdb032Zf78O/cgv9sSmLymflg8nh+FN7yYqtLvdew2dDMd8jcxNV28s8Kd7QJdmFeDn0PjVGStfH+it0l99z8D/2X1bSoOp+i53op7ABdf52QlN8+kaa+7OZHBJbfucQXvDRQVYBV1YsKIheXRNBB8lSow3utuMBhKD8S5gcsoEbA6PCUX241PHtrAcIQWdz3WoXzFgeMiTY3v/8Y/+MdUOAm9JnTFS5LfbNltQJs4hQVtCOptS6LmObcJn48VuevMs3cnbrAx3wv0+ARKfsJlellVLt40TL8hWQxUVTLN+WgpCF5lidsU368UxYiO2nSfZNedFNrJiqv122DpUufDtuDcyNIaEm+Tx4ISJdyVl7Ylo5n+qrQfI4T37sOUbA1wnhGd6jBti87INnQeR3XxP8ez5A7CoI/5rerb5HucAzd9kKVMJpPEd8F3dZOU+nVxnQyuPpdLl1tqDqHVC17an9RYYsuwKSVShO2X7RXsOR8Y=
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