select `a`.`stock_id` AS `stock_id`,`a`.`description` AS `item_description`,`a`.`long_description` AS `long_description`,`a`.`category_id` AS `category_id`,`c`.`price` AS `service_charge`,`a`.`govt_fee` AS `govt_fee`,`a`.`pf_amount` AS `pf_amount`,`a`.`bank_service_charge` AS `bank_service_charge`,`a`.`bank_service_charge_vat` AS `bank_service_charge_vat`,`a`.`commission_loc_user` AS `commission_loc_user`,`a`.`commission_non_loc_user` AS `commission_non_loc_user` from ((`0_stock_master` `a` left join `0_stock_category` `b` on((`b`.`category_id` = `a`.`category_id`))) left join `0_prices` `c` on(((`c`.`stock_id` = `a`.`stock_id`) and (`c`.`sales_type_id` = 1)))) 