GVsz+F+669t/9t+d35o7Nytrk7tXl8sx5gl5k1Ys/g/4oUuNuCZ+GNihagPbsdJlMtRllIyVmxdf4vgY2nAEuCHXg3uQT6shQiWyvfCdU992BSzg1/a7fJXugOutBFVtRhDUok2GzlFxuj1JiEznDlb+VP+F/xgqcoA62Jfvqz81FesHH9BCIbeP4XrhYLVzF8Uh7dB3JMQx7tWp2tuC3dXxajkfGD0HkrtGx7loyI7Z8vLtJDV9YPRrrvRoNoPjfI9Me3C2X+YPmZ2MhzOLHe8Kui5NGUhSRx9Sk7sAzsNAYCq7wngXlrcd+keCOmrA5I6nGlHYgtDeAODJT3j6YatZ7dUSjKJL/GYV8WDoWq34MxxOCRd146DBfEDaiL/WwHoZDDZoKKH7CPtIksjEjhJ7OxIwgqK5qggTUFzzV2Bj+Yq77DTOKnmSiKRxcGyMBCmg38uSoBOZRead/4wVGa6UdYfw03LT/dag692zYbxvXUvJ7cEnZ1a0/BbF/aQO7+rwvrwe/Ab7Z99Q8DFJ4zUaSW5RFdhIKutzCXEkNiR/56tfR6JCERdKkxK+zzijVvxgpqz0pFFmKGIezFGMA6RxziTdW9qqyBlt7+rWN/WgyDi71fSMVtaUsfnSRdjLwdY7Ad4/rk1dajGRVFKcyezjqEZjkLLHskkgG+SR9hDa7LJwgZSY7akiYxZdTgVMViUPY6m7048S0D6eOkO0NkUl4WysSTUI8x7v4tXVsW7Ry0FnZugE0WCVZ8A8G/QOOs1MD5jBSqYaf6fOBC8OqDIKXwboHSYB6iTiwdUPtNp2CZvcLU8UId81eQPtZmUDQlBMD2PsFj03k6i3ZF7GF4dNVv6l47sJi80QJuBqcxU2TwdmBrORKJaZetDJvVQTsUfhkDLaMZgBS3xV1fQimHSLak6dcv2z0uXNPu2itL9wX+n7Ymqm2A1D9ixkMjwa9A5sQtzSuHECTZaCj6bNWhq4A9ubd4ASF/n2kPOo5gSoR9g7ZW5QdXHZkQ08Yhuo1UXgPsbYM6iQH5qOYAjGKJZ2iYeRW77FAGNDIVgE7QzJBaEfAADz9Zt4EIm/yLxlOa/NSPsgVAc71W88Bo/2xkT+KDCNjGcmMfp9UHhYkRiuziEeu5y7s61atjKDU8eHeFLfj8RlgAJm5OWgqtrNvAKj5fAiWiKs9uuu4xVBaT6hTH2HOWsXQ/U7VfvktlSQxjgiSVNQmRoNCJP2rB8prNZjeHVqqN9Zp7egtf66u+yl+EKuq7rm263SCk9yjYfyMAEP+TXP3kiGbzSDyNSQX//ORx28JiYDoSNV1+5JIluIZQU+7QSVNe1erzUGW91nfiGXsQbwBbJR3LSHX57wtHzvcf2A3I0nhm0wGu0=
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