select 
sfoi.order_id orders_id,
sfoi.quote_item_id orders_products_id,
sfoi.product_id products_id,
sfoi.product_id products_model,
sfoi.name products_name,
sfoi.base_price products_price, 
sfoi.price final_price, 
sfoi.tax_percent products_tax,
sfoi.qty_ordered products_quantity

from 
sales_flat_order_item sfoi join
sales_flat_order sfo on (sfoi.order_id = sfo.entity_id)

where 
sfo.entity_id  = <@ORDERS_ID@>