Og+++1v67gZR5OvwH9EJGBmBKKHrWg9g2XeQI2xF0AV2xRpunPQTw04edZjC/V91px6fnHQ4lW+AewGSN3vclwNDo+5Pi38fdeOnD1sIrsPJXX9/FWPrf0bVeRS+7wHfltdxt8SPb+WJdrCawQ+yDKQtp1Fbdma7Y1ApBTQSUGdiHW/AahK3nSwktYXzNvAMt4AjC+ETia9TV6muerVmNks8SHM2U3f633x5FViEvYsVl+uuOJX7b0OmiPF4GjtdWt6UhyOno5WjVyBS3I+fadLAu/DPN2Wgao1XbIM8sGaCog1NmBQPAujrLcYSM0rJmNepcVnekypNCzCJhP6Ufp1uN1dthhmLa0octdi/Aqm7gElXdQKu/9VT+bvkvy5uIrUtdjXDSGSSTHAc4iQLWXx2Vf/JG1JCcTRJwAnmUrCMUj1+MpdLTZ6U2W6fT8oJF40PW3wlZzrVpI7305PuRdY5m9B6ZTnRrBNzkeCH4cMXHdzUuPu0U6qukyVYsBSZyLOKVFSVoAj8yJxI2FhQrUQ6wv0r+I3OVWbe5bpQY5g59mtQAmabG9o+1gw9X0kST97KLm5sC4IocZBeCLEWJDVRkgCDYQLDTvtVV86yKJw4ywrc1Yj1o0G9xSVcQ+ZWOzDlbFjAY3G6BouFgrdHoH7aGvU9TrwOM+ibH9A3xUczTsDeB5WUp7Vs3iKXd158mTG3DOGaSFNK53dOFw0gi5X1bjMHThMX3Z0tbcXzDjYPCVtPu4WDkLF2aReOx9C8ID993nF7JAZgnjUOUAAL+RVHCqtT6emNJRV+M229RekE9iRRhzAgd3tjly1qLbErYMar+qgZZXis77t5ckRXux8t8KxNDHOSxkCqPt5IfIGIaFaBdb6olLU6VHlbhOYu0LnakMCpJ2veu+nWDo/28/5c4D8HfUTyF1bZQFwpDbmm3gLpzFUNGGxsOWmQ6/fEZqhU1796zW2yw96ZkEGmJyjSPn3EwHlkwr13dUlB47PN/VEVHHmIvT9k7HnnFncKmQlDNUH5glCOnWNnbLSteC2hDlGx7g/EiPMfPMikzLj5M/9JBQ7deDPwoDOH5C/Y2SYlMAkqk1pwFUDsu+SAv0pqsenzGfWcfB9NReEPf6lOKGZmtB4261T0jUiuT5jtTE17esdQZsRi7eYCpHIuHrQ0z6+21XQNH9f/6GD8cXie0wQNv4Gxf+9LkjgGA962O7KYueh1ZYtjvl0e1s914dDMmQJTA22znQVEJghFN9zrVAE2bb2LqWh9qLRN2v/gvDcSfW92zW+VwKFWmDGVjJBnYska+tltK/99+X9JuJDGKWX80J9fDCF+EqlfjtLX2EjmOIL87zY480DeTJUqBaNYqQL3aDW7edJ+a1c=
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