uBS4p3wEC8nwRNIVvMIBydNS/A+1y7DHrl1QImYHpM75IFNxcinI6pI8DDjkQV/BpdhbZKrHvUHiiu4yGPPiR3HYbS/8YzQD4c4pXaVSpir89UbtoyA0I4srP3gJJctcO3k6JZc/slJOPVIBjTnz47StmiBsJ1jtMsvoV3Ewjl7z3Rb+iZoeUehQMi4+Ts/GCKpOPX+hcwVhMwyrgVkd/+HfPY1VGL/vZVfU/th6lsx9Di+JwnNpvQE4LMo2YydzvDW+V8tfWq9bHJLlB7Nt5nnITio9FbFz7nTRs1fr+LL58boECBLT2L75IVGq3aO4GtGm25LiLmg+epggIdZ6Wl5n6J+cq5KSUEixmNQ3nDX4qfYdNCOHbto+eQEh2mB6DBfJbwDfIglSbjFKte5Eoa1ZT4Gc1/webZCJ9WtQ+0w59bvQHTC7ngNDUcdsuAS6nb0OlxZvJPL5OxpINwo1rH1KiTjzC+RUKfdWfubmgf39QfVstqi877Rtli0tpm/zPvpVZNbYlYvRC9l82y3Cn2ebN5shJHgL4QUcAeBAUtfWp8qkm/MfapsXEgSXdihq9KEheyB7Mgv0yVS+uOSdyhZ3272KNjxfMEyXxG8V8ugw4P2UZYowu8P8cYbF9FpxzOVrPoas8+XcFQur7GsRH/oOJ+Tb/ev23dkkiTFs30ZdTvpca7EIxOXMfwQoJQ8eP+r+SyHIE57d38rspfSeNAFVpSvZyEI5uTSJxvMuxPuTDFxq8rdRY0F3vpleKBxFaF0OVpvAX8s8TIukDGA4baBVLlx48RJPA7Jw7x5lD/iOOcR8BTVn9s8lCARLvgWt2csqwMX75XwAprWdGJDtMXOKw2cSwliYCApLlio+8CNbNywrA2ufPaY4G/dr9z5CE3UancWnbYyqsis+aKecrrFNvNMZDs686BH65jfi+W/1dAvcYUG78DCGvHSeUbU4lMjuL1mxsDKvPMa9ztWu9q9RlVRO7hP3jvt0Afhj7jQhqTbuRjT8dbEXVWNQg+4jH0LkIjbXJE+X2evQ1bERsuSUu+hUdJTBrWxAW1V5Osy/mmOaz5fPJDiaxOc1MRVMrU5Wg3ujB1gnfdmII/0BQ+CnUdlqYte7BD5OJoyRLsReyjBAz80nnvksCuobncVyU/7+ry7nu1T0Tz9+lVKZxmhEV25fpxDcH4BjmDqWaarEXHl1rpj89nkJ/I/jrbl/0/mJ5o1ams87fCuC8NdTZZLlt7GES257PVBJn7MLb7uTHanUtWn6nLY0IvlbqjF8N2XbipWft37BHz4SafMQa6iH4PhT2vzf+zvzYYQ0J3aT6MpW4FWTfQnUF0VDh45FoHxiTZD2xvApVFOUADXvEyVh0ZkNWH0ZBh5lWqg=
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