LqloJyeiIrTQUp14TY+tP1ILVPBhWeHGWkBdemXqqXuira2JUDqfO26O9vb9uZSv6M+qhouA9HowmMF1MAaM1VgfF/1Rp/mVM2kxegHOu7Rej4hYc1UGEfpmuexoKx/LIvggW/U3JZIkCKOD/d+FuoA9/wwiFLf2QcV9DYcojvv91D8V7hpzuNgjni72c7kONaHpuetqiez1LaJ+6m+m2cY9WZs84vS0cM6goTy22r2iNTNEEE2a9PqUClU+eP2Yh2m1y7CiWP0CZfv4QWnBgnzJ6MFAY780X3+gCrkuAajylyKKsbonZ9B46IBhCyAZvvRBIX5O7mJ29JQmKm+UvrkwmqOB/6MX0qlR9s+N4gYLGPspoviG02RysaJBcGNrZ/H/uFkdEN5ynEA5p2xZJMIFH//+gOhHtjNhn5YwczXrimd5T4bFYMkYxLgY0Nn7A6HpOXUlmHsJGVCJJaTvA8dKAybHO8Ceu4V88NQ6muU1UWIepOpoHPSXwHqdwHUpYKGx5REqdgtu9DdDI5txnh6ntsEl5E+CcfISe9WkYdKIGl8JIXvC5QSeL0N1m5ZsQCgTpqfVAjS8h9uS3GYsAyV/hESbBVHhllsc14YqhBT8xf2T6TnKLKVbMfajQOK1Vv/3vcp7FWDnjuCtaCDNTER9C2vXKGp7GBg1tDVitLYv2WgdCikH6CpGU40ydShwngolyCmLBdHjhTpH2dw8ToimxE8q6f3nTE67JZmunGt4nvS0bg2/3vWD9nVvRsO5/AxG1HJAxAT+nOZqI+a/hv4f2ovO7uNZMf5nnkVij+/KYZBHXywUuVDgJFlu2yeKGfmnmFSLAXu4d1+TWglJPl8RJEfDbXmRTOqu3PfbBGgVTew8XdxKF58bbKRfEPCnd5Sge5UbT7JAeYaHaKS/uF93EhkAvdxdNoSQ5nPt9pPhjESQ6pUoO6uvVNzQitKSse/MF3kcXn8ksQ9C8UkJs6Jx20lVrfDUAeO6b4S7Ay1YcDYArboWvAra+Od62XZKD1IeZU4VtnM0pSqO8KqOsE3EOhk1/E1KYrS0yE7OErn3DefcqO9PuFOhILOY/cMOQ/Psrr/xZtZjV0pMxsnD1rkMTaQd66Knhyo+wNQDgpSUeY8phYZnfMaPFLKJ8pPK0vGTB8knHAWnhB5eqIGDUq7hSNQyJR6Rlol/z8t6my0UhTRa6kp+rSSTWFmjJM00pqo+3mc28dtWQJARoNfO/HRm3QvDjNe3xofhYVpCcibSR6xyCut8PmEAfQa2aIy86wdOjyqmBGzuF63q9CpX4d0kQ7IauYIojxagE6FPuS6Y68fE1Wtf1GJD6oS7/fASivwB1ZFBRm4A04N5Ad8B9YDDKKhntjVxFEzcb2M=
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