LB1RS5NJu5LQeocdQjScE8yEbxuDyNobAwRoEeYxL6iVwvDNqXt8fPRnLsssHLD6PSFaBjouo9Rw2R+G4wHODeNi5KSrMzz5IYJuWGHU2A0TUL+d6FqROgiChkQnVqB+UfZjFSIkJZC6kGM0lSZNfx4E0PZWxC1LTrfiGgrBEPl4AmN2ZWY66ZCxVXHofsRVYg2ptLpKt6yVmt4r4K60GyHv2oVLfb1Ti6xAvnH1GmI/MSW3JZonFOe6/vbTQ/MCGrkHxOoMANpemihSunE7LoRH58KDiUV5BB8eb/OPQ9WFABXv3UhPRVIznRmw6xOpg1tWS/ybxl6FbeZdPnH0MLEnAsz/9U8s90qkYK9uWpGDBedFpD43fabgBGUzYrdClrR6a+YSaQm2DCtVmV7zQ+z6vopOduiNNF+fQRJCNjMFa7lSwgttmuHE/uD6iQbhF4flLF3KIBaY8Lge+iN3VJHEbRusOLaqpX10zkOVYVWfFPj8mT69U9Ofwlyp5K7Gg8TRaAf9LOeva1Sg4iLj2Bk4Ioi3O65wEo50VoNU0qAiHJ5zx+sCwLnFuhFM/V1ORIngYXJGlwmzDSRwRvqla5Fxyb1WlrliymG5id4DEoCzJqUwvIlPuMOIzLbjqqs4/IEIiEFpHKmpSAf9t1HbBQW/iDRUq/Xluvl/ZAD/mzAWE1osJZ/voDG33Tx1mYFyv+5A555FMj1U5yHkewZ7PeRh8J8Ffc+UDN828hBdZ2cH3F//ty+NWrwzltZJfXoDMjXJkvNyyWjLZ4hyvREFlXOCa+ONShRocgB1L71FI6tFwT/ONViFH7cTAQ2eSpJ5v/RfCaCVBhlPmlUiWmCG/DkW24CVlxOrTocMhtEnqIzPT2j5qKuVDBCV0Q3Iokf08tYQRoGUI41I5aHXNHispL9wkuuWFOS0xYDFCFja80ZltdrK00ikqsPlUFZuPrbKcS00ZVPoB0/S3aXj5ws4QRPNHO2JhTRCdj5h5PwpgvbKTcI688eWfe7SJeJkNMW/rC9f6zT/HGLKxlUmLvGJaEWW48+23XvPBn/98fdapKyoNWU3GdMOh1TAsSXHt5UtNDePBiEUcR6jPv2hz4t4CjhssgzNKdh4k8W850Jg83hu1Nn1+ZaTZ5tql1+EWhoXvCVK6qEUAm5tpt4M4tLmcIQRPxxp8iWx1Vmxe8n9HylTrj9rpoTI/qK7/xzpvGBZIBzWByBspMlioJfwD8RcbI8C406zIIv50IEEo+9LqmxOjGJLLvCLfC6Yi47vIq0qmrsXhvc3C5Zdnf0q/Q/zGWjfOMnMopCCN+o17xSQgW22orvJCWWktvwa7TG9jlqklyhxN3xowNsk7/U3ge8wq4230n20wad01RVTaWs=
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