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

温馨提示:本剧院楼层间不互通,抱小孩的观众务必为孩子购买与家长同一楼层的座位.演出前一周订票不再快递,请前往售票厅取票,选择自取请在地址栏填写“自取”二字,无需填写地址.如选择邮寄的观众演出前三天未收到票,请拨打86371698 招行和平安银行支付时可能出现无法支付的情况,请谨慎使用.若支付过程中出现故障,所选位置会暂时锁定,不可继续支付。如想继续选择相应位置,静候40min后刷新票图页面重新支付即可
热门推荐
票价:120 - 580 元
2017-10-20 20:00 深圳保利剧院
演出信息
暂无演出信息
  友情链接 >>
                               

(default) 50 queries took 106 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
2SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
3select distinct showtime_start from shows where showtime_start >= '2017-10-01' and showtime_start <= '2017-10-31' and active = 1 772
4SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
5SELECT `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_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells=2 ORDER BY `orderby` asc LIMIT 10332
6SELECT `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_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells = 2 ORDER BY `orderby` asc002
7SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`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_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells=3 ORDER BY `orderby` asc LIMIT 6002
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_szbl`.`ads` AS `Ad` LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells = 3 ORDER BY `orderby` asc002
10SELECT `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_szbl`.`shows` AS `Show` WHERE 1 AND `Show`.`showtime2`>"2017-10-23 01:49:09" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010102
11SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
12SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
14SELECT 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 = '1824'113
15SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
17SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
18SELECT 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 = '1845'113
19SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
21SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
22SELECT 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 = '1846'113
23SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
25SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
26SELECT 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 = '1849'112
27SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1113
29SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
30SELECT 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 = '1858'112
31SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
33SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
34SELECT 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 = '1859'112
35SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
37SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
38SELECT 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 = '1860'112
39SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
41SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
42SELECT 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 = '1861'112
43SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '经典版《暗恋桃花源》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
45SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '经典版《暗恋桃花源》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
46SELECT 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 = '1863'113
47SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_szbl`.`nodes` AS `Node` WHERE `Node`.`id` = 5 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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' ORDER BY `Show`.`showtime` ASC LIMIT 1112
49SELECT `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_szbl`.`shows` AS `Show` LEFT JOIN `eticketing_szbl`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_szbl`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_szbl`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' ORDER BY `Show`.`showtime` DESC LIMIT 1112
50SELECT 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 = '1865'112