SELECT d.* FROM 202200310_article d,202200310_article_cate c WHERE c.id=d.cateId and c.tb=2 and c.lang = 'en' and c.inuse='1' and d.tb='2' and d.lang = 'en' and (d.inuse = '1' or (d.inuse ='2' and CONCAT(d.sdate, ' ', IFNULL(d.stime, '00:00:00')) <= '2024-11-21 15:08:27' and CONCAT(d.edate, ' ', IFNULL(d.etime, '23:59:59')) >='2024-11-21 15:08:27')) and d.cateId=2 order by d.seq desc
2024【International Hardware Fair Istanbul】

DATE 2024.Nov.20-23
COUNTRY Istanbul, TURKEY
VENUE Istanbul Expo Center

BOOTH NO. Hall 4 B91
Welcome to visit us!

2024 / 08
01
2024【Taiwan International Hardware Expo】

DATE 2024.Oct.16-18
COUNTRY Taichung, TAIWAN
VENUE Taichung International Exhibition Center

BOOTH NO. L03
Welcome to visit us!

2024 / 07
01
2024【International Hardware Fair Cologne】

DATE 2024.Mar.03-06
COUNTRY Cologne, GERMANY
VENUE Koelnmesse GmbH

BOOTH NO. Hall 4.1 D116
Welcome to visit us!

2023 / 12
01
2023【Taiwan International Tools & Hardware Expo】

DATE 2023.Oct.04-06
COUNTRY Taichung, TAIWAN
VENUE Taichung International Exhibition Center

BOOTH NO. F37
Welcome to visit us!

2023 / 08
01