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

温馨提示:本剧院楼层间不互通,抱小孩的观众务必为孩子购买与家长同一楼层的座位.演出前一周订票不再快递,请前往售票厅取票,选择自取请在地址栏填写“自取”二字,无需填写地址.如选择邮寄的观众演出前三天未收到票,请拨打86371698 招行和平安银行支付时可能出现无法支付的情况,请谨慎使用.若支付过程中出现故障,所选位置会暂时锁定,不可继续支付。如想继续选择相应位置,静候40min后刷新票图页面重新支付即可
网上售票
大型原生态歌舞集《云南映象》
2017-10-25 20:00
 深圳保利剧院
180   280   480   680   880  
大型原生态歌舞集《云南映象》
2017-10-26 20:00
 深圳保利剧院
180   280   480   680   880  
大型原生态歌舞集《云南映象》
2017-10-27 20:00
 深圳保利剧院
180   280   480   680   880  
大型原生态歌舞集《云南映象》
2017-10-28 20:00
 深圳保利剧院
180   280   480   680   880  
大型原生态歌舞集《云南映象》
2017-10-29 20:00
 深圳保利剧院
180   280   480   680   880  
北京文化艺术基金2016年度资助项目 话剧《新原野》
2017-11-03 20:00
 深圳保利剧院
180   380   580   780   980  
北京文化艺术基金2016年度资助项目 话剧《新原野》
2017-11-04 20:00
 深圳保利剧院
180   380   580   780   980  
伊扎克·帕尔曼小提琴独奏音乐会
2017-11-07 20:00
 深圳保利剧院
880   1280   1680   2880   3880  
闽南风情舞蹈诗《沉沉的厝里情》
2017-11-16 20:00
 深圳保利剧院
80   120   200   280  
中外钢琴名曲群英荟
2017-11-17 20:00
 深圳保利剧院
100   180   280   380   480   680  
儿童剧《海底小纵队之火山大冒险》
2017-11-18 15:00
 深圳保利剧院
80   180   280   380   480  
儿童剧《海底小纵队之火山大冒险》
2017-11-18 20:00
 深圳保利剧院
80   180   280   380   480  
《百老汇魅力之星——美国遥不可及乐队演唱会》
2017-11-19 20:00
 深圳保利剧院
100   180   280   380   480  
“天空之城”久石让&宫崎骏经典动漫作品视听音乐会
2017-12-01 20:00
 深圳保利剧院
80   180   280   380   480  
百老汇经典音乐剧《音乐之声》中文版
2017-12-15 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-16 15:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-16 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-17 15:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-17 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-20 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-21 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-22 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-23 15:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-23 20:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-24 15:00
 深圳保利剧院
100   188   288   388   588   888  
百老汇经典音乐剧《音乐之声》中文版
2017-12-24 20:00
 深圳保利剧院
100   188   288   388   588   888  
2017年小野丽莎中国巡回演唱会深圳站
2017-12-25 19:30
 深圳保利剧院
180   380   580   780   980   1080   1280  
俄罗斯国立芭蕾舞团芭蕾舞《天鹅湖》
2017-12-28 20:00
 深圳保利剧院
180   280   380   480   680   880  
百老汇原版音乐剧《律政俏佳人》
2018-01-04 20:00
 深圳保利剧院
180   380   580   780   980  
百老汇原版音乐剧《律政俏佳人》
2018-01-05 20:00
 深圳保利剧院
180   380   580   780   980  
百老汇原版音乐剧《律政俏佳人》
2018-01-06 15:00
 深圳保利剧院
180   380   580   780   980  
百老汇原版音乐剧《律政俏佳人》
2018-01-06 20:00
 深圳保利剧院
180   380   580   780   980  
经典版《暗恋桃花源》
2018-01-13 20:00
 深圳保利剧院
380   680   980   1280  
经典版《暗恋桃花源》
2018-01-14 20:00
 深圳保利剧院
380   680   980   1280  
  友情链接 >>
                               

