yBhrht01IgiUDRhbzjQUSc53TFVEZDZ8lJ1tTwpcOIbHdQipopSGzfUkhnY1ZZ2IQ+U3SyuKT9ih7xWek4a0U+3761kGopwXUEJKopI1tZQNNGTbZzpbQjBWfaofzJpuqid78NYB3x+MBJUDULYBPDWreGv6PLoJ4gWU+m1ee2rmEoH8xRrdILAafcV3ZX1nof/tV3WJ61BwGoLp5qsAI0HBJrbnuuW2C04/MvLcLe6kgAJYV01/bYTWfMb7xGxB2TFYURQnuhXH6LEOQaXYT87yT1WEkHYQZ9TZSo7SvHg4JFVP+qAYbajNfoNYmwV9EdSOVczAwBpGQwoUEzfvFe1fSkuWTl4sA1KsFk6wGHOUFYKTKkpiG3q1mNfNkqyHf7fXDTu/5zVgO6qq2KfA1e6W+j592CUw84uGQFyoX5AObyGOgt5WCRLT0xUkAdMTlZleJIblVyA6anwWpv720l1SYjd0tcLW3XTkzZhyua+uPdYogclwX2hyXj5FbQgnVZ6PdbGntxhrlvl4bPTWWd/No5OkNvEGE//1EcjKTROaMEGPB9Tcq97qTyjpo2mNqjYtiWX/ypOd+uMbGSYC4ORBH8nEFRtVFWV8wKfdHBswuBjwUKfhAf2QLnj0IIgtSiz71vP2P4id7lQmDO2ncus5o4lMq23QgF25ysyimCK/fKqzwYuThFKQIcSDtkcBYisA3OOg5gaPcR9MnVdgzpI+3+mSpPDHjll9UkA61dKdVLkY7DlV7nWtAgbs/fKKitEGjho7NNerLGQIQXOy6/IIPPHXVvbHr7NDC2oBku3VHc1mJA2vnb5/TrDgfb+fjqrCUR2vVraVPcJ5pnxdtfb72C6+7ZOBM1PfXGFe5XMSHoM4nONwzzOTBqYxTKLiEJmeHQTpgeeujyv3sz7wzgK78CgR4fZlDzPO8mH+vrATBwFGwf98AKZMLrpyf3AdBCFCTralc1IBvJRUT+famm1F6L498PldxdLT5n58XVBvP2Dwc951YExNtpHc7ujfjh9sNLth75Or6yEBYV4T7nDud9hJMAW9q40XPem2x6WzWkZ7yZ/p2R8ezJgJ7Y4721C1XGm6C2n2jpiGsxCdUBhClvd84u3nKS/AV+rrOQFs9aEc0A8Nc/xUEhKMIXZVwUf2j7cuch92kuMBisOIIB7qR5Z3poLc4VQYaFvrAhB4Tb7rwlavoNjD+Evoi3jKRcmfwhYGadWk3RrkZs+9Qi4MGXZqT67XUrM00+7Ijpojz7DLnX9IWjAvEMxAWwMegbweVdR4GvJ3mNj/GLV0Ql5uXt3v/gBZ+0SgZ0wWLGl5d5LboqhdaSMDd6QqoGiLpiWXZBMPZe1NAaXktr09M6d4xr4YEU9qTBzoSw0=
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