SELECT v.productid, v.productname, v.productcode, v.productcategory, v.manufacturer,
v.product_description, v.qty_per_unit, v.unit_price, v.weight, v.pack_size,
v.sales_start_date, v.sales_end_date, v.start_date, v.expiry_date,
v.cost_factor, v.commissionrate, v.commissionmethod, v.discontinued, v.usageunit,
v.handler, v.currency, v.reorderlevel, v.website, v.taxclass, v.mfr_part_no,
v.vendor_part_no, v.serialno, v.qtyinstock, v.productsheet, v.qtyindemand, v.glacct,
v.vendor_id, v.imagename,1 DUMMYTAX, case when b.TAXpercentage is null then -1 else b.TAXpercentage end as TAXpercentage FROM vtiger_products v left join vtiger_producttaxrel b on (v.productid = b.productid)