SELECT oi.order_item_id orders_products_id, 
oi.order_id orders_id, 
oi.product_id products_id, 
oi.order_item_sku products_model, 
oi.order_item_name products_name, 
oi.product_item_price products_price, 
oi.product_item_price  final_price, 
pr.product_tax_id products_tax, 
oi.product_quantity products_quantity
FROM <@PREFIX>vm_order_item oi join  <@PREFIX>vm_product pr on oi.product_id = pr.product_id
where oi.order_id = %s
