sLdvftEmJKMYMTaDDTeNiusBoPiMOTF/wbE09fL2283Bz1l3czEYATOZInnPn2j6QONd9d8sgn88M3jhNuiQU8CvhBaYA0OD1/59p4yEgXnlUmFDcRxg8k9jot8EIyWOAuoRORFCmsk0ZDbsj+842hL2deefze/A/AjBD/lodv/mdZFB6PavtBK35YJ+0bz4Qo99e/1G9pSevqGkK7mZ1rU/N2VJL8FWLyTNgj79Wh2QnysnPbu/wTJahFDosUz9sMijEVIIYv/q3A89hA9jHdfwttcHsa65RMgNeDLoRuB+VYW2v5gui5AxRrvxEYlLLv2sD3+zlkZePWQW5/YUU/Mw0pUvhgm5lmi1dkVq7Iixg5j59rnobo/6O8iJJA6DJz6KcC7CPSCsuUHYPOBnUgo9qa7LgSRf5QTDX81OzhzXVaCA1NPGX2mLdRkJTqnEZdImUmasHCyDdOYoRdd89p5T1QD3A9PAZwfIGlHaQQqqQR0FvYwBPmy0Vphxk3y4f62fSVyphLMaZfP8UU5OJ8BZDqmDX7SRLpX0j5uhy+zaDU/23zS2qzShjRvtQYGbDkJX08dZ/2r54Blf79nVyR/UjINZGyUcdby7wldYAyLMVnOfxjgKxsLztTgukcdNIfYR4ST+y5befdw+LTkCy3rDckRzgquhKfsn2d2iho1jKMqbXGL3Dgnd8FrQArOTr3S/CrMrdzWNWsWc7gi2grlZ7BZjQRkH2frAIW+hv5XY3wuMZFtd5kkSP/MSREn8/1srnmqsu9k1/a3woW4Y5IbpxgS3U/XbdWf5Od+lG+5lIpEoQxySOZtfucv4gIcn5CYYtDuTbV9bB2vm6sjDENjih8/tLhYJcIrBsQjergK2yWDUlFMZrFC8tE+/bmDDwX8xv4p5t2JP/JKwU/YhAHewfJE02GitoLsqZyMtwXhg8t37cTT7lM7Y8L3tLI3mUSFhRANs5Rj8ZNOwRlRb1Xx5qyG1Q+aV9COw98FL/EQP3vw6vUL/dH+szSFSvFgfgShF3zTczIO67WGTQdaC5SCrRL2eRg/TRJBvx3gVvELtOoL4Nc8rhmQCELA7S77RpsQcquQ1/rUVYyz5pEVQJ9ZwhizSSH5FwNYxv+34RbAQDu31VoXSIDd8Sm11326MF0ycewnCZuAFNNtP/N80bMPe+AxvY6iHQbTZvixg6QlCiqUmbmHOE6Fs+hlfYICiStZtew0I2WSU1xy5Nmk/Mf6qDjLsxshQ1Eyg705qwqfxiUsY4zAO47reRZqYBF6urk1UjXqZ9xhBh4dVcAaq2Yi8bMeXlXsmdo9YY6F2M3h4MO51tERq4sg/43pBZtTqu6p4aBeXnxV/iN3+xf66mi4Lu0pH6CCwvEl1XgM=
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