mpeigbXZfACbF53AAnGDaw2Wup5GgfEk6ikseLtHSVWb+aVV32PrOhE1bkkSMTIunTX/653qD2rP9TRLeUhkZZMnX/c5/xkAGI0hThLhv5Obs+uQ5D/mAAQHm9Pw4yUCnIslGYFQQZsJJQsaN2MeCLxKv1txzRa2QFUqaH73s4DjAj7IMDW6qyqEU7nu2zat/L7r4snWrAuaayqK18U9EC+NxfE86V4YV8g0+Oj7zsGiB4re3g1AxWQJthKypdVrvIQ4+PQ/5YSfNbJynlz35vGg+RwBBhqiZ955yYA2amfzTZSl6N6UY17lhqOlebz2GLAithf4EV5ys6JHzslwuz9vBsnYvNE6LUHwrn1jqrEHR6VOSnodCIzkLxZNmLXAQ77MxRzWefU0avrXQNKZmAsI0O1YbaZXAATaI7YH8+/wNPtTx2f1at9y3trRWPd2pDhlZgCMThTFToLW8PE0hs9QcIzeLV++KYudrpDAbePNnYxM/0BYAZiDV96CFlfXYBckWkALPe29dmyMJi98+0x3bUXdsFzxC/CKti2eyuUXLhFkTtfQMwYmCFINK2Jy1gBmB8VXX+2aiNOfGnIreaB3ABW7U1WLFdwbWtQkM9DFsTSyA75A8KtzN29E1JqEo2AoNCNyxOSZOXBVSjEpmmtmbrFFytgoZtdtkdWgQKFzwGXCgFZ2iLlhV0cNHvj55men5txesOhznHr9xPvPEU/sV8CfRZ2zMjleDvQ8tt+iQol4E4XXOSh141DXq5rO2VqNYlGyvHuD6YVYxLz9p7yEAK+NQ31VqteeKyWPGZtSvOLcJyRmFPe3Z3bEuJ/4vNIWanWnraG2nQ/JaQIRLWHjicyCRP2IebmxCx6CAzdPhG00EXD21Jl7lWiXCvLUN7b7w+3L1R2ue70FgwuW9kX7k0iMkYz52x7hvrdYX/odAjIcZLrJoK9+s1DWM2/bj3Fv+X3GOFfDijaTOn+hfkm8rHDKN1yAGMtDD0i0AMqehwZxnd3et/8sgy2dHhgcUDdGJQvkEDwOOKbTmlETAXJhYZex5A7GwO+lsIRnJXNxYffPGrWyXwX4p0Qk7vgpDMlGMM+C26mkkFJqALG2gO9khwdlJNZonAcASf0d627rzZ5rqmqIn/DJMLQAn0vUo0sJZWUtwcHBMPREg0W1w+nKGls/NEjzPmxKc5NqSZ2mvxissARHxI9nhngJVV5qi3I+2Etq3Rk3fwF5XFpAK0eMod4q99igacXRRNIMe9k/OeCbkUylaL+MGQs8mxXZct0Xv93jTeoGIpqBnFiYZNRqG2l3+e3cN0z+adkwWfEtb3PCzLyhHryhA+sQVEJ+q15aU26rqHHKZtCikijQJl/OLTWUCPrB5/0OWzg=
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