FOw4XuHbK36ZGoEqmGT0fuxBaTapmetckEeeUnDRZsbdDA841sMgk5AB7vBLMMcNvHfOwAcYMukP4IjCrZQaozXdooQ71nbtN3fOeO5fY2Xx929OdpRoANR9NbkLIFXl492IEuloQKznBRu21aeL1HQqfgtuSMA8KH0l33f52qH3FQPzdwKQVMTqQFgmlbzURBuzVjrh/5FArrG4sbx75AzPYCorsxJFDiN3Vf8u7t21qxjCiJxp8iqB+eNcgvoQDpSBeHjts/OK72t1fBGQ2Yvw2O1e/zpSPVu16NSmBvCK+yp+v7+oZCNV1Qd9bHSglgaAsSHDT1z3cd3DucuXpro//S2aK2LBxUIDZ+5pfhsu4FoUbzbxBxjwdnB90Lo9rBinDQzNuapvdoZThExXunzKrA+fwHe1eaw9f3SnESZ0oSxgny4gH3R/Grla4g2orY0XXLINTUYb7vAZAI30dum0Daa85XoBk8N9BL4+6Gkfnsmabb22xnYmXU//sFLFeuPcAvSmNSJFxN1ohGSFA++4bGl9BspJ/U6/Mv2ensVJQTP+1/WSeN9ZmhZnjPss8gdO0VOb60ebPU/Rhyw94kRtPOFhNI8dlTstuFG8rd3+sIx0ZbZfTg+DrYar51Ujkf03RkSUR7YM3UXGh+W/U108y4qbbD+KxtdvJmlpkwWUM1UGwLRxio9pzSwZChETZzDPrm6AphIVfL8GoJgNdaSPy77eMoHvDk/U65vLiuypcH+5Rf8GZBNd/lokmea4mVS567tNF1aGUN2d1CK4AMqie6s6KJqidFWb1QscvpzplZvF2D8SweQy6nqbf3MoIrhTrLF9InAj8dBH1iRWhe6tgORposd07YqJBQ1D9oYw8JQZGpTyVSGO2+zQ6ra1xmtuZsfjjH7n1Nq80x74mjMm6JgqOQlgWfPGOOcpPUnb25X1D6hDZl4PFfik+f4cZ81Jle9SbVOF/2fa40AmJYXVJGVicKfGYXLRqLDLebkQcY/REJc58PEuZQq4LAhOanlTEd+6RCOLvhew4/3NMB7i1Fwmn1T9K3SpKwIhPYVANiO2mJEwv7QwzLTTDNGno13tJ84eSQV9KDtha6ilCw4+FxOrzVNlO4xtj+NAkGaM1CMeDrzc3Nxela17FACPgK9OgWe9rDESa+YIz/TXOwUXUTXgkFZgpl6WL7qNNOlXner73nnCMo8UjgugXdMPat9ZkoxcW+fyWpF1rvb0BVJju29IPAZaIV5Ih8OpvpvEP8iWt50ppmHt6LrzbedE5ohay/K0jq3n5k8BFgOwj6/WQum9g5I1rln+0i38+lrd7cSNV8DBFNle9DgFUQ+dsC9IDkgtjN59eNRUPylP4V4YyRp05wgIlm3+05k=
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