SELECT `mat`.`unique_no`,`sc`.`city_name`,`mm`.`manufacturer_name`,`md`.`department_name`,`mft`.`facility_type`,`mft`.`facility_name`,
                `mig`.`group_desc`,`mat`.`item_desc`,`mat`.`item_type`,`mat`.`item_model`,`mat`.`serial_no`,`mat`.`contract_ref`,
                `mat`.`waranty_date` AS `waranty_date`,`mat`.`technologystatus`,`mat`.`status`,`me`.`emp_id`,`me`.`emp_name`,`mat`.`remark`,
                `mat`.`sys_date` AS `systemdate`,`mat`.`expiry_date`,`mat`.`pur_value`,`mat`.`est_pur_value`,`mat`.`installation_date`,`mat`.`est_installation_date`,
                `mat`.`sys_date`,mat.device_code,mat.verified_date,mat.verified_by,`mat`.`waranty_start_date` AS `waranty_start_date`,`mat`.`tagging_date` ,
                `mat`.`service`, `mad`.`device_name`, `mad`.`device_class`,bct.remark as transfer_remark
                FROM `master_asset` AS `mat` 
                LEFT JOIN `setup_city` AS `sc` ON(`mat`.`city_id` = `sc`.`city_id`) 
                LEFT JOIN `master_manufacturer` AS `mm` ON(`mm`.`manufacturer_code` = `mat`.`manufacturer_code`) 
                LEFT JOIN `master_department` AS `md` ON(`md`.`department_code` = `mat`.`department`) 
                LEFT JOIN `master_facility_type` AS `mft` ON(`mat`.`facility_code` = `mft`.`facility_code` AND `mat`.`city_id` = `mft`.`city_id` AND `mat`.`facility_id` = `mft`.`facility_id`) 
                INNER JOIN `master_customer_district_facility_mapping` AS `mcdfm` ON(`mcdfm`.`facility_code` = `mft`.`facility_code` AND `mcdfm`.`district_id` = `mft`.`city_id` AND `mcdfm`.`facility_id` = `mft`.`facility_id` AND `mcdfm`.`customer_id` = 'AOVPB059') 
                LEFT JOIN `master_device` AS `mad` ON(mat.device_code = mad.device_code)
                LEFT JOIN `master_item_group` AS `mig` ON(`mad`.`group_id` = `mig`.`item_group_id`)
                LEFT JOIN `master_employee` AS `me` ON(`mat`.`login_id` = `me`.`emp_id`)
                LEFT JOIN `barcode_change_transaction` AS `bct` ON (bct.new_barcode = mat.unique_no)
                WHERE 1=1  and  `mat`.`city_id`='11' ORDER BY `mat`.`srno` DESC