SELECT   `ma`.*, mig.group_desc, `md`.`device_name`, `md`.`device_class`,c.city_name,fs.facility_type,fs.facility_name,bct.remark  FROM master_asset AS `ma` 
                         LEFT JOIN `master_device` AS `md` ON (`md`.`device_code` = `ma`.`device_code`)
                         LEFT JOIN `master_item_group` AS `mig` ON(`md`.`group_id` = `mig`.`item_group_id`)
                         INNER JOIN  `master_facility_type` AS  `fs` ON (  `ma`.`city_id` =  `fs`.`city_id`
                                                                            AND `ma`.`facility_code` =  `fs`.`facility_code` 
                                                                            AND  `ma`.`facility_id` =  `fs`.`facility_id`) 
                         LEFT JOIN  `setup_city` AS  `c` ON (  `fs`.`city_id` =  `c`.`city_id` )
                         LEFT JOIN `barcode_change_transaction` AS `bct` ON (bct.new_barcode = ma.unique_no)
                        WHERE 1 = 1  and  `ma`.`unique_no`='4100040023'    ORDER BY `ma`.`srno`      LIMIT 0 ,20