How to export special (reduction) price with SQL Manager?

[chipset]

Hello,

I add a SQL query:

SELECT p.on_sale AS 'On Sale', m.name AS 'Manufacturer', pl.name AS 'Name', cl.name AS 'Categories', ROUND (p.price,0) AS 'Price'

but I don't know how to export the real price.

 

If I have product AAA with price $100 and special price $90, In the above example I see only $100. How to grab $90 (the real price)?

 

Thanks

[vekia]

wtihout php coding it will be hard to get specifi price, it's because in special price table there is no price, just information about what kind of discount you defined. so to get final price, you have to do some math on variables from database

[chipset]

Thank You vekia.

If I use spc.reduction, can do SQL query smothing like this:

Real price = p.price - spc.reduction only if reduction_type is amount?

[chipset]

A temporary decision: SELECT ROUND (p.price,0) - ROUND(spc.reduction,0) AS 'Price'