nO0RsJ2kl6/KZfb6RUNQrSfZDqaY4KPUSE/W9rs2k/YmcjSz7ZmkT51t98UanfrwEG64mNAymycDZuQ6p0nxv36wBFwFHcSQXgNteJySObUClb48YVRn4c0/KPR0DxkWkfnIufaXaT0WHHT6CElwHGfKc8SLVTegTt/ZCEmMK50b5BoDFwIspHIOp5Vd6VaBRy7t+i7JF5spZlQ64C8Cf7djPXD+GM7Zf1SkCCpX+mG+c9oENIIun3RS/f7R1VoUkOtOV31g9oc4S5/bL6pobNSK+himdc/S8BJVl5g7h2uSTZGDQNmdt71xvbpcPB1oorsz2nm8+nAjIIrVPOqxfaOYb5qdMvk+qLcUYoypBkDS8GWtOuAKtZTl8Yeud+5r0OW+PXtFR9c3bsUgnb13TkfSQO95AKgq/miH17fdZk2/nF+FhLkuIs97AWYDsQwrTb0BBFGa/0QiTMsxY8VBgvNXufHunOYw4mmYaQonfB2mTYA1e6VZkcJQuyRjWNMkwqn6AzQCbmDrANxZkX3Flay/LjjXI1klOJE/jo/XP1CPbJP0GxwKgAz+EeHzR2hPDsqdw4ZYVAdgwCQ023+vK9Kx6UrHjIn08ziyhsLL90NpFG7C+UUB3+ijIMEKQx6Oy7OU45kXRhVStv7ghcCLMpOAEvhiYWW82OobOTZzH+BvUpf++OutrwGkvbu3jQf/gB7nefhEFs6m45vdr6EgCEukrLPZbaMl+jYt3J2TJcrm32wOLBvM3jbZv5ps7YFfDtAvg0pwugVweJaYCQN7GwxgjszHH35HruHDXGPGC/M/Hk9juR89TG2NST+BHQ0PGhPhZN2Ss1tFRoRZhXazdn1au8gorINersLnE4WkZSbQCtqiIH6kaQSdYBDNyOSA3pU++BXs7D5LQ1EfOSJg6ptPogiJ1qunseTQ5sItvyRelZW8DrJR8oKpRmGov1YNXPUf0Ax4OowEpsuqYqr1c0RIEMdQH8+L5qVw31UmNB9ppXomgZ4tT/1tTVcmV6I8tHbEcpM43Bx/ShWBEjh3930qu6xPBXqDUEf7ZvJRYaXyY/jPxWDzNd8RIfVcwSg1DwddhPjyjVH+5XICf+f/jo1wOThhLfaPhnxSSSWw/S3FFuCIWCdXKzCYqjqvAHwRIhccRyQmJSdG/64L6a40AuVgOeBOMpYj09uGmdNh2JP4+WQBwkjl95xfHrY7iVZlzWL8lDbjbw6NDDzjxA73Vu1436SKRseIalmOEbY9ZcXDG4KVEcWOxhGhXp+HQ/9d9VpzJO1jb3Gwkzc+F/HHa+TKqzgeS0RwGEferxZmgP7KYSnaObTTrLA590hzu8XhvF0tmFEnoEkyTikGmv+pGhVW/4asC53bKpxDuRI=
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