4xERyNMbh1VFp15Z1+x+doK/rB91/QZ1VpPfbCdfoFG/xkCd+YLlZ4y76ZyQWADVK17JUGx/HvmhyjNkOfpIdI9JZcbyWRRa3Ksml8Mmm/dToUG3fF71Huvrk18PqjA7vygc7F/MgmiFXq2Q+B//BisC6Rf+HTSuXOjKPDlGuqOj9Y0x2sm/DTkzxysw3LLcPjjBkItrmFgpcjQQiDp0J+r77bk1B4ebFhi3bxfB76QpAxzqDypJnJCQDfOYuJDsZXLxDfjOBzvsV4ZPxO+Oa0mxQe7TDQ10r3Jk0s1Pzy8Mbg3bifhgxgJXkH1TOG5xqbu8SyU4rpNvrhwmeCt738Fejdh2S5GMTnHRDTxxS8BuG9dFNlXMH9IHCCNEOPQT9OEMCM0IJciz3ANEBLQsIjrpcblmiR2nSjzsLiurIz5QvrFXtozDbonr7B1sgrEP65q0uSO2CQPC7IO+kbSPVZesYeLFIx+tUS/kxfa8XQnNuheTkcP03oPqHR6uMyyUB5cMMjUPVOPNlwgsCne8IRAxBBPcuGDUkB7x0zMPmcK2W+Qwj5wL8xVX4UDBi3dw5i17JF3krm0//KWvH8pDyp+jWMygwVYK94STh7VbylmvcN7Cq2GOB6OTiww8PoTeeisGH2Hg7AUyJJDI2nCkYfERU04qQQQlBqUxV287CCwQ0Bp4UsNXe283ACRTgPEUnjLV38zDrvfjnOyo5+myX3ICoDUrOEYrvqkuFZ1b8P/M+ynOM+IFq64fyEXPvF9DeLBII3EBS/dFR5Et5M8nKjiVpBvaPAuHld3XtG1Dql+9c1GqLr8eOBgJdg3O0nT1GW5KYz2+SavTHkn+p/brWhLi8TZ3drxg2bbJrddO4xb8NZz24g3/wVKKfOdGRDgN9WoAaCia1OE2yufheSIDWXsCA5q/RnK/GnKTu4y1+bzfOoUTlprJU/3llrQXys7FI2h77XoKHIulxLR84vErndhVIwehQNmprwpkl+H5owMNYb55ebuGDLUhxRsgOWYD21oe/k3IjJfNY/HiwCR/VivGdCOuzlnInFb/LEvkxZZL96d7y+PK/B058v0nh82fnobioDe7gDSnM3iLMaoo5bL0d9PalyuPpDBnUdqXNNAgbfdOhI/iyDue2O3Z9FPxB2/WoLtZM/pMxQ3pyVC77okAMu7+KLVzKP6Eayx0z77ahM7J9vptVl+09Fk2L9HIkzojxHx/RRIbIolujB84UrVJoaR/zPx7W3+h+amDUFzUNaUlsA5G96SRNV/xgEgLf08Ra8rwtsxxKyGnO4rg7eof/t34avfeoWTDXwkxlcq5ASH6LlJd0yYUiawC4HLZCwSXgC6dFMc7hV7kcAV5VW1+OjedfGDKcf4MKhY=
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