Sample query to fetch custom price levels in customer record

SELECT netprice, internalid, base_price
    FROM (
        SELECT
            cip.price AS netprice,
            cip.item AS internalid,
            ip.price AS base_price,
            ROW_NUMBER() OVER (PARTITION BY cip.item ORDER BY ip.priceLevel ASC) AS rn
        FROM 
            customer AS c
        JOIN 
            customerItemPricing AS cip ON c.id = cip.customer
        LEFT JOIN 
            itemPrice AS ip ON cip.item = ip.item AND ip.priceLevel = 1
        JOIN
            item ON cip.item = item.id
        WHERE 
            cip.level = '-1'
            AND c.id = (${idPlaceholders})
            AND item.itemtype IN (${ItemPlaceholders})
    ) t
WHERE t.rn = 1;