Igxq9OptewRgsxTgDT5oqm0XzDBKGI4bvPBNDvSpXy362HRqWR46tlFKUGFx4QXXgT49hSogUS80Ul4ab0ScTXrValyCseux9k0z++Szo574lj7cVCyRb6uvua9B6NBOhKnrXbyQeW5MbzrTx6E0f0MwgDGiaxFKu7iswOrC4nzeIwYExtI9ugTU8tgmmrBk+Y2b8Xyo3suz0jyvdPWc+W2BD7H+WUXWeJ0Egz1VNhpypuT5Fphc+vD+ZPvxF8Vfq8c2nki0/Z+Ve8bnemLHJICCNgt1K0L7KQoyU+hX5rTqkRuryhu7R96yr1jXWVDxpSSTUoCu2ErAn5yP1j02oOPaHQxru/1pjDg2GKjyDlOKz8WU6TVpbFEbU1B66jHu8YKYc9EpYkoM5d+3ZUwd4LEcrzBY5/oe8RBSox08qDa3HPYC/RGoc2jK1YYgjUdZbi6HyO0uRKANE1+6KctO9hnu8vmj5mSrwQjXZXLwt4M3pglVdQrmnivyxQpt+K4uXWdhIqTNoc8lMrXaYqcBvVYXENebt9IHCuXj0vXam7hGplhpbfy9cXjSlrcZiW9vief2MWHYawCf7maPhAXBwkXCmu1Ny9VjkyDpsU1t270DAHc1ST8MesfVwFzzI6BW9OKiDz9Ka1dgGVh8HviiGyaW22i00FdLErtM6zEoz5RZQOXvq1N7fNlE0IdeqA7kQTRe5a2HTtd+WKYxFigUXH57Dg1QeQCWrx3/5Dob4SlMXBZu1MzwAs91ykGj5C8IQaf+aufU/8R4EMShzsI8w8+brhw1LzcriakJW4BoVu/uD6R9YxhNLajoyxoAuIxCbWw5GUlAsjUPvkdqXzPD8jXP6McmdfxKQeJif1sB7Fpp7W24wzNuOtdcRrZC8y9VRdlM95mtDhgfYksWm5yAgJjs9EimpucwS5g9pz49kTGt95mimQsrd+31v57vc9bFDBjTTG7zvqyj3HnKCjJsuAwZO+ViuHjLVbRaGQnHM+6ebTq263GDPkjw9NICf1r5tOKHYyN8Ypve7N+/9Us+Po56sP+JTpSBmWOEmV4llh29Z697Y0Ql9DJ3E46+FcdPPV9w3YODekfE1lglcE7q1XDID5mqTnUh+WvXWG/z1iuzstePkssmxXwoAglC6qmKcCt4NXmZM9Y4O2psb4YHI94SnphsR2WGqv9M6kMk41MASKl6ntcUalBxCxiiBII8kO6UnpNUXIJQxKIIS3Fjxp0idUk/+IKqF3dfyiv0Gt6QGs0W7V39Fw5NDh8Wawqf8aFai13Rb202GgnokQSegjHf/3YB58KVxUoa1mTX1i/T7MtOB0HIqCm+fdS2C2q+8pfadGlll8JkQfzzycZNDycrJ8Dhl//qpewpj4Y=
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