qEupiV5R6FqklpFLN4vlHsBrMJqnIsnhy1CmHbrJkAWjUQ0+XM64vOWPZId/eWCctTqCg8fTFB3RuB908hWyifWbsOl1zQW+mbZFd/IJEokufDwlbUs+x/1jRhYapWWEp4e8lIb8TOtaFVu6F+GM08967TXQ1UUlfaCvMiQLPyEJsfyKVG8JANacdDGih3T1dV65Oga4+eDga7jzq2OjMMV2786IAbE2paosw1oJWSW7WYMa2hQ6BV3ZfyjCRTrfEA8pf1JBES8AB9uz7R5z/8e+g2WJ37JHKt/UzSI1XmZAqZVdmF0s105y8OsL3uFVCcF5HzvqGs0x0gQDe1f9wDQIcSx+oCb3M9KUP6aagd+PRxG5CNWuCXuLiFyz28UXJbZgDZrH3QQIMXcsETdk+ymaloi7wDfln83jUr7GF4hQ2D3itBtVNdJygDflI7mdobk79yS4+8sfwIevJ6MLyPxb/FS2ng7ZeqxmtdoMolcvglywKZyijZb5ABfIQGU1j70XJvFAkZDo3n9Edw/HRzW3nMTzfVtRtMApucGKwFoffjo2sdyvS/5FPa3KE4TTOXfrtQJpHYE9oYsLx0Tj4neU793XJGcZL7aXmIXzGrCiy/5LfJJs00ZanRkeQS6WZFNH2tF65SearIuwyFfW4AJ3CFMxCNyjXyu4NflqL7MkRIxopSxmmsDP5Uf4Py3Rthf95l5A4KTE/KYaPg5JP12IausU/3mQQVm9uPPhx5CF3qmAP6vCj2XgNp2zUbqOV5EOU5JIA2s7cyfwHbHCXWjcT6/PkG9w+L3DaNjNGVs1FAbIFTx25/zo8l4lXpgqOu9rTj5cMKCtVV3UI4NCneiJgzWKQ9FeqZR5HWR6hWmy6vRt/wulZeU66YP7uSJNcFTiDel790oJKMGqoRPY4dnxNQ5L1o6+ebu0quvxIQQ6dlElsDTIBhJHhUJyBtNFno8EQMm0F/utK8RqOg4tKvGSSYXgW6LZ+J/lrSt6O3mXPY46oueyybLMAx/ujYRKUiJnL9+c9Iiy5RW7D9VAPC4ykfdbwJanVnbKWvBLiirj+z6kB5LmOENuanKg8PEhLt9P17nVzqOu5SQaO67qQlvu69M/KciLiddrY7HbBnDqt7tuxFHwcYOyHhPLtNUSg5OPh34onQP7cgblOIyPo96eAKQ6XrsNjPKlduKgpZWTOurVlMGg2VloBzmvhuCvDcCwRkxSpzeLPoBPfi0duE2bCS2bSNwwi7LFksNIVIb4h6NPJE0GGG4bbnfBFwINhEVILwTlBXe00DETU1gh90nmDTU/rizxf/VyFhmcKDS/n9r2zMkPaZ+4XUNy7gkkRLO+yzp46c/+Ysw5hTrC1UzpqE8Y+vjYV5i1fo0=
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