Q89EP7Tm/IQ0wLf6SjHgSYQ1FMA1bEmIv56BlKkpb0pSSRrDoyq3APnKhUxYEmH5YxUSLfHopXHC3BhXyvzQUN1wcnOrc0UHOysJeNiNfIAvs3XLVTwg+eFykibbUM+NlvDbEpiHU8oXx5047n4aFweWiWAvD5Adzi5GOgCau7xdHeTWiQcugAEsfGABOS+5LWl2lsi1oVy4OqyVc7jYVNbNtdNAG33HqH5TTrwC+wl2T77HNN1YZmveHO5kaMGFmk/kBy2ZJEjlQGiCbTO0uCUqQ3KliKSIu2dszbk5t01o+zSNnJ45Nme8zSGW6QftsVO/lB9MFsL8bxOFgNNkveQHb34XH7d6lnPwGtC1xtCsmsa6sYR9MfwwApJQCuRxVs/El22LBRTxtnErJWF6E9WQSNEkdJtn/5H8kN2H1T2d3WYwc8CS3L+Wov5/kKr5Un7uLljdiUsaDkINhNB9J3rPf5hTCSoYp7uwJ9vgu//xGLnu4f3/nH2uZ1IVf+nJpZvrJbp7CNS2oncbjMYbrVyWIpS3p61E6VzGtEj8kN+CQxzR+9o2XwXWMB4gi1964Z1PmP51Mg1YBytlzYH7mzPwinBGCaC2Iz+KVJbKZfWb8cTzGtlPAXCjt/+/j4wQYfh8wSZIA8iNFAozpWtgiFSdRmvoluIqjbWk24LkVhpjv8MBsZtHzbP1ftHdbdbM8GxNd2ZmQPGbK97ec2wvBQ3DST4mwOoYlO84rubS+dKVZHr29tS8iNh+a7Pkucdy6a6u5FOXf7QhtrgTpeDpP1razG/KzvgesBXmCHXeap15tk6LTQIecD1bsxxzC85mT5/yclezcl5PzghPUeKeqXCq11hIQX0x5ZkznmV8w7XydbG243rxIQHtg8AXz3IWHAGKwbtBjl7D6Bme1tANA2HrPnkMexe7JNiLJiYo/3xj2vbXdn0w6+X9P+C6n1KLp3lxGTI43bM7K8ab1DPI6jB15Ny7OuLil1dnma97WKvHXGdeQujb3mwOJr+GMa+F3LHNUjXe7wIShiX/3DmiIVtll2hwGJZkqcC7LBqy5v6naNr1l63i45CEP0yNTXNteTRBMjj1p9KwodxuipsglMU/UqQvR8tRx85/CxdU5LxA20sp45fAjGSzsyjpjmRcjcUf57kRakzPf5L9phbI/1XeX6WL0M4gtSDBs8Xbxrr4pkMM6rbSWZQagR71yEjNMD2Hii4+W2pHn1dHoLurZEzIafyc7teyLbZviE0zGkBFrp1z3sRGCiAzzihpk+briXGlZUxYsJjV6fEEQBrsVG+6DD2qw7JL8Q4XIlkm2beYu1LF+MYqW4Xo6h+cwXFl2mQKfS1qEP43izdTdXoWQxVOtKqstBliUHebAiQ=
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