fxffd/zJtcC3ajPkPYuFNRdOraGld+8cGGBsORqv4nWPQg07cKn9YCyR0wdHYTjkiRQaX20UJ+HfE6O2waRJieuBCu2imZKxa2+e3dEfQrO+j2ybNa5s3ZnsNtJ1dVtBcebLr6WArfBF+E8qkia2z/jTky9+CPI9YC/XuPTOAcsJ5XvYYFoqXuqmBRcRJUaNKHJxsycCWW9NLXE/B3/zREPassLitHSGiqkVzI2wwm3aVOxlfNVy0iWtCZJ5dauK89zXSsBnTspsLBdZO7GxTv0nSnc4hPow3izepOyqDQiMTqwPZUrCUUb5+1PCcdxCECfEnLyhR96Ljeg3RSlqeeaAnciGrjTSdHtQiQ0LNfKIiq9qxC/zdUsTPJ+IZi1cjDBA1qyBOueaEagHMmiZpxb/aF5/UPyrRQk85xc11UPt36LxmbHG/xEuTr7wHcq2orNlIXoEujRJz/wUqeWBHB1q71HvB9tIm8Ml/7dr8LfPouRHkFZP5FET2woY3ur2f7Y6qi425ZPA0/YeDZh1HgdVrIQqKgdnUOGpXK/0t4qtAV7Ps/S4ybAyHFfupkmYZvpVl53PlHzUi6Qb94gQ8Dyh0zXosyNpREKHVhsULv8xK43HKjqBEIpZeqHn8qUvD9D9RG2HEXiwbR+xYjkQYy9jjJXKXvskAG0KyOkB4p37qtJQoGR0WGwCHWrakhWbA3FYNFedXOIq2xj5/tr/TuPxMc0h/n784gzewoFqnc3nLG2yeK6liej5eu0oyTWpBLsPHQWxx5EocsWVOwnT/oBvFHzmB3gq0mNdBXregKoYlxEqh53bKau2UflRZ9NVbfV9fRIY2tPAi8kX9gLscKmvopbZiAJWXrNSQ+bLF9pOTftTS5GSu1LDzDxkbnYkcL0iN1FmEByxYVp6Fnx18jF7ckBgCU5F7mOK61E4eFffBc30L+7BDlPhdgOOnrLGogwTCerP4XAgotmDmuTh2Ely5R4KZGtRdGTyTYO3rCJsTXts38zuTkMqf5Ymj54jh2BI+KwqF18vR8IGToqYf8mKsZS930IIQ9Ls8JC0hSqj428EfLv8qbl7LqCDbQRNXFOpkyRyRvvtQ0Fu66q6jTjY0k1HMvMYK9xQ9V/IWJJhcjY9CVnV2PhdhSyR+TdMsxfhkz8agKxCjMaphmuNxZpR0nFqBM60IZJdZnAhf6tmzOdRU8+2NLM8YlIfFMJFUFQm2XGb+S5njHoZNXlZpga7JHfHA0+dmB0vEi8msPH5x33EE6DX7+iyPmbe+afhhbTtjuJUY8L+BnFe522VqZs0j3SXlyNSOzDLkLgfzLVbtccHxG7ZsPFZtCJmxY8W6g8GqKW4JR/Moy+TRRJM7fHJJAgxJwKLLfWzLpA=
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