l3snNoM3UTGpl7fvCKr64VfzsQEJ1uWcOigvhfnW3v3INUBQNL6GIm8ycdlCZuTidax/vR9iS0SJWxt22RQtUr3xpAEYSAPgYlyOCrWFItOwTgZtpHNPmD1ErJZCFvEnLRj1R0520MFOR47Cu5ghT+VVUlrhIbw8d7tdDupsc36JYSEEnuSWmkwQqW1E2XWEvTJQt7mmWs/0VfgikU1iJxT/XyHPVAgrkjdip7lFNql7rivx/mTdU+7NUs0iM70y0NGvIgC03pHL41wLE53cmU2oBimZ4s1cY+polNrRcQvqsH039EXZTR7c/RMhsHR1Ql8U4SjJwBaI1W1SkX/iWbb9PMR3UksSJ/Uc94+rzTWW2NzoaDRZfW4dI2t+WfSoykDog/012c7kCy7jIDkyMGsxHcI6fFJX3qOmWBdPvzmD1XHYJ+JzBrasaVwAfSteWpzJfNdJ64KPATlTjFnckboEd77M+53GRxBxtp7SzHPOMHp52j6CJKGBYFlDaHdoii358U3/tdy/sRMiYKZIUeA4u48INqCzYH3by7C4fAiRxCRjcZFscT0y4BZIz5S3zE5eVfbtlNizTbyGUVfAYyomKtqUk6T5cgAK5OO8oyhXpNrZip1mwBH6Q2g0fZoloM0Ix/eqQ3iQwRJNVHqlO17Vv0JKPFOsJF0ZgE0UqjTfwXzT85DW2e/a+KZdgtW1Nhpi4fIdiOh+BqSEsflzB0osW3emSoDDFu4Tpt2U462Jl3mSfvui2k6NIjKfhE5KN9AUM9g1EJRGJIILQjeoXjDwljIWCs+EM1f/JOQqTcgVNKsQ7IgEurrYPPKgAsJvJRRc3T4gkbuQex3AL6re12RAFldMuBQULkfBaclnfqJgrQZZXWXmpT4nJCVVIJOoDenm
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'
GROUP BY et.id
LIMIT 100