SELECT p.id  orders_products_id,
o.invoiceid orders_id,
p.productId products_id,
'' products_model,

p.comment products_name,
p.listprice products_price,
 cast(IF(p.quantity =0,0,
(((p.quantity * p.listprice) * IF(p.discount_percent is null,1,1+(p.discount_percent/100)))
 -IF(p.discount_amount is null,0,p.discount_amount))  
  / p.quantity)as decimal) final_price,
IF(p.TAX1 is null,
IF(p.TAX2 is null,
IF(p.TAX3 is null,
IF(p.TAX4 is null,
p.TAX5,p.TAX4),
p.TAX3),p.TAX2),p.TAX1) products_tax,
p.quantity products_quantity

 FROM vtiger_inventoryproductrel p join vtiger_invoice o on (p.id = o.invoiceid)
where o.invoiceid = %s