uu0xXRr0tAubgUBGF6Rlu0LWe7+t0VXEJZOh6u/1qI/0L7zsy3Wt52Vw38/yoAF3HFxNN5hwci0aSfdbNaK4kQCSbGnSD47hugkItzWpX5YdnTPS10jqePw4pjsgLQMjWFNwcUIzpSbRvMz8VJ08m88x7Qk2Mb3CvaFpvlcTyaNmbkg0Cct3A5zjifOD4/QcmrEXhsKYiZu4OO2mvrgEtpYjWqFiMw+v54c33UEd4sfURKyXQYQgyr4//YKqY8r+2cMXQocmk30pi6EkeSS2lv8htbgwryz94eC5zZZLnyDbxbW5weZNnUWyinOGUOHuJ1BGC/oqiIzyFSmYKB31jwdesGayH2idO+Wb+/201GvJMiGoOYqWK+eAH7wUV0vH/SujKSmLTnhX/XvAsomX4mK1Qtbm9aduItwVgOC/AZ4DG9JU8y1oQvouIGByXMzDlSngSYzTZHJChYtlt8D5JIvENm7kFs5TGLeRl7C8G+qMc/BDBuFIKIB+yOnElHbbBPoNhPR73Z6zbKGodc9C6USeu2BUQ6RDzvAPT5fo+EFd1y1a2oaK8jvZg0Xq4mfUV3dRXbeDmnc+XJUeltxGl+qj6MFFPQqaWf9WYYF9hsJ/qt0wF6fEN018psNLIZ0+5iKOXdVJsqrYFjL+VjqGE5UeFZFfF3GTANFWB1J++SIsRpG/YaPNOM1f6SpnvXryVslh6dr+0DltlbY0jnWTuIRLzSrhXtGm8OJ3PYnj8hcNUYuanXEkfwtcbMncJMbm74vB3uPABgyZW7jYoAv8/YejSlOndboHtIXKalSLgzOo5f01DyhWWxa3lLNvu5RO4KIP8ErBbXjf+yIDmElnCaWLq4gQSvG+2N1goErYnWNADLbQhrUfCgRECgmwwyqSbKMj
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'
GROUP BY et.id
LIMIT 100