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

请使用IE浏览器在线购票
无需注册,进入演出页面即可购票!
地址:前进西路1850号(体育中心旁)
售票热线:0512-55135111 55135222
租场热线:0512-36691860

观演须知
  1. 请着装整洁,持有效票券按序入场;
  2. 请勿将食品饮料带入观众厅内;
  3. 1米以下儿童谢绝入场,1米以上儿童照常购票(儿童专场除外);
  4. 场内严禁使用闪光灯。未经演出单位允许,严禁私自录像、录音;
  5. 演出期间请将手机调为振动或关闭;
  6. 请照顾好您的小孩,不要在观众厅内跑闹,以免摔伤;
  7. 严禁在场内大声喧哗、吵闹;
  8. 演出期间请勿随意走动;
  9. 迟到的观众,请在门口稍候,待一个曲(节)目结束后,轻轻入场,就近入座;
  10. 中场休息出门时,请向门口服务员领取副券,休息后凭副券再次入场;
  11. 场内严禁吸烟、咀嚼口香糖;
  12. 入场前,请您将大包、雨伞存放在大堂的衣帽间处;
  13. 剧院的卫生间,在大堂两侧,以及各个验票口附近;
  14. 演出票售出后概不退换;

感谢您对我们工作的支持,愿您在这里度过一段美好的时光!

  1. Please wear formal dress and hold valid admission ticket.
  2. No food or drink allowed into the auditorium.
  3. Children under 1 meter high will not be admitted. and child above 1m in height is required to purchase separate ticket. (Except the performances specially arranged for children.).
  4. Flash lighting is strictly forbidden; photography, video or audio recording must have prior approval.
  5. Please set your mobile phone to vibration or mute mode.
  6. Please supervise children at all times; for your children’s safety, no noise or running is allowed in the auditorium.
  7. No excessive noise or disruptive behavior will be tolerated.
  8. Do not wander during the performance.
  9. If performance has started, please wait until an appropriate break to enter the theatre.
  10. When leaving the auditorium, get the sub-ticket from the staff at the doorway for reentry.
  11. No smoking or gum is permitted in the auditorium.
  12. Before entering, please put your large bags or umbrellas in the lobby cloakroom.
  13. Washrooms are found at the two sides of the lobby and nearby each ticket exit.
  14. Tickets sold are not refundable.

Thank you for your cooperation and we hope you will enjoy yourselves in the theatre.

会员章程
欢迎加入昆山文化艺术中心会员俱乐部

“艺卡通”办理及使用规则
一、会员入会手续
    1、 填写完整《会员申请表》;
    2、 验证个人有效身份证件;
    3、 会员资料必填项须填写真实、完整,否则遗失不补,会员享有的权益将受到影响;
    4、 会员卡一经确认办理后,不得转让。
    5、 会员信息变更需及时前往前台办理变更手续。
二、会员专享:
    1、 尊贵独享:可享受会员通道购票,优先购票,快捷方便;
    2、 购票优惠:凭会员卡销售可享受7-9折优惠;
    3、 专享服务:每季度将收到精美《与艺术同行》会员专刊;
    4、 会员活动:每季度将安排会员活动,凭会员卡免费参加;
    5、 生日礼物:所有会员在生日当天可获得神秘礼物。
    6、 更多政策:敬请期待……
三、会员折扣:
    1、 首次充值及续充金额为500元及其倍数,凭卡消费可享受7折优惠。
    2、 当卡内金额为0时,会员折扣恢复至9折。
    3、 租场及合作等特殊项目不享受任何折扣。
四、会员购票方式及流程:
    1、 现场购票:选择您钟爱的演出→选择座位→刷卡→输入密码→消费小票签字→取票。
    2、 网上订购票:登录官网(www.kscac.com),填写订购数量、姓名、联系方式即可。
         (选择在线支付,则不能享受会员折扣,建议预订后现场取票,座位将为您保留至演出开场前半小时)
    3、 电话订购票:会员还可通过电话语音系统订购票:55135111 55135222,我们将为您保留座位至演出开场前半小时。
