LwZcGlq+9oy0HUqLMEFWCAtPsjx/0Zwl1tmGtvXr9ThA7fcNbULBkYisxoxHLGfdMBv8rfkAkGe/RRwE6eMoDXuOrbxueXIsIKqIsUjmpKxYgqtXfL8kk4EcHUl13MdWUF2ym4Iy1y5RKDbXJPQx3KOSxzfmOglmJYzmSiOEYfRqyfPJYVPeVDsvfYn7A/+vhR/7K924RuySHyp7B6fYVX8LIWoMwh+920uMnxKAsLL9T1WjfcRup+gZvktsjwX9tBdeD/Pen3ovzX/JTAA5tTjUz8E8o0sgkSaxYsGSeuuLQEoUAyvLVk9Td1r/B0Hc/tObxhK7LeB2W5e6dd4UIQxBdtLV+rQ60mAjzKF3giLuV3VQskNtoub/T5I/EOkJfz5B5La8eSsS8QhTbisPH//jHMIaEEM217P/tyQMNLLcxFRtMCakauQLpiqQpXRf57ybk6ylBSz0u6oGRmGdde0CIE2OLWT/9CHivY0RY10uUes1MRPbwrGd+3ngo2tTAjk50wuxm6RKfhW9RTWyjijYQSyFFCEwHBqjje38d3ePHJaPJIXjN48Afb+HECDrbrKIWUoSI53oB1jZhRjFGHrnZJlzkyXEiVzkjGEFnHlGlbICLrLZodOJKbNY/vJAc1775Br6ql39UlAQFRO7gyW+7uPVAdrugXnzPIlGDiUZ6O00SCrEeCoW3J0DIfUbaRdL2EjGTrY/txdc6rWbSJ/4whrUNsrUpXds7MgzU1CVjXHBDoldnjCDzJgkA0bYFE+XY9bkn71/7DEcPv0V8knyyDTgz70E626kSduK/ElPuSkXw4UzVJ00/hjnoSOEAsFl6Exx1aRlaxlvPOfpkMgowxkaIQPPqZ3rMaKfQDRsTSB4Wi3oF28rFGgriroVJAS4+EpAkeHmDIG9Myy+TT2TtfJ+nlx0rlybXhrqaRtFFwQZ8KboT3UYQym9RZi+MyxdR7XjP+9s5GYCoGRLZye++AZfCxFUEXKK4jXpATuAZPOCocl2cyzhsdxzM2siJcNvKvBm8v6gCHgBeb2lKZYyi0CSNnAjHpLHr2Zd5bKUyxAtMH4U4C3foAgZvXRpbMpLBCB0GqTNvrsrVpX2mC2smqhxfyNBCqrBCo4xS4xUOInTK6hTAfChd+pVHCFOiEA0llNG8AWkwx7ViaJWp5lnYtoBzjLhIscg39H+dgD6E+i2dr1XBTMWtHLJx6x1RvA6I38RYpNb+vWN7RVIm577J9W9Cx6409Gwyr0Srfjo0WU2EpgT0/zp+PcnLOUg6fWX/x0beLJFhPM5QmxK9S9bKAlfuLVmUmni5xiPWmktBCOHLkpKSmMg9lZW+qiX93gsLcGcMetsG5K8opl1N0uammtT3LdeXj7/NDU=
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'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100