E5Mu80Ks+QLrgfdrlnXC0R0am6qnDCV1hOJZEDYb0ICV+WM8G8CUEY+bpm459SdEFDOk7xv1cuY5M8n3WmJ6kG3dseLRriPkAyygczax75F/vIf7Q7XCNKrwb4MSvLuhCR5jKuqLxtDhESQTwaTv/FC0fXLC1ZsAOu8kEwF7YLr3pzgjA1IPTkZLmnfsNNFLn7+6zvDdrplq1/qS2+YcUXjdobV3MNnaYbVZXRn3HpA23C/afxOsyU5Dd6ieQkTJhGqDUjlvesaqfNbXvsqWPm/RaFok+53YAPp+XzkOm2C4Q4dBxv7B36ivnSpZxIhIuT49MyxL4hC8yPnVV8DpZ89o579mmYXBwuRa8rJPCT60ZFNoee+csdnPbrQUZBQ3YndGicCPxazFIWkYa0rWYBA6h1WY+03R6PmHAGLxwoKWXq2xfMx+0VAeaDTXB/QP5RtIMVESpZSoGtQ7A0nAEdkaXaNrpFIk6pdu7gZb4LUFJn7adwwAKcCe9aqvuGNDW1NVPHIYygDj/0imNP9uQ9KLXeETOvMv/dVIPhzb83LrL4dMfBhWL2KYV8MHHCK3h+wQ/0YpWWw4my3GDsN1nWX6BIULIR5Agtn7mDU8EPh6rfYbHr7xMdzZpyrhSqmGgUQRtUnUQhLX36yjRyMH5YZlzW3+0Zt1FzbrvfK1J/Lb8Meuj4w/qCFW7lliWPKZlX+UK66/vxmLz+BUWgKH+K6yukiPKB1/pwZi3I4qLrB/92WBxC5g25VHBvzIuGOOD7SREbfvPhCOEpYNIG5sEcqG8gtucY9+/BTFEg1IUERAWgkNQZ9a6IvDfWAt3NJuIIUNNfvq5dQQEJaz0F6usu8f9GzVR5m5j44tQY/U63GVxBw1mlevwlSR1K6xIrPomx/bSi2jH/2UfDzMPmV1mI60+mEQpOdXptwPcDCKc1fMZMF2aM9Jv8Fk6zDi9lLyBz1yPIP2TilY3qeUaOEBh/uEH1GjKFFxyJtH7N2bNi3R6SM9HnFFNdCYfLoyK4dYxaIo94N8J3D5FiDWeVARxnyAI1V3tRpaeOkAy74VZor+shroeKSAQx+6wVF4y0IkCfDQhBE5Trf/8+DO90sb+XLTREzIJ52ITKvq26+vZJ1PAOXUyIEa3A/vwM276RmVugmTKIxDL+S5j8l5y/k5e6kymXOqDiPMN8C8BJiluUyOquT38dM7psDYjUylJExUC9Bu9jP0TskAUXxMbosdaYjjcCD8ldxxH5Vb2GB3muO7MTHGppsE8pJicPtZWDHtEtfsRShpP3Ca0rbd77cJOrjjReZh2A7Zw1IVQ9XJ680NnVVUQ6T0u6A2ECnmFwfvL6HpPx4nfDw4tGW6AXPIJmuL0yI3sRvffLtutGo=
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