b4V2HfeyauFTz8E1yFgXrOKI90MWZVcfJuLgQAxbK7/4diT3vtDpRpU1NK4YyHn82KkIcjmnlcCY2pbJu0IrTDqCaw07ziYo4Xl8jGxzM7FK4b5oDknxyrMo4lGei06tFbr71bOUbppgpMSVYcQX8vnUuhCbI8j7DTZ/ap9SqvhbU8OOnO5Wo8inXPepLbDAwKpUPBxiIKhsXDO4abQiLp/7d32eFSU6J0g2JvsaS2LshvHuy4PkLg1Mh1U8Zw+aWdcsWybw4fndmDuPFCiLWVHZwyk2538bfQL7aXr5Yd6rv7l7PXmRadE6dnEqHqlv1dp6jOxAcPiZGYdQX5u3DBuSxqyM73G9S2BtjmeV+5iwkMlkM6ytCzS/GK1lonQsybGRulI+yG30MVRRkhKd1uy1isMdm1M9MESX3MiV7kmTX9qU2F/qXBmZ0hi6QG4ArSOOQiVWZ2T/QowbDTkApur5IyaaRJD9iyJA6Rb4JHebNjiWB7xk7oR9nifXPTDwrvE5BMQP2IQQsUaxpDi6wR/OJ8gIqYwygaPIq+i7oPJNaZ8JY5vgUHXxAdraZGZrpGY2b0sKz7Yk0qokcaGgVtsJ7r17VMmIxkjJr3fxW13SSSaONgdP///cpJ7qMVxlHdQ4bbnrBW8rYDLpIHLkp4Pg6OLzm06SQkHxrz8UkexZAjFIHXn8uWEr1Eo66LWZyUMmUhfwGEZOn6noL1uH0HV+Fgk+U9tvYUjGwTMPWEdJbCQTEMiI/cTbdCKZFqJ0l4e8QgwCLkUE+v6Bs8/bUHxKc3F+zdPLIKAB6TykQKEAA0f2lzRkANRxlJfo/TfZEgecMkFT71RiVuojHb34KP6iOJwD0EzeEnbcAj4JcZpWcali8Pca7OorRHSWMjFoJ/G2iJPCdHBnhrzXTLoLubV8MSvNHNzI8toAcBLfKi6T2AtCXiOPZZP12xDhdJ4crlRSKBTG7ZvXnRHjzEXLbM7kagPnslNRu0aojqOuZdMNKRvFM74qlMraPR83itlWSBhNgoPwoPXrjXPaxEZZxDmxwPULn1UVpLaVDNlgo8ZxuwPVTyuko6aepy8b8u6e0s6oWvfj30lENyaVHhprk1MqG2tbD+MQC3b8MLG1o52QKdmYLyUK+t6BxAgULGmDu+RINDdLZP6MqrdxBe9tLtg7iQQlCgaW1EQ6RZ/vz+0d94nAtk/78M1NEq53Ir7OVmve3MkF8aK6MWyxZsNmMEkppo0CSmzqHd/McR5RVBk2YT1y4CJsLan8ipxDsVD/u4mrqUkYKLeity3S4RCEjT+Wvck95ptPhw11ZDXTX48dQhJBXn738o8B4R3y1/kYhweH8z4UZ9BE5OYA3QsLPUevTK8cPy+JJExyVaY=
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