mNFSGF0ZleLWzIJzJxoeupemorloAfWsII6qw+Rl7liO7BwDlgnpFp4YJ3A/XNWZOcx+xWJCU65nD9g8vf9Y7emBe37XyK8CGNH9+dpnuI59mlSuO2tR5wrLVdZ7NWzwW+mO8KaMjBLgYsavxCAl9VyDCFw64m9L8t44Nu9xn2hwK3gGqEJFa00H04ZX1+r0Cx6bXNNJyBh5k2WS+HVL+0SN6JylbBXEvS66KGq0M5QSFxVisAZgzpiXz+bToRXFU4t1pGu36JLrybC2SVcVC4HaLRpYqws1Vq8wsMTVFyrFXeR8hor7giubgoqaW0z/v1e+PmxIoeV/OtidQ2xVgg19NLWHW9m24tDG10m5VxrTfVeLiFsasyeE0T8sg2UmGZH0gdbXBAU438IXJWwJy4O1sWo6+4Y6yP6+7MOLA/deik7bLlNmFAnMk0jOk+eH0L3ssxvV+SFsE5AtqtESqfPnr1bKv7C+5jlT3JB3qLyPUHmydmjPjOXKY47Gr5ZZ/zLkdxuNl7HzHOmM0sgIqMp7L6KNiL2p2SI+GstXE7bUacvODuprFkRihUiwduJeXPI2KM3BlwthDKXT5qZyHAPU9AjVi4ALt4uDoRKhJoSCDROkwX0ejC7RMj6SrY4YMHFxwM7P3CAPrr7mYNIheS0NmbNR1HfT2+tQ3g9LEaBeFJoFr1YGBOHe+CCPbHrsH0YFkEwWtOl5IDtBa/IbdTxHkg8gNDL29nmz2clX8uDHem6ATOVBG/KXx3CiWaqIQ9N2E1obnDcdK/k2q5ggcAaEtzbP7ixfWDCuILaacK/RLYR0UgkZRQjcPOot2boRDBQ0zWWjIKbRxy8qlJBdgV+TFZSwb1Wudiu9bSE+fxNcKDQiEWAv6nHyYj1t6bn4YpLWGOTcp2QdmERX2568LUtzX6I+jScBpCtpBg0wrdlgZmnYzNJS+XHk1IypcH3o5IutWdRmQRCK8znya5YWZQtdD4V5xDbB1tRCDmn6VsrP+IEwhPh1SAphlaWPy9ZfF0tJIdwoF593JfWqaS+MGOzNjw3mfFEoY+gFYXgL/dJ/XJCE1YokXRRWMmSXsFYUqJvZKBI1Qd5Vjru2OrrgopZG+0o18dipDXvGA1srsVae/cpeTR+t+qMl/gwlR9JJIDVBOi0FaqSnddRiyt0lvbA7+nnARtZIwK257nn9d7SF34t2QIv8k3fd6F9tvZIHV7iwoGpFIhDh5gVGcoYhP3VtYANI9TsJoJ9pPW16USdGumEK+serAHi+pwML3IeCdm5DurrV0wXw13pF6Y3d+XBQG8wQXVWWhfUte6A10+HQg7fQ8E2XejcA5aJWD3yvGeNGg/JYqp8+lxGcyRC3cqWB682KEzx976QRg0s=
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