+RHOPpeIEn9Ha9x2Pg5eWHzL4AlAl+nW+rWO/qgMIoTiMUHnr7JgWjT4zEsCdOwsVkZ0ZT4afBKJ8SCIvGheXbyBMzKns0IfdtYAe0mzXADsf6VCt1uHBiAANVRvV+MgzDfS/qFQ1AxYXi/jMDxbLsD40wBR6Ho+QrZRkWQAvVA1jkmr8T5Q4vUGKda69SfQaf0UeD3g3rIx6FLXkmD10lPm4Z6KsxgpJgubbu2sDlJ1g/gmyZUHZ0iFOrkXCwroBjgu2iyUbQ6VOEiRrKQxDrhF0sO/ddES2GTF8qZDTAlOKhCDpZhVk1imf7GKNVvtVwBg4ihSTR4z8VwwdjL5y8rx/eNxQ3b6fMidQwaKtFhBCDYFwshNGCIWxXls1lc/o3HkVehUcwDw994jVWZvVrTaOV/KJ6FKhK/rBebe9P1CyeLQXdnSH0WNvzXtkWsJCmFDD9jqtAZYw2qUp+GTUAm02MMoCOqZ9UfZSCTzXlJ19p9J3TDu/DJ1q3NqtWVONvcmm+LMQJpG90EbTry1guLC3xhy9/bA0KmMFctSgynKZjTTQcb01n2nQLxJdoYua7ODuO6NnCq5D46r5saIZI80rOfaqA2nA4UvlDfHuGYjJgi23UU63wiC1GtID4WULGwq500VrQOGbSD1rA/K+JieRDXd+eEaYWo9ANZgp2tJfe2cVOKIeh8/t1OxVDtS43kqgkIKfYNs9PByMk2vvcF9+Yxl4pSScXzKDpxOCmEFcslRoahuovVc/6+tXja/joG9A41aftAof5qizrItQ7N5bCTj1d9vK+0sysGpAYTsfqZgKDTVoURad7926ueELCfnNFAU94md06K9AQETcWa8P+DH0j4nROJgwIZlztMZe0ewTO4UxrbwzpP3mjAQEHGw8NXtgSXvaeEx4E+Aw2GWH9CiFe5OEcXWz0nNTYk/5z/GG30ll8xhQZXPoSSmak1hy5v9PRwBup5TPlJjac4mtT+5OUwaW2DH9jM8NY8BgtEW17Tx4+ZlCTc+VQQeBCRvScdFIXRWMyzoymVUSLfwqCRJGnl569nGk+tGjMR++F7KBZk4S/Yr/CgejnTfWMaxq6tAstZd+hdu7Q6xCZpZtSQXYxtApqy/RAFxFdI6zcTsARNpyrN1LeINze8ODaRwQuT3SgMLi5d5nD1xmMnYBpQvO1kE2jWIynWw8bwo2aGVQSfU3vw/taMxxhHvGhXqNJ9oolaTueM20VU9KRyer4IN/31EnfcsXFGD6lLgz2GuW9hgtU5/a/ZkNZrEfYFMq1E82ZIpHSpe8oHpUQPPJs8xdd6VmNyO8tGygsz9P8efA3BAiuyCnWStXXYZ4lJVYvB6oHvbF063/DdROquWFDipfP86Z/nHbus=
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