Anek Porwal
03/08/2025, 12:59 PMraghav
03/10/2025, 6:07 AMAnek Porwal
03/10/2025, 8:56 AMraghav
03/12/2025, 7:21 AMSELECT
i.id AS item_internal_id,
i.itemid AS item_name,
p.unitprice AS item_price,
im.item AS component_item_internal_id,
ki.itemid AS component_item_name,
im.quantity AS component_item_quantity ,
kp.unitprice AS component_item_price
FROM
item as i
LEFT JOIN pricing AS p ON p.item = i.id
LEFT JOIN itemmember AS im ON im.parentitem = i.id
LEFT JOIN item as ki ON ki.id = im.item
LEFT JOIN pricing AS kp ON kp.item = im.item
WHERE
i.id = '65743'
AND i.itemtype = 'Kit'
AND p.pricelevel = '1'
AND kp.pricelevel = '1'