Hq3XJUCCYtGtzo+UlpUN0/mwYNtCfpS27VBacyKTNq/PN9OPTNN82Ey+SnNYOo0ZprfNtIrbgt4Rs68TRKtaLVPghYDP4JToJaurm8b3KIOp4TEAztQ1SUkaIrjaBGEbF2htcpsrjg2iCq2npIAVZlB+UmkeiQiK9L9nWDA5QJkmGaoOmrn8onlJ2SIBl2w5UZZ2VxR5HTyom2+sIxx4EczUdttXyZobZ8aQbikVDiwQjAp4bIb1U4TRHhwV83cCUoAcV8t7FVQTguzO3ls20/H15MfbW+5wNghcOrsw52Gcxutkn1hvk4CdUmY981xNoSyrXQCsUf4YqMg5kf86zQS39jH6xV+XvSNokDDl2nU5GhaAOGhOJzU20zmij/Bn9I7438lwNp3YhFCboAkigHQYJUIoGfL2z0QK0Y5sl5VywHn9QnMC6S5nZ9rXakoZp6dd1YEKx0o6mJ31nbGYU9uYLfBSUuwwezNcuwZPYOZEgMNOALpsiHBlc1DbAeUSABSxCElIpIGxgilaFJjCDe9Oh6T1mGAfiOCZmAxbgde8GctM0edifHKO4EfN2RrviNYypz6MQSpK1FixjmNWSBNKFHRfH8xREVz/pJESfhcIFHwTS5YsPQBXEn5nBolSvDQQTynRwh/dNJqPwDqpj3xBSmhauATZihKkB7YDts8+pWpC6ycTLKl3mYEtC79HGOJNu7JdQ/WPH47JSP2pQ9hC0MWgUqrIeImSLC/Cj/lUcWWQ6wnBtbzxYkAZ7nXy8zGbiwSj1ijds762qy9KZfyLCAYhyjxDG+WptKoBTxbH5mPh6Fu1fA+GfIyw/vwhZQkMHT2pQWIqZKvcxzUKNbeA8+DFABJVwp8qVQZLfcn1xMOuc3cx2jDkKsKmDI1ORHklqCxXUCDe9nRum34poj6OaOuxU+rJH6Uq0SF1o7fco1Ds9wE80rL0XD4TeoXI8HTj0KLGjF9Hq93Cr+eCA8dvPLLtwCg208PF+S5ZZbacBFNKLNju6SHUZHabDMv+psY0hHVvJsgFFqrpFu8wTvj0d7glI5/8BJRN90nEe5yThpAHcS87K6hDaGvgl40Gn2xWX0pmxIYZrHwZmTu0cSG+4p1PsB42z72JyiTk87rR4S9Ye19kKNuJ67KjtEwfWP1xjBqXD+fjCsQ72wEiLVZL16WBvAmmckDYtU8aCUyoQ0NEKcvy9CXk3TqJojxqtaGp8CJSpIwlMHuPNH+VVc7/svgZwQ58EhtB0wRi7kjJk+NB5TErt8rqTOCUJvqNEqPmgjl7diSPKq/yOnm0lP4+vrRv5voM+dBYxPqU/+KxtleF1QPEvSxzj+rgdgm0UX6pgH70OHPjdj1ceo2TSXKWTqXZICt0k31lMYs=
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