CRwvtzAldYaRqvefrCl2EzxBaqFJjcEBaUwVIft3GTXrfwMoZVVm2V97P1rec1+JJBIy77IIYvlbP+J++ES1iAC2ZWXHSoZWvy/VFRveWNVkM5UksfYxtMm5JwX762IPwwtDmvALrxXjgGvGIj824mP9+xhib2jJuE4FOwpdK66f7dpRQRg04UwV8jpaNHQJQDXvJZorsl8N1adpH+rYALTdgMxGjQli+ogcVFMoh9V2lM6ysYcv8Ido+IteH/JfT/yOsZoNcMoKIfc+EX+V0WkTVV8WaHpkSnVnqwDOa8jTUAnmqOK0b4ZmyByQv9yvLL4hk3RSdb+QWznb64/sHq8w5ARM+gCwS0rT6Eg+myZxDTY397Egc5IE/Dwb3xBJDWOtGQbSXl4X46MB9t4weU95YvjqfxytIjdn96YTiqj7wmZUYUgbp54LBFRI6uCXDa2OvS7SOOy1R/hyazzM4oRRyvKRTNbu1/Qeb3rX7MKaZpvuJf4X1Mc7VaO5EDWTpIC2YVS2ikx8Ih8AX728Hmw+F9U91WDVf++LGCyCxwyG27ry7aQArTcj+cmHUTHtHxUlNGyf4lb80leLa7Z1axsBg98gNTTZCkZZyKcXd9WMhA+mYlo8JD+u4gTzeB6xEValVMBNCiSTwOwv1NH+jzNEgD8Aph/Go4T1QR5y+mMpGslmGpbKsR2hl/SDGiz/VRTe4HW+eMB2ByFf/RdTPeqskJO0Z3ICB+p2AQb0s7qayw/GXD/1RIhIppSdXRmf8/PXhJwtT0+N836STnbte6MoO56/CaRxGVv9pqC9mK9Fx5qAxrloZapEuQH0ZYAsbkdi5QyXNhtwfA/mE03JCtoBJgD/Vl4ZM7bOatln4DGobfvVkHt93sZBvc/UopBtV6ShF3zF6i9UPVxuzwdO1bexAhDhOevOFVMR0kviX5s0+wPBFxgLz2Fp68qgTFt/4AEypzlRBjfgPchAREvdOyM+mrXaEzJmnhuUN4K55vVTA6Bp9tQ6WSxeYQTSt8zPeFZ7k4vFhAF2gldbzDwIGyBsiCk9sqKw/qWqXimfJTY0X+HP2z9QLrLEsuowlmlIrOcmy98G7ALm6jU8iBv6wdJLQueOx+SUsW8YR24DEImDPy8d7Ls/OVxpatjm5ebGoHCFMdihVrZyG0Ep+mShjJ5jysYCXhDbFt8fTP8RXd3/r/BrFGVr480JACjCfw1vZ4hX0AzFTt1uUbSj7J7V3HCX4JyBPSnXEsfReHO2PI2W7+RY7T2sI5yCjx54O7Ma2rsSnMHr4P/p0m5MWcbdq6PQ/jkDJMvA8x1T1pOMJ/Rwqx1y3xA/Dd+3hsdZTFx5WkPqNlCaI2LTfc0Fms5UTr7cGq3RlJURTAgZli0=
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