4QmwAYWsLmQ+DqfDDvLmoBuvz1Ch66K9K63nrR8F1KQN6vLS+SGG5qoP4MnohwOpjVfsGP2gpI/cKj9uYIoJj+4HbCLpVd/xupVyLXtcgZoIk02vKBf4qkHOsNzN7+jhKnoXRUm4AvRfAVcH3FlJbwLw4c41XkVC9HhchmE3sEMuczGT3crYQgP5bdU4A30J2qZtIZe0vtWXRwhJ66A9UJ2hbxqIJuJXlDC/kddLo51riUaiIy4ttUM6TzPlfHEG3GA4PsgZ7NG/di78+iJyiBYzI5xsw9lDEEDoNvM0S3PNqmPcRw5onDzfCSTQ6pOqKyP63xtW9h3b3prJSBWrtvhegn71CcOsX1GPvCxA7tLEyct5tCB+0IqJo9L2EnTyrLGzdkXkfcnDZtGGjlUZ54dAv55VGWaAMryt3/Yr2A8Q55mjFSAQfwqK/2kZK5Ob0GXcEW+cNnSp6fWjee9IzPipZNx9FT41W+7mHRulc8kh790iiuEX7OIuRcFax9NuyygkLysfAWXWrVgbDesJStBHElptGftNBNnpi8XHWoT6jyp7ynoxMomCv/KKVZ3NfUIGYYqrb+VvZTNbdmuZIprD3/gPDI5wUitTUDL2+AluWdTLdgVPfJ6lXA5bSGXTC/RK4kx5V3OzByV0YdvmCae0t59c2jqqUz+j5+bWprtA83r576Uc4igTVH2/c+QkGt+an1AFH1NtH3KXB63r4HyrnBohk7lijxZCxeqjuIm3flKYJbeqrL4iu+z6zk8YVl354tzpMlK7+FoSQiC3wS8Eos9cPhTdqRFXZzSLCXioyJYwAH2F4PxpdZnfiSi4MPp/aF/3vX7hME5oE3Z5XfZmxEOmLnXwdfNNoUCb6tQwLSsgwFcKHCKZ+RvFzsKQDULanwdG6ZB5HpBIeAX2xO2Zt/kuXpWl+YS2niofuhKMIzjt0qXkxb62XkQ3J2q/8AtSVQKI8mngCD7NHL9+BjgCwanvifH5VJWN8K8sD3H6r6QYWXhBydnAjTDy8sCziv2skMM5/w2926wwJ3g3ruKzy1RxBSacaQonUubmkRCVSIvqzlDQhJ9+VHTJRN5cU0EeeixkVrpTiixo6ZYUKZEcbdJFJBDHtALWPA8pe2dFuH+jZMIAAf2hhQ4Dt7NPqUmTLOgjMnmSyUN8mtRyKmCAvSz0z86pzGq7PafkZfb2WOTjj1CVLZKjyuCLWtC5UaQqrUNtLyMifMPWYJECyUFbCcXaK94sewKigOvjniYmFmJavg+w82PrNYaQTSvU1UFJCX0piPeBXw7FWk4HDwQ7ncC3XugNWZDBkYP1Zr0z663kyw77RCoX4YmaPOa2WidmuB2FIxlxg1UqBr1Y04bmrHI+az0TCs7jjds=
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