2017-10    
S M T W T F S
01020304050607
08091011121314
15161718192021
22232425262728
293031    
  

温馨提示:本剧院楼层间不互通,抱小孩的观众务必为孩子购买与家长同一楼层的座位.演出前一周订票不再快递,请前往售票厅取票,选择自取请在地址栏填写“自取”二字,无需填写地址.如选择邮寄的观众演出前三天未收到票,请拨打86371698 招行和平安银行支付时可能出现无法支付的情况,请谨慎使用.若支付过程中出现故障,所选位置会暂时锁定,不可继续支付。如想继续选择相应位置,静候40min后刷新票图页面重新支付即可
第十二届中国(深圳)文博会艺术节展演剧目推荐
最后编辑时间:2016-03-18

《夜宴》

 

改编自莎士比亚经典作品《哈姆雷特》

顶级华人艺术家冯小刚、王媛媛、谭盾联手打造中国版舞剧《哈姆雷特》

享誉世界的年轻舞蹈团

 

第十二届中国(深圳)文博会艺术节展演剧目-当代芭蕾舞剧《夜宴》

演出时间:2016年6月23日 20:00

演出场馆:深圳保利剧院

演出票价:680/480/280/180/100

 

    2013年,北京当代芭蕾舞团建团五周年之际,舞团联合东上海百老汇剧院管理公司推出年度新剧著名编导王媛媛舞蹈作品《夜宴》。本剧改编自莎士比亚经典作品《哈姆雷特》及2006年冯小刚导演电影《夜宴》,舞团持之以东西方文化交集为由,融合当代艺术,以现代芭蕾表达长期索求的新舞台美学。

    在世界众多版本的《哈姆雷特》中,这个中国版的《夜宴》是有着独特视角的创作念。舞剧缘起于电影,又脱离于电影,在通往400年前的哈姆雷特内心世界时,我们重新读到他莫大的悲凉,对人世的悲悯,怀疑,生死与毁灭,找到了他的内心世界的美好与黑暗,经过了我们的重读,摆在你的面前。

    故事背景无需特定年代,由原著中汲取王魂、新王、母后,王子及青女几个主要人物,重新塑造一个关于生死与爱情的故事,旧王的灵魂萦绕在活的生命的四周,王子借王魂复仇,泯灭了爱情,毁灭了生命,新王、母后及众臣在邪恶与挣扎中塑造出一幕幕灵与肉的交易,这是一出史诗般的悲剧,舞台的表达将以极致的美感,打造当代舞蹈剧场艺术的巅峰。

本剧由著名舞蹈家赵汝蘅女士担任艺术顾问著名导演冯小刚先生总监制,戏剧家李健鸣女士任文学顾问;北京当代芭蕾舞团艺术总监王媛媛女士编导,著名作曲家谭盾先生担任音乐总监,著名艺术家谭韶远先生担任视觉总监,服装设计阿宽,灯光设计陈侠吉。

 

 

夜莺与玫瑰

 

以爱的名义,让美与痛共舞

这是王尔德笔下一个爱情童话,很凄美,很虐心。 
这是采用了林徽因翻译的版本,很温婉,很恬静。 
这是二者之间的反差,这是存在于此种刺激感中的、更具有舞台表现力的韵味。 

 

第十二届中国(深圳)文博会艺术节展演剧目-当代芭蕾舞剧《夜莺与玫瑰》

演出时间:2016年6月24日 20:00

演出场馆:深圳保利剧院

演出票价:680/480/280/180/100

 

    这个美丽的童话讲述了年轻学生为了与心仪的姑娘共舞而寻找一朵红玫瑰,一只美丽的夜莺听闻学生因无法采得红玫瑰而悲泣时,认定学生的爱正是她一直在歌唱和寻找的真情。于是,为了帮助学生达成爱情愿望,夜莺毅然决定用自己的生命之血培育一支红玫瑰,将美丽的爱情之花奉献给人间真爱。

    这部舞剧是古典的,它采用了比才名作《阿莱城姑娘》为配乐,你可以体会到古典作品那无法超越的高超手法、严谨结构和宏大规模,也可以从古典音乐旋律和解构的美感中抓住它的情绪和节奏。

    这部舞剧也是现代的,除却古典的环境,它所展示的人的生存状态完全是契合当下的。而本来,人的生存其实就无所谓过去还是当下,本质上的那些东西从来都是亘古不变的。在王媛媛的编舞中,情是一样的,社会关系是一样的,生存状况也都大同小异。说到底,所有戏的发生都只是因为人。

 

