u7pkNc9nrecZLW3RXzbiNMkUE18A9BepLE6t4ZBoJ0saTPR9PizGoz16BLUpU78GjA4H3TaYWLA/IE3ncc6xZYe9Cf3dwiXS3bpPaj1SgmYtS5ctO94AiD5NKSPvvBHaz6dkUyChuKKrlbPJQxp+grd0/QrbiqANw2JgYCnapj4WzK43qG/Tb5EZ4DXesj8h7JRs0BFQL+ddtoGWfeKKa4iykhrQNJ+GbmVsEr82eb9TKyvBOEmvG5thX/tApc1MH/pPgfPdi8HBjAMEaqYhhNmBN9Kld4iFJJ4w1+88Iz5zxkeeWxrpurYbdB8KVJ+Ie4YDNN912QnnaixFmpSL0RMOw7GFdaqJx10bnptetvsrLNBG+pQcLbJM3CF1FAQyxHi4ySjUJkLuU+kpoIyS8b2bRZUhyL0YV9euXzRPaw76S1XfJg4KVSefAZD/QxPBJ6Yh0kKOWjhyBHhsWMnrchu7Bdv2xgDt5hZGm/zfYIVxF7M50e/30E5owSjMsjRjpTYm7SmSEX/QEcZLEWl11mIbf3rJcAur4vkrKYEEEzQjdjYYmmTmIqXGnUy0XYfpMLePRnlMhwZBQh4opzMKbjhECHOII3J3JthH65NNcF8sya+NbxRlFDCwH/RsG+957tiPS541amWumUcsTIpm0tbYNh5uasuDOdL89hOz+ST1N8niAtAh31keAHOmMUQrTJnK5hT8tBxupVK8VulnZGHKNMf2T9wRBeE95SKBJQc9uvT5ZC1gMSLx9pNpbbz9nlUYs9NM6a7+PfcuMVrbPnrrrZS6khU3T68jWWGGhjNcvl2HK1MCZQZFZLflA+BCSmvGwlTnagvHNTPO4frpWRfjuCocjyIkdRRu8P4pbfro3tIDobqku3xFqCkwBiU5XexqIahYzfr4WbBJl6xztniGYit6ChhvVMX0EVP1apUTszwSLz3CCI32ISkKVa3hw7Bl1FmS3oH18t8bqwKwfm05eqTKTjtWwFwcEXvMzTFWY9HMWo21Xnyyi6YXN70gnQe2jSPtHrIxnvEDv6NYTvGW8HHcUl0FDPofYZuPsKR6E3giYWjUm9xBpPgs87OJ7Hj83mzfLnDXa2wnXoAcRhlnmRXq3jXAV7JbA1uL5eSRcA4NAUCsJF1N8iuyjx+qWIFE3pSryYfaHCXpdCiwbpFnMGoV4GkdOkN3ITKyZGHz7Hn/UU+q8dmnzitmmni3aS3ogMYWA9gLZCvAJ/anCZ8Dks4vbdmXLdPUILiOe0Bd1Exws2YLVb08nhPd4drMmdylbZBcQYg5HXgUWkJt7Tj0Bm4d6W+xs2GZoj3qPjOkerWO4mucf04+bLg86WUq2G0OxEMpS2oGOKetIe7iWA0qjatvEza5O3DlxTQ=
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