vHZoXuFE/+H90imnd5k3tRHf+sZXsn7XNSmgssfDED9ZTbWhj0LPNLMYIYipdGDqZO++c2SnnuYk8V5/35DrHAfnHGOHeoVdkKA86ZQPDFjtcmVsSQdmTsK0qciPaum1pnLUtALDuH4E/WepUkbf0sA3/e5Cv0fBOSdH5A3m+bu8uX2DUXj+2NWhYu6Vj1zApbm9Qu4qyokIOBQuJiSYo5cMnBM1YbuMVRpvXDLi/TJdPenUjHHEpIpQ7KGIitoGIa0PmfLUBTySuSxpGrgeif8ov4DXn4n/OEFQh7Jj1poaiDMJHvX3q8DV38zihCdqUXowTcxiOwf8VLOH1lZ1OzXatJIcKS2/lhORusTKgELi48AKTtgW6KfNr4LRr9cg3yz7pgFP+TVuTxZJ6GUQOQDaiughHZ/6jfMHRYnSVGSTyNew358vFPAu8mk0Unx6KidBakgM/1LFUjzUmWshcnkwFx7N6k+3672A+8EDpA2HNE4renX9CY4FiEQD9j5Cu02RLrqTfGZ2txirY0CaJEOFbvhwWxVJXQZzUGgetFJXx7mpKfBwdhFPLvpIvOnMMyoL0aYdbggkRg73I8eAbgwvg1IneYh+buT5ttgcqVRKVSvSGcWAk8gSpl1sOOdjJakzqPZmbWUDmbFmiBGZ5lnHPCotX2JjgoDTrf/sW8m8/wkiDoSRArbWX3ZTiZ2O1m0fmou32raIj91c2X8HxYxcz1+6U77xhZQttquFlMifGOEv//QVItSlpCoGMStVqzOQ/W32oclwMxUIdCWOGWDvnY0omkFA2+B8WrtGzLuwSgxyBq9SV2Y9RTD9gfPVdwYosbzR+vXfqCdt+iwnvnCWyE40sdbnYykAgzmUnuD9Ba+dU5zeV8ARlPKiprPz9T2iUikzUs3NoDnaAmQRkav3IRdPW416fuTm4IGsiW7+1Vf4tbxDNqWWkQGq6AQS/brEE9qQdGo32x/NmX7H84rLi8Rh0YsN27Z/Ps6W9Yhxy4Vtyynh8vEBKXCPeqw6djhr95Y0A7AlohNdy5divPrpKEwoqn5PTN4q0OnpbZRibcg0Bm77DtcOrhP4zaW2wW7Rem8VmlSoBG86AwJySNjqAC9RbC+xVCcTUDqcjUROHyEmXtWYiaBAfrcX1WlsaDHpGioXJeOKSFbOk2ZTALTGnXkp25oVaFgeAnUQc2B91efCkNGVBto0qIDMr438M8j8gbfTG6bDm4oL410qq0eoCr0/f59UPsd/v91l+Nu+x3MT4yXjyeyhCAQE1XQxUY03KCGJD6KGUYs3dZfrtYpRukZu14XQ1m5JvNbMBBbnTaGXgjlhdQDOShz5ie1DMuBw8jTI92mqA16NYu/uXiz2++RomSWZXlJ+OAg=
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