SELECT `service`.`id`,
`service`.`name`,
`service`.`name_fixed`,
`service`.`st`,
`service`.`branch_id`,
`service`.`office_id`,
`service`.`company_object_id`,
`service`.`managed_service_provider_id`,
`service`.`development_service_provider_id`,
`service`.`product`,
`service`.`developer_id`,
`service`.`persian_names`,
`service`.`other_names`,
`service`.`service_account_id`,
`service`.`service_account_email`,
`service`.`technician_id`,
`service`.`service_manager_id`,
`service`.`expert_id`,
`service`.`arc_manager_id`,
`service`.`arc_expert_id`,
`service`.`description`,
`service`.`active`,
`service`.`domain`,
`service`.`aspect`,
`service`.`scope`,
`service`.`service_nature`,
`service`.`other_technical_representatives`,
`service`.`other_vendor_emails`,
`service`.`document_sender`,
`service`.`document_sender_email`,
`service`.`modules`,
`service`.`service_status`,
`service`.`description_and_approval`,
`service`.`approver`
FROM `service`
WHERE `service`.`office_id` IN (6, 7, 8, 9, 10)