Uoye0jTGr58mShJ6aTsG6iWathDFDOJHf3juVi9Hrh5pUWpWyBIDywPIHfAXD4SE4cROFE2wxow+0Vjur2AcFT48TRMsS8DhiHxPgFaGwKVfd6/qe5IC3Fr/6RfG5k3x+TMYi2L1Kg8ToTyrWqWIz3lWoYUBef2kdvjr6pI/y13xfZxMzrmLXklp6LmGP2rheMkHW8i18ZGythID4Pk8BXoXy13Kw7LJ+rQ8QE5C+jQBNVR+kKEcbEbI5R1YcfjikZbaf+I7BPgwzERyZ3sUHuII2LAoKOH72Lbv1+pCKj5Lq3/haLhx9gK//MWPIQ5EwmA8Ev0PXd9LPzsdWCvVhPcack64YrN5hLZbLirMs5Mzq0/HhzMwR9iXQsBbNavKtqXgizPfyDw/+sDNOtluzgCvGy6KiApqkDD7sAppc4+XTsoE4YHzf+Zac4N/5uf1or9unn0pgPTk3TUQBNnBJGAodbaKaQot7izdYEln3dG2HdZy6ezGliHUBphJ9P4y78V5TRpziSY3IQCZedpeFGiXQx0O9wlpQMTYs4vPfJQuAsOEWvFK+TtSRDo8F27OR12i+9fwn+LiWptOr/63z+DGWYwjMJ8tyRAUZINS7z6dgdHZY4lw8D1NXiTUOFNx3tI40GVJeIPAZFoU/JqU6SAUwc4GbE+npxIn59yMpiQHmQzO88OtLpD9GXhEzcPnlIZG4fFnWAYBqVjF3omRMUk4i1lHR8xCR6aeRSi3EspmsuB5KOdjJIpMnosLgK4JJn+CjjClIWGYHXJnvc85V1UwEBOdzugHz7T0pL7J9zxHLANWUQypKddzuEHzlqvPfS0SP1UFzIfri0AjkwdjLPdT2wvomNUkTYXsI33HCQNxZkhQRgB/b72W5tf+ta5moLwtq5IvUbINOzA5Pmwq/h+M4JGPNmBaoYeptgpdz5x4WIRVZvhrjm+hPKboLXcLfv592beGo1+Re0PqPH2hbhDRlX5GRrzxq7YokNg1+vH1s2reaY5KG21IjiJSpH0BTGL1KlCyl6Ozk9i03mTxGeZLETVQRTU2ILCv3FqQyY1Hp0m4hKvzzY8Hq571RIyMXVnFRGyHI9IjTuqFrOxa2aHmGpKk2zRUfl030BUWv07mCSBOfHl9Cj3HHwsA+qtxX/ywngWzYsy1mqQ76yXZEuqvSRRmMEWo1ELwiwuu7Iwk8kvyZe/avspGy7ZgZo2zyhUs37RzsDFhZJD9loUg2NY3aiSgLifYmGWBjZDc7JBcaDJdlQ+J9Cmc8+Mfa3lH216/A9p6jt1WoQdIamobjoNrvFC4IS7VrRmcrXVUolFlBBVnAwbHUM6hXIccFPzpXInLNSjkHtdlhk8z2jePcxhmUcurNKcV6eoXJ+M=
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