yzbCj8X//d0nfNqQqgem/TLgnXgNk7uUXCcqPb7gH8Em+UjknBzCE3DveFMWSynXF8gtKDuhZUFHim2gNtkFCFIf+oi3DOPDOr/B8tf/eX3sTwo7v/MNqUwwrYOywMeY7gSPt6Egt+4W7TM/jSHcNlBIaS6Gr2rpB03tiTS90q41CPpfVeX35n51u3X2/uNuPB5Pwk9jGgMRFUwGBB77/DWhNMiZo7OSuVMDFzNTBJnW5Jjg75wotSJBpONkw+wDbCwmdzdEGI45A133H5B6bCjjLdkqv9bdCHTiAkGhXtRZY32TJMEJTA/8mR41f57iWjEl48QmG2k4l7mlPS8MR4vwBMKdT3laDPBo+mXgaXPc4IE+MU9jjTECFK/IW79DBw23PMpSQjihliIqoYMVo3nMvKl0V/x6uzVYjFVlk7uioexjQTsiwjhgDzWpT+ioaMTdHj3rJa8EcDlsB6+F8qakd2b8h7E1qFtsnu2p16Ei+r9fGgzG71uBSkiyMMgwY/tF4x+n0XV07HCGodpLxRWlapQKzriTJx47SGp709CaKMthbG2wTnGZTUvU4l4hT75w8/PdGajuaBIglPZ1DiGYbdBdJG0IK+YRlPzbdYQlSk/Yl0REKdcWc5igOafiEHWKSimzbcLb05YKmLLQrxnCjHWgJsTa7loc7rxZXo4FtiR61/7IO+5zrqMNM/MHwVAQj2ds+EyMzDL12Vi8vpMAaDqFUeuxgYy4M2AuC50gA0rrbwBBXf06EvbKQvshopxizgVxTSPn52bCzNAS9lGconH/pytDWqY7PFr+I6tEcvA7k/XWyq2B5Zn4Q/CDYirAR3THUzpZ8Uj/bOg1VQUIVM3DxAyni0t8TE2JiPYD+Z01rGMOWawbF8fBFGSLW9AaCHM1srLXiwX/OMHVLk/dAS/UhEeTIhRXAht1AoAwbuyA0XonhMZsIf/lWaKYf6Ljbj+11iHyS57eRHFHk75ff8irpY3Wje2XrqqgI6VVEmj3nTuDicdeq7WlvVSpePREAL/zgmRKDv2rq5hL2bSzdhUahmJ0/FX9umP6j+vbtUltRQV8AqeL7zDw/xZbWQ24bQrQtIMmCR8nCAsaGDHv82jDYxcFoYQXnlsaW54q3HSt9KplCL9UQIViaoomghOjlBcUuSNhSgrwA0lAVjqWHhvptnvvm1I2bEA08bj8FTWQe3gTj6glszjRXoy9haNatGrPz48bRKbW9al8NuxqYSjhPt0LsyF8woSFQDp+EjST9x0P0dr+rqQN0c0Vdk342Mi4M1kZQAnZ/X/EV+KLTBaXycgbiNa+bYW2WB+cOe5bMGsP4IEaUbxsFUC5rFdZeAwbxVOeRGIGezXNyFdGVvIzRT1VLqaG3ms=
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