Abml+gMIGmgK669dZxkYv23r3GXOFBbOO64I44oAq4hhn35Sar6xzYo7JusYFVhXxpZgnLITiUbaomMUtlQvs2I9yUrObdSKKcEyDKplGe53kduyG0the/XWUy0+NuAXkjvzVExh6l6q/hURnobioFYpYVxvr8F28C1hY834h/T4j3WYZy9UbYJ/B0YQHLHz+l4189RtrxYyJRCX41pHc8Q6qqV8T/EqbdhiYbujjUn3XAQBAf4ScNDoASQnfngff3kN6imgP0W4Bbho7d+kwOD9T/tmw9r/33mO/ti4Efawa142+OW//RCEkDM3PclLJthmbrQ59IGcAaofg5MTTjf8N0eCUG49/IqKtUDgKYYUvX7YezRQeuiEMDzKLqKy7lFqv4acM66jzfiHncioJHrJM/5fZWMVLqcapMK8potCgYTw6jSpP0zvnv+IIDPrUB+q1ZzAI/Ccy2pcLm00Jkh7+if07DpXBDQ6BD2mIk2UNeAcm2DkSlkmUNc1T3OLUls1g1pbo2pSG4VxyG4ZCCmIrft5b/adJ3s9xMPkjlsZHIzZHSQiipokozH8N1F5I/hDQD2SdoeYdJcKblRwKBUPYjY1wpxEGV/j70W5gz6Ii/C1Piv3SToNfDsaLkP2cToGymPrZgPtq/Pp+zDZlmOxAOa6h+9p26QkdhJWaX9qzLbon9RXuqP+fP0WhsKQSjBcALE7gSxeUgfgiJKDOFZ7KlXQ77CHHfEABsWnyQhMb/ufxdbozn6XXgCG2l6E1mrbzAP0WvZY2vjHwACUFcHSvd9ipE8yTyfTd5kt58x90LZMQ3CWfDNfnT1fR0b5JLwiUdBwcuavXP8hDUUjI/G5YAxh618Go+IumABCrJxYoROUEYXBaiMKyoA+wXYdYGS/sQMCkV95kl8J8Ue7USJNwFG4HAmOg/Q4xt75n2PKETkFoG6UeQ13TnKbXmhtMF8oTZ+/NU0PiJkzk9C3G9RGCO/VLeF6KRuHujP9F1SMSFxAQSKN00WG4PgDUdEEDHq16ViK/cM/yoUwvjUEPd6nyfjMQJ7vXa0QLtIUfj5QMo5YfHU8lQUvqdkwpQmM6truaGyh/fZqZaJbWWrI2Qb/Eax0MO5QPCY4zi0r7i6e5bSgjGynVqZoMKl8TKJDSgtxNKxrlm7BVmHySz4wa2/aTqToVg0LRG5pu/GUReSvCO5y0O/Bg4ML6yzQbfg9kLi0q0h8kKebucxZ7e2QmKwa4sSGxGtaLzKNmD1QEOMAsNI8qNFKAv9JaKRYiDcDhE1oTd3OjV7V59ph/qFsHatO3ilOhv+m6mLeEB47oonLlqMIZwbIN5s9kMQms6qUBIyZDJsly1ksloJ7th/hXuQWkkDfS1iLIHV3lSw=
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