xJXCMJPw/mfI3pYf4PMLgeUiBaKnay9ZUF2PEn3k2nNyzTjh+6HkcrPHGzPQL+0g4eQ/teqo9vpYOcTHX2iw5socPWIjjrGdPuok9/ASY5hl9S/qY8DUPpC0Yaq/5EBRaL4ECBI7xiQxEo4365lrelOu2IGPyY7oC8X/fQWzBoKKhH8yOdDWGK79L+MTIpaBKsSrp9ci2SPLPY23v653UHIp4A5Snhaa9nKItqFmckgLplbW9DFL94Ckp/P2bBc29Abaic8TfDECQDJcMmFGnKtDmIUEPhjZfkjFW3ifrFVfOwcVBxX3IgztREeBxH5yvdcCPRUMRlISEdRLiTTu5Uu6dumi+NoHXdvET4223WxJb6lgyvaBSnq75BEouiNV0YCwnM7wxZZW6ARDQqLmWlZ1MPWh4CtZF+2mf2Sd6HjqRSF/WHspAUZx1s9vXaKXLdNeEGPc8+p+9SlTkadhy3fZzT0vFlNPgqQqzNYsCqdneiBkR+sgYNigM57hciyvgYvpZG6F8TizJt+Q2eZma8lPqfMiVcFI3WBb8K1yN7fl7y14KFsFKWPjnzyBa7WdEyatbBa4F8G4bL3jyw7/fGNNCkdUS4UQEj6TBb+Y4oa9XTirGManYV2Q6r235vzXeQqj7sKzC8hcQOzydQtBEtdxmRRJeDliY+C+UpMGHnbV4eEdrIcolKzcj3ML5el6+mz8kqpX3jGutE91beUMddM7Qpw7c9R7nTG6C1a3xHI9aBL4NpHvnCP5HnxxTbaHhoKrmsa3HSeNDWdOOzBJuo/pkrpHi05vCMyfib8mGVJwBt3qrX+yUEFbRetVAakjrY/ZHu0nZm4sQsa1YDYCCQoIYEPmYwsDSSO2awmJjRYWtDaTRMQuD6Pou4P+WMPqW35NjcYebNk5Iu1I7oRjovlcVd1V6rmBAE5Q0Xo6cU0VYUqxdghPpdxHzWVwrJFpdWcsKW6dN/t5wMnkDRoCSnsVbZM74d3+DnjGy/0XmdBfC27uy8KIWvcdfF0IdmuijrSItOriKG7UYemG1o6daBdJx8LH1gb3W2YG1jGu9yYJiGGrIk2qWMu0na8Jyx7bSPztcl0tVMXIcfJPPSeXg/mFmRPogsUAND5C1k+GlDcg8SLNYnysWjDREvmfsLAR8ZNBj0Pglqeft+8sZaOdeYnnYoQNdtJFhqM4Jt1UYuSrS54HEeW+9T+4WQ72WU6RVKBmPQNOIabANlqOvSegqWU1COX5dY5Fkd+qp5YsQQhroK8ehd6WtK2xyRQaJs73+mQrzISRXRXhqka2answ/c8vK8DHYWRW8n25qHWMb0japLHEp3L5fKbnf+GgIZet4z8/rWm2SKrlZuRh9QQDBrmyXMmq89i4GUPO8Dw=
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