(default) 119 queries took 242 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 `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_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`.`showtime2`>'2017-10-21 21:55:37' ORDER BY `Show`.`showtime2` asc34342
3SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1824112
4SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1020 AND `Pricelevel`.`active` = 1552
5SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1840112
6SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1033 AND `Pricelevel`.`active` = 1552
7SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1845112
8SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1037 AND `Pricelevel`.`active` = 1553
9SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1846112
10SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1038 AND `Pricelevel`.`active` = 1552
11SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1849112
12SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1040 AND `Pricelevel`.`active` = 1552
13SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1852112
14SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1048 AND `Pricelevel`.`active` = 1552
15SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1853112
16SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1047 AND `Pricelevel`.`active` = 1552
17SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1865112
18SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1057 AND `Pricelevel`.`active` = 1552
19SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1857112
20SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1049 AND `Pricelevel`.`active` = 1442
21SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1864112
22SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1056 AND `Pricelevel`.`active` = 1662
23SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1739111
24SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 942 AND `Pricelevel`.`active` = 1552
25SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1738111
26SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 943 AND `Pricelevel`.`active` = 1552
27SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1856112
28SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1046 AND `Pricelevel`.`active` = 1552
29SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1804112
30SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1002 AND `Pricelevel`.`active` = 1552
31SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1825112
32SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1032 AND `Pricelevel`.`active` = 1662
33SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1828114
34SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1029 AND `Pricelevel`.`active` = 1664
35SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1826113
36SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1031 AND `Pricelevel`.`active` = 1663
37SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1829112
38SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1028 AND `Pricelevel`.`active` = 1662
39SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1827112
40SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1030 AND `Pricelevel`.`active` = 1662
41SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1830111
42SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1027 AND `Pricelevel`.`active` = 1662
43SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1831112
44SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1026 AND `Pricelevel`.`active` = 1662
45SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1832112
46SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1025 AND `Pricelevel`.`active` = 1662
47SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1835111
48SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1022 AND `Pricelevel`.`active` = 1662
49SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1833111
50SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1024 AND `Pricelevel`.`active` = 1662
51SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1836112
52SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1021 AND `Pricelevel`.`active` = 1662
53SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1834112
54SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1023 AND `Pricelevel`.`active` = 1662
55SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1851112
56SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1043 AND `Pricelevel`.`active` = 1772
57SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1844111
58SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1036 AND `Pricelevel`.`active` = 1662
59SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1861112
60SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1050 AND `Pricelevel`.`active` = 1552
61SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1860111
62SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1051 AND `Pricelevel`.`active` = 1552
63SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1859112
64SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1052 AND `Pricelevel`.`active` = 1552
65SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1858112
66SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1053 AND `Pricelevel`.`active` = 1552
67SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1862111
68SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1055 AND `Pricelevel`.`active` = 1442
69SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1863111
70SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_szbl`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_szbl`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 1054 AND `Pricelevel`.`active` = 1442
71SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
72select distinct showtime_start from shows where showtime_start >= '2017-10-01' and showtime_start <= '2017-10-31' and active = 1 773
73SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
74SELECT `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-21') and foretells=2 ORDER BY `orderby` asc LIMIT 10333
75SELECT `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-21') and foretells = 2 ORDER BY `orderby` asc002
76SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
77SELECT `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-21') and foretells=3 ORDER BY `orderby` asc LIMIT 6002
78SELECT `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-21') and foretells = 3 ORDER BY `orderby` asc002
79SELECT `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-22 21:55:37" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010102
80SELECT `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
81SELECT `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
82SELECT `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
83SELECT 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'112
84SELECT `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
85SELECT `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
86SELECT `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
87SELECT 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'116
88SELECT `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
89SELECT `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
90SELECT `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
91SELECT 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
92SELECT `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
93SELECT `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
94SELECT `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
95SELECT 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'113
96SELECT `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
97SELECT `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
98SELECT `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
99SELECT 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
100SELECT `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 1111
101SELECT `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
102SELECT `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
103SELECT 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
104SELECT `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
105SELECT `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
106SELECT `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
107SELECT 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
108SELECT `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
109SELECT `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
110SELECT `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
111SELECT 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
112SELECT `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
113SELECT `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
114SELECT `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
115SELECT 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'112
116SELECT `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 1111
117SELECT `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
118SELECT `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
119SELECT 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