GS-2375

alex

2025-10-23 96afe9253474a7d542f3e5a467276993b7dc43ce

 lib/db.js

@@ -505,6 +505,7 @@
                      ulc.item_id,
                      ulc.lpmode,
                      t.obj_id as item_obj_id,
                      od.type,
                      ulm.status,
                      ulm.status_changed,
                      ulm.percentage,
@@ -513,10 +514,11 @@
                        INNER JOIN ${database}.object_reference t ON t.ref_id = ulc.item_id
                        INNER JOIN ${database}.ut_lp_marks ulm ON ulm.obj_id = t.obj_id
                        INNER JOIN ${database}.usr_data ud ON ud.usr_id = ulm.usr_id
                        INNER JOIN ${database}.object_data od ON od.obj_id = t.obj_id
               WHERE ulc.obj_id = ${obj_id} # obj_id Kurs
                    AND ulc.active = 1
                    AND ulc.lpmode = 5  # nur mode 5
               ORDER BY ud.usr_id
               ORDER BY ud.usr_id, ulc.item_id
    `
    const [results] = await pool.query(q)
    return results