Sa1YDQOZN/KCzlZUoP8jvGY1BYuMgcV/XjchhGttRDYq8mMb/RdHTK/s/dJv16va2r+Y0uKwtUvRX0/XjPt6V/RrKqo5ZfZ73tU3d+yNB9QFTXswy6bHuV3wTk6DNQVXoGRjt9p8D1MBiHYIeiu4EOw1EJzJw1kvzI/A1DE8W0IA/5BoXpNNyXLdaoy3NCKKiIZ6ED+YjCnXBqHr9Mu1TOyPUPz2/hE0/5oHSVdUaButswkxPG31Hze8K+QkWXtDO5qBlIKyX9I1AEAm6qeZ/8l+DoDlMniIIl70UghesBORW0hSEHkd/1CC11Mn3wLufM+ZG762LwXIv7VcTzFj3BcIoXqPTXHTXopWJXn7hpiOTki/N+FDWbEHaXYbnv4MWK04yT3iN1VtjvOaREaFd9J0g/EjAyJgFfCe/5SNo4aaU9oivrm4JObkOARbkeT0GVVA5JM3hBNt9v6WWSCqFTsLZQCEj90keHmmVdkHk27AfMHyiDPtYo5JbPY1AMaGF6WnW9+jsjARqgFqf4ZnGrmS4/XEBCOYIp2q47B6DeCWZ1PDumitIdmToaX0CdZI/V3wKf2ZBtryhiD7iQTqnFQLUBWlNlaIX1I3+CE/Ev61jxCYJYwxwvPGUoU8nN28jKgXA4kzuPiIYnrBBgpY05XR4cpyvfigvKIOGwHMuMlPXIhWn4ECVOsHQ6aLGmBB4/F36wja14Xm/EfZxWODXATFAeLR22Sue6SuzaO+OFGCQttuFeLJbIF3GmUmZABJX/RJqNXQyujvazupORW7wWaIKXrO2sIG2U2RUf6eYxykIB/KrWCTe0sCmhxOZAoJrJMM5V7UMtzJJ6ECkq1a34qB2gutZJg3o3XYVOE9XMLOZxb/GPc7SR1i13RvP+9iwQ/kRj0vIchy3eLyoQmunZVwd4jfGu4LdPNJdqbVOVAcKBIoaTBSWjAEjiK/QAzAwGxmAm2k4VBI2SRgkdtSjZ9amZlrXbmsElc8o9NsjsDMQK7IJhQM7V2OxCx+u3okx+KmGQEGMcAnI4ox7V85KtZNmpjsoBcYBQa6AnqB1ITgSksllf3s8Cm7KHqwNP7fCVxkSinl/w8/Bt+7LDvKCUWHDpKevHMNWdK6LgptVLw3Vzy59yIRIvLFKtMkuexXzBp19e68go/pQCMbyNUdHku3kiM7pSexnNibnkDNqbZZuwf8HzwSnenc4F0unU5/xSsJwwbtRSC1A6bIDw7IH5dbtk+dxgyYEIrDmIy1MRlJGOeR7qSBwXNuvJzHdtBDvIzBkgeEsZiuvG6Lty8CYHbyjvZ4JV3WLAGdAbrnSUwFwuJp3Fw8qf+43I8IE1tTqlqOe1DgwcpPTOZMgqx2ujaBefeFVDg/YS2ILBQ=
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