Q7kuRX26TRoNtRViDI82G9Rk4L9BgOc4sRA/wIQQaqra5KyI24/vyMpDgY523oouJcH742Tbgs2iCn7eWsGYpjQuL3L1/ovAOmVIUtYcSPgZbUFJJY4uoe5C8R6ymEaj9dDTqOY6AyPpc9Lk4AGUBP04821u+3n/kdG5JI+YQzEqvP9StD8lPswfMTgNDLZg5HeYKOsaA6+VdQZ4v4083u6kux1mi31VO8kbtYLoEF/mqxESf+crrKyf8w4CNqRiHdCtMCu08DhQQVZ2PINhtWgguBCnQswE2xtAVD1is5A7huun3zsQjXurVbVs+nCxq29Xkb7fAdhZt3G89zdvtFoYBlWcl9OTHSM3M5I/JVlP+NFo6hdzkYoDdNDQbkHyc9xrJiAVJ2vpaoFqja4MOqpbjt9DHteTXbK2p+dUdWysv8E+D+r2tpiCHddRmwb51HfzdPZRuCwGpLNqcqwkuwCv6SGKlfuRH/yOj34ueqwUDO+c08ElsnhTV4XRjCRJdM4uNog5veB64OmBVlXgUPo5POm86gtU3VPtX8hlFgOST1uBX9/XfF0ij8Ttttlt3/8VGRT5Lx2/1NowluqciS49OlhsdJCnJc8NnCM2K1wH5FR2MHag6Ag1oXK8xjjBZJfPbqFkoVVVzzZWQAmHM90KUVkpjSv2VOP1hMBfxZRtiJnQb+JqX9EZW+chlugHvBv95mNCc5SdWnIC3GzapFG2pNEsl8cP9nbWl5EmR0e0OZE4NqJvBTMXnXBQEVATtf4iSqfqcE6/rud5Tdk8qybGwSDqgHA1mYSJ4WIhy9au3CoK9rLRvIyJLJe3UX6JOqptL5Wu1ma8+m4Z0JLUE/0ybMqGnEkeqVtR953CKVopysmCMLrDjltzJdFzF/ncQdd0
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