7agaSlrCHWtUSMKKJcGHXkjrUNJUJ0TpFmKBE3+3ZZMvqytKlES6Bhkqs9WPyRNID2iHVKIqD2rY5ydKsptTZBqPsy7EuZqXXA8s/s0P/4cnqEXpAr+/VXQaEgU8fD91f3DA45kuYaffB2OwbAMpvAhGO6GnUmOEAED8sw5TT5KuCk/WO7fT95oVKz9zZ69XbdDHYLyTY4XEQRcdZMwD1wzh2/+2MhknFdIry61SjlkdrD5ZoYJcqnDII1ORe/S8EaxxGrWyVEY1AaPZEEHVkWWUqO7JJiAfv8gM9JkfIS4GL5pxeEOMDdmuxY5Qfx2tI9ezi9CDeTyr3IgbQQ5MOiKOmdJo7m27LS2ldLs/pJ8nsubpPYyObgmxop+7cy1dtNkvRektAvYK1ck7Zd3+gVJHXmTMfwWtX8/McLMq8kxm5cKAMO4jdMO0d5YXwXueKdNTSuStbJb5Ya+35KvNn627oUk+PdlNfu3XRxjoBShJ+dP3y2num0RwG4GeaBsUWRIyZobLdlcXROpQ9LPvdeWKDP5DQIURgiPelkaDHP/YnpHozM8wKK8gQ+zu1IC3S7Oka29v3yGkt/CWn+PFLbBZDvbSuAvG4smG5Oqo3IB5b9p52xpCRLtJyUn6a+Wjoh+XdTR0TLp5hnglJFCpc7kHcBzMOTpKaMCC/11TywPwJKbp5FREkvkzMYXG03JGDggsEkI0+Bf/gOydo561m8T2f0rDWJFn+B/vIKm8YNXA2YibpO9pX0FXrEqJPPqHwmvjrO37B+G2557jSHEgFYq/OviXDCbE6h7h7ikQUJMPepdu8i2SQ6aKDmIfCJJbR/8jZnl1XEq6NG0VZY+NqavQCFxLvLP5Ke1/tBe4x8D0ANEUjoE7soVN5H9laBJElMFKS6OxuLJ6L1OonUq0DABOH3FO+Y2X/QohNZQGrS1S6kyo1EHFdZVwKiT3trkOnD9NCpQIYCDOIFyJDoPlxj1fSaDc6Ja42EIkMYFSfO6+8kNtL/eU5j3YzWvRqbxD8r/ANoX3qPCdcjdgpcARdYiPh6WZGqX53EBT3o4JSMRaqdyhgjz15JX68vxx0I5AXs0GmhbSDo6tEZihbvRpXViIx96GgRadtsi0jJm/xFDov+IktEpDyoVqxytqMY/REmoGcHaupc7OHCz88XywUK+gBr8rfQfVohR3I4qZWtAhXgoEaB/rhwAKG626CFlXtkvyqGQAfexVBWaqHJWIXXzAc+knlwIEGKECkc6srpekqmBF4f52nUseiUh8rXbd7KQ6Xd2BM5aiq0gTUQZMKILTNYcHLhS28qh451sIdItwVg+M1GBcFx5kzZjhmjj5L9kK+r/C4YgB/FkEcaH3PO+MWj+7mctad5esTu0=
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