<1--SQL : Select x.mapping_id, x.image_type_descript, memo, (Select count(a.img_id) from image_file_pool a, biz_archive_photo_publish b where a.img_id = b.img_id and a.mapping_id = x.mapping_id and a.mapping_id >= 16 and convert(varchar(10), b.publishdate, 111) <= convert(varchar(10), getdate(), 111) and a.image_status = '04') as cnt, (Select top 1 (a.web_relative_path + a.physical_thumbnail_name) from image_file_pool a, biz_archive_photo_publish b where a.img_id = b.img_id and a.mapping_id = x.mapping_id and a.mapping_id >= 16 and a.mapping_id <= 30 and convert(varchar(10), b.publishdate, 111) <= convert(varchar(10), getdate(), 111) and a.image_status = '04' and b.showname_id=280 order by b.publishdate desc, a.img_id desc) as thumbnail from image_file_pool_type_mapping x where x.mapping_id >= 16 and x.mapping_id <= 30-->

COMPUTEX TAIPEI 2008 Live Coverage

Products in Nangang Floor 1(23)	WiMAX(66)	Exhibition activities(31)	Products in Nangang Floor 4(40)
Product presentation/Forum(45)	TWTC Nangang: major companies(21)	Products in Shinyi Hall 1(23)	Mega Trend Pavilion(36)
TWTC Shinyi: major companies(82)	Products in Shinyi Hall 3(38)	Exchange convention(10)	Products in TICC(6)
Show Girl(30)

1 2 3 4 5 6 7 8 9 10 >> Next10