JYg3fMSsC8AzzpdYs8J6yAispp66fF8fTM6SnpI5R6FF0ZolizAeDPE5y5neZLVv1P/5SVsJ4fQ86c8HTOHpsj9D9QT/ctdpILONkGqB+6r+aZWazs5INN4fTX3YwvJx3Dclhn3GZwGMoV703POvC9bUZDOnyHMyUR678zX9vklOg6YxtWSQizR7EGXUO5l8YtAg6qs5k2vuJSYqaV0gANrztCPcFpEtlgOywPwmi1PYbLrloTKxYYQxglZgKtyE7r6EXhiUSEqJNarjUFc6h8OHP4rk+7aCOK7VfBz09UpnUCw/QyW/eF0QlQzETeILhbY4WT+MIkPyLgrIMf5c8+2ag5JXl4Jm5vl5PpF6lx9sD1XezHyAcALOk4CCDiKVuqUr+K/aWmobDi/Y7getxwHHL5B7UhHvsrDFfC5XEofSPzd0iTgKnvcVc3/H2RH2vb1xGHCh2QRILQQNCLLTOVQdbKvIVjuCvUBxIeCXKJLNNht36Lu+3CgbYHgLFLTMJM8OqJU1sHEtHis16Uc9Xj2AnQir6QKfNr8sGm6+ldIJCeltSWsR/IIjBv7uVeVoJZaljQYoLKVCpSACqxRV25QUEUuXGb02foYyrImetrfXF/dZteDD30Nrst58dh0qwGPmPwWOVj1Dkdi8olaF8k7fvqdtKnHsRCQqMpSsrfKxGHJL+bRiRLsWodgr9J/uh0eeGEOLTGt+jhVBgeRI6oZ1tcdfTNxPx0HQoMper/c6zD6EmF2TrYJVM5ut3xiilnrklsPBJbVkMwZ4AAmG5TELQd/yVNlgUaFgMSCs6YLC1C4/aRdpyxDSKTTCUakUluTOeE6akQihykv0XyBL3rcTwki8o/WCY7oVK9QtEkwd0UqLWR9I7XqEpBKgBNAX82ajOIUfA006/G2jPu0G2hfkdY/Oeq256ffC7hV0wxgnzY1sWjVTcAPOKhZwJ2EWLnWZcfp6swVWIXOlSyLzA/NhxEHLvSoZckpRG/AnjRZBDMh+Qgwdve5y+Aa1z0V5Ml/OJg0rmnF6nBo9F0PO+6p/sWEX97VNPd9ZCzZx0heV1ThQRWmuFlB+3kxKXntHVeKeFvtH3W1dkNg9TQ59M9+sNCN8rukRnHj3w1stSuTLB5xbbIt1vv71R91ANRR1UwLSCn2pr6krWzaXMdCFH+FPkNTqO3kAvBwXEHo9ojvP7RwxPYPhKXov398jvGqZFdIopRC45z4+oJsVA0eVhx0LihuKgVT1+5I7dD2UVhOUmqDwxxAoowEDLpmXlTm9IabU9O5Plx2YmDXMz3xxF7o2HHGwzfBbYWuq0gCmpbaYrrroLauiBMgs0aobGtXuyGTF67xMfhoFCeM78D7/Paw8UFOcyXD0J3PQWiY=
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