9lcSwu2KTGnCzTWO3NNA+t8z3HSUpnZ2E2arLm+Trao5Tqx9seYwlw24LnVsO40kbT3+FoVxU4ISeL3A6M6PKhB8vz45VjHGWfY05/2dc0XNJ5Fd5Z8irnhDDCNadS/Ad3qvmKQ1TlvXZfusVo0G66enYiluguV2RErEbQ7H/dZXTmeDHmwUrg7BdVhEM2/pWFTwByewgO1emyKdBIcUuW8R8Q+mx9jEGkRRKJGTTmJ2derGoZp6ZuUkOnnzIBOvXVDsB5G2etOL9lO4/1qsDzljuTNZeTdBFo6CpAZNosih9efb5Y+NtkttgnGl3iUWsGdyhkBEhV3wtWM/bmFgm8jjRd4v6eWnB7dq8h/Nv7b3Z2UEkq6GEJu7J994mbm50SvAi8GcBATLnXGgM33LC2P9HR1WWhCADIYIe53sRhQJg5m/62nG+NZz9TcKzBxnP4GOJ1G5UknWiLth2FTMNvsb8+TyfKQADCmccGIZnTIR78OTq+Ws2fFrofKsH7Bi6jPWdiAGx8sVodWeLW7AeqkTsrpmN2vSRuQSh4/ghMckPoTMPaVN9TRtncCipyucuxboDJxUjbxnLFIeXL2aDhvqHD6KRhPLrxfkUNZOKevIx+OvGE3YuvlEZrlG/y4rPY07vCNZoK1dJ1hQT9s1goGexl16AY7a3hCTFOZMr/H6bPhlAQDQFlojuCez6n13KExfC0c8pQlP0WeYcoCtQ+CiYBp1Tk3g2Jh9DUbPlmmEPzuKCPIYbwUmE32ovQValbelqiDxoVmmBXjR6DqJ2TpD44I54rO2OYa9YD4CVhcnFjQKVppOZwFgrWVAc0pg/GIPFE8VgWDsb1El6zjFGgVzaTevhbrTWeYMVKOymruM+a/SBCAPqc/zkbVPEumI0iJo/F8NB8chuJ/Rd0s4Z2PwEcLno4/v+8LYFWomLr+lMho9HZwI8I+9LW8U0usq4GRJLPgYvYexfiXgpG1Nny2ktL+K8TJJXsdP27h42+J6iOn8TNUm5Ws6+/gONHEcRZ9AYtdeBT25jlxu8QpjBcFViMpmPFwhPiVG5aNyhYfdXiuswuMmsAub4aNFn+L9zmDynaeV64YuSDs/h+W+Hmzkq5vkK3kGERu1NQIXwkQNYgtGV5dw1UF4816tMreZW1a9tBfzK98jfLUUD8jZ384tmo2vEfdGq2g4mJ3QR5I4PrOdmcRySFZszUVMoIqTVSRbJ2r2RrybouOeNXKOPq6wvS9AGFuQAvFeJAZyKM2Y5KD+/A5m4hF16gAsoXTeeNUY0k3ib2WCnwkUlBcH9EGgdXv99F2C+N13pQZtocr+wU6y1RwhSd5vITPRadbCe1h54sQi5NSoWZ/bnsi3xru6QSfPmvMxKCuLrak=
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