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

大剧院临时票务中心地址:梅溪湖国际文化艺术中心大剧院大堂总服务台。咨询电话:0731-89518800/8811
爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》
演出单位: 俄罗斯芭蕾国家剧院
演出城市: 长沙梅溪湖
演出地点: 梅溪湖文化艺术中心大剧院大剧场
演出时间: 2017-12-26 20:00
演出票价: 100元,  180元,  280元,  380元,  580元,  680元,  880元,  

在线选位必须用网上支付

此场演出允许1米以下儿童凭票入场

其它场次
 
演出介绍

官网购票须知

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

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

3,演出票售出后不退不换,请审慎购买。

4,所有观众均需凭票入场。

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

(default) 41 queries took 50 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 1111
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` = 75 LIMIT 1111
3SELECT `Section`.`id`, `Section`.`section_code` FROM `eticketing_mxh`.`sections` AS `Section` WHERE show_id = 75111
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` = 59 AND `Pricelevel`.`active` = 1771
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 1111
6SELECT `Updatecache`.`id`, `Updatecache`.`created`, `Updatecache`.`modified`, `Updatecache`.`procedure`, `Updatecache`.`last_updated` FROM `eticketing_mxh`.`updatecaches` AS `Updatecache` WHERE `Updatecache`.`procedure` = 'updateseatstatus(75, 00001QCX)' LIMIT 1111
7SELECT `Otherlink`.`id`, `Otherlink`.`script`, `Otherlink`.`show_id` FROM `eticketing_mxh`.`otherlinks` AS `Otherlink` WHERE `Otherlink`.`show_id` = 75001
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` = 75 AND `Section`.`active` = 1111
9SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
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 1111
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` != 75 ORDER BY `Show`.`showtime` asc111
12SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
13SELECT `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 5112
14SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
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 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` != 75 AND `Show`.`id` != 74 GROUP BY `Show`.`name` LIMIT 4445
16SELECT SUM(seats_left) AS show_seats_left FROM `sections` WHERE `show_id` = 75 AND `active` = 1111
17SELECT count( * ) as cnt, pricelevel, section_code FROM seats WHERE show_id = 75 AND status <> 'B' GROUP BY pricelevel774
18SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
19SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'A' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
20SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
21SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'B' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
22SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
23SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'C' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
24SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
25SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'D' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
26SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
27SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'E' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
28SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
29SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'F' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
30SELECT `Section`.`id`, `Section`.`created`, `Section`.`modified`, `Section`.`show_id`, `Section`.`section_code`, `Section`.`section_name`, `Section`.`coords`, `Section`.`active`, `Section`.`seats_left`, `Section`.`last_updated` FROM `eticketing_mxh`.`sections` AS `Section` WHERE `Section`.`show_id` = 75 AND `Section`.`section_code` = '00001QCX' LIMIT 1111
31SELECT `Pricelevel`.`id`, `Pricelevel`.`created`, `Pricelevel`.`modified`, `Pricelevel`.`name`, `Pricelevel`.`price`, `Pricelevel`.`section_id`, `Pricelevel`.`active` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` WHERE `Pricelevel`.`name` = 'G' AND `Pricelevel`.`section_id` = 59 LIMIT 1111
32SELECT `Otherticket`.`id`, `Otherticket`.`time`, `Otherticket`.`price`, `Otherticket`.`explain`, `Otherticket`.`status`, `Otherticket`.`show_id` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`show_id` = 75 LIMIT 1111
33SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 58111
34SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 58111
35SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 58111
36UPDATE `eticketing_mxh`.`othertickets` SET `id` = 58, `time` = '2017-12-26 20:00:00', `price` = '100|180|280|380|580|680|880', `show_id` = 75, `status` = 1, `explain` = 'System Shows' WHERE `eticketing_mxh`.`othertickets`.`id` = '58'002
37SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
38select distinct showtime_start from shows where showtime_start >= '2017-11-01' and showtime_start <= '2017-11-31' and active = 1 551
39SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
40SELECT `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 5001
41SELECT `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` asc221