ZoXOX/qFkZ38F+bBQmamB9xu2/hvXkLZwNBsyP4u0LkZ5Yz25VtYFTSM/noiU/B2hkDb5xIO79+6oyRw4179t4+qRIGX/l1QUGPTV7L99pkyhYEQuSS87Hm2eVB68HXPvjEar3DjKadM3WdtAdVXZ2y2H+MX8+cHmLhPOaV5+6nRvpZgnvUpwILgmLwd62fHmY384sXRF6vXHq/BTQpfnHatTKv3183Vcg3dirn/Zvo/OmM8hZny1NN1W/WChJOYCrbybCgZiPClLxpsT9/z10Hrsi/Nd4zU1d5EIWf3JRyL0mtYHw5MfXsYqO3x+MPNOm+kr5XMdnsYKndhALfr7WQ2opRUSpgRM9lVoscbgZKQWEqBDA449hQhy+zBTcmANJNscCjdA4iAEYXF40Znb1oOkxeTwZ09o0lOs7Tj8e36gRYzo4I7NLAI7WTEaAXPSRKkmKjk8eTvDXxChR//vnNomNaHXu8+0UdfsXWYMPyFgpS1I28S+3Rc8vz4Pia4oV2T3ke+93YoIKZL+Vou0VSMlEqqO5n/J/pUdcjx/JDD8xAG36uuf1D07uZEsPuMvtjZqrtpdu08t/KGo9DbyC78FtIV6jwnrg+Mggyr+LizGch4yVSX+dLkhUVPQ8+bnmOdPNPhhegjb0rhgyz4GZ3zTiYyjxk6DiESgGZdArD9pUHaVdq32AdAGh2ns5GKL6iOYbccX0gG9SI+X8kA1b+DlAN/k8UFzLuHOjKzIog6fku3JTl/Yk6U4GNT5s3dY6j1WPMff2vT2BXrvitZtE6eLGRNLMHSpS0ueSYN4b7U/wIu9PUl23MoZmSeXApNZyhlwcocKNqi3R9h5oND78mA71dwfvCuxB91TbiS7IyMpPNOTs6cav/DdZcq9zHU3yAp1pCDXSExxyHIzNmVwKbYRBKtSU8Xj+jsNF7wBCjcgneFe4RC4wT1fIe9brF0XTE1NRu3zbOT84YogrMfrQYcwr7w0/jkEkS3Rjsq84Re5NhV5g7lsDdVzKa4/knNIdMGX6VQbBEMBxpzKwDUiX9sFvhgEtlmCxjVocpEAnuAA5sqMJ4IORMt0kOwD/dzEBi+hQPN/w49XoVAbLKXJzC9/lgsqA7nRfe8zc0dCsUum0t/W6uGdEMx1kKn7eWUSjtUw39ul0/UtG0kexIXv9Jwy2kQpDu1P0HNhK7jz7wZT2lKdx9QQR/qiJ4e0tM9N/FexD2Xsl4fjJsfIdg/Td+Ks/YhYZPq8J03x/sCbZ9wq6GhFEMLUDU9JgavASpMkpz030Rg5ZubkAdqsaoOsk8NnqGRypqFdv9F7SjD9vTLdcxGYxCL8UNucogaq1E1uXKxjjodp+VWs+riuwbChBcvdQxPkZF6jXZbn1Q=
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