llfahHXiD17H4FccwpaxWPcxRSfLAuLWuQOq0wJzG23po50lpeJn0mNYT2RDqB/npYvjQjCWr3LPkzA8sIOo4GWCtHdtDydu2IOOq+X+0SfU0YnlP1SqeZojYWRnXy3FVehynfhij3w6B6HpVZcCaEzF/ULtdcnH0qQR0AQ/xoIi9QeYCCsX5tDt//oPEN0Ah61fZAdXu/peY9x3z3piB6OOwhPutGGePDNrLDZ9nESMiki7n4PX0jzQE105nN3KxrcKqSpHK+vd4tjExchRLrjImNPSRwkNcl8V9HIM3IpbzMorDaGVsvmXAefuwWkSkvN38jM+g7aoB+fR/3wefjDRyXV4vdFzQ6wDtY4utvycJIdIxKzydrVdI2u1u/rI1p1+uHK5CQfxd82cWEV8znmUc0pBF1wiVqxY3OdvbNTKAwEDESD2q2gZ5K463gCb+b4pbJJLd7WDZCAWgDECa3zNDLLJfB5TIVbiPsQkxZvAekV4AXu2mVjPhLNL6nC7PTawCe4rMktdlWGdERkbMMbsW8gqXeVJWYMznSAvsfs+9WT9FD/CRSysxxZOlqH//GxbntsqifNPcEgpIvYKV+ugTpr/qLJ7tCMqlVdkx/adcSy08Rz8EgwVhLyLGhyf7eWLy7ttDpraed/3KccPiB5qqwPcDKmCXF943FbCn991yUQBodzFt4Hzhabc60XtB0kLOHWuyjlESgrIKgN9EDKlp693Frb3h7wCveNV8HASQ9FSIjmEcPgxdt3Dk2R5GX7rPiwK2GemLgORXWGeJQORKCCxYVyFkqNZ6HgSU3qF0jfsw9aBQO7E86HGbaZsJY+jaTfqLz7YzTIzbssRevbpu2YqQ+LvIg9mabKxdaYd1osOK5rwju3SNK9GDtzWAnEWyACCtcLeafQQiKij+8kst+7i9Vldoemf9n5yLITaR2uIxmd6j7YKhB7CDexxgmqsKcvnWa8s5G0uioDuUsCQSuxEJ+MVq1o4Cby8NCxpKO9+5Z7XmTRpilCCyeJLxVKvPq2/DS54RXk8uSK4KkWdvay5fJjZCAdCh6hucyhk/Vhc3+0rARptHe+Zlq15hO4Tl+o/qTuPBBVW8KASgo/8St20Ks8FkbMnl1XzzJxXtFuKfP85/c5HqdRp3oghKi+UKlTHzSahaDjGgycL8N8M6FHMR1wiwIm2X2xYrqcch7HVPESyFcdQ96bK4I5uNzJO7lhbzyA5N86yiWZBIQHXggFIHl58MZRyvDCkJhoX6yfpVaM5ph+872YikNMQFe/pjG8HqqQyaiE2gFEmdXwnv6DFHa6XjUZ0wUAQx3Mz/4UJw+DRCryGCD923+5eaOmN7pPRJ4N9kJ62t07ubmslKW1qP2BTRJfppSw=
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