eimLKmpZmz914o4hME5t9NAu5diuiIZ8QDZ2l+npu85/j/aE1ZFoABtRW8O62dKE552lQ4RJOagsJ+EDVT5AA4aSQxrjleMT2ZKNeHxueJq1yFZXTbBLfuVqSYQC5XGrcP2AhlIwkqMRDaHRU0Uuz9V5630MgeamcqqYJunC98wl7GZkm8o2Dy2G01bLm39zhsN6oqD6MFkKibW6kqFCfQdtQqLFsJcFrrfJHl5O2aJzOhLZr/hiBuqtBzMpv7ouLfC0k570BAor0ssfCHCxtGUnkK6xEJFStncsvlvdXkI5k+iWkZjTo8gIddQ6dS4d51QXwtaYPjQsLzG8RODYDfXDL75Mp+5cEWrQH/oJ5qlxKlrEvin0+HGcn8uNHdI2foz+npZZbQkxzEY4LXUcTPRo5I+tPBM0U0FEb4iRxpiMfSvmFTnxKkv5sjOuBrZbImCbZjoUeypHzZFhuokSquuxv7gqvYjs1uJnADSmUG2FfF0WI3BbNRdA3yjwCwBCKumjcTzdRTLVPWkV7d3Hy2YM1xAqEoVKLzv81s6/qWaWWNzWz34ipe+NxdtV6kkVZ+fiCXsHPjLb5V3tRp/75zEn2FWagvah1KPh1xEqIE/ZQ2g+2xfh1tvCBDP7cQCdv8BNts8xRANK/CCVNl+a8hSaaq+TgVtI7GsYVPoAVSqvyIieeOnPLb1ULXLC4rBITAc5oN41LBbPsnU0mi6V7r6pPFrbLmZ/5n28ZD8yDIH4SKJOvDm0t09zp2UpTwdQnDXBHJN/fS3hGawuSfH9Meu7EJHf7lgfyCl8isgCGrA5Jk9eeWuCMuoj0153KeSbVvgc6tdQT07mKa+Z6fsOYG23OpokC1T3DBS3qI78vTM0QjFoxm1RaQE8LYOh8Q9VXRcLHz/FQ0UkIDlk9HLmQ5vocE6eBwO6qTGG1jjjfRv74a9DJNYaN8oUZ+1pdZGUw6pa0feCIDzS3JQQB/SK+5WTRDRkado50zR4Xe9E5ijBnoqqapP01rztFu5Qap5A8CfhMybdA7SDMnULTKiZGfkeLek7ZUQ6tPELYgancB9dNUT+NlVtAV6Eou4g+4/iIKb9D+umhsn5RgDfkXQ9xyKBAVhGciAyJ2lP/fppuD/KATEpe+0DFqZdFgVK3lLMrZKUrcxoJZBJPI6QOPS4c9OIFhw4OaIDmKy2+5ur42wXzjmiMh0WSBchcIjKBYLelkgqM2Pyc1e1G30Ix5o2qU8P
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100