3JlpSLsduQKqOj6f4qlQwC9rZV0z7JERxm2GfwurvNVQgZ9zgnRCDBH4s6UJF5QGpGR7iPbRM4BuC8mDHIDEAt5lI46eKAq25/tUw24o2JLWxuw8BAIkqLvwGiprRt9R7Mq8hbPq8Gpgb/X6jwmAYWl8ta1RclX0WGadiBWARt0ildzoel8tFpDhvmL01+hg1geFo4Z6M/KVM21bhUkH1WI95+dJKgrWCB9Lj7iWP5BS8faaHC1S1wJ/vxK8uAhl4ReNPtyYr65ASeiXwexpPvJswlhgdjPdeG5LIe+lc9WjQyrnnCfXGnLehSRwaC54NlXDiRhawB9zA7Gp04kkTs7PG14BgMw4NOHeGLhzC/7RiadNhC1uhdWIpi1parBJRX9qI4eloMbWt2wAcGSB0FKMqGmDFx6vkARwNIx6UB8ed8cUlGHg4qAseMHY5r5C8Nem+QGk0Woyftm93L78CqB4F3ER04fLD2ar/q4p6rKQeJlQU3zcfi4695f4CGXT4hemc0VO8vl+ujrcD9hE+CbYW5hjqt4XCJaPaX0Ki3ExBJ8TfhQD06e+8HiZny8BZ1NVbcNWk0nfFDrtmokuMgAvWIhhk2ZDrh/cX1sLMjEN7CfeeuWEJ9GUCtJzbSVLigFXqKGWiCM1VcOWGVn+YFsUKavq9DquaYc8me3ywpnuv+d805P9tizvrG0XxOp0j6WICgJsAhECDW0+3OS3RbWdCN+jWSK0TmfIxDp0ERPnFOUTfGjfoaTKvUwORArWm6tVg3vx5MugG2BIspcEJpQ9JhzYv3qyyd5SjokdQcd6v5Im/ZnzCEZ8ab+lM4jL3blYYlLMM7LorVJC/FXuNa6TIpr2fLF8GuIOqeTpKUVqnKAAHpqR6l/Btpdl8V/GPPFkX3p+iIdu93aZh4JfVc/a7nYrMwbfzIeF2xWFRMmio9gnMLxbmt2mQTJgfN9cdIP3x1rpydQXL+Pe1JGGvx8LxBEQ/QfvBEe22TftH2C+cOM0yWvxG5o9NBkRr5ySsareVXXujZ9mWxHcB8xOjV+jMgA5OuAxw8ff3aZPsEYFPVEJCoHBeqLRUmRWO3uCBrW2NXHBpRxdloW0S4upebc1UZTS5rZkAeD0auoRxjhxxvKrka2n4Bo1HlT/QeUKe/4DyDswUWIF/3vLSXsCI2sYG7ilhykvSDiDsXSe27b4BINnwJDwXzldWMQVuJXHJ4oJaIHmX9kXOXlLbxewY89iYgthd4TRZvHpFDWr+6YK9z/Aq2ZUodt2UuB8w5nnEuD+WdqxjTMsPZNzloWupi7xNXQdiCMvIno8QLmcAOWjnNgOb44y+W9fX+5f+UjFbvROZr2tJBinBrbkQHrN9RBZPLEbqFwqzBEtEFY=
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