77KqW9n5zsQB8eGAPDYY3ohm1N3i0Zdrk7h/DbRBSSdMjC9MvnJ9lmzt6wYWdEPF/shA3unHyYI1KkAk1e2gJMOnh8maNZzxOh9DVjhs/TABmnJZ3S8fgbFn4IkIGAbO61fQ17Xz/jEn474wcknplGuvm7hQa+sCev3xxgPAp63X+bGbjn+qaqHvKLSLgKPqF1M5na05r9MBuSvkvt5fWFZI3Pr4d5CDaxFHXQp/I/bXAQYxceqNFItPAMIuB2RJFG/+zZPOb+QrQn9/i4Cnmb7f5gNUZHJLCW0wwQDbqRA2XCJ/i+qAYCs/xUKGI/AmIOctebdoAlZBKW891vVbrLlapz+69/0N+QRueFV7PInvoG9vUqVusDri3QyutAkGm8/minut6HoXtm/PGNAP+3SBq2rcxLYaEH9g18pSIsIuVIV032pKiZ3nh8l0DOICKuv12IwR4VVtD5dY8Nb2jAuw03L9rFJkyAF0/lIVO4AUTurcrutD6B0yOsR3ClJJn3XoS8XXUYwMrHhTA1b7PCuMlyBQJ6KAItzw+6kaGTqUfkfRaJkiPVSkIXuMZP+FX5NKuxopWICbhtA8IzSIQbo4aOTVim3RcqN8cg6iyhbfeHpinH3vZfCjMMafgvoahOB37J2mS0nXimhgY9mVikS3rp/orkxoxo/AjySeJFePlHBEKwf0SHronpBvJodYVdjvq/gKOaCJAjQZkWG9Bd9lY9UugoQmTJny2WvUAXaLhgqz+Uf4W3BWqNpeKWNbhjfz/OCoVbgU8WsJ2xzyPB1v7yXi+Syl4/e5ETzErQ4ohF0oYpZdwKFkXy01e1YYBDC5xltbOr1Ik1G8BvZsfSV3rYI20zepGFSYKa19EUOaXeuAdXm29eCB9Sq2XLrMeHtpIsDB9lueK7ki9C1NOfHGQXyG8bq+jnzuujZ7HiP6Rrh0dfCVq94D7OY/TiWuz0MkhJGP06VAdYcChQ3NS/eZ+NO7J6IJrk131bYCMJhmvpvDv4D9c9uGErIhWbXVuM1064OGmSzQ/68lsIYMNSDN9LxR0eCgNOW/qGDB2vgnTCuRz4iTsuw898cb1Gy7EEUAPhWHIy869ynw942pIkhHCxLIYCrd1MUUokGRqFxuRKVFaoiKUs0p8SXHEDPq8IwKael5xCCnPHP9S2bDo5NQY5wg5Gt1jCe3elb0l1CERbpplu75WqSfTREvpzMHwLJ8eRBkM80SoMhMM9Bl2Ed7ejr9d8FeMWItQwtBM3vqK8Abp2wLjujlTFfbADB7nrvgGlLawV7dyEgCOT666Sz+Vp+CHT2WKBxG18fbxGv94SZAVO7OeCjlEvDjLXOHHsRBNqggVWeGAJuPz6heT7Mgo5lmmfTsitUF00A=
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