EHRNdvGJo/UmT8moI/UVs73eYciRDbtKLmL3dVH2tvEyR63AcyXkgPL474Mx9YBqgB+rxb0O3MgEnla4w5WIZtsKcqquk2pl2N69z6rYHV4bCqxAaUOmpHFICXS2y67fQ176nGb5xJ5fwJcqpQYOnDXF1+6iJdO7lzuJlGRFv3J2istrLZ6+QMUhnIu4DY6fy2WQpZi+DJajisY1mm0u2TeqIkeMchK6j4dLz9wV/6NGwvcop6XdJ2hvLcP1dnQWgDmxmlZG74eJ7w5u953n5NlqDO8BU39FJ/93awZ9p/FeyCxY0qk98lMRqQXUFwFmaa4rpQ+bCaePwcYRMBMgMKxds3j2QYAB9mqVkn4vGX/NvRHgxocs4TvTRb9bnYBOq8l1NrwOrqgGfkPk5MccXerRwojGJRXyhFIazyRGkmxy311+wmUNa1PKrcmmUdwuGBCzDsy5AlE30WSOwJiCM7FC6XGsJGH+mNoQi9+f0f7R9+fJLjjUKECy0FDUxdu3/7zDufYQtkI57MTPZ15G0ddaNmEsnMbueEe7hegQCEHGDvv5nPj3W26Z+Z0qs1PUjyZNQdi+KQcquSoSOwcDRonekd+n/Zz2UR2AgltJJHvWAx1bxOSlKeltABMv2U5HuwU2rBIu3qsQvoXGYxBnc3eHy278rv9bt/ZAQkUfzKD0CZV80tHjNiMikBpsH+LCy6LDd2dYPUaSiLkm7AJ64bA8x8URJS+BTaIiIQPDp0iMs+CDUw1QoKpn3Y+8Y5GzIlVZDR7Oiin9N+cRgJb5Wd9FGqlDVqMnAZoQ+TlOYFmAS5Q5pdPqhZTdVjeS1f04ffI6XTDs3CMTWL47s7UgiQdP7hAwhZmt2jT+WxWewGrFXEfzpv9jiZxNKQInol8JsePzIUlpyeMYiBdotixwX7Y+AnprnAlrLiL+2EZaF/J69/Rv/rBHCuIYX8xWjALZWf3K46jVgDMQz1u5CC3UcjGcvHa6uZeM/3yfR4JSRmT6iXQiHHw5n2wBq9pJybMuKQd0amAtyMHA4xue927wKoW41EQnm0dN/iV3QA3UCPGEyoQ++MVSuA1HAJgEvSlJSJ2+9TQnIrsOoDlh1IZzb6LotiAypUeRJxZbz23zioSk8cq53NveRK4+6TiqRICAXBC2YAJGLLfVOeeLL/Vow9MRVidyc0pyd1f2L7aTOQPKMVm0ZGRR55+7uacgt5r2ZEUJmvPbS9uXIImekKXIaF4Ingz4l7R2nOivvTX6Icyuddp1LT+hmhB/94XosZZG+jRqnPAPAJ1Kz7tU6IA32G0r80TzklajBkeAITN9j3WXzdZNH5WJ7DzEHCnLWdzOkWeHi2ZrzYEPCytzIYkibdoh692JfeacjBKCEks=
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