vo83PtXtO3kqfha6n7Kt3hYn34Rgg5q/79XrIUuAVfHkBmCi377AaZqs0ephYmrrbmYkcgqGZwSx9HBoFaFTHEwOFDG/fIXSgRYzwWPGT2lD3G2xT3ixxVYPXfKpRBPOx4/Wg/xHDRNkAP4e6hrTR+vReH8rXSXGcGUJx3y5to2ffMJQIfXUleRHTJzj+iiR7sEiIPnhjBKR7/6Oi3QosDB1NHDl2gbrwQy3dELQC3DWNc/UrroHcdFKesOcpiGYCyEFbabY66uQ0d5YqMTM8EBpdPBg9Tqio0uCNSr3RZEVSnwtTXJO68cuyI/pEpJe5OCjUMmvyXRtu4WkEP6fLOR3QBHVthCYTlC2pVe8wkqvp4Qe4cAM92uGAMxwHWzxQexNG7qZJSEopTgsGOcnpDo1Kmx9nKWSlBP2kFGW6uMpzJBvyhZXSdku7S1x89yjNhGN5v8eVVJYZ7T6qP/f54flUQ2wnInS/o7uAZPHCylP4JuNhrTW3ZHXZ458eqPWztCYQ2EcaR9D017Hqapp/Dw26pz8s0x7NnysEHynUoMtdiiHCJZnRPDX2GG+N0wP/cD95mdG/wnHX2gsPVECEzmBmdg6I2KlfAAJZlQTYeB1qaPu1/j7GbERWRTQo9X7/XmzznLD4Wt01Ks+uUXb1d0yVrAe8mSa8chsjT7NfqY6QdEGahQKKZD+FJRRw+H5/ktB4CDQo5zfsyANHkiGPQmmuZFXwhrRN5ZkClDtxczMn7w5BKygZEtXs8yPQz0yky3HhskbsQPY+hro2DZadHGvi8lPRAKEPb2I6ozbj36iNwti6zaPFtXJ8LlURqR+jBblWOnpDUYXOZLERLdHiloEY1Ax3PAdCII0CJ3FME34Y4nPucsMC+Ev1SsSLR6Ey60mb3jyeOfYy8iKUhD3O30QxTv7gR1RRU06LhgJIi88fLeNINrlWKmXhr/4yNbzCJ9vdB8L9VfK4/2J5TxqBWEkHWhTOJJwBo9K13HdsapBjzZAyvvXHBKAbkMINMxwYB+daoz7vzRabYJvR4thWBEgvzYgUX7x+zrRdZFonpiHIyxEKtF4YZjvMnKSkXsHcl+JJR4ZNgs51B5qlpdrSpEaBJTotW3uLwzBNu55tkGi8NnjLg8xtv/dVqI0geHHpqVTAiri9LPtVLfT7X4BA1IS0eKhecx+EIgoowI7gqAFy/3eYbenpacvW4SKeCh1pRYgM2WeWwtLRKp2OtleLqrFSdk9XxAa83ruf4DgNVK0JHthWzRqDGOLpHqmCpeT9y7OSNGg96huA79X4Sucj4ylrmHjK1NqYM5G6NrVUU1mMYY/HKeQj7a3YEG219gKsB730p0kjPTp2HPsvNaHuQ0ESsDxzTtjKVClFo0=
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