6MZHll4BM5xTVuBBPDTe9YL4/PADkdzvARXKhZlbOe0VpnU64PW6bhT1ariCSwGDigFmWclRRH7qYbFTa6y4p7Pz0KiTROlA9ReXj19ahvsPDEBlnAVPa2oTt3Ycgyjji+5Fl2hST+TkADYboFBq6kGlsrIDPGGqs2JLERo0DSaNwtBGLOEiUz/2jtIxLFhczCur6rEj0utVDWe7WjH5U77AejlxPm1XQxhEUe2cLrnGIhide7YtPL3Le3W5e2/Iukx3KgFRsalMOayuHIcgUA0x3KbtapcSzR0npqsKm3hfiAoQcJqhTLYb00B73d1a1ixgnnD2ujDNabdWnj4xrRYt4NS1MGDtdAlIZHI9343+M7lp6wLttN43VSFSg9t9EaxVL2z6OUcVTLN4FSLg1h/r4c1MiBFoARkD/z0FsWQoDknGgIe99MtE+Z3SSZmSTQ4xArVWF4AOYleJTNp7dBXPeCIw8WkJq88cVQFJ7BFhZidojpr0gLQeM0iyUzvv/uacX/2i+FYy39el/6jr1A9OA+Rz0gewgYs3n7mzMOQqlRP05n6bJvvmRTVyFsvAMpUvIxx9yI0nEgWrr+nAA6rFkl0U1HOgr+Ft9+lxKNsI5PDz+AQgEwnbMxdWaumLYpda/hivBrQ4I1Lt+8K6/M5ByGeHrw4sNk5lyoMDz3OKGw4UF2EeeWuxzpTMiOW/Usq29ZDZ+5BjQuVDO1phszEh61e9IN5SPehhjRIF05ywGEUaeHs1/ZjAny+ofEG2paHsuT2xjhPV7VIWVKdPf7vppy/NWlrp4SiH3N/MukIQYJQgF1FrwZKFdf3b3Q8loAr9STHeWknnofNWUJ7nSzD+OipDWAyoj74Sl6wyoE2v+Aopyt0ptt0HGX8hihnsnvnHDpY4lPUzs+rIslxgZaO+/GjiO1GB9bkoyGMsvKICLRxYmTgdf8cJOmZeAU+M4mYbOxUh8DoYnyVgtW3dYJlbN3ZPLMhr8GCCt1HBqH3Jha23LtwTVydg9jzX0j/SZ/btB8C2mxaDEHSq55ViZxxTN0P1fsDNaW4nmmHL/gYV5AWi0x2/lL92v4r96ut65JrZ2+jEziT40eZA08FteAeHeUPInnJH+WGTX66Op9Ju3JwrHVFZ44HakBRbo5urTer+3wtBw4YSvQMD70/GOXvfsRJqHOEvRTs7lEFtKVqBTqhKExWqhfGtt3DeXzHVYbNUTnQMCZ3Gq3OcO/G82RlqnFBEPlEpCpj8u6cVMB5fbLgeIL4aKHMBG3eo6Zxd3UBR93aiaMKwqqi6596tNPNGYq3/REogQHF8ERTZuruZxnEJJEgrMTmAW70TuEvPkcJLLGq2gU2wBAfn9VAzCj/aWP/xsuJ4keWW3+Q=
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