plfbZwsn70D3zhtTKiK7hWRAo5C7BGZ1qECSzrAVhdqZdTGj3cCXr+sjWgFwqAF6s4WBciopAJVU+TnPq7USOmxgxjRh9DA1+8Amg+YkxnsP/tflpz0wEC6is6H+tQlcf/WxxCJnxim/hQqTqZ1thNhE6p3ZuvtbLgUs1VxzvWIwWv6M56IrHVRYrPUNE0sbcrATrX4FndyPFEgpAe6SlMuk0ulc6+QVGmZUCoWtIyzWZeNAPplDDSuoGxImy6k9HYrYf7uotJdMvIG3OZmhK4NEX0mzS/RfENZjvdwoNgKG7YpJ59ATfOJYRxGBazGEZOdhetG6LNJVqzGqMKYqDpZRKMz1Yhju6AqEIUBkICc/wFMQEg+MsMDN5JDpS97kkZ3syMVYVcFkW5amEFnCpaidL3rtuhWphuXiYVrrEjlbtVA3H+rZ5cH+K1IIeSAIE5wUwYGaQM4Z7S6e97LM51MfHrsRN+Nqv5/Vs443S5Nrbv5T7ouxnNV0gK5pqpUA9yiU9e33r2EodrEqfa7tCvHsTM/FaA02XmVDTEcRYCHaTSEQJ+1GGpeSpSRXmTvE2uNpc5hWUw9yUKTe0FS5DbtnKmHxy9aL0wt18aUOxwaHXD1P1YP4Xjzphwqge2w3eUXyzevR+S114R+Yl2hBf6ThV00NXZrD1Ri6lTY/y0j1Se762fHfwzAYM9Q01WFvBK+ukSMEaAraYqb6MY1LORkIbq9leWTZtkgQKtkV4SnG095nj8e2KIrQrsq6h6tmYyNTdFWFImBM19IqOT67kwvlSHCNe0r7dek4lkd3IyUdr8UAhk9i5WtO7UShrziRekqWsY+oD7RYlUSBSkKZ3gVehvBhLBdTD3aK+ydka8VK0cUah1cCFdQTgr95A9/U7HG6J6NFt+viHm+vB/dnmQ5ncIaEJUSqmm5XCdXW3jf//6ZRMPqvD/sj+LGeZIG/NjfaxI504izPEJOi23Z99uMJJZWPQ1EheuU3oPP+ZsdmE3WM7Ud0c+rqQqGdu152scV0TLPt4hdg3kQ+rufiMmyYCcEwsKcQd0oDqQq9N0hfnGUdRGybZyfd+yvdVK7smI2jVIqmZLcKS9TCn1C8FThSRiRUId6G5jxmfKt93UOFPLXT3EH/sJrwqolHX9Pc3vbKHXM34Mu9NSS04zj/eQhZ20C1k1pWmGKboGlPBRjP2G3rprVC4bVB9ITEB4uo03HX7wD0K4ZuWadpq0cEUdrIA2wgPxcIJgmBG8UjmfKXArJfr59zLrh27D0rEcmQp+h5CmXTbFGA0qPp1X6v9u+z88hMYGUeET/2ctUVcKcy+pluAybhUVgyIYx+Vs2Y4TqzfjSoiQcTtXz9bViaHzPqR5ZLiESjINED+Go=
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