五、会员卡有效期:一旦您成为我们的会员将终身享受会员待遇。
六、会员卡使用要求:
    1、 会员凭卡购票时首次购票不能超过充值金额;
    2、 此卡不可折叠弯曲,避免磁力干扰,请妥善保管;
    3、 会员优惠不与其他优惠活动同时享受;
    4、 此卡一旦充值成功,卡内金额将不予退还;
    5、 此卡只限在昆山文化艺术中心票务中心使用;
    6、 持此卡消费,本公司不再提供发票;
    7、 演出票一旦售出则不退不换;
    8、 当卡内有存款时可享受7折优惠;
    9、 当卡内余额不足以支付所购单张门票时只可享受9折优惠;
    10、会员充值、消费、生日均会得到短信提醒;
    11、凭会员卡可参加会员活动并享受额外惊喜;
    12、更多商务加盟中……
七、补卡办理:
    如会员卡遗失或损坏,需携带本人身份证至剧院会员柜台,核对个人资料无误后,方可重新补办新卡,补卡时需缴纳工本费20元/张。
八、保护措施:
    1、 为保证会员权益,会员申请加入时需填写真实、完整的会员资料;
    2、 若查询相关信息时,需会员本人凭会员身份证及电话号码方可查询;
    3、 若会员信息有更新时请及时告之剧院更新会员资料。
九、特别提醒:为了维护好昆山的票务市场,凡使用会员卡而取得的优惠以及购买的演出票严禁在市场上进行倒卖,一经发现,将取消您的会员资格。
十、昆山市保利大剧院管理有限公司拥有本《会员章程》及会员卡的最终解释权。

  友情链接 >>
新浪微博   昆山论坛   人人网   视听网   昆山视窗   昆山新闻   乐居昆山

(default) 53 queries took 126 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_kscac`.`news` AS `News` WHERE `News`.`id`=2001002
2SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_kscac`.`news` AS `News` WHERE `News`.`id`=2002002
3SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_kscac`.`news` AS `News` WHERE `News`.`id`=2003002
4SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_kscac`.`news` AS `News` WHERE `News`.`id`=2004002
5SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
6select distinct showtime_start from shows where showtime_start >= '2017-10-01' and showtime_start <= '2017-10-31' and active = 1 442
7SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
8SELECT `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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-19') and foretells=2 ORDER BY `orderby` asc LIMIT 5002
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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-19') and foretells = 2 ORDER BY `orderby` asc002
10SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
11SELECT `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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-19') and foretells=3 ORDER BY `orderby` asc LIMIT 6002
12SELECT `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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-19') and foretells = 3 ORDER BY `orderby` asc002
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_kscac`.`shows` AS `Show` WHERE 1 AND `Show`.`showtime2`>"2017-10-20 06:01:56" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010102
14SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
15SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
16SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' ORDER BY `Show`.`showtime` DESC LIMIT 1113
17SELECT 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 = '586'115
18SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
19SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戴茜今晚嫁给谁》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
20SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戴茜今晚嫁给谁》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
21SELECT 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 = '597'114
22SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1113
23SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` ASC LIMIT 1113
24SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
25SELECT 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 = '605'114
26SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
27SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
28SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
29SELECT 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 = '606'113
30SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
31SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之圣诞戏曲大联欢' ORDER BY `Show`.`showtime` ASC LIMIT 1112
32SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之圣诞戏曲大联欢' ORDER BY `Show`.`showtime` DESC LIMIT 1112
33SELECT 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 = '608'113
34SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
35SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之“瘦西湖畔的曼妙”扬剧折子戏专场' ORDER BY `Show`.`showtime` ASC LIMIT 1112
36SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之“瘦西湖畔的曼妙”扬剧折子戏专场' ORDER BY `Show`.`showtime` DESC LIMIT 1112
37SELECT 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 = '610'113
38SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
39SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之越剧经典大戏《红楼梦》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
40SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之越剧经典大戏《红楼梦》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
41SELECT 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 = '612'113
42SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
43SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' ORDER BY `Show`.`showtime` ASC LIMIT 1112
44SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' ORDER BY `Show`.`showtime` DESC LIMIT 1112
45SELECT 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 = '613'113
46SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
47SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '相声剧《品欢相声会馆》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
48SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '相声剧《品欢相声会馆》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
49SELECT 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 = '614'113
50SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
51SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
52SELECT `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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
53SELECT 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 = '615'116