SELECT p.productid products_id, p.productname products_name , p.productcode products_model,'' products_image,
1 products_status, p.productcategory, p.manufacturer,
p.qty_per_unit, p.unit_price products_price, p.weight products_weight, p.pack_size,
p.sales_start_date, p.sales_end_date, p.start_date, p.expiry_date,
p.cost_factor, p.commissionrate, p.commissionmethod, p.discontinued, p.usageunit,
p.handler,   p.reorderlevel, p.website, p.taxclass, p.mfr_part_no,
p.vendor_part_no, p.serialno,now() products_date_added,now() products_last_modified, p.qtyinstock products_quantity, 
p.productsheet, p.qtyindemand products_ordered, p.glacct,
p.vendor_id manufacturers_id, p.imagename ,
b.taxid products_tax_class_id 
 FROM vtiger_products p left join vtiger_producttaxrel b on (p.productid = b.productid)
where  p.productid > 0 