36HMvrbKJnYlLlmnN2SHRR3m6Qa3OoUMGc7kpjQGQ4VRTKWABHZ8TYBnnE/3C5uzSZUJ4+VDebW4w8UbtJR2MCO/k3clonMe+62n+8Z/tiVQzCB06yMmwRkYR5epAOY9fZGU6lGiUYRxvoVdbk4vBOpxOj0xLKesOzPi00W0CvGXHXSzIp8Xzp/i+UDA/RUJDIS0iSMtssN+zpZdZ0vTYeOIpFPHbXj/tICD4UCvCcy9mWgDjCq7IAjAcgFYJB1vbEcIU2fRusfzIGdcQnPeeJIsmBA8Jm1GF4jk4gI+c+D4OvEq2xU1ftkgXT6owST21MrMHWLxkxYAtgmq7K1BkGaXEkaOaxgwjCqTUqjIRirTciiYMlwikBwXNK7jgHGDgh/C62y9NpqtPZLu9kk6PwZ2E6WYWKWFFJKNjynIUDdHt8F11nnVcTFN3QADAWg7inUPszXShNaoD0GSOLex6hr6AjAQoqjxI6pWJTqZFwmfCLKqmmfScC0w5rwHstx78npT/ZJChuqFH8qkmVbKBE4SRIvazAY35ZrM8w37lYUInIbUXKCTGLVLJb21hnX4sKMaMT8kr07/bzy9UQ3RdAzXMMRf7dF0ncBDBoSx80xYIvKkB7OoiS4m6dkzCsTTrgkI/q6O/2Y5zWprEyRzPmZzsZ6iHYvBFqd4p3fSDWdBrSYMGyZlNXZ5/ab0Ek/uZUK9wfFlgLGXnl0BGBdG8OFn/nsZry79j68wQEuJbdm2DNsm4T5BdrJdYyqjQ0aIa3ZrhEednL4v+pQTQF2sCUDbe30T/zBGuSMzAmeXZJcfqVkgmFgNsli4e+WdR5Q0kpFA9cHSyisUd/pQODds8dxUCIt4+TknHugevzHFiAaTrtzSkF3xYr1ly30wYeWtucoA7wMyGnZKILb1IyZUQonGX6ZMRJ7pHYsk/Tb2ENMa+bJh+c9mMa1yNx1iLDGxNwfPXLm/us6mBf5w4o2jHM8LYyCdGYnpEOVV02o2EUDXFXA3CsPsxLGVMs9uuQ8dUY5gUDSMS7TNfPSy1v6IdUOcAhqAof3mucNruM1Ta5HJTN1Pc0+nW5dMlisUwqdBEDSmRtVlkZpVlZWW9cXUMDBc6D4wT2UD90jJ9hvvcJRC5s3tNgMoh6SZm+ElhPE7UEGT008kQkWcoPYLSKoi+WGVht10tNmf1L3zvOcWh5RsmPyqU5Tpa02r68if9zQ+xBT4loABa8ZHp5PYVcYGDE/IuTgOOXYGB0NbJ/F+5G7EiEanZ2ru7lKMyR1WclkxWg4Om97Me7TC4vFIIhPcWYh8dIA/7iacNismv4CtpFavtKTTpRWVaXcgf6ScO3bod7QxuzmkqRuK1YuLKv8BxTpcuFEmP/8BR7EaJAQ=
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