M+ABtVnZVuyXKbxx1uUbSd3R4PBcf6N0uWaIFYFNghJXDhwJObItictyWH+o2iv0gtLa+9i8q7XcQMYJE12RF+W4S4Z5daaZo9eL10r0BMLLwDrC97BvRknpDbsEnQ6E/NXDCJfbKULer1ZQGRDWFIZhBRR2fuGCyLZyyWbfH0t752HB42YqY3CW/kdkm1lEe0SA482jhX3qakeKWuWwrrA3U7ZHuZvhRDdUbWlcJ6iO91UM1fBMAyeSvu5deICGZIpX6R3x1559DZwRUUrxRfwenxynMZLdWlJ7Z1fTd8mMbds3wIt4Q3qv/K8H4Q6Ua8/6pk8+4qpnZbCUxcd+PMPOh2YpoCL9lZFtauIV+7n0UG8bf9185CHqUa5rJ0dcIf4yu5Hk/xFdno8o4dCGW+IviilI+fJpdgDwbgOtNXZPzvLHbEYAN+hNnSnUZZok7VkATMjPVU9I23qlNy8vhK6ucbPp/Y+Edu8FLMjGf/IkynyrMc4FSvMVSMHk8kG+tUtBS4AWyhoLOqJiC/mg8WVCY4O/16Rw0cOuqsHpWCGRIZi2XCC7A00YaPm/f9mv25LecpYHwIJKMRJdo9UtTHdfIrICEoYpecfgRSUEwtjrn3ci/82FGzCTPn3ITSXlFpwv82J6EeWko9M3kuvGIkdUhCHtq8xiNjNxQAbh0Ty6R/OT3QdyjfHR48vrUel+WOQJH6/VNApgdl1UdwL0ts3v7g2gcNvlsXu3wubgqQLlMlERQ6wCVgdcxQan1ZaBDcAduC3MEfaw0WYiitCoY9FF99Yy+91A/Q+63u/ycTV5HGSy9gamOYKmpktB9x/El8fdSDc8rSpB2CCi76QE4iacZNyHTxAJ8qL31pvpCVDH4FjMHHl9dYOW7ZsGns3uO2aHFKZZ3FDexJvVbXnq6E5Px+30b817FPQINbUFQOQNkQzCBAe8BWQwIrprBynfHVHz3kdKNy+bNufF3zxmbBpGUNQ0n2y9DvRFOcuRP5pZsNhOJkTArOJ08UJysukvsWCTZEdP9b1i7K+EvJ2LiBdsIRyILfKyD8ltupTpEqMoS0rKxdsykOeYH6NZvPpsei1v58GBnbUyJY3YGeNs18BNLZPXPfxESdCjgl/mDy4hSydsb3ga3m8Yjyxr15rFw+rg42tHACQOIAI6h0C7ZbafBaLWTQdjI0Oj3sZi75F7wh1wZcQi/dHjNr5/yW1lFoTQq7J8sMrSEZdbqLCX/GyBf2O9ilUJn0SEnTmW5r2lERec1lnqTEgph5AipGIDYQFv6fw09TKXnx6sNWQBR63PhzsOE6AAtSt2UGc0s0OrZpf81gSG+34CfHWBivdlDiSHd1qALFmhR8MpTyWfmwv63k/kXAUcizeKjTM=
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