ZPSlExg7FW6H+A4bHI6dyI8ObEmy7dXq3radyLnp8KWgK7r/G+76L7wdeBadmXnjhUU5s9r5fr0q8mF5CZrJeNoxZBijulH/dSvkRQRoTOAOi0gm4WGwC73Ch8iVdwt2yfpJskjn3qhCjq+yGYECPyIvAX+n4hQAAgkKnClKb16wb6kiQRm/ToRdyPZutUVRLhue84jrjjIo40utyaXpqGG7knIPhEcPp4vpNmGJXHYBfNr4KXdz77WWNBkzoIr42msEcuI7dmvQgUP5zncGq5EHmj3J/EY56QcRFccKu3iKILEBPj9BgqDWqf7TNf4aBjSwqSHZnEpG1jOb8M1tz03gE/GNMdG3RqlzwLYubx8yr1eI4tgpXXpwUIkpHBVOyGEv0PlXzZbmvUfznbkCFDAh2W2NDrdQkn+4XCivjZXjpO5rNEopmCuSAKjoJ33KF2mOs0JQ3n6s4SK211w2lTHIeB17K9u3G5zGTZmHvQiyhHM9wIuGv5o2EP+HuTn+4iFGiIUNlm1biPJNhNmvbcynMwqlG3VyhUBnerR+k0wqF8GVjMDu/jnytHrpuR0dh5L57wjB5frITpE8F14tbKXbEKaL/Mow+ubyMy1+d/01uG1EoZ0yqKxyd3eFaFOhe4HEgcEOAl17GcXc/8cqdNh6PwLr3Ks42D3INK8ZuqIsPxIg4P+aF35/D3oycTtqnAByguprolnP4pi6p/Pknz43k1bwsZNJ/zRKiYHnnmNNpWPhMVK61TaPzn1YCL4vKoDsXVPmapDSWDemNHWY9P5GRLYm/0g4ZYVtjgxWmaEzXb9XpQlC9cGIYOIxiXHTgmvNntf2LymF6bvbY+UmPE2yLg/5XIkfHXXALWwPrKELhZrTAygApY2WFor9yS7h3uOSWzF2+HBkRwO23GMaLNmgxOxdgOh9aBIgftIoNHdtbDzEPNdWmSeQdj6hg7uoZyDEQ4NGUjGt6e+Lst8CfyTDOQKINEkrVYNI/I1OYGJxQFz7VlCGYkq0GanOucDG7i8GSi3yOsUg0WA7YksqsTTXIEOYrs2n4m80InPxw9d5SPPizhMS0/Wxg3zzAZRnM6xmiZoX/XPQprhi5jx5AESOfOnyknuEXDL5K9FAX38p2lmiZTutvJIxUFnbdCBdEKBbWH8xtqD85/wt7kko2WJ4IG8GCEgZAmvK3qD6PHdcK/3akS4jqaRKtU4OvyaXY3TltebNT57PSpshcuOeI6lceoxo7t6rnLTKSvtNV/8on/0ojFz+Um7/NZTqslxqHlfIZi6OisGeNIeAk7ACWPyFyGM02xcMBP32r76Hi61Vr1QBKPo99m+qYyRSFpT72dAIvu3cFtf0WozVgLZF3aspLFMpPNonpDqa5lE=
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