EuZsv83eD5wEDGFy9aZIj9kZeJ+DpwdorgkyjdN/ebV6bS9/s8VEg3K8pgsIKtA9epNDCxMGsqfJ2ObBFkFNIU4YRroELrgL6gA5sz+PExKU2IVhhpcJwBXiRI5sDzW8L2BLIH6pkAaBytgETbRpyMfyXvxTZ8NBTeESjM4t5cbaCtPg4ObZpyJO3YVz/4hNlQ68hEIRQg3o8eMkWE0mukrS1BJMeRmFWe+vLVpqNZOCie1g3HR9TUGv2LFtjpuxqVapztt8zlhZeQSmKDIjckFWD0KHqm4jjP4ch74bKBMVqn0kkd+q2Alq3pgttjJBQjsF4luNr+Q0ltbEK5paZwloVltxDr+E6uM+Pk3iRPgRQ0p2Puk5yjWvDFI0ssOjopZmvmYT+sMY8qpI+iYKvMqoHSe3ThAWMRlY2QySd8x4gFfOCXcxMxlsmrEf8L+YVPtOa+OxO2CrAmyY2z9OJ0qU7HOLr8ytPb4AH3Ikcnu1Nn0ixH75MukJINQby8TdwD2sPQKjCIGs4uEnDjhBVhZM+q6SJHLtvAxwyCxGaQlnWouKi7xtPLpnWHbCjWZdF0pPhrx42VpHTiur02TJgVVWwJnrT82xxuRvQ+zjaqgwWbECF8Jbkyd9zZLkmiCv9uI+uL0r01gTLYIuSM79OjZvVTfdhQ2OaxRaLkunFCanhkABHAyanNAqaYuRmclNMFovIDQJf2Sgrr19q19bdtFBuyNXyGaTvyzm6gsPVoKatNU80TwqfwmxKg1z7X71mHWBqQZ2j1Mw05Nr5LwJq9H09n7s9+HCT33fy3UvkYTV+Fr2Uc1ZxAyI5vTzsHukygy1KMEdvo1yBIzzC0S3tvnJbSHkLnc+i4cpWB8e+6QyWONwvWoIdbe6VOelSFz2idFb11E/+Nisyh4tE1r8OFHf4eJYjGMORXunNY8Qmxk2n/RRmof4OmLjMgRblX5eln6/Y2XQdgkyxLADScRM7KcSLwuEGR3mI9774cOvXPi7bI0segRltKAfDLZKngxWXzw+cXz2eFxz7R5X6IL1eFMy1s8ZJ7ksUg5j62KbpE3cdQ+RujvcPR4oXtwxIxV0qLIlqPMkq/+R9B8VQXr/fG/eE7tLqdjx8IKXHU48njFwEYmTXBTrZ7RRUM6pxQBdEMH9k9kXKeO4zEAdii4UwiA8YXeCVFvo38PCyHucRtpW0WzfytAO9WwQCaaWAt1I5esnhcHDlhU/thiLous487BvzPPiZtQnBjY6rrodCdx6cfsiKh2cWjUhSvT+brhf5IrpNQfxWg9dtPIvpyuOEd9k8ECh1UpJTvFByHWzpI6xs3gQqmUSfdX753EaISVXrPaQy1A+OdhFJzOuU62fOHZZZD6AooXmZ71vMaY=
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