SELECT name, Incorporated_in, Group_Equity_Shareholding, Type, Principal_activities, id FROM operate_company WHERE Type = "Subsidiary" OR Principal_activities != "Catering services" OR "Group_Equity_Shareholding" < 49.0 OR "id" < 10 AND Incorporated_in != "China" AND name != "China Pacific Laundry Services" UNION SELECT name, Incorporated_in, Group_Equity_Shareholding, Type, Principal_activities, id FROM operate_company WHERE Principal_activities = "Travel agency" <table_name> : operate_company col : id | name | Type | Principal_activities | Incorporated_in | Group_Equity_Shareholding row 1 : 1 | Air China | Corporate | Airline | China | 18.77 row 2 : 2 | Air China Cargo | Joint Venture | Cargo airline | China | 49.0 row 3 : 3 | Air Hong Kong | Joint Venture | Cargo airline | Hong Kong | 60.0 row 4 : 4 | Dragonair | Subsidiary | Airline | Hong Kong | 100.0 row 5 : 5 | Cathay Pacific Cargo | Subsidiary | Cargo airline | Hong Kong | 100.0 row 6 : 6 | Cathay Pacific Catering Services (HK) Limited | Subsidiary | Catering services | Hong Kong | 100.0 row 7 : 7 | Cathay Pacific Services Limited | Subsidiary | Cargo | Hong Kong | 100.0 row 8 : 8 | Cathay Pacific Holidays | Subsidiary | Travel agency | Hong Kong | 100.0 row 9 : 9 | Dragonair Holidays | Subsidiary | Travel agency | Hong Kong | 100.0 row 10 : 10 | Hong Kong Airport Services | Subsidiary | Ground handling | Hong Kong | 100.0 row 11 : 11 | Vogue Laundry Service Limited | Subsidiary | Laundry | Hong Kong | 100.0 row 12 : 12 | China Pacific Laundry Services | Joint Venture | Laundry | Taiwan | 45.0 row 13 : 13 | VN/CX Catering Services Limited | Joint Venture | Catering services | Vietnam | 40.0 row 14 : 14 | CLS Catering Services Limited | Joint Venture | Catering services | Canada | 30.0 <table_name> : operate_company col : id | name | Type | Principal_activities | Incorporated_in | Group_Equity_Shareholding row 1 : 1 | Air China | Corporate | Airline | China | 18.77 row 2 : 2 | Air China Cargo | Joint Venture | Cargo airline | China | 49.0 row 3 : 3 | Air Hong Kong | Joint Venture | Cargo airline | Hong Kong | 60.0 row 4 : 4 | Dragonair | Subsidiary | Airline | Hong Kong | 100.0 row 5 : 5 | Cathay Pacific Cargo | Subsidiary | Cargo airline | Hong Kong | 100.0 row 6 : 6 | Cathay Pacific Catering Services (HK) Limited | Subsidiary | Catering services | Hong Kong | 100.0 row 7 : 7 | Cathay Pacific Services Limited | Subsidiary | Cargo | Hong Kong | 100.0 row 8 : 8 | Cathay Pacific Holidays | Subsidiary | Travel agency | Hong Kong | 100.0 row 9 : 9 | Dragonair Holidays | Subsidiary | Travel agency | Hong Kong | 100.0 row 10 : 10 | Hong Kong Airport Services | Subsidiary | Ground handling | Hong Kong | 100.0 row 11 : 11 | Vogue Laundry Service Limited | Subsidiary | Laundry | Hong Kong | 100.0 row 12 : 12 | China Pacific Laundry Services | Joint Venture | Laundry | Taiwan | 45.0 row 13 : 13 | VN/CX Catering Services Limited | Joint Venture | Catering services | Vietnam | 40.0 row 14 : 14 | CLS Catering Services Limited | Joint Venture | Catering services | Canada | 30.0
col : name | Incorporated_in | Group_Equity_Shareholding | Type | Principal_activities | id row 1 : Air China | China | 18.77 | Corporate | Airline | 1 row 2 : Air China Cargo | China | 49.0 | Joint Venture | Cargo airline | 2 row 3 : Air Hong Kong | Hong Kong | 60.0 | Joint Venture | Cargo airline | 3 row 4 : CLS Catering Services Limited | Canada | 30.0 | Joint Venture | Catering services | 14 row 5 : Cathay Pacific Cargo | Hong Kong | 100.0 | Subsidiary | Cargo airline | 5 row 6 : Cathay Pacific Catering Services (HK) Limited | Hong Kong | 100.0 | Subsidiary | Catering services | 6 row 7 : Cathay Pacific Holidays | Hong Kong | 100.0 | Subsidiary | Travel agency | 8 row 8 : Cathay Pacific Services Limited | Hong Kong | 100.0 | Subsidiary | Cargo | 7 row 9 : China Pacific Laundry Services | Taiwan | 45.0 | Joint Venture | Laundry | 12 row 10 : Dragonair | Hong Kong | 100.0 | Subsidiary | Airline | 4 row 11 : Dragonair Holidays | Hong Kong | 100.0 | Subsidiary | Travel agency | 9 row 12 : Hong Kong Airport Services | Hong Kong | 100.0 | Subsidiary | Ground handling | 10 row 13 : VN/CX Catering Services Limited | Vietnam | 40.0 | Joint Venture | Catering services | 13 row 14 : Vogue Laundry Service Limited | Hong Kong | 100.0 | Subsidiary | Laundry | 11