qfVhn+NtRTEQB2/PRRJgPqAsknux7V705j36NnLpwOzf5HUDag4DNKQw3Bs3Cs+YF2GYqSLtp/qGT2xdVQMcmUe9njaEYBvPe8uW2o+VxEuHLtHBpEVz03qs5jFgKO9qYAntlCqL7shbUU/cEEZ82e7C2TTcOl/CduP6coDH9Zii016dBd+l5/pdA3QZ2Wpa8mFq7UW6K68CNNZpqQZfMPK+yI+rhIqJ/y+IJNj7DAfSehC1bazB+sDdphFkPu2aAS1IMZ2uh04mg7pT3Q5hz3h2xJh3u69YYoIr53Bl4NyGMcZ2vpHvgPiStxvOCaqoNBvMSk7KLygVgEnBuFmEqDaNn77Ls/Dw3jGo0PrjlQXDL/u7KkGWRLI1Jqekk2GYutxz7Mh5I05RBIbUuP8GVjEnu3bRu4zw/H5udIB4vuN0nEH+OL86zsKgsFOUyrM1/27Ki+NANd4o/AhW5JLNnBSmnB4+GbmzPzDSYNoy8MPORyPtBpEwG66NNemKyCuV/Wa0eY9SIjT+7ZtLbIMAo4fkKypvqyQx5VTdxkmCzaMyj4fBh1nQIiqu2TounMw8U7QEubGC0tK65cLa4MvBVUebqEmkveKMjjNs5n5cNqo8GmC12pQ89l9m0Cjww1BVBqAfVSRu1I2BWUbioEtMZtbSM7qyrr5qsLZTxbqUxqhGivq5hfRfY22/qNmk+lawgbBuFp7FZWdVw3shoMjdHoBjPS65COiH4rzZ27NzOi5X6lUFkf8P9XkfWmPFWX4t0eagdj4R99VpPUn9FY9UkOpPDiAjgM+tO9nPYH4gia22lHEHA+K9YJuUcDHcCdNOcaa1zhh5RqE+gU6/ul7qsTOz42X2BTIDljeehvOG/lo1ODyB2SygF37aPXHfwjqsI7HI9ak+DMs0wyd9oX8bSGOePTcf7c5Tvb05aEjGuKda1HTPKEempc9aBgK0Jdq9pbqqJ4AFKuMfJ0uF7f/hELCpaN5aaLfELgfuIwzRLZqtCE6AiPV7CzT4msJdmwd9rG4VNO5B6Umx8ZJOfQwLlhQ+7YnYKNTJc8a6g3ICAdqVpZdsCZV6j7ds/FVcCkgrZocbRIaA4p6yQFX4hvVIShGWpm+4vpVG4CT7ml9cVkrDFZPDToE+li9HEoZY73AIPIaJoRUwIsV003kGYwJKUk1ulACL0LA4PBryjiQrVw6cln0vozDFCqyNsZ2FYaSG9WLQ4XDcg35esPzwHZ03PvpjHqyCFiUz+GxO/w0s0ZV4etxyMGWwO6aQ2bptvXEp6oX1rT9DIEp6xsp+/lrbBhilhKK7vpTwpEnMTnkPmtWy/LyBHjXMwubxEA1ZiPhRvaGRUQKU9WaWPFsogfgtcg9HF7fY/1SSGdP1mIU=
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