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

大剧院临时票务中心地址:梅溪湖国际文化艺术中心大剧院大堂总服务台。咨询电话:0731-89518800/8811
经典原版音乐剧《保镖》THE BODYGUARD THE MUSICAL雪佛兰迈锐宝XL倾情呈现
演出单位: 经典原版音乐剧《保镖》演出团
演出城市: 长沙梅溪湖
演出地点: 梅溪湖文化艺术中心大剧院大剧场
演出时间: 2017-11-16 20:00



演出开始三天前停止网上选位
如需购票请拨打电话
1米以下儿童谢绝入场,1米以上儿童照章购票(儿童专场除外)

其它场次
 
演出介绍
演出介绍

 

    音乐剧《保镖》根据华纳影业的同名电影改编,讲述了前任安全局特工弗兰克·法墨,受雇保护巨星瑞秋·马龙,当一切尽在掌控中的时候,他却坠入了爱  河中的故事。电影《保镖》是歌坛巨星惠特尼·休斯顿的巅峰之作,揽获了诸多国际奖项,此次音乐剧也最大限度的保留了电影中的经典唱段。

 

官网购票须知

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

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

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

4,1米以下儿童谢绝入场。

 

 

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

(default) 41 queries took 76 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` = 49 LIMIT 1112
3SELECT `Section`.`id`, `Section`.`section_code` FROM `eticketing_mxh`.`sections` AS `Section` WHERE show_id = 49112
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` = 44 AND `Pricelevel`.`active` = 1882
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(49, 00001NFS)' LIMIT 1111
7SELECT `Otherlink`.`id`, `Otherlink`.`script`, `Otherlink`.`show_id` FROM `eticketing_mxh`.`otherlinks` AS `Otherlink` WHERE `Otherlink`.`show_id` = 49001
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` = 49 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 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` = '经典原版音乐剧《保镖》THE BODYGUARD THE MUSICAL雪佛兰迈锐宝XL倾情呈现') OR (`Show`.`name_en` = '' and `Show`.`name_en` !='' and `Show`.`name_en` is not null)) AND `Show`.`active` = 1 AND `Show`.`id` != 49 ORDER BY `Show`.`showtime` asc442
12SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
13SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
14SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
15SELECT `Place`.`id`, `Place`.`name` FROM `eticketing_mxh`.`places` AS `Place` WHERE `Place`.`name` = '梅溪湖文化艺术中心大剧院大剧场' LIMIT 1111
16SELECT `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` != '经典原版音乐剧《保镖》THE BODYGUARD THE MUSICAL雪佛兰迈锐宝XL倾情呈现' AND `Show`.`active` = 1 AND `Show`.`category_id` = '8' AND `Show`.`city_id` = 17 GROUP BY `Show`.`name` LIMIT 5002
17SELECT `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 THE BODYGUARD THE MUSICAL ZZ雪ZZ ZZ佛ZZ ZZ兰ZZ ZZ迈ZZ ZZ锐ZZ ZZ宝ZZ XL 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` != 49 GROUP BY `Show`.`name` LIMIT 5556
18SELECT SUM(seats_left) AS show_seats_left FROM `sections` WHERE `show_id` = 49 AND `active` = 1112
19SELECT count( * ) as cnt, pricelevel, section_code FROM seats WHERE show_id = 49 AND status <> 'B' GROUP BY pricelevel664
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` = 49 AND `Section`.`section_code` = '00001NFS' LIMIT 1112
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` = 44 LIMIT 1112
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` = 49 AND `Section`.`section_code` = '00001NFS' LIMIT 1112
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` = 44 LIMIT 1112
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` = 49 AND `Section`.`section_code` = '00001NFS' LIMIT 1112
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` = 44 LIMIT 1112
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` = 49 AND `Section`.`section_code` = '00001NFS' LIMIT 1112
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` = 44 LIMIT 1112
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` = 49 AND `Section`.`section_code` = '00001NFS' LIMIT 1112
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` = 44 LIMIT 1112
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` = 49 AND `Section`.`section_code` = '00001NFS' LIMIT 1112
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` = 44 LIMIT 1112
32SELECT `Otherticket`.`id`, `Otherticket`.`time`, `Otherticket`.`price`, `Otherticket`.`explain`, `Otherticket`.`status`, `Otherticket`.`show_id` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`show_id` = 49 LIMIT 1112
33SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 38112
34SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 38111
35SELECT COUNT(*) AS `count` FROM `eticketing_mxh`.`othertickets` AS `Otherticket` WHERE `Otherticket`.`id` = 38111
36UPDATE `eticketing_mxh`.`othertickets` SET `id` = 38, `time` = '2017-11-16 20:00:00', `price` = '100|180|180|280|380|480', `show_id` = 49, `status` = 1, `explain` = 'System Shows' WHERE `eticketing_mxh`.`othertickets`.`id` = '38'001
37SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
38select distinct showtime_start from shows where showtime_start >= '2017-11-01' and showtime_start <= '2017-11-31' and active = 1 552
39SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
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 5002
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` asc222