qaajrXvSflD15j7k/kWppeiAyGcLMFx6UHXYHKSyFewu26flHT263YBBKWXG7DadLRLSDnj4AV7X2K5OjJLSksnSs2isaeGPCG4ITikIquZICFCkuwKKhVCcjn4xGi475v3dFvc4onsem2q/fVnFrybO+3gb8o5oDu926H8earRnOl0eronLCpWfJIgyFtfNo8/d29tXnZ/3aNB6PN4BnPBoWml+Rg2LVlkB5pd+XVo/Cg4QJr7b6cVSg1P84ho9HQ/Otp1F3urtMILkZ53jAneJra+jjp5oL0Dtx8xVzrlWG0UrTgLtcXo4cKOYr00USgpXHOQozbPFbpt/0QRz5YUiXCLRY3UZNPtYV/SMKTAbplyk+YyNnkZB1h2L+athCcNvbMP8NRIOOjjrfJG5rTH7OBJeCA5FLX5059sfauGebNgit3k302WFHh4L/6P07lDqz5wf047pjnYLQ55KmNwEwMrHZm5LePn464mc5fCbkU8aG/lyNWHSs9bHkkC8Tat/te06H+W5SGGoXYCXWTFOH1VOfwqQtci0IM/I7ZVs0jR0YcRgd1OrRoa8YyuSuH6Zl7K/MkUxKBr4qtHBN0E5T/p/BQkY9IeVQzyjSsz7IiknMSHjOsjqIUL0gNQC+B4zw24RGWXvhICAPGud0Wp044Jp4lSA9bGEjtZuoJpRqqt1kz785MuEBbvq5rykc8pc3EAU0QUJ1EgafbY3MlyqWJcC3sbtuwNMDRNiAPRVFyEe+9LwxlvBKbZiaHw+z39fK/i1h5o7z+S38RPA0U3clqKDj3J2rr6sWmJoeyjcgasa8lfGPdOEh6vAQqJCCLrzRsSGIvN+XxforfZCUcQ9a/ldQTZWBglUVBMITCS1Kc1uUzUZ7pPkEWWrnLRQbKI9EvkjnMLoKmy3BeKxTdphgJGlXqkMYC5oju9IcGHZB3S8+/kc0v22aLydWyAta6ip+wpy8pvJZZrpqVKMuTh/kc5W8q1kWE/O5buDtLfHUiS5dWd236umVsruro2EWK+Vc9VCc99IlXR+tKUViuKiWvd8y2gKLZe/OoEsUAfpfg0ygRZnVXKBmNwVIGiRdYJwBQ9vQeG0k5D61hYrjIwnguC9XG2awF7jqFCF1JAbTxFgDK0JXigAS9/zpDFjflvdZYMyPixQWAFdKJruqO44xtoGPGsZTQOsm6SYHSEnjbxTPM0rl1yEyOuCOB/JWacmCvCDpZOqOOftAGJs4YLXKhMrySXFcfAE0CdzESBNAL9cD3pumZKPfSYMsws1F60y0smkmeUCHpfy8UYrzL5+PdCH5TvXj/1iBCpZwJOfwR9hn1bENiywDA44K9MLrkvyNhO+6OGyQhl8wvDAMJIOsS+hnfCvC+BJIEg=
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