ax9g0i86UVoe6BmETHADAHy4Ki3aZS7Q/ySb5MTr0EXOypq6bPlE1p2Z6wT8WEXuQVT/Q/dXy/FzCzgEc4LLp9o7kDNxX3Ac81nIscd3o6NPEnsq4MhHjOfz+g5sr9zgQ95TX9qWBzQnhAmUulQvwoT1K/nhh1wvCyJ0Lm8qpbFGtvz+jWBo2IINcViCfSkUeexQNB6s3tk/I1aSa91u85R7qoFYecxaO6Q7q6QazXcqzyKlw/TT0lISvMiwA1Nwon0gxd0FIR/0H67GGidHXOJ4fWgTDAjiQvsRV/NEtUNWHgkQNKD/z1orxekJc5uWuiwC6TGAZ8/nu9nkp8IlcTD9DWyV3BUY6+caTYCz5yIluRUtK87cdxHsXObQlRM5lnEsnV8ChmkdFNBAJkia/LuE7av1Mj1iQ5YTY7LirIRnYUeBn4QPWBp9kyjbseFHVOOJtHv+/0WtJ2/TrOGC6axdamUs24XSIgdix4cM5nnptBLh4wTmtlgYvcHrNWs+acVYPsdu4DEpVZh9bPsShbPu9SASPBOIC+1EAzKj8K/kpey+Z9PiwHJJnmuyZGDkj9LcSmkbaC0lHddErdMcqBSKPwSewh/k2t+4zRYwoEr9Y/4+Ru/hSd0gSSptfhs2wH7+Jogwc6Htyp0eXgMb2WpIkE/LcnQ0yu2ayiVgPJ+IjCvOPKadA9e9jMiDoHTdTnklOiGfaY18umAquZNJLOwOL/iv9gQmei3PxH+sV/ZOSIUPPZnbZTSwHqyia4qc4NppicHKOjPq0ek31Gn15DKA+fZpW4WGyJl1K6VHnULS25xGQZkz250diyR0HdoR47o3lVO2PaUzXtp22i75tV0qdnBSLhByAY8Zczt0vNoikLFlloee2ewhEZz2DgU0NG6CyI2DAvXH/EKcPp/gvsZnVum/lGsQHrPumIWR//gxxIEU+mZIUqJWpBz0ZkuI3LU8YLTL3gc9NMQp+td90WHdgpqiyHfllytxgIqsGQg4/MxZHd36ei2VBzGIoxifsObX7y8bbl+0y+UEBUlE7orEueJTP8ZQxEhHNRDv8qMTK1MYo7h5TtzPACGHWOCcLYXL1WtokrLIVlW5x5/fydQB+/b+xBQyQIa4NA1HorDkr4oMDKB0CyD+YcOLhrqbnKIy3fFcr+R4lirfFMBtoC1pHC0FQrnYLImuTb0WSVUsS4OkbuTBRth4PR6Pp3IOwudzqEMMQUap2xsTMgBoXVp4D1dwRUqMwG6Kxl2FIffyzOzaFPzPu278EH4tHEMUhFCm3d1+kZcqz+na+/G8wkBgyndxkvdLckcPrIwnoo3wrLRQcR34L7qpAhPV6rf2ESgLRxQHOk2IeWKOyxx0WBHUseG9dYULKWasyOk=
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