SDv+qwZL+DB6ckI0cQdQr0vFNt2wAo/VvwMMxoceGdHuGQJcWyuN8htCdDWFyLr28p1Lu+btX4BfHEMZF9ecJwmlBoMqqxn2Y0RkHat8LmP9aWxU/4Zl4C/aK8dk+rh+Kx151C1bNAH4Rdh5LQQX1FSH5+dUo8CgQD032icYi+DFdIho8TbOhNJ4NcCBYwalXsOM5fGvAVnrCyTBjo+kUZ/+ziTgbfxfBukVejdl3CaSwtrij0kkY+xYFxsYBRplNnyHVyPrQ+FvmPtR45svU6awHWhs4OqruKiIN1QDL1SqyViu3Xu0uritzEAHxc4tBn51bFYFQCVObzZGr4IGapurCkBo927yk7EVcCFDzSqRCA+2WHoi0EfHR28D79PTsTCsHhMO7LEWAHsm2PJLyHAEy/3ACJAKB99vqc6FYxeR6S781qcZWjD1qvL+BTcbbiefrwoQUENqAyw7+SR4/b4Ujj7N6NmArfBuonpLktoYwBlRtygwzo1DhKvbTkCSlPH+fjtr/0ICog7t70VjsFvuzUsp8D5NLuLQYWCVFu+KzKCrrR10Zlwm5ME89Hkgh5wzI+XdTiIaAEYsU7vpVnKXaZorIq/yQNm88scCa9e3U6t43xUQae7aCQzFRLF+vjkfc83jaEVXdxD7iNdEaE8qwzeFtAjJ0/Axa0kwFznh7gatbDq+XF/L0d5564gOtR549TSnxyV096FKURzgEdEFYkiFuLxhSk2vRWimAKLnT/x4uyONmyZgrH9j6hBcR0/Ub2jxR7rfUD8f+ATvlNe2iq/+BN6JOC1FWydRNaJlDMr9jz+TcXOfy6AyJk3TmxwS5qPHZSTNSX4gA2U4sSd0F3dAN49HZbRctP5HHSHI3SgMcM4u4qhGtwKSpnXZblFR
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