select p.category_id, p.amount from iv_prices p, cr_items i where p.list_id = :list_id and p.price_id = i.latest_revision