retrieve salesprice from db... it is possible?

[Loris]

Hi there,
I have to write a sql query to retrieve some data form virtuemart tables and I need to extract the final price (salesprice) but I still do not understand where (and if it is) this price is stored into db;
for example, in this record I do not see any discount but in the frontend of the website yes... could you help me?

[K&K media production]

Hi,
the prices are not stored into db. The salesprice is calculated by core function.
Regards,
Maik

[Loris]

ok thanks, but do you know how the function apply (calculate) discount and taxes if product_discount_id and product_tax_id in the db are 0?