PkJ/gYwvkpuTMQvzOKEl6myYYf3bOUwS99hvUEBH0PWb/I0Xxaj54liRlb0f1mUZebjugLH6pvCI9jygr8VfqW2T2wMFW6L8/gx+JY/OVHk2ANGYuoV07GhG73lwS3hRrUhh8xtURe/yqXQ7hciJIMCh97EUpwFGV7Li7OhWOZ5iXqXMIJ8xflYv0fKlJGnR/KWcEl1nS+dwOFI0z5LpZRdkligYyQJAF/1cU3dEKOqiMvyGmqv+auNWO4wSvDcGRFkl8a6d5mpSskJ/kOcVANrHeZyhzP+tGebCzE5SokmpdtDfmlYqA1s4kEC98tW02YZ+rbgN7UVXJo50NhQKmlWS0bmVS0D3AFQLZlCl3eG/QTpojZ107nsCGFRQwgeGMzMgeUDTGWFALabz5ocUb/A8S6SbwgKokkGuasj44Uduyo/C/yiF2zHZxu786ZhT7L8/3+ntadFXxXv68QnNdMpX4C2Mrz0UffOeaeEowXOIrSLPIWYpOsz0BcTCDA+iR87UJLmgZNUXsBVdg1XcmNglu8cdWRemgYMeKgNLRgj/ZnPfX6Dr9vYeaDbS6lllHdVGnb3HVXcnYDgN8P+kvBgMd5qPlOWviMUC+sLzNstDNnW7ULuHZIEAZ2DOqAZy7jq2UGzuRMO16tSBdI/DLJxj0KR1Jj7GXlKo2TwhFqUPvRVerqkmWwIfgEWzmf9S81iuEDsf/MGtWad5j3GxReGMYYbZHVy0CO5Msd8lfYIA/gPoUT2W0sbLb4douByFWtt/dl/3NPjnSDlaUbxq9PR1oViv2Xw5xYuBHFoUA1pyJE+64ibeI6JX0I09mnS/SB8uil+ez93MpfI2qyyP57/0Ebrel+W73j1kfr/mE6OilBRllPzPQFW4DDC4Uy3cuKTvuVc7VzUQnm9/WOS03AgIPr+DGADPrK7QePklUXRt6Tjf6ONoOVXzy7oIMCTE61y81Cij0hZ8iGAk8jsQG1+4GqmBaE/JDjd4Rhev2Uy+sh0wqCEv2VpOlB1K1JViPvC/s1Aq4qa4huJ2OD/1HpfXRxdUjP7/WTnVw5BqzIWHT73HPhMInFodeVFfreFznuMXYOGrXD7YrDfXbsC67bUODQ0wLvwbCK/iKVF7aHIyYPahwcafNY8KtoFBQn+oYDh4kbgTfr9ftt0UAQoJrvt3FA+MDCzUiJ/YAWfVIXzS2xq14rCVmOhDVnaQS1i/5nxHiVoy+58PjVc/Vbv7zdJ5a9M3OWEpVLO9DtbvAtK3xdsE7YDRaq8Y9npvDveNl52EqUJsVONKTi2HcxCJDoneLOhqHe12pcJekKAI9LCmnWTz+pt4aRbY0ZRxCZhj7H7ysOWRwPbhCqp6sNabCeLzoxdrZoEItiZzBAQ=
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