qSYZB8ezGtgr5lw0tJsRh7syMXYhY/LFk+DmkvV3ZWgmBVFE6bDFkjeo4/BhXSM1uS9oPS8DANr7RvS6zQl/3wzztIvQRdNO5FKRVgmYR2lK4Sp3N94pGYnOjKlGn3JCJHCoM3JJdOW8GmJoHBh9qpGS68hbZMkcBQ0footA8W8Ab828FP7NBZXtddoUoUvj4QIDGy1CW5OE6qaiUE+CKlzWVaoJvqfZfpGxCSAZj2a8nYSmlK3V7NbkzUex89P4ii2FNZW2AYPnVMoyVZELDRk9jI2OnMZutrhRMCxFysr38O442cOxbS/F44QUJypV0+U3D5r7xiYLgE5Qw44xpyqv+wtSvq7Y0Mc91lz8n+LM5/YHemwuywxMX+z/uGhpzbkwn8vgXcsTDGORK1QaZnj/NIcBhJaG+Rw7bnkMErtFjmeI6Qvr5UVXzBYfHioKsPfbLiXLaky+TgJn3Edc3X/r7Z8aTNdPI8B7TmAK3ciG1q2CdQ118gavqGVZ5jJyHzLfqF+imhSCu7WYhQw9NSt1QpiyutsighPb/9cco/HqgjWLAwGAZYRKS1OiCVHHFJ5/RyGu8m1bMN55OJrQsgqH9xxx1emS9I6HOB0mZAsXP8tOeswwEYSpB/AjAQ//fiqOpyTUTs2frGwsk2UHm0sLeePq+rN9L0TLgDDe1rL9Mt8FxU0QCMfa5G9bp5nX9auG0sL7d9E0YF6Q0xBrP9y2aFYbnGDPf3D4Ua1GAA4bViaEHST2Sf/hCYifAXtQUrg5mKeZQXRSkVBjU81xW40EV5AGiZDCh4B2Mt6wpQGwsWBz+/AsURQjRGslPDCF4YyQ/HrUbU/tKtZZJsXj4h6BEVo9ZJyGCntNQZ9yV4uTsX7KhGyT6Sp09GjmSc0nbC0ljX9FJZru+0LaVr4gpzV/Gr3WLcohWbsuyLKyKrVECs/oc/Zscpumuxw7LM0BRd5ypyU6UyBuoHYg/wdow4EMAApiu3KXaUX3wH2P1GghyuaqthvrMPa+TCFJVfPTUhnhR9UHdlWhSoi702NsnNGUA4n6Jygcf03D3A/0VRBLmJPqzwL+ri1zfgJz9K78Rib0S4ljKVOEiHZC+0wQ/YaKBiTnaRjk2bZEA4L8Hch2CuFxNrRstYVC53xHTe2ugmaUAFvIQ9TzbkVeaAA85DXNdbHf0xW8VVBJm3mebr/gIs8kpaf4Jo0T5fq/YmMToeQ3mPHd5lgdPvHYaDUgtYnwp2kCFJSw0q1ScTu3yDS4iYoCBL+4UcuCU0+0MtqyPhyt2PbQd3Oka0xA2PSdb7RJNSV3m3+NIVg6jCBGrV1Rs0403iaUClnVFYfTeuI6djbxMS9TuKl+RADk7EZBmJMymhAEaMkC4jY5HX0=
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