world icon 繁中
SCOPE Smart Live Pavilion SIGN IN

DEinternational Taiwan, Ltd. (Service Unit of the German Trade Office Taipei)

feature

The German Trade Office Taipei is part of the global network of the German Chambers of Commerce Abroad (AHKs) at 140 locations in 92 countries around the world, which offer their experience, connections and services to German and foreign companies. AHKs are located in all countries which are of special interest for German companies.

SELECT *, A.`online_click` sco_click, B.`smCompname_en` smCompname, A.`s_name_en` s_name, A.`s_summary_en` s_summary FROM sco_solution2020 A INNER JOIN match_supplier2025 B ON A.`smId` = B.`smId` WHERE A.`s_pic`<>'' AND A.`is_open` = 'Y' AND A.`s_status` = '2' AND B.smUse='Y' AND B.expire_date>'2025-05-12' AND A.`smId` IN (868, 869, 870, 871, 872, 873, 874, 875, 876, 877) AND A.`s_pavilion` REGEXP '[[:<:]]47[[:>:]]' ORDER BY sco_click DESC
TOP