/dzNdr6PIYrOYXGGrNdKMebakjuTizt4HQPdY+HNkuS7ysJJsbz3fjOrBoqQW2O34/2fFWcGEefX67AJQeWICEeBL3MSdD94LOS4M+cCSDEHPkHpQYx+QscsEs1HL1w9ESAype9Al+dcied9mpInqOVmwMmJDHuaDrL7oTsYqUaQeTfx7rCmmKSsIcbnPgOccncM/af2F2pFy+wnNQyCaqETt1Zxs4EDl/PrU9rbvemYaLC5xaPCCV11WhHbGw2k+hnTtNbXi5bUNiBHtq7JE0DIsFKOMS/kQ0lqiOv8pA9Hu2/Jpk7lQlqmTx+rjzgHHwHQ7BgEBruy/Ui/OSxhuzWoHjD4lO3STxcx5aw/iUaEQ6LZpmm/dPESnW5HOH/ZOW72E2zBNHtQaDdz69f3mupIXNAHjYzacGh2x7ZGzk9Ck0/cZr+oYWMmYctPFCYpDEWLqqwHsvYvsvOoSKAoodh+YEDKtDe5fsiTGOuXS6Z22Tdbo8lZu9TRX09Yu+foxc5MPZGvwnnckkQUHoqDyzKvDjl6iNtrkj7JCc1LMFEKZOyxvPOj/srBVPks0iKC3TL5YuDxfqhcznxVmi6uAAig1LFA7fBMiyfRMmUmtuvoWWvLs6N9oRo53D8aI31MfRk8fcbzpwklXfwY4CbKAhUnbqdkLzMajN57+PbOvJAVIvk0zzQ2Q35pwqmdHdJRt1lGm29fd5PQ3Z1DXDqroeZW0EmUJw7Q0zTFUB4LqwR3LGPJBcFiZpP8Q3CcWFHNRC4uSCwzyTqju419Du//zss3MLdAzLxfbb3BkUGbOcQxVvdgtug5biErFaYUnn1cLgPGP7nKgJEamuoeakt6z4wtW50rmU5zgJVE4XKs3x/huJ2izwEiqPw1NdUjhBBNTHXbHytOCucK206TNzXLee/ZX5/6u1SwQ5jOnt1HIfmZmO+5Hv+XFFJYgDtgcXXmgRjO8TWj7fxJj8/oWUplniqZ0W2bAHA8zter3UeN0M1LJjTe/F86csLcDOf7raZ9jie816znTUqECsXcm0tJrZtYwKksbj1J1MC0sQ96njohtUcGeX7qTciZf6Kv+nkvgWuEmwyb6JCeMpI37AI8u8KWM++COWFpNTV17UGFHgDyKemVK0VggJORnTh373py3yJokQIz/zoVs4P8hVbS/zS9O2CRu1vgiIUipZGFezR3oGVfrntkhhTws5h/H4Aetrmw2mgteDraNLBxcmEMQCGnf3blWsWwtiDSsg0Kzexmj+Ac/E6YKHaXqN8sLrJiX8bccYBoYHMkZnKHutAFlpmjJPPJe2+CeajCdvKj6BGBlWPOLxK2Q+JN1pTRyu7Pu+NStQf0rgEO/aK9Rg7aQVHNJilVH7qiL1Fp3MY=
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