LxqSsZivry99ZX+/rCdSlnKzhcz6O6gCTzcz/vMjvkDh6dUwgD3Jmp6B1RX8qbwOUq7bb5xAgwpH16xVepEC29f1pcSj1W8LfKNRwQOdgoXBxcQdPRMhkiwpD5ItYN+kprXxcQnvIvA6bV18icqxTiuRZ09doTyOSwzvoyGfgqpcAAbASISlYNt7++85Y5yHeaRf0ruy0HtqdP1LLLXbpMqFMR/20budaYGs0INz/IZK+1huV9XasfxWy+vHIaQHCI3bRgrw3IiI2eLAWSKspxWgDPVVuzR9HpgzD3h+sZzZbDIcIbtNnHi9RPSt432T6/8mVVR8WcCLaWWSkCzSti5KWFb6r41nJI4M0XRn8tlr6BeXXlk+/vzDYZcDCDr+fpqybmc3BSGmNv+83KoIAssEW9qijjoQ7H6s9GPBg9617h4XqhMFK3MJinMuDYq9Bv7yQT1MICQS3K3nTIiEkrUDBw+0ou/ySIfDIGECczddoVzR1eQd4uO5zh6z1n5zRArGDJqExzRxDPoiEpCC5WVW+bkX2c3y8GeqzFRjRyXO8eYPSdW9nQP8hKcr+hXVFgUED6Z8G8k6+c7d4JZ6nPjrZRxRIClBPFOn0PGMbI5mtnePsXLrQViQRnSvP0UNHab8GHMveTmVtDz5zWQAJFFndfe080UmBkEqxS6Q4GViKJ7BeER2k/aMDocFekHFh9CSkqFaCdvkU+QCi9tiDuLvS4iKdhGqkWZwn7SVkCLPtfnlyXEe5zQIQedGkpgXKKFzzMC5Tidm8KJQmyQ6U9kPW/Ms/RKB4Z5Bip+a7D+scRtSjZCTf1jUnLujtutjToxpinyKMMc+JoD0UFk7Ksk3xieXswSzcgu1WciG1oyOkDx2ly/VqLgUNyoZ2l8tv4lOLCWAbyJBD611hhbQxhAQads+klaNbtP2Us6JE/yhqGWdSYzthyamvF5/7ReE4CYk4lABNk950Ro9/iv0MyRxhERjRlz2KaieQYO+j943XVQk8DBN9V2xPrQVdqvkkHnRU4VMIxLXHvpu+spTXHX2nKXuMdB42nYioTNTJKaaiQOjEg6HXf3pyH2bJ5VtrvNYRcXuFYwTbtgYzvwraqXi2DVGTESPGc/hAztrosSHqitr+zOvJpCY0pT5ubJBCZw+tiAFBa5PcGqnYZo4P1rjU6Vx9/YvcoMg6ZzCx9Xg7HOTOf9JUpQJhDUpbhEDc7MfnU/uvr3ORTJMxL3JEFQRn6atX37FhDjwZzCBATzUGKpKhqF2Dt4kxxXdIdTMQLS7pCLYShULX7TGZh/LRbBVngRv/cVxropkZNumEyboDpL3xXzsBIU8Ae6nHu1qtc8Cm3o4AACxXyHogVj7Z3s8FbfMLgPjnQ5CWFg=
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