SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT `tbl_videotage_video`.`is_public` as `tbl_videotage_video_is_public`, `tbl_videotage_tags`.`id` as `tbl_videotagetags_id`, `cat_id` `tags_en`, `tags_hk`, `hits`, `tbl_videotage_tags`.`status` as `tbl_videotage_tags_status`,`tbl_videotage_tags`.`timestamp` as `tbl_videotage_tags_timestamp`,`tbl_videotage_video_tags`.`id` as `tbl_videotage_video_tags_id`,`video_id`,`tag_id`,`tbl_videotage_video`.`id` as `tbl_videotage_video_id`,`serial_number`,`artist_en`,`artist_hk`,`artist_about_en`,`artist_about_hk`,`artist_img`,`country_en`,`country_hk`,`aspect_ratio`,`title_en`,`title_hk`,`production_year`,`sound_silent`,`duration`,`bw_color`,`affiliated_programmes`,`language`,`synopsis_en`,`synopsis_hk`,`original_format`,`filming_equipment`,`remark`,`interpretative_attibutes`,`tbl_videotage_video`.`file_img`,`tbl_videotage_video`.`status` as `tbl_videotage_video_status`,`tbl_videotage_video`.`timestamp` as `tbl_videotage_video_timestamp`,`rank`, 1 as `union_rank` FROM `tbl_videotage_video`
LEFT JOIN `tbl_videotage_video_tags` ON `tbl_videotage_video_tags`.`video_id` = `tbl_videotage_video`.`id`
LEFT JOIN `tbl_videotage_tags` ON `tbl_videotage_video_tags`.`tag_id` = `tbl_videotage_tags`.`id`
WHERE `tbl_videotage_video_tags`.`tag_id` = '1670' AND (`tbl_videotage_video`.`status` = '1') GROUP BY `serial_number` ) as `union_exact` GROUP BY `serial_number` ORDER BY `union_rank` ASC LIMIT 0, 12
( 10 Results ) New update of VMAC, please reload the page, overriding the cache.
To do that, press Ctrl+Shift+R (or Ctrl+F5)
ABOUT VMAC (VIDEOTAGE MEDIA ART COLLECTION)
Documenting Cultural and Social History
The Collection comprises of video frames, sound bites, pieces of programming code, moving images, as well as books and installations
relating to media art, current affairs and social movements past, providing documentary evidence
and insight into the progression of art history and media over the past few decades.
Serving Diverging Interests
This unique archive of media art materials enables artists, students, researchers, historians and
most importantly, the general public to access, connect and understand the social currents
that shaped contemporary art and cultural production in Hong Kong.
A Dynamic and Expanding Collective
To promote accessibility and ease of use, the VMAC is upgraded to become a searchable
online database with potential off-site locations. All the while continuing to
develop exchange and collaborative programs with peer organizations,
both regional and international, to promote the appreciation,
understanding and creation
of media arts.
Unit 13, Cattle Depot Artist Village, 63 Ma Tau Kok Road, To Kwa Wan, Hong Kong