2017-11    
S M T W T F S
   01020304
05060708091011
12131415161718
19202122232425
2627282930  
  

大剧院临时票务中心地址:梅溪湖国际文化艺术中心大剧院大堂总服务台。咨询电话:0731-89518800/8811
冰上芭蕾舞剧《天鹅湖》
演出单位: 俄罗斯圣彼得堡冰上芭蕾舞团
演出城市: 长沙梅溪湖
演出地点: 梅溪湖文化艺术中心大剧院大剧场
演出时间: 2017-09-20 20:00



演出开始三天前停止网上选位
如需购票请拨打电话
此场演出允许1米以下儿童凭票入场

 
演出介绍

    俄罗斯圣彼德堡国家冰上芭蕾舞团创建于1967年,该团是世界上唯一一个能在冰上演绎古典芭蕾舞全剧的演出团体。此次60周年建团中国巡演,众多芭蕾明星将在真冰舞台上带来这场既有冰上运动的优美流畅,又有芭蕾艺术的高贵典雅的世界顶尖表演。

 

 

官网购票须知

1,购票时请填写完整有效邮寄地址及联系方式,我们将采取快递方式为您寄出(单次消费100元以上(含100元)免运费,100元以下采取快递到付方式邮寄);

2,如您需自取,请在购票后3天之内前来票务中心凭手机号或取票码取票;3天后我们将默认按照购票预留地址为您快递,如因您预留的邮寄地址或联系方式填写错误而导致的快件遗失,我司概不负责。

   

 

 
推荐演出
        
2018-01-13 20:00
梅溪湖文化艺术中心大剧院大剧场
        
2017-12-26 20:00
梅溪湖文化艺术中心大剧院大剧场
        
2017-12-13 20:00
梅溪湖文化艺术中心大剧院大剧场
        
2017-12-11 20:00
梅溪湖文化艺术中心大剧院大剧场
        
2017-12-31 12:12
梅溪湖文化艺术中心大剧院大剧场
  友情链接 >>
                           

(default) 21 queries took 53 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
2SELECT *, `Show`.`id` FROM `eticketing_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`id` = 6 LIMIT 1113
3SELECT `Section`.`id`, `Section`.`section_code` FROM `eticketing_mxh`.`sections` AS `Section` WHERE show_id = 6112
4SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 15 AND `Pricelevel`.`active` = 1663
5SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'getseatstatus_validity' LIMIT 1112
6SELECT `Updatecache`.`id`, `Updatecache`.`created`, `Updatecache`.`modified`, `Updatecache`.`procedure`, `Updatecache`.`last_updated` FROM `eticketing_mxh`.`updatecaches` AS `Updatecache` WHERE `Updatecache`.`procedure` = 'updateseatstatus(6, 00001M05)' LIMIT 1112
7SELECT `Otherlink`.`id`, `Otherlink`.`script`, `Otherlink`.`show_id` FROM `eticketing_mxh`.`otherlinks` AS `Otherlink` WHERE `Otherlink`.`show_id` = 6002
8SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE `Section`.`show_id` = 6 AND `Section`.`active` = 1112
9SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1112
10SELECT `Place`.`id`, `Place`.`name`, `Place`.`name_en`, `Place`.`city_id`, `Place`.`modified`, `City`.`id`, `City`.`name`, `City`.`name_en` FROM `eticketing_mxh`.`places` AS `Place` LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Place`.`city_id` = `City`.`id`) WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1112
11SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`img_b`, `Show`.`img_m`, `Show`.`img_s`, `Show`.`img_t`, `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_mxh`.`shows` AS `Show` WHERE ((`Show`.`name` = '冰上芭蕾舞剧《天鹅湖》') OR (`Show`.`name_en` = '' and `Show`.`name_en` !='' and `Show`.`name_en` is not null)) AND `Show`.`active` = 1 AND `Show`.`id` != 6 ORDER BY `Show`.`showtime` asc003
12SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`img_b`, `Show`.`img_m`, `Show`.`img_s`, `Show`.`img_t`, `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_mxh`.`shows` AS `Show` WHERE `Show`.`name` != '冰上芭蕾舞剧《天鹅湖》' AND `Show`.`active` = 1 AND `Show`.`category_id` = '9' AND `Show`.`city_id` = 17 GROUP BY `Show`.`name` LIMIT 5223
13SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1113
14SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1112
15SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`img_b`, `Show`.`img_m`, `Show`.`img_s`, `Show`.`img_t`, `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`, `Show`.`name_delimited`, `Show`.`venue_delimited` FROM `eticketing_mxh`.`shows` AS `Show` WHERE MATCH (`Show`.`name_delimited`, `Show`.`venue_delimited`) AGAINST ('ZZ冰ZZ ZZ上ZZ ZZ芭ZZ ZZ蕾ZZ ZZ舞ZZ ZZ剧ZZ ZZ《ZZ ZZ天ZZ ZZ鹅ZZ ZZ湖ZZ ZZ》ZZ ZZ梅ZZ ZZ溪ZZ ZZ湖ZZ ZZ文ZZ ZZ化ZZ ZZ艺ZZ ZZ术ZZ ZZ中ZZ ZZ心ZZ ZZ大ZZ ZZ剧ZZ ZZ院ZZ ZZ大ZZ ZZ剧ZZ ZZ场ZZ ') AND `Show`.`active` = 1 AND `Show`.`id` != 6 AND `Show`.`id` != 74 AND `Show`.`id` != 75 GROUP BY `Show`.`name` LIMIT 3336
16SELECT SUM(seats_left) AS show_seats_left FROM `sections` WHERE `show_id` = 6 AND `active` = 1112
17SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1113
18select distinct showtime_start from shows where showtime_start >= '2017-11-01' and showtime_start <= '2017-11-31' and active = 1 553
19SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
20SELECT `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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-11-19') and foretells=2 ORDER BY `orderby` asc LIMIT 5002
21SELECT `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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-11-19') and foretells = 2 ORDER BY `orderby` asc222