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

大剧院临时票务中心地址:梅溪湖国际文化艺术中心大剧院大堂总服务台。咨询电话:0731-89518800/8811
经典版话剧《暗恋桃花源》
演出单位: 何炅、黄磊、孙莉等
演出城市: 长沙梅溪湖
演出地点: 梅溪湖文化艺术中心大剧院大剧场
演出时间: 2017-12-02 20:00
演出票价: (数据未更新,请点击在线选位按钮)

在线选位必须用网上支付

1米以下儿童谢绝入场,1米以上儿童照章购票(儿童专场除外)

其它场次
 
演出介绍

   《暗恋桃花源》一剧以奇特的戏剧结构和悲喜交错的观看效果闻名于世,被称为【表演工作坊】的“镇团之宝”。《暗恋是一出现代悲剧《桃花源》则是一出古装喜剧两个不相关的剧组,不得不同时在剧场中彩排,遂成就了一出古今相对的舞台奇观。

 

官网购票须知

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

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

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

4,儿童凭票入场。

 

 

 

 

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

(default) 30 queries took 63 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` = 3 LIMIT 1112
3SELECT `Section`.`id`, `Section`.`section_code` FROM `eticketing_mxh`.`sections` AS `Section` WHERE show_id = 3112
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` = 8 AND `Pricelevel`.`active` = 1552
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(3, 00001KL8)' LIMIT 1112
7SELECT `Otherlink`.`id`, `Otherlink`.`script`, `Otherlink`.`show_id` FROM `eticketing_mxh`.`otherlinks` AS `Otherlink` WHERE `Otherlink`.`show_id` = 3002
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` = 3 AND `Section`.`active` = 1113
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` != 3 ORDER BY `Show`.`showtime` asc112
12SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1112
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` = '1' AND `Show`.`city_id` = 17 GROUP BY `Show`.`name` LIMIT 5552
14SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院小剧场' LIMIT 1112
15SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院小剧场' LIMIT 1112
16SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院小剧场' LIMIT 1112
17SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院小剧场' LIMIT 1112
18SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1112
19SELECT SUM(seats_left) AS show_seats_left FROM `sections` WHERE `show_id` = 3 AND `active` = 1112
20SELECT count( * ) as cnt, pricelevel, section_code FROM seats WHERE show_id = 3 AND status <> 'B' GROUP BY pricelevel004
21SELECT `Otherticket`.`id`, `Otherticket`.`time`, `Otherticket`.`price`, `Otherticket`.`explain`, `Otherticket`.`status`, `Otherticket`.`show_id` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`show_id` = 3 LIMIT 1112
22SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 9112
23SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 9112
24SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 9112
25UPDATE `eticketing_mxh`.`othertickets` SET `id` = 9, `time` = '2017-12-02 20:00:00', `price` = '', `show_id` = 3, `status` = 1, `explain` = 'System Shows' WHERE `eticketing_mxh`.`othertickets`.`id` = '9'002
26SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
27select distinct showtime_start from shows where showtime_start >= '2017-11-01' and showtime_start <= '2017-11-31' and active = 1 552
28SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
29SELECT `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
30SELECT `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