dT9Ab5cDolL4oX7hTZXJzMwTIzuNBC5er4ZT/4v3wImcghObflsegQHVc//q+iqBHGrYUgXEA/noW6bKQDKt9tvDOXlv/hG2SB7AUd6/L8D3mU0v4rn+m3TOjxNLWCV7dLKxxxcvibf8yeJASOnDfFUNvwrnewY9EJcKiVsbobxb7Kp3VpQ/DIn8sbklLNFEuQhu/jgIVpPX6+k+6HIY6tWE/n0dfp1lg73S4CXDg7O4vNhLYEfXUnhejsNL01DHDnYCwEOcKH4rc86X086X8On57f6q7vDCzVxmFfvIKzVA1gRojK4HR/7rw9iDl5N7YCbfEUPu1KR5kmaiZl42eZXLLBIhR/H7M9+kgmVHuM6pF8YAbJlLM8/L4818j0xqHIkCGCFUHhiRjb/IY6cYwPOhsU5MgLuJMi+p3MlWwcFVFLe4zR+Xco43/A64++3N6Pcl/wLvAhFVztbXeGJzc9sMwuNBRNVegqK2PDQZhDajLql5S0oJbvm5n5GjUas5ZxG2Eunx4InJVjsoqf3n/YfhnJBzMNauuI+r0DIqFrLPNW7Iev39higZRe3Wi3NIb/WBoQIQCXd0YUMIWh3iSzQ8alHhJjatUhWuFck28GxS0W7P0WUnRdlcol37IesgQcikHeKUDJmYnWy45Q213UMvDoQBIgcJh+wFSMRLq251p4UgXE2ZFt+GttH62UQ2BzGHLgExBMUawns3OJsug9wrV0t0MivzQUyywiic1FCDa+DX4mHOqWb2DiEPmV4oxHGkEHnWBfEwISSMNkdg776QNmiN5hNais5bnlZWGQUW3MwbY6ptqZmGBuUyQ6UyZcvu+/ga6Tjj6XiiNAOAYZOygBTqomY0aycImEgKwdM1EcQc+/GBb6Vgt8EgGHZrhz7qGlK0xTvO45EkuBiNcOlVOGLxJ9vFvRmG7tHvQ3iep+NtdpzvUSGEjf/eHqFMkEAL1AKQipU76D6i2/d2S2pu+lSwRnrKZgsd7lniczo2w60GPP+nvftZNRKg0goprcU2LG4UFbDLkE2gXoxCUK9XGoIPVC5f43Oxw8Pzr/pSxLW2mPc4eyw/Fdhk7lkurMpP11BRt73ZIlue0gTdkkvmE+eUgI4XLhb8GdGKs3fepL/AtMpqOy5Boc9ZO3Ll9AwBiwvCrwYmyAhwb7/JNJmxzUcxp5TmsAid0/9lKLcVc61rrqlYQ4mlNSO+SIfgINSnA274TFrl4H5ldCEa7LsnINsXdZpYjWUW87cna8Fh3ENgVJWPT/qZ/0gVKoftAwHx+0EXZh1Af1oNvC3/JWBlpKR47LTfev81OE/Ko9tpiq9NlCcXcqYQGbR+YGoXpiHa7GvbBYE/bH/NqxVJXSdgmv2/pOLJLilFNE8=
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