StLo6rQ+8z5Ve/v6x6F2+1A/Q5wrAAfURwCm9pNPm12QX8J+fDQFT7JEOLIYA9T4972ic1xaA9Scs8jsVrZf8qvOuIr4ivzk67Kk0wSSCeGjozcWInRlJ5B81JDpSvQLhLLaPFgNtvLlxgNIf7asWG8MIU9z7K/qdFc9et7yrrK3rHeQU+bYJlYIkYMSX4+I+iEpgUcvqxw6pcS3YavC8K2pT/kGbYZ6nFzP27NWvHE4HheC1smKPiEcsHCzpmmj5CUxzakffG9DpTTE5QfTBuT5AMA2yrk0eLErVBm8dBz9HJSxO3vX41abIk27R6fIIc4eCiLE9xERy6dYeb5Z0F405b8Suxr7rxFAue7lEV//btoyYUuhzQNYGxnoTnjgx/mlLEUHQEdxxT3osZp7q6TCUWk89/IVmeS0U+KnD2LT1PCpT1Pe4pO8Fj+lq6WKLLlEuCoSzKiZwOsfvWkBGwlakFOq7CnolsI6d/7EM3i7yTgZ2cTeYPniVkv0fvW8nS/t+qQkqd8P+cEnWRumOMtmSSe42woyV4z5rXFuxWvHBms2sDi/NoaRDTYEX3TCOWixrWZL5NyVIf+7vlSwNeJluDdOOCAp8fX7Y5/EDZNZvLTCn86X/QR0yCK1wjrDPEHBMySiAvS9sy+M91UcBfdZS5Vo3gOhWSB1NXfiGy06no9wBUb3AbC0NM7euSd+1iIgqWQ3alh4dDxvZKlOXD2KZ3U2L38Mmyr8rAyqWnCcVfgaujI2jjkA20J6GpUICBGbs7oEdiz6Q6dW6Q+ccJlEpr8UVBH61udAsH6DVy5EU8TFwGy9JZ0+vusVkzRJipl7RLpr/mAIKhKhBLdX72E+ajaNrxjEbmWzgK1lKnFgx80NHgI5f4zsATuOq40NmioHg9XccODmPv9od1Hs5CasgvQA8i6Y5ZsleSHFkU5xn9BoD3GgLSHelI909LXlQePOBdSOfD1963VldeXG2a/YP3vFBhZ0XtJIGEISjWO9dWaeWDy2MU0DTR6g8zgheuw2uTmQnBF9qrap6Plm4KoltcYqtZF5Qc6fzuTWS3D2hdbu5O9hf3LJDhOEGFxNNhPZecAej6bVLkhCFMQEGdbndWsoyV/YczycflQJutsl9RMVGU9w5rhZ8Z4HhOUv3ZNsbypmisUNhonEhiCbbphJGHv/kKiNBFBLD2bz1i79dN9Jl7lm02hXqEZpaZbg/oDnCpHVM2geF8niUGr6xqmn05ak6P8jXwGJimzkMArJfadBsRmB5azIV76umFFZDMZXgAaMIwQMWf9/ReUO3gTZVZwc5OXwyWKBxUhW+kg1IkNZIn43AKqDUV2kSVE2kLCwr1loWnpiugXMeZbaOYMmb/LAcUqNjQ30VQo=
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