iAeCoV8aiyOYRttpCmmj673wwJq/AWtqexVYqwEwhFvF19SkPNzoh8scg/GU/yFxP+xAg8OroKkPBu/NJ2SlFxYRl4Jo79duJ6X9+GPNwtEC7buAmNXq4tD+ZWetXhmBlJbQ5m4YjeQf+z4GElH3rFx5A6GtK75X3ppXEGt8vZFCHWVYt5v971QjKFQra+CmhT5hX9DrqvdDj+Tk3OvB58uhy6+q1StbcSYZvvF1Pk4r7Vbryo9GPp626ASQ4C1/IZThqlmZ7SPBWk+71dJvETLT7eO3AztjKli2fzrKb7xFPQy+R79dEVFzvRh5jwK2OJPQ34npR6pr3u53rMJrkDth/AlEVPNpDmxtcxagqmVHmxAPirtX9GdUk14NwKzAis9k+fj9C3HY4K1jU0QVWHcvdEByB2Un6e2F7WeO9i2m+RJhP/IsOUCLKCcbGG8+2ffJS3LDiiFO9hsVpHA6DeOlg5nT+Ef+BfRnTfoOtyKPj87cRzvyzTjEMwVWAchuQeCTmmZ0VXmH1kQZ3iZoHtBG1pyjjdjzUH2MNc8tQHUAFnp9i29vFiq2YILd6QP69uyVSoi6+RTlhGjAFRPEFlnGFEncpDNKiZiaF0WSIUPgTmgOogCfTs+TCVFh25+VgPB+EYgydJUQnMVAXDmQ3u8oKmaJ4B5/qWuLSHtgrngR/PQZ5sl+Iir96vgcZC7B5ls6CLapbyiKae3INN+dGKVKttr/TnZualOiXdjn3AZn91NphCjmmufuC9mbJHFDJjgoUMOy+f0IunrF7aifE2v6uG9Y0uR28inOKH6SszxzgRegW7yMoTpZbYg+C/IM/sZBSpm9myS5eNoLnhwvuyn1qpql1xnaYrn3AE7QjSb9NPXKI4iEItKbFti232FqbazPBv0Yfwz3sP3O7kKavMuK4TLOFGVEqarcn4S4RiS5JLV5Yt0txvJ7XmbKJ8H8+Qo/fI8cJ3KaUKHDgXImwKS2tbMK8NWOEPuclGUBtbksl+awnvBXRBKDpNUMLwdiocHfIuvVK/MpJGoecA1PM9CWIT8nLua8xRusg96zQd/CA8/DID4SKMpLy8wm3lTYv5fWwO8dZ+22i8hMupow7aMsKbfaYpYsCY3Ew8ngdxjDlV6r1Ztkfs+B0LBEC1kwOA7eIc0ulxZHU6e/MBpZvTyz5d5dfAa9TWgC/sYpasmp52mQq8dPlDgIvcXAaZsK/7jEgsFzVeEEXKkQMAv4wsh5MhFvzdE6Wq0ShWUiF57A20YYi4nnfUsxsJ8xMYbalrMuBqvy5g7xWOCeViKvyoarfxEJQ3Ut2AL2FWf7Bdn/lRatcsDnmAG0rHsU/hk36wZrOS7oN+2G+bTZEXHhBNabFuoWGR+ykjUOKSY=
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