K1Lb5aZzIbD/UX9H5In0HsZi6AaPRfI733zowW1iybKwWRPJv6GjOBL8v69n77vZGhLaJydnJBUxOXxs4WMuNxTP8JggMv/7hldjao5dDSPfGkvbkpyYVmaEZmX2CVMvMExsQDTSc9oRo3D2SFC5fQmFEMI3THA/CDE5JD+mayvZrD1I9h20j2GDf7PJOieaii4x07P/MxaJw0TFOGY5OzA1iNFnTWRUbxHgwIasr9aNppas8mNS1HtEs0cnu4DuQsUFn/Myx3JKbySB5aGccw5WSaOwmurufWW1UY3OPmSq789BD0KwVB69aSNJi8YAn6sccc/zPhIlXgpWgm87Offe/K1YmiPsZjvsp1IugWIubr1I6TFc5D19bFgQHapbW4638GJoe3YP+BuRoV3jxrhTGdCMiL1IgfuSsVCk3TIHn41kczwrqS8GCAMakWG/DSt7CTJoSAqT+Q50Nn3rER/Wgu1Yg5Yxb8m0iwMW6R0CSDP1gO4hZqWEegJk5Er2AX/oySxi8/aaU2g7oNT9zy5JBwbBtjE2ina2oT9L/y3AeqNM/0LHLNSkF8YthqGEMUUXVWNJtAmA9FsYmLUf9iJXveMx72tYpkFRmxbwCLhG/NUnLdynhy5XE7hB+ul939sJIWVjrMA+dZcSXFmbSkITTx3TGD3CmEfEzdEfFV3+7PYD29ii8nLgtpSR2FhLNt5GakHw94JQsj9yG9b5UfeFrgGex1iDVCC2kOvX6LlMKs2w9tg5TJBFcfmua8Q3he0f/RthmjPYEsbLxImJ5EHyLrau6jJ3xNkHb1vj7k3G3XdfPmSxP+gZOxV/PcKHgMxlUGVeqcYmOKRUHHKwyl8U4c9ksfeOtxD4RrBGY2jvp5yiTfh1BJofEkNmUwLsmmn/
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