ovCXcDDIWR5Z/RB6LH8LoIX4Lf0sS+iS3/zCnK8bvpqDrTdgcIvdU84oI+BO/+8XvJiFEZ4ubQJUVBJ0c/BWNC95Mp5TyonqIkveEOKxBG7kIzDlbQqpGyecNG0SWMXbhUlYCDaCr23wzHDKqLrrSipUnqvNBoQv1vjuBNmtBWu+hS3bOh8WbACG46G0Bq8DbkA+RWHDGJ7T+fuYnsRnFUK+etx/BbpGgPSu11+AMr4uinyAiKvGj81U0padHhKfrzoWmn2HQnoRakcW0eheSTh9sIWw9Ss4kNIF/P3dDh7BW2Kqkvyxbwp5aywHWZwZ7QtkbSg1bzYKVjthxyQdhrNb1ICFuH2EoOvDj10Xg5HFgrhM3QcrAOf7+WsRUFGYnAwGmVqzWxIO8hB1IEUUK1aGQXWO8Y8r9c7PuBZeMV6t2piqXhPxM/Cy0GgxTlhbdhrUIJ1Ecf5wJrPXhUQ8AdAbYQG5KPLe5SarKZd18SvTgIcqa+XhJyQDknAVEM7u8RRIBtQIQRU01dsnxiwRzZ60qKb8hbX1VWkMSfp9EjXTkl+U3j/CZUFu63MJs2+oj51gqEKywHGnfV61+Y0jhVnfas7gPHFDgT6ZgdgfneE1bPuQeLBRLh+kMIIy5DY6wnLu46S8IRRBa1UQMHuqznEtobiK+iKMi10MyAPoF/j35gxuZXeJC6FPEwQU6vPNChbCldr/lFI39kg308iurbeCkzBaC7KKenqZsRHPTWFVHmk39KnQlRbeQCXIjIggjf8o8Ys4Qzutj2Y4k0mndOVHOr7+WX/QywCj+QBidd1yVft8tLcCkehKhPQIaXOV4tj9lErxMeb6zZELnGXu+G0gQ7pj0LllmZ49w8DICvVIEfxND9B3t4vLDuiJ7UhuoL0EY9fRF8+N7c4HnYl9WbJB+uLcpt82Qh08cvNEdTBLoiO7iWbAcAtROgmUsXCXVY0k9kr401Kdqy2YlnypYm5dG3BgpyVVdUvM89IxGJ0pp04BcjrwKN2MFJQ3alC/+J0t6ToQuKt4EA1GVioALDJfKUQrkNwo2VsAbI87s/c1w+vJJdKX4RLrJHeoTpQLnzJlFGxuBQ36H7W3HAPT9GYpEuNXyyFVF5XjCyc+RWUH4Gdc3/IH5jICGhxenDHJ+BNvXBTRI3TaDM5GD7jLd5GwrW8MFFXfmb3ZuDnv+TPl2rTcqpEdnUUuPZxYg3wuu86p5HbcEvUorNozGhaTbT9AKwxCsvwDpPg1217vn72n5Uz4HERP1mYJM4i6VguFF8HE8Zrq2qLsdE8PH+pdjxpKzBsA4eTMDTN1IDb5mbgv3UQ4JSYpCjl+ZHmKsji4Az4EnrzFg4959ivmeINxm2EqHfq6eVc31sc+pXU=
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