x8PU30ETsoeVmncOnYvWfim+oYaixfojQUbX+SmKXeSZ8mhOvjkJjHlD8GOYpZ9CESqj221UYk2tmOgJoTopI3iY75drJwbbg37uOJQYbh6OKfdPngcL2V/ACEeXeJ60EVAmaFbv7WV8vlNDWtNtkRMV9wS6b/5EyE8i4pi5OljC2ilnb31n9OzOUhJbGPe+r6FlZPYQCDlZn3k/jJjn5WWYVx3O0rv8xaedBk1kJfDGmES4ggMVhYOZkoEgv8LuFyyUw5r7uO4bF5Ls6ggl1t0A5SgjcDNWvmaOXs0UhMGlReCEVtmBjaCPUT7XB0dbPkVxVHVFFjNGsgoBTjGf+vc2Xe2lIdoe6bqD1EBdX6hsYQa7JKt0Q+g9FvG1RwfDh1j/fzY1Q5rmLVRcN1x8MoRPxCh31ZQ/S/2MWbgjpGPdSvO0V/k1hUwcSFvfYkMLG1AI57IpQHtGej/npsoZAouKi0/bsPBFvKMUKlArRAwr/VTkANnM5Ft743daNnMo6KwEmlSzPGflHyvk8jEDhT7q7FpkewVf72RKlXSSOFYnlp982f8p4W8+hBBPsGnNCgRKehy03V+KLkOKVvign8RSvU0WlbcNfDg770hPYlceFHOae7gR62Ojz1aPbVt1mfnTVeJLfm690ZNXRFup0ELRvbN/sSMLj8cYw6/M9gG7JbtRz4Darlo53HBrrzL30oirOLyKbhrNE9xF4W6K3z4fdiTXTflvNvTgiBXZgCUdcCXtkKXpUkSBfjdMTFcL6qMD2Sn0qyX19TgL8PLNkGjcQWvIISEHDvLTGZzO5LnzPaSJCk/Y/KsC7EC8H3olawYgT/6XVPqnc7JvEvUtzVPJtR3RgQNDV/Jbjrmvwr9NuoivyNgw8XFTZC0T7l/5JDQ4d6fv4uVUDanDcgZpHU9ANWVIQvMhWf4c2rzk4Vxji5WZ5dFSU01z068JLnn/9+QWwTj2wqPy1twlYw3rv996dTC1SkjSTlAoNou6HjITsLUD4PoKB3zO6+SHpGX+JgrPAOVDlfqYLi+8Fy8J3HREp7fO6YWyIZARn3XTRvghRi5BLL6AYr2h9y2sBJcDxYGXOiQrgNKbPTbevWC3sS0ZvlYI2ZxOdZuBCWfmeINCiM0ftW6LyDa/JZqyzvG049uxKteuPf81CwYzvHrSBeXk+NB+BSdAs8y6XPVAxkxUX88wobbKstbvtdgJ3poX7soyzBlayb9PoNzVfJtBlcEWoFdWG8zS5RrDRCkJMZo67o8hcJlki+ccSjTN9Z5hA6JXaQoSNgf52+uwWevHjLx3WLe7ExAaRK8dF1kQAotYKzldyVw6jQsAoS1DC4aZBlew0chgq1599uq/Crhg2tVGmmiHml/LpDRQsT8=
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