6Wvw7jtF83KME7THUK+GaFyJU2XfI5voW5yyhzNaZ3CwcT2oLbg+IDLrBUJcPtIj7CPEpKW8bOhOJqAKx8Fh4nm9jBtbRU9qw5p6TUaIzpga5MpCJD+C2s5Soz6BHFeSn4hBtVEcjN4q/jUgayjxGtOxHQPw+jI3m3qtIryJLA7dpG0Pan5w3njKxRAsAhTDBnZLavVOHyiwggIONhsDRRICHv2UjdJcP78HgAn0CkEtdQp4e+5Uv4zcL5VzIrh7OAgmAzPfcv/K6Lw1tPkokwLU9h18XejZUVoMmFuVxDNBTXxRC5TdIXP7fwU4oCtn1Q+cuT6ItQC3BmiqH6ILjjslTFAVA557+fDLFDmk4zmnt3CVQQSp13H4pXcqSM0JjYDhAYhaCH/fs7/wadw5AZdBm6ilqU6xn1V3XW0822XuKUaMBNww+0E6CjeKYexsOXNo9v1NA9KUkVDkrzLPlc9eCO0DTimedsxPf2z0ax0xF4W+6kFXkn0qSb6S9nf3SIv2wVbYKgoGbDV974VPSSrHl2+cRi3yWYjkp4cK5w0F6/UO3CaXC3mHQQsljQnpXsEpDKPXCy1HT4RjZ+Axn0t7bow56Xb5U7sz8wNDz1Ryzyj0k01On0c9I7LBixx0It4eyujh1IusuOSWeCRAJy1laN1qvNJeSCXyQ8lpOFosfUlVIfpanwkAR6AL4aWmzV78MO9ONO6zf1WGVy40pPzEwcloRyfj8EvOPv6EhQFhqZDwrPE7Vur+hNn6uOC0rVORrRUmSKr2dpCxHLLd3evX5Eb8V0JoJPI3jjIqQd3sMHirDw5Ej+693s/bL4huB7tHUn4VSfpwelrWPUJJ0mc8f/JaUroXaT0CUOKUFVjX5whUzfqUpiNULT4zHWBntXd6NKWiM7DfiVXF29vm5bnXk/OgA4nwQ2m73DiHRgRGB3M1otSdhNXQqjtK7aDdxiNlXIhfPoasn/RzqwGFc8siCJOHWUF1q036wcyamL+6HqhHx9e8vZ43u+kuWWn/d86HnzxCXl2YBtm52Nlv/oOlHTy8iFohoO8s+oRw9DV+emd+vINK5EHaYpI2MkxrlllIN2613Et3KQv01FXfbU6vM76A8zxX7n9O2f3JJiNaW4ds25MQqB3ooH0ISO9c/EgF6eVCCpEsQjZMdjivDJryawYe3x5UBwJ7PNs0CX0GjUcYl7lwNRbETVnd/KbrwZNS6tBriNweN4d0CKpLJCitIhVMtFSa5C1IUmJCb0AEroi+pBY+fY2t9elJq83XuipzYFUW+BZwwBh4B/JQNAcWKSHBj6EadT/M4pBagyZ3E+lN8PTBWkJuRVgeij+ULgid4ysyUdmpwpGz357jrsztpsZjitfe9ryTO4A=
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