UgVytQNqHCwmuIlH++9Xysb+GoU7jK7BeoDRWIppeq5C1A61S0LC7++hd6CRFtP8yEmL566YihifxommEkVffBL2oHQgFioAi0o8sJKE4W+/fStT1F47td5AYXfmCuUsOZJiKvmkP8Ap9y52/c/CgCyolqP2xu2whsGzCF6QtUv1+9SaRWmiybFDsUqneB/GVvWwHudXtRbv0dFM389QNHcXoh1e1vGHZGYKi4qci5omyXKLYtHRh/qVHbnfRTEXm0U/c24tzkv0KMazcGS28bNf+huCEKf1CxJM6nMAvJ0ZQD1yfQM4Qo1SAQZCLJRT+NBFrqU23x/BzUE1PgiQ7/3ueGreQzj7YvJwt1u6fG3R7zOp+2/cMqSYTFh9WH8S+i6pT3rv8zpgz31tum8BUsBbHhNkssUnhPihbIQ4uhxZQPo85zB/pIsQEtjWue4Tu16TTzNnXRaPPuOVNZmEYUKWD3LnAK9tG5tAUqXStsIABs1yF0JuvSnE/iq84CvfRQb4ANG++JhMc84SdiUnDp7wfNnTqzChxr1TR66UlBXEUDtCllOS1ocXZupViJ8nUHSUzno2Xmz1+/8HMQF7weVYdgVZX2vXGMGBvbfkh1Aa64yzn9iXgo+ig+dpJyZwj37z0dPGTE4M/NE1x8czeayAdGdpmnRb5T20J0tz/3dfkF3yik5Q2GqRJeMPiS3wl0P6+YipLKw8Kbc/76TAZlXSCQLHndsOs3m5Tj2Xgkzbx4eb+uYtUrAwYq/As+HhL2l8tJ+Sd87RpqKOJdczFN8CLqcuT1ggzKcz1W3xUCcbbAQxCO3OMSoVMGDtEWoKGbkrjr0Qj7VqlOzfxUx/QjOxwuJXKPiVv9aICzP43hUJzWGWCCmoEn732n86QUTcPynITO4mhFDCxsv4prKnkxj5zzmDeUNhHe6oAlarJAAvaZ8LfAVaE2w/Ub1GsGhYSUYUV6KBmwQLxvm2pEr2VgiBoDIQS8o5tos/yP9iB2Skb9WMbNm12y6om+a1rMH6a2WKvS/lcmKBXpYlsWxIUYGVJKUIacJT6JngqETiVk0ROS08RUDwF0rFu9xzlkjHTZp/Wd3MLbBTWC4l2pbGWBzcUCgMqFQVfGEcuCBddTlZS1H5BdXMwacJS2L/kXCs8IwCTy5akeeT22PCFDmoyboSS6z8O0WI0oj9qq7hF+dZvd4eqVBPOyXoon1AVW6SOSvd1VlevIG3ynb0mzasATK7FntHrAxz7o6EHAleekN7FCMH2pkY2dJ45M9B67MKer+VI8JufyGQPa5lSj1HoZcdFYHx5wKwuIawC8M+lVQQh6J9rze67AbNrG5FNk55ItJkUk9yvnG8XfNAFmZ5sbby35UulYhSYIXoZBI=
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