qqfcfSdYO5RhGag5HO3ojHtigv5lCpPbhlsurEj+1+NK/0T++WJRcsf0GMRipCPu06FREiUzWRzMfcei26v9a2wfu/gSXm3TYPkkt+9xjC25kEFGy9Q7TZENTOgtn3h1R3jIM/esNTpqNHq3Stdfd91oVzPKXxgKWpSYJzxULHyhbpFz2X/ur7nUvtksPVNEup+Z7n8MuewsVE9sWY3/yNAlbbH/eBZcLX83NuHAIOSRvsuMl+1n3x0oA/XnjKD0airlHl5tOiIgY8Mi74xQRyMBe9SolxYp44PdcqYl69aM4RhxrdmVrhq0f0lWi5NXB6YK+K4HR7/Jc+rgR8JJdj7OsNb6E13p6iWLkHOahYGbsLQ6/Mw2R0jLvRKdmS+LUYb53hfpCUCkSazoibjBznxrxwaQ/4mhVJa3ZH8LwbIJhBofHXDtA/RkQhRutk3BjbvgY1XVrJFfnSqrHgXjvY7t1A6EYzI3Nr+Srm+kzQ6w7gMozqyv2357UkNZpwME+uXLVzXmf/pn5Wj3P7QdsN1O5X8fr13FacuouGljtk2/PHKICzk2KGH61PxnTeKth706xmN7b/oPNen/JeUvSgLKTWyJ/0BzPAFwhKs2Fw1aryXpMiHaCzQqZiK9gjpHOy4AyWLjTLnhdp1t6jQxfc+Y865sbCRzUhisS55RoL0aKI1FHIGq2nth2NL5oTQF3tHAkp78/JvyX0+FTqjVjl1OTWWKLKiQS9SslmmZaMLv2iriOQx1vM1QBbIjJ0F/2tbln2ydWI+wInkTQjUFc1emU05VGudkkI/4NoFA9nwzbRAQpW85LEXKqf9mlvVYwkRhf0CDo4+CZKEO8I+m0kl+q66Iulf9Roy+/4xtGoNSLn1bX2ZdAsWXfcnWm/7Wu1ihZi0zgQ9qvGREX/oSnmmgHsEEu0+h1nv9Ov3Ol9M08KX8ZX3ONrldrk1MXIBpIibp1yU53z8WSySJgo9vtgJ989emKGu2Fgdhb15siDOsmu9kx6O1C68SX4HveMNDDjNVZCVoO7KqPrGDIdTcyVxixd7YlvYlWfrpkIjdMR+J04TKAmAIQa1Da9aPYgt3GgHdmClyjUFZF7ZkwL9i3IPghaU58S6sZWc6B0XIULhJkmVB4fnWMv7aB+wZ6tmsbgqY4092+g70CADLkwS0Qvc/9mKa0mFvWD/D+zLYxs4ENb+6dCx1KgwvFwzWMaYaiIO99OFiuUhn9C6Z/uvSQmRlZCChuHJaxWH17ClqHnDs7B8cAwL+97LGoxf+7FD6kyVuMyOFl3DozDKSCHq2yKAEsDK6ov1hcqZ/ck8t5y+xnIVnVxlA3PWhE177ibGqvARfp3rWatuQiK32yaIx3FOGzFfEHTpawuGe/sM=
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