372

    372,是界定低烧的起点温度,是人体感到舒适的环境温度的上限,是人们恋爱时心跳加速的体温。 
    372,于是也变成了一个城市的节奏。在夜幕降临的酒吧里,灯红酒绿下,一对又一对情侣,他们爱意浓,他们佳期近,他们沉醉,他们挣扎,他们在爱情中奋不顾身,他们于流离中忘乎所以。舞蹈力求临摹点点滴滴的情感细节,将记忆与经验外化为肢体语汇,在舞者的相互冲突与缓和,隔绝与憧憬中,探索都市人爱情平衡所存在的可能方式。

 

    舞蹈力求临摹点点滴滴的情感细节,将记忆与经验外化为肢体语汇,在舞者的相互冲突与缓和,隔绝与憧憬中,探索都市人爱情平衡所存在的可能方式。

    372》的音乐全部来自法国音乐家KangdingRay的专辑。Kangding Ray本名DavidLetellier,在投身电子音乐制作之前曾在乐队中担任吉他和鼓手。

    David曾在Raster-Noton(柏林实验性唱片品牌)发行过几张唱片,包括Stabil(2006) 和 Automne Fold (2008),评论人认为除了延续厂牌一贯的冷静作风,而深入内里则会有温情的部分。

 

购票需登录大麦网!

 

 

 

  友情链接 >>
                               

(default) 51 queries took 120 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
2SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_szbl`.`news` AS `News` WHERE `News`.`status` = '1' AND `News`.`id` = 1082 LIMIT 1116
3SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
4select distinct showtime_start from shows where showtime_start >= '2017-10-01' and showtime_start <= '2017-10-31' and active = 1 772
5SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
6SELECT `Ad`.`id`, `Ad`.`link`, `Ad`.`showcate_id`, `Ad`.`category_id`, `Ad`.`foretells`, `Ad`.`city_id`, `Ad`.`orderby`, `Ad`.`attime`, `Category`.`id`, `Category`.`created`, `Category`.`name`, `Category`.`name_en`, `Category`.`parent_id` FROM `eticketing_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-21') and foretells=2 ORDER BY `orderby` asc LIMIT 10332
7SELECT `Ad`.`id`, `Ad`.`link`, `Ad`.`showcate_id`, `Ad`.`category_id`, `Ad`.`foretells`, `Ad`.`city_id`, `Ad`.`orderby`, `Ad`.`attime`, `Category`.`id`, `Category`.`created`, `Category`.`name`, `Category`.`name_en`, `Category`.`parent_id` FROM `eticketing_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-21') and foretells = 2 ORDER BY `orderby` asc002
8SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
9SELECT `Ad`.`id`, `Ad`.`link`, `Ad`.`showcate_id`, `Ad`.`category_id`, `Ad`.`foretells`, `Ad`.`city_id`, `Ad`.`orderby`, `Ad`.`attime`, `Category`.`id`, `Category`.`created`, `Category`.`name`, `Category`.`name_en`, `Category`.`parent_id` FROM `eticketing_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-21') and foretells=3 ORDER BY `orderby` asc LIMIT 6002
10SELECT `Ad`.`id`, `Ad`.`link`, `Ad`.`showcate_id`, `Ad`.`category_id`, `Ad`.`foretells`, `Ad`.`city_id`, `Ad`.`orderby`, `Ad`.`attime`, `Category`.`id`, `Category`.`created`, `Category`.`name`, `Category`.`name_en`, `Category`.`parent_id` FROM `eticketing_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-21') and foretells = 3 ORDER BY `orderby` asc002
11SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` WHERE 1 AND `Show`.`showtime2`>"2017-10-22 21:56:31" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010102
12SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
13SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1113
14SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
15SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1824'113
16SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
17SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
18SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
19SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1845'113
20SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
21SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1114
22SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
23SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1846'113
24SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
25SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1113
26SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1113
27SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1849'113
28SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
29SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
30SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
31SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1858'112
32SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
33SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
34SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1113
35SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1859'112
36SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
37SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
38SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
39SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1860'112
40SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
41SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
42SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
43SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1861'113
44SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
45SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '经典版《暗恋桃花源》' ORDER BY `Show`.`showtime` ASC LIMIT 1113
46SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '经典版《暗恋桃花源》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
47SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1863'113
48SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
49SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' ORDER BY `Show`.`showtime` ASC LIMIT 1112
50SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' ORDER BY `Show`.`showtime` DESC LIMIT 1112
51SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '1865'113