5QEv51Xl0rR7LKGlhz8efbmu+ESHXHeqlF2hydfN9+339n7lMKjChsIUROIC1ppkyp+93AuyMMZJJOXjktUE2TYXtc7q4LB7RVTXveNoCge7mndPLnItiWM8/GhjG9W5RxVaRZ8xaq8+Q5pDhltrxfBXRnoTP7aliYM83sDf7uAxugaxCywCr0uoTIZsVi71dBjOM43+HEkC28wbqYgq19istPHUe21uo/5oCslzUmqaZmsRlQtybHlUXAMbF4H/Ob6vCCZCUJr2z7f/jrpOyLnOrAa+Q/QhnHyD/EclVW+Q0+9iqtPjfT/KfFF70E3y8AHQzRb1qWMwLjM978T7SG7pAZn1jR3mRPnYl2y8oR0E+/gfnej2y8HpujzZt5Xe+1xQa0xOvXfLywaWpjGGkeBuI1qzIVlCemO74/SjQCPL9Dmcra7f2l6BzVdCeMGCtUke17h7Oo/iozN2Kn0FNZE9QAsNfhD1b4DtmaMVZ2kx/CBcRdPByaW+aBnMKJ9stHkvEscD2QoEsTKZRxJuBj8KlQFGq2F+tb5qU2gRXALje72vuSZi+Eph0KeCU6BfFI6RFqZYsdZGln4hF9FmVOsJdIeI3v2I7hHhWEdUYi65cDLS2uJ8ekdKPMMfkFe1vvZGINY8BIam3O2kLoP/3F6V84IA3Y2kqxZDFr4dMRV132CxPWwgAGJzNllfDLzhvTdvjfxOCpKKTgXVuF0lL/0l0U+zkEKR+Tiemh9jKGqUuv5d6UEWcozzk8PZzLRyVqD94DnIdjui0cmBqaAX7Vv3UE8dU8V2iQxGAjltj08fr+wzU8ISIiKm53G9eNuHI7/omWmwN73lYtybCYRM09eENs7/SPp/w59pxGgNKl4z/wVcKBSJyK1lMhjB2yAvgsRk8ENylMEhBUHPQDzUNB8u9WUf3drtu4NWYtQmPnyQ7r5X1RFC38ox7+i1KLr06T64leGb+UNfE40hUJlsTujdfZtB7tC1dyazFJuaH7B96Lzz+pYa2iiCAxUgSIUc+kxepYzVfH8LzB6QTfiEmzEj9a4UB65uceMyjfiP+zxICs6XFtaGsz/DF+o9sd/D3qusFMthyUyarzwW6+W3Tfgs1dgqms8fB6MfXZ2ODDbka9VDngi5JqXHWaROvS5ybzYGe5bfSTTUnmHOEm1907n/9I7Rn8mdqNcVLYffTfP2Lk0tUI9VDlmnALDpdws0PA7R+59P5eml/TP1gh4iRciS7Y2rGG3ny1zN0x4bYLTQF64z29BN1u+KnP96XL5gHfFA6Kr4IH6kyPjoKhwslcH+g9gzJ9LENUOzKfjiEouNJ+OCfxeyjn5A+3sWDkDVyPpOhBW1kohwrNiztvum/AK/90Pe7CuwvFkWELI=
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