JXWxvJZDKWJBOviune5pmzEj0AqKu2WMx8fG86LnjxBmUSmV4iRytlkAo9b+X0L+0V0qvBxQCtk3zf9wcDIAUYzJ7Ne9HxRSnzutxvAAab+J142MaHGx2BHHu6J90eXlFRkt2iintR8z4Jy1AKeZOgtX3I+mn12AVdd+oRizTWREG98BA8MQkWGplPlIwxC0DQSUK6+4Ycr5jHQ2oUsFDRdCGLVbGK1Rg09hVAw7qiWid0feSEXhUD+MYSypaZt4ECV7E4rrodgrkirTBvAxQxHKggKItPBkbQS74Pgppkq3WC7Txo03E1a1n9XGikrnyYBL7qmJnqA0npkIUvf3XPUw3/0DYimLckDR7JXXNfINJ1yKGKdWo07H672ZaHgNZPDjqaOmpKne5ZS4VKwEkedjwYXKnSukkmOu1qsAQ0OgPUTRrzCS8eJinnF1i6eQOV2z3km1cGWuCmwEDqb0JwcuJPLpDD2qQmgQk/Jz3nPLFtU71Ayj9WIBS15cfU7Uij2681JObw4vzxJOzgbAr9wOGE/bjRrVKFm4SQsAyrb1Z1HPaAn9SsUpCEySa5VYdZyXzEhp2skwXH0LYjaO0hReS/YUCsYf1Wlm8FgYF2ldpZjyDJyPCfRc8pOpWDe0/LxYAy47sYZ5xPIOHdiHxTV1+Z4t/U+JTiKqVx4VHIZkfF5ruE2ktzEcApLYKgOChDy5axyDAYa6QH3K5gPOJD9glOECN/LybtGq8FY88MA/K2kEn+gDIa0aAkcH7hqDTEK6OupCmj1nAu1FAiou5YnuQirAL4y2Mo3v/CIhPQYoF+dyI4Wkxv/iF4AaBxfaCt8rkJjolGSN7HLqbU2Ye+45+IWDeNP7HZb9Th6/XXZcChmnY8JKd8gML5xc1rhPm0l4Em62H0Mvyo1aqL90083TxkWQCr39BeueHOW3+8py0hCDMcHMMG9rI0jEeiAY3L0MtDmvn9yD3wpSHACDIIlx5PH3ZINpZRZMYOaFVkTkJMOYmwS/Uu6WkiUjaN8D9bmf5g7nhb0udeW2akzrPQNknpSaGtdkwnIMTAvejXVmAzxYzE51m7ajNiapos6qHUXCOOCkIzJ2MDkF+htDHUDbczbghsW9Mz2jP+HGd2MRVDwmpUYi4cHlZgwAJ2mmLql6BMEhYykmSKaNV+sfIBGT96lqPvmY6VGPsw11odGSDMNK4dZkKBr7XKetoIVpfD7S8TSbaVyiJZvF58sVGzo1x/8YtaTNscL3JEmIrhDb9M3PcFD1fmRuE9YfXWNTSHf5wYZH/vkfVDXfi2kiwO56r661ph/UnmRa2raIbuOTf6on8nvpI4bLBatE/BAnAum2g7dk8jrz44HhZAdJorDn2/MFv3bRy60SQ5U=
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