rRFq+4GlTHGEBNEnvKT+nCrKotmGTRv3FxYMXUGFWnxtA/kTF2ofYoxe5UNfyLg8aO8xLpIDnAiqkf+0wbutzeAlnfn0zHPFIiubVKnP7r1LfxoTMMvFpzPE08vtm6pINf041CKaMBVAjjq0HW/X/MTwBedFjW4B8agSZtNbsoz1fODMkSPFxV4aUfwWBGQPUpci1TeRnLsVDHrW1PAuimbGnJ1//d4CJYqF/d92a0vTzjIzV5Feui6fWwdmT2bRsNYdGv0whlmNDnEKrIRjWJmMrLVWIvuYYaSF/MHBzYl0xX43bHGzyubPCL0TZK60UpSWeWj3LXifJAM85Pimp7oFsl31pabDsDcJga2i1NZUMYtYqAAObKqWSZtDtF7+0Ei4YUmNSZItCmamjKl8JdTGgCjYSo5ii6VZiNHZ7N1tfvnfBCaxqDjq6cFy2ZEXeyrBX69KTBzcEIYyygJgJl/EPRnvcpCUeeMZRf8Qxmm5G1AtapPtQPWYGBHJucDcGGz47ZL5vgWFupq1JYvRhp8nHwPAMLjJDumjcY4OEQaMu7yHBW1nZPaev1oQhhtu4BkSxfLCpZ1Qp06/YhOpmhaoQhzCZoKqCHn9ePLYfwjIdmQ2fZlkDKogQ46UG3CoSRhC2WTbA7fwtcbH4gU3xzfTXjFf0QWDhOICMC0fl2zA2qu4dVUfX4Vc4Ufz2gj9miazMsI9tbcoOLWxB8m42aG4q25El+5GFrxUvVWAMGEn4Q7D777243dFITpwPwiDybQt2RdVPlHw6JxgLcyUfI9hyTHVcZI7FVUomJXW7h90ift55uHZMdqWlfQX5Mquyc6wk6lj0hTkOjnOo719mfli6BrKeqdlapaRThes7zf6nulz8zg1Q+IYZQq1Hokwg0aDfvHozkqdwpwbz+2+ELZ1LM5zBzwuSWUqeC61yEQs6vFQKNgIOd9F2REWPdLmOuScfaqoBXn4SbfSOOdjTOytd9TY5Jfiam81aVD3198rt2++Y47yoV8MWdJpnITSqULZ9oD00lJi9rRLCEZ7Y1NG5ugpQOcIGX+BFD6jVJIYgWo7CGvXfAsAGtqTP5xE26u75PiJfgkwDgbQer+p1HkVPDSkVHzJ0fpypLx8qvoKKwa4Bo//EhiSagReg+hOZzUXaV5mThyOArZ85g/IS/6zAydfFYfap+2vRMolguk6U+dxLhN86ytHA8es35VzA69ZP9xp7B7PLKnvoJP8T/oFjIPpD7B6GFs9bCsSkc38tjA8dMDW925HeLlkqaCVMVaYDyziU6629hH49l/PAlzuCgA3gaiMDIQmCIqdvlF0JV9MKKob2go9MwnyuDtim6zi2D56PFlzQ3xZ7uUUGJGxKObaGUoi2dVRTcM=
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