50Apf1N3v1WMbIq4MPtLkbG/tZxYalwRxM8lC+BWQKBKY+RJVrRxa8jyvBgnGA5v19U7ZPRbmqsHq9dcwcFICKuF5XQN4W579tkxwcZ/C8bcbncwq6eJtwA9HOQhassKNfa/iMYAXjTwymIAAcXdtPdPE3v/5V3Lch5wP+2SCcBlm5EWAD25XdjHAwvUnoH+/PtQqP/OlWzX2ZDXDoqYb40hE1OMy7k9GZUstKH8uHMcvfZSgzp6CxehhrVC/muV+oZy46IAnxnEf4YnlYPp6zbBcFmQv09FZeOE8iiZ8DvptmIgKGlDSJWlc6WVAbjUfa4CxpW0gVQQvoBlMvGlgAd6ANRO/IFVfkKM9YtrFcIRmwQKaNMosVVTcBg+5dHcrFO4lor+msTrD+jChIWrS4xLuCO2I9/5UCuo0Jmnjt+ASby7CXy/dhuP+UBpmnj6wpaK/RkiaUIZpIj8uzy0mdgcZs1M0SQFcPLrNsIPW08HB+B077WrWDrFinjII0pZ3G2Ds+JLtGpGted2KaOpQUOz/sM/jpxG6ltkvmSKUEVb/E5M2xQHOe43kcCRtvjCtsbJGKxf0fGCMbIeC8RXuhxhj/FDSyLQrYYGOFGHIt+NYJ0zYKwX8moUg+lf6WDlMAXlK/bNktBwQwAGWMp1UU+5zz04p3R5EsfriHSnQt9w4ZMwlGauBYTX/liBcpKKG3v8MQVOUWpsmd0loqKUvBHD5FxJwBBdUtI9SZ4GtRQ7vGLB13SRGpmz95iThHpw51TFprRKdC35MbUqRIQyslSeaZHbA5Vz4aHFdLpNxsaZUmgb2IFPtSL5yn2xpsu70Q+W5/CF/139E3HCKoqEviepI49nLoAa2UQKHuSiQTyvPnX/DMMxg95p44MTazWbFsrRBhty0/V3jUGjBJz3ASyPeeI95OVF9puM/lQKh41RmET71p+AXkHc2Gd+46i++hv8uatijsQwOnA4uFscUPS6lup34PG9wKU2t6yyZDzxjEAFbgqtbkT/3oludgo9gEdZfn8CRl4ohDQw8eVY09NCxPDGS/lephMY4RY8X6txBfzrjTH7Ursj3aSuyc3cxoM3A6MF62R/qirAqpA4kpaqcNSML0k10P+WJZFZ8igCc5MRvwkdO5nY+4EedW/cipQNcY7nXFySo1xmbGjuvDQb7QEgUlaB1ije5aEQ7aWbcbSwsUJszvUSVq6aWPS1iTiBzTXP0MftPrCDjuriqleeYk2qS+Vmejw0l63NmKnYrO6tijeEktFoXlGagmfXTu3/g3zXJkUSgLdEFKqvqs+jUuRtOoLOXZiX7AzuOf6WW3KcDR66PKJ/J9LxNXjXMxTc6Zz/EyKZ21AEHtXVyC0FIFgUAo2/L61/01k=
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