incofOVVgebvGqw6z1+m+gRvKLtqGEaeLxcAZ/tLlVVCXs6FlcGDWhlckwbrb+f4EvVYWUm7PgmPPb1Pk2pwtmpU7JrBfXj3tyETCLeMOh70/MDqb495IX7vIbHf3o8Nb6ehSDw3BQ0j2OVjyV9s1NAechU34R95fdEiHcov+3S2tfsB746KKimmJk+piKlieCVjYoXNsDvAYw42GAgRA3LADD4QpFWGh+rHICplRtF8pzi8PkCECNZP9ElFkUXra4MjBW9px6DkD49AoatefSLck9npCuivdyWLg7wym4aVMKTOJ9MDZVqMTwVnqp7VxFYaMTzh+1+NSq8gISho2nBL5XeQyHs8PZ9bdmZnKbZPNQCASpf5F3g4n6uci2dUik5bpbR3nt7F00x2ZHwhhsKoZdsX7zBLfJxjj5qAgC6ErgDAknB2Fhg6Zmuc+pBRqcKGqRuukSiy3C1evcgIvMU2UwWV0eOGzNPVYg+0li3/dpeP/w1LwIU1Jmo7B/MAw8rzXLQ2Sx5rEjVHDO7m7bJDjqlROLslfAIhaJVPSo+wi6ViCeTuHUd2zszUurhWWTGigF5ZURz2SDRJeX32mGB3YXUgAQsU73oz0irmFcBYB0DiFYZpA9DKITh33hFvsQNfvHwLWqRRFrhwVFoevXoB9NgYbWL7QH/WJWBz5qylyIZaQWh6bT8tHZL2OZy8sxM7+5GK1+J+eLS1DAKph3LjWKeOhXTv+1f8JyuedQWcc0JZ0qcgh1c6N9O2y+gGl81VwvjGj+jVc2kkv0B3ITkSBVt+ggKKQeUoR2PoF5eonkoz4qhP69zqd1iaXq41qjWZCPMukGaQu3byimR4DOTE3yH1FSXwavDCbCpOdCvGQhJySy088rmoJcPOxD0ukG6jas4TfhZba8brf3aey+MFnzOx/NxWwx9O0kcnTpOWa53a/yEfabC1EqMd4sGfNC4nPj/wg6O0DFLLZzjeWz/w210N3QNJXL0nf1Hi43HOuqVs9dlgw9owJ7nCXMMnE9ka7ReO4WVQG68GtjWD1FPt6cgPtfOGuAsqu4n+nOMVpRV8Rf9g6eUe741xZ37uPVYGW2ImjI3ZlWb6b/mIpPc7eJh4sIZNRmtI/Bi5dumcYp482iapgmkLny3hiIg5parvcZtZLOYF5UWKMGizDFS+6jgcgRaZoUD0slgdO2ByPfgEWkAA6sZZXRrgXAAF5les4gsX2y+CvpKoZfsdapbSqjTam/wv1qjQrbgnaV7UxoyKciOlufGPzZBWQ/lH79gUsbdHWTdkU/54FBsRLKmaAUfe+ykwo3/YJR8XUec2Y6uguMTdPYPR8ctrRD3EiZM891u6WO7VDI+XIjLuuYHRPDln9bxm1rqr+7I=
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