dwHRiViIfauu0OLImGBUuUrjGR3ORVXEXpkO5bSNXXAEcGLdql4iE7yA4AK/E2imON6+f0L7b4O1peRDSw5or9r8//yB6jRdAu5WAPnmqLCy4LMB+hT/LhHjzhMgcF1nKkKyK3tOtBc1uhcycdNOK9XDj3An5cptSE66Ql57ollT5MW6I4AyW1ydIDFrl4LvjEoANXKEGPXLIuz4thOxX7mvVFqciGY6IF3EhXd/FCSkKbLJ421Hrb8sgftoiEJIFPEvKpEhayS5/m6KFExmrvKM/ZQA+ywsLIgcy06i3fVgp8+lDa+f9MU7NeMOqSQFYAks1OTII+Qx6rGGuYGW8K4xixIC10yo8kErVlstAv4VluOohO6Wo0mOyJsbGPJd05nj97uG24z76FIEA3Eove7aUhRhfrKnlLgMCsiEE0UL7Jc5lJeQKlCP2FlFA7+dvqnEBIhvZ52Xgc9mprks/8bJ3lr+d/TRVpct2Xq4pSPgflgceHAUjj+cIA+RplHTea5y9FUp0euVW9NhaB8HZcvzAxTuhYZWhF4xEOoxETUgV+s6d+RSLHzo/0gV46LCBWZAlywjyo/4mMsMHpKyq+mvU6JasvezRqtMg5+6kpKxhdyigJZcW6MQAt64YAQytxaeNYjvQRkBIZ1NoIRdxiSyes4FN1XlcKxHLbH/FZz4ISefbQ2mPw1IVaZ2ZsGpMsUB9d13nEY0LVzOeMNaVm8M2jxuXkcl7BpkPaRGh+VkFB3h9wgEuwdhugDjt94oQCnhUvMEIbKqFB5PKRzYmLFKTgAkfNgUFfgqToataWsSjJ9aTtLGMkIX9MBQ0C84/rQ6V/oqS6G+nisu+nLVqKSWK1K4V7a6EhFzkpex61ckRRDn0TlWH8iAWiHJBUYk7joD9ZWa9I3+IE4EWzI444PboMTTz32PhZng0EBrggeopmLOisELM/XRSw/jZis1N0tmJpk/ytABVFqFNVwkPv56IYHpbEpTU5Yz4JL2QZAZh+Mu7WEasC67ctPEhTUIf0+X4cyn1/578G2A2ZYc8egwobVu9qLqYB6sVG8W+vm0b1E6s62a10TiSFXJP3jKbsc8h6e1bMquR/zaCs86AJqDCTp88+eEYqLLWWlv18po5pyBXNB+DClORCHZvy7DeWOxAIoaMqG+hx19+OROwuY75zR6In2vdJGY804qZuyY2zfBSBX3LmrUt435ARtL6eVdy0wBhKp1PrXV2N/WyLFoA7sGKTKl/H3rl5uqmDz4NzfJhQryrAsjmNzBiQkIAe9hJzDQ2kbH6zgWCj2hAcKWfHtuCOyudyNvJ/qVsMx34FRazsfGIVSNcgNMuLMO6+Uuw7FbmMpm5RWHMJzz44wwop9W3FHlpeUsjRA=
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