to find the product cost price from direct SQL query you need to join it from these tables:

• product.template

• product.product

• ir.property

For example:

select temp.name, prop.value_float
 from product_template temp
 left join product_product pp on pp.product_tmpl_id = temp.id
 left join ir_property prop on prop.res_id = 'product.product,' || pp.id
 where temp.name = 'Corner Desk'
 and prop.company_id=1

Need more Odoo advanced techniques ?

Check my Udemy courses: http://udemy.com/user/akhmaddaniel

Or visit our website for courses and other interesting stuffs: http://vitraining.com