ilPmsdRpuZyAtT5Uqvt2KSfBCE8f1mky6UdNxaFuo5odgJORv+v2kYZC9atZ81qzPBkgL8WfC2xqzzC/swYWY/AzoSyUVCXxVU+NYg7C3hc+lEpwkerL1fLSHG19rTukx13EvZsERhUjt0wlyJLB4tRweLOKX6QY1Fk1VlLrwFmllj5tE2oolU4iyPpIejIYhbXmcXIknNbhU3/OvkGRxx0wcPbCJKLOQiuschEpWcoSC16VaMQ5z5rXP66Y48THHJsUWfUluT8opdVx0WDdQLgmsGzINbKACwbxtPV429OQ0esTvyJEyyDH7iGyUXaKl6zf6wy1JlUV7Rjod6hiVsAWHFgbaLvM51i5o/xaKbJGV4xuO6pD/+5BJc3rhpKA/BzDVV4AvlCHO+15IRUpF/Gi4dChAUgl+6hoZkD3jfQ4EVsimK+hZeiBGCHsXbaTpzl/3LxrC/6PJ27Qzgfatw9qJRCMojN+r0kxQITQ4Ed8zP3ttsCwUxSfnaE7cqHOH+VPNbBiMWHLLF7YIJz+AjldUR1DGRpK+hMnLuzt88073khVIjQjtcVToTKaXIBDfYjYi/PGB2KbBwXaNST8zpmgWoAE96EJRL/GkPv7s01ZEqT3yJnsUdmW76WGN2g+9bDzW3O7Fl4dm3zUNvdVDmspX2nD2UBGsa/saq9P81Fg95Y8de1UvutRSE4DdhAbYhR75g7YZW8WWEJjVpajxEQnW5IYbzci8vkkyYRmwrbY0ATNkreQHLbn1CPX5oaGTEd5GmCwcvy/x+YUY/+UVuyEOgFQkNOJbFxkiGtBAdPxW1SZvW9wZvfCzJZpXsW51QpN6Tl/m93fGOybt7YA8H9N0wLTrXmENRr452aLc184KonXEqsZD4qcQiU3rduPwRkPWjixroq8aJp48mbpMnyky0xuw3iCsK7PkZUumJ+MMv+delP91LPr8ODCETrO3BfiOpnh0jAPx3jk30X/iqFJgFXhCdsp+lk3Ve+DHo1eqBuhTrLOouoQMl4DjaoErA7YZ/F6zhMRgR9wvfyS2lzdtEYqo9W11Q/vCM1Ihzy7jJwX+FYtNltoFs54bwzXHAbyZBH6IqvxmhCNBPpQvWMRJktBWlbwxAIOSCir7ETUbW2yl5ZEvmsH73O8DQTvRR95zVs85MliR4zGqvAMfjNwhyVzjcOA/s7AyFH8gTg9Z7jJXQyox8AiCknM7yCM5Tb4oZknxRT1q1+J6z1/yluRxYmKodggcbpJ9l3fXUP3ARHAyTL2OmGqagw4Nl2B8NMn+lxM5Ml1iRB0OjWnsZR5c+oH3rNk1U4kPTjrNTWrBb0efhXCkjeE1rlORK8xEttr3T913O3MNxpx4xKNTiKS48wLTKk8BspQ75U=
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