lJdd/tbHgojqtTgYMFFIssfHuOn3yQ5c95KTtRO3KWvsJKExfZWPkjcQautmSkwST/Hhz+sWtujA2S1TE1p7CfkUuh2taykUCTVxsw8PbmPSTFdwe/GIyKB45GDpfqhS9Ws+cMdzQY+ZgS1cSOK+m/vyWVhmddbSe/AjElQVWLxWiXKWPXnzstHAifmYQ++IoOFIUBRq1c36NGKKUcISBZ78g8Z46aEHMiE3AB/13jieTOREfCxUaZbJotKkQkswmgMfQd/1TlP/NV9lv2NwNOz70c1CXQ9zfqurbB9Q/i/lK+4p3BJGFmknnvlwzia81JMhruo81N5YT1E02paC/uwenoYUGOT+M1XZn15oEyo5+gXJCg5BUlRKmoGyttES5OBIr3Y0T28vtpIod5kkHHywPEaiXabiZrG2QACmK+2kO+i+JhCDK/tYH3HkMDE0gxlAuz0HBv2AJD4kphChP6Yr80juKFmDGtFSoyNy8GuG6RkAGVBsv3GJ3IzgA+BBb0lY2BZxT5LKgfkwNGRS2zkyzdz0FlKJb6aIjPhhrjVXRcRirRAxhmph/rj7KuqIFTKReCjUVPKSSMcHaIM4pFTHbHv1UST2zibQjKIPW07w5sh4DAwBSK9mbBEeREYCxcL1VnjC+CqBsRoq4aQVTXP40bVSuI1TjBNX5TJVhL5hrDnfTAHqQ27MqsDGmj0KpqvffwvsZW4zKQmLfZ3Lm+o/OcXn4D/N7jyJCL5fxh79MIiFGlnbfu39kyj2FOOMKHoFFr+AcPW+nhdlOSzBMMo2s4jFxcnY2xdzWAhtUnGDQZm+B4Y8Z3d9S52b5pP8xSlDoIt1rrReLV153dJUwbwnUDrYSM3UmelZ/m0Fq0cI6UViad0ARlu+pQ9KWysl6YBsMWnujCNsuREXlHofq4Hz2SJN0vuOpAxHBPVkSbuRVEHhaAlpEEoi3Z2VTS3DC5g/WWPKJa62k3xh95Am+chEWoYVdU7Zv18106sDs8DBxxc8sUR8BIai0NSEkVC7wQRYhjB6ik1mQBaeWb+I72GeKf9KVEFAfO9m49Rk9WYrDJcrCy1OqtpRx9VVE25ENGR1/SkbwKqcCoB4k9TNtyAi4m2JbabZKCc3UK7Zd0zRMvRTXnZkxRazWCaQMXR3olzEGjOI6H5xQihkxDt4dWrsDwZsgPyTaC+6uiPaDdennloHd7wKmFdu6rjPlj9px8m8yY48hPhfVHQjPc/TT+88IrLBm539MS/WkzhpIzayEAX4TpCeNSbZ6Z2xPICDUss+Gsoftke23Vvj1GMGNmgZnaf05IyettUSgpeGxawVL9Wq4p5Ww6NFM7ULrYS2BxBLKiFk4xl1A1fmoGu/jEBduSVLkxuhSVTXDAE=
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