tblPzXxRxyHHBl2iBXM5QJmRsuQq6e0zVgWdfdc2Z8EBdoNRnjft2kcq+AzNXkTqf/omK8c/S9uK4E9UdhmVGNuCsXnSA2wJP6tBh6n8k1r3Y2DJnBFI3lr3BtgLDU3ROslKyqFDjUfsjhdpUAvGVUc+EX+i0GV18JtCtIBcIq2rn1OlflqnIezm0KGhhqQeK1/AEDLUKEqCOvNWdISpoCL9vli8k5kq3sT92X4NVOfvARUCwygfZUqBO/O5jpC2mLfK/P9oH7xCDCJd2qY2KAjZz6ILnqQHSJOZMJ4jT9nFF+OSwkSuqoP1eofdGrwGcBMNFTGFl25UbuN+Jj68JHAXnX7yUvstqSvib+FbvOpFWjizl4em3AQNQoF2tQPTigDOUN0x72wRRTLj99l0D3XUfp3mb1a89WmrpZWRuofA4LRi0Lgk15vOzDnQj7TsOQ5W9mUXT+vkpYxCXnF0U1Y4WrFfuhJoUg0vWGfE2JZJSd4222mDVSg5aTRwjZNJkdRGGiDRbGcG9XV7Sz4LPR3SQPNRTkPJYFOfO5lQRFB0HaB4a8CNh6jSs6SVRBX6YKSrJIBnvMBUKF5n6TiJm7XAF9NAFtjsl5fZt/HXT+Zl0fQ9uCo/ZotizrvRVTsV1r9qczp37wisDDiH6O6kcFjVausJ2kqWz4g5Vpi/8FhPYpuOhXsiz/+tBe83WNCHpNOdkPGV/u3J8Qzp8fZJUC/q50mkXhLm8p1Dr3vI3u5COvsySUf+kQmwiSl0+ciTq0tfMXsE14zG5UnnAPMw0/u91GEUT8nf7K3V8NIyz/EFl8kjyfAK6VT02DdJoj/7OP46C9yvcAC+5ZE28nRlYYwzPqN3PZ7BQPIUG+x2yBOUvjxrq3sN+bG1DKlloNwZlaUdxQdjvMibzOv1PaKD2urYrs7qjyLDdyC5F9jb/c/81w4sZghIqlxGLqolhENsFzSMAQGuKRCwWUwNJuEy98byL8bTU6GaJ+8KpVTOqGedc1bXLqx8aIactZbg8oehuYimunQuVKow+jnyG4lZvGyIDQseFPIJe1cZ+ZcHE5ftVVro0wSUtPoe3kgwrzIjwkISqs7R9JvtZJixkIl4ga70gg3x4VfRKHUwGCt7EOA3w6HoTc2MxMBdTaHRGGTHPMl6DjsSizvvaTwQnNSCeW1plP9phclaU4xWAUfJCmK0XwnViciAqcfTD/PoIvi4di7r52HC9NuTU+r1C2DccQDiKCxrq7mN+xSfcRzqJNK2PNOBEgH7tYKQdYLQdGpPXMewCSiRhzQK9XuVXAzePedXcbnyrZd4NmOki2IFwr2Z1lHNXGnK9SdlND0PSxG8x2yCACPl5EqYon1fZZml3GDAXvDNzmLkAUOzdaI=
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