NX9tlvQpQxtXjZN8GXm57n/c32g2bzj7SXiVNFipu9eb1tI+AUfXM58H+us0wkZ53Crdl0ywtkZoLBfirTSUIyK/4mUKp5odzHACbRQ/pajC4BtjnKKBptt4G9XXzkNSiIxH67TvpZfr3y4B2y5W8E39dtQJwg+ze1Jigq+EJORATSHczUpHZW+lmjLh1lBy6wl8zbxdHaKpnb52bgGSBbfBe5Q3jCGlK7JQK+F4GUhqZ1jKoX84JJDSqFMoXOV8t+84k4t8EUFMNBuboBopEC1YS8Jcv8mC0CvbDTiR+NGF1NDIqKZQx3Kfyx0zsc04w+jRKu4CGclV7NwUSYv2LLh99/WBbkSJFwmWMSqyRZ8zVNml/iZfhSZATbnwqT/eiW1DFEZbj1aGP+mmG6lRCX2qHnTpRqiZKzeNQ3cm5iIrVS9iZA0n3yLvsS+vj8NKERFeAs6UJWk0cwDNWJu5ObH94VD7M78IdV5VzSdafxCa/sREDg9DNXpuMwu8XZ2XZQi1lXcSX4i0BsIcMr7+2BUsDLbL4lk+7HcgWd2CMtb60D4uOeXewnksbDuqKNwaBHHNdjR446q1wQXJtt5hW+2KQwAgPMQCHanSS0N8jXFtXaH6mfhhhx5MMdAv/rSAcBQAjzd/An1DhxGP34NOGvRjYzqC6gGkAaD8YoPOkJdmMZaXzSbieF91BIA6eHtQ8KOSE/8/yPhMaPQBzLTKJjRtQLQ61SM6IIQf1G/ptFIsD3IsH2d4fx7x5SDcM6/oQPWCXM1tEz8SXCfJMgJf6FOsareJJbti+6zkNG7ftkbOk2sFR1xeDnZBQIAim+Ym6ViMwjUI9yqCkkupKBoQsoHfg5XvJDnmrUyt7UXkzkSsrIjWgDpp9tJwqOTSj+zZhNxHVIfM6jd4P4fWngwAorQrkxLftNONJacwbk/CfdKxsopsHwgM7QaYWn+w3BPA9M39ZSuTaG1VRT8lWsC/PZWx7unr8fmLvRzMEELdjyzRdo3xmK9Mi3/hC9BuzsCQFmOd/+TxKALXrHRVVXVhctOQCKMsIU1RdxuzCNyEFDzPHjIhuP6QcqZdChq6vZovSsnisDWSPu23rIJB82Azw3Fe1cXv4qKU9eN4/ZCM3iKskut2lCd8VwmwBakcXcfFbK6qGFEPnFg3hOH+K6O82Ny9OZLhSxBhhzd05eZLzu7PnC1DWjpHObkV3tyP2LER70x14BRch5qy6j3P1T2UiTGUPUSyiSkK1SGQbbxdlPl4NfBuVYcpwnZUN8xFrpcl9EBO2rIbWErhpmiNm7FHH9I6HJn22QyJWkzTTcaBoL9VmB5suiVdH93U5QzH7Bp5Q+X0oekWmk8GkqrvDi8SopOaK4p3DG7yp075NPw=
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