pknDWWVejHhshps20pKoiZfTnD7m8VCLhOQnbqWRi9Nfwk35iEI+gpvtWbXOgHxL6DFYTZflbMCxmDwpPALq7PCG1cUV7tqF7GMJ+lxLF9lFWgz02fgkQkXPySvvBRXiK3picxzJmBoazn1aVrwY2fjiMFHqOHDFfOfDKRJSrUIBjyHupsB/c5UNVgGijv9HujTBG6Jx7PPhmcd2R1XnjXmGisYSzxANn5+64ReUZLH9JAe/RHdY54j1gBqw8cLQajSwXIUvrMNNEJ4uwD3e3SwDKfqjscCjXm7/eWbm24/Y3QRDyWKyqNkcZfSVAxVM25YOr292uNbSqGsl/AmDiqWyCZT5+tF4PBK9RLlcHScYSzKedf4bCfw6x9Oj98zGQK4vD5RfElc+hB1U+doKqr9FwpNneDlp401i/5gtpKRcm9dBlyklfAts8mnwXIX2ktVSkntk6GWREGubkuHVcLtI3RaNtXakWWXFX+iCo1J+yYa5KMWILFlQi0l/lyh7dAeNCHmbwcKG7UX+s1Wu1tZJiiA02stvlXdEUIiSFlldF6x5/hQkDBSlzLr/OFeW7Qsv72O9IgO5YU5WdO6Oivndn9iSU32CdG79QPBOm7EeYcLJ7iOJS3QtM2wSxFOVKQ7HUcIjc4NKO2nmdENGXv9wVdsn5QHTd23/zW3tjR7rI7VMSoDMBuP3ywMH9+5MSyZu0PS6O892Fqsq/v7YOsIa0mbadKPc3t2FgIUpTQcl8kXOMRwOTLyA8piz6ExDBL79Q6hmaVX/UylZ+gk+fmgzX4IbWS6x481sNpfUbeLmcvGeijasiV5Oe+903+6DpDJB/hhPmJoSNw+bFD39ZMes8OahoGmEN7YkiTVCx6syJ01L2PMtc67kAR4a0Clj4O/uUYax3yfIhejzl1C55BLPPE+rJltJDU8Zxqfgr6wLNRxU8063e8p/2nAs+43qSuWYKYGF1D+imNnv8ojvybM6rF/QsgwyT2IYsXGq0Ywh0lcuRT7m85Csq7r7jppcXwX1OcurDWt4YFgFZotNj7+RXNZe60JBf299VrM/xaiC1sYAQJbS3YE4VxFLEQnl45lYswmxB2IwcjlrzEdPiGme6do30G/gys6xa7/l9RPFCV8K6qlHJk7kugpVvgf0WEuPOUdgi6iYMsXuDIhcEkZr6THuzUel/7YxFRIQd/wrZIvHz5yI5qW3pKy0ivg019/lmYme0j2npwV/D3572de4/8W+CHrsFB5bk90+5YiFEQo3gbW6crzqvUqMjA0pIz+AxrFkLZVJZU99B+1VdCKGejtlOpmik86JWlQS4n55hcq0Ju3PrcHKudPZlEdMDkzpo+jbPJqkEodt6CGj6q/kyfjhj6ZhU323A5g=
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