SELECT *
FROM in_inventory_item A
INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
WHERE A.product_id BETWEEN 6838 AND 6841;

SELECT C.journal_trx_id, *
FROM in_inventory_item A
INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
INNER JOIN gl_journal_trx C ON B.inventory_id = C.doc_id AND B.doc_type_id = C.doc_type_id
WHERE A.product_id BETWEEN 6838 AND 6841;

SELECT D.journal_trx_item_id, *
FROM in_inventory_item A
INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
INNER JOIN gl_journal_trx C ON B.inventory_id = C.doc_id AND B.doc_type_id = C.doc_type_id
INNER JOIN gl_journal_trx_item D ON D.journal_trx_id = C.journal_trx_id AND A.inventory_item_id = D.ref_id
WHERE A.product_id BETWEEN 6838 AND 6841;



DELETE FROM gl_journal_trx_item WHERE journal_trx_item_id IN (16693063, 15960233, 15960232, 15960231, 15960230)