WITH old_stock AS (
    SELECT A.qty_realization, A.product_id, f_get_product_code(A.product_id) AS old_product_code, f_get_product_name(A.product_id) AS old_product_name
    FROM in_inventory_item A
    INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
    WHERE B.doc_no = 'ADJSQ/1605/000142' AND A.qty_realization < 0
)
SELECT A.product_id AS new_product_id, C.product_id AS old_product_id, f_get_product_code(A.product_id) AS new_product_code, C.old_product_code,
    f_get_product_name(A.product_id) AS new_product_name, C.old_product_name,
    A.qty_realization AS new_qty, C.qty_realization AS old_qty
    FROM in_inventory_item A
    INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
    INNER JOIN old_stock C ON C.qty_realization = (-1 * A.qty_realization)
    WHERE B.doc_no = 'ADJSQ/1605/000142' AND A.qty_realization > 0

--OLD
SELECT B.doc_type_id, B.doc_no, B.doc_date, A.gl_amount, *
FROM gl_journal_trx_item A
INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
WHERE A.product_id IN (41058, 41057, 41056, 41055, 41054)
    AND A.gl_amount = 0
ORDER BY A.product_id, B.doc_date, B.doc_no

--NEW
SELECT B.doc_type_id, B.doc_no, B.doc_date, A.gl_amount, *
FROM gl_journal_trx_item A
INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
WHERE product_id IN (43520, 43519, 43518, 43517, 43516)
    AND A.gl_amount = 0
    AND A.sign_journal = 'D'
ORDER BY A.product_id, B.doc_date, B.doc_no

/*
MQ19 - 15873.000000000000
MQ17 - 15873.000000000000
MQ18 - 15873.000000000000
MQ16 - 15873.000000000000
*/
SELECT f_get_product_code(product_id), qty, gl_amount, gl_amount/qty FROM gl_journal_trx_item WHERE journal_trx_id = 691714 ORDER BY ABS(qty)