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

温馨提示:本剧院楼层间不互通,抱小孩的观众务必为孩子购买与家长同一楼层的座位.演出前一周订票不再快递,请前往售票厅取票,选择自取请在地址栏填写“自取”二字,无需填写地址.如选择邮寄的观众演出前三天未收到票,请拨打86371698 招行和平安银行支付时可能出现无法支付的情况,请谨慎使用.若支付过程中出现故障,所选位置会暂时锁定,不可继续支付。如想继续选择相应位置,静候40min后刷新票图页面重新支付即可
【2017-08-18】
【2017-07-04】
【2017-04-14】
【2017-04-07】
【2016-08-25】
【2016-08-03】
【2016-07-07】
【2016-04-19】
【2016-04-15】
【2016-04-06】
单位:霍尔果斯雀之恋文化传...
时间:2017-10-25 至 10-29
地点:深圳保利剧院
票价:180 - 880 元
单位:北京央华时代文化发展...
时间:2017-11-03 至 11-04
地点:深圳保利剧院
票价:180 - 980 元
单位:演奏家: 伊扎克·帕...
时间:2017-11-07 20:00
地点:深圳保利剧院
票价:880 - 3880 元
单位:厦门小白鹭民间舞艺术...
时间:2017-11-16 20:00
地点:深圳保利剧院
票价:80 - 280 元
单位:钢琴家:唐瑾、黄子芳...
时间:2017-11-17 20:00
地点:深圳保利剧院
票价:100 - 680 元
单位:北京壹佰世纪国际文化...
时间:2017-11-18 至 11-18
地点:深圳保利剧院
票价:80 - 480 元
单位:遥不可及乐队
时间:2017-11-19 20:00
地点:深圳保利剧院
票价:100 - 480 元
单位:西区爱乐室内乐团
时间:2017-12-01 20:00
地点:深圳保利剧院
票价:80 - 480 元
单位:七幕人生
时间:2017-12-15 至 12-24
地点:深圳保利剧院
票价:100 - 888 元
单位:小野丽莎
时间:2017-12-25 19:30
地点:深圳保利剧院
票价:180 - 1280 元
单位:俄罗斯莫斯科国立芭蕾...
时间:2017-12-28 20:00
地点:深圳保利剧院
票价:180 - 880 元
单位:百老汇原版音乐剧《律...
时间:2018-01-04 至 01-06
地点:深圳保利剧院
票价:180 - 980 元
  友情链接 >>
                               

(default) 147 queries took 203 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 1111
2SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'getproducts_validity' LIMIT 1111
3SELECT `Updatecache`.`id`, `Updatecache`.`created`, `Updatecache`.`modified`, `Updatecache`.`procedure`, `Updatecache`.`last_updated` FROM `eticketing_szbl`.`updatecaches` AS `Updatecache` WHERE `Updatecache`.`procedure` = 'updateshows()' LIMIT 1111
4SELECT DISTINCT `Show`.`name` FROM `eticketing_szbl`.`shows` AS `Show` WHERE 1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ORDER BY `Show`.`showtime2` ASC LIMIT 1212121
5SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '大型原生态歌舞集《云南映象》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
6SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '北京文化艺术基金2016年度资助项目 话剧《新原野》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
7SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
8SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '闽南风情舞蹈诗《沉沉的厝里情》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
9SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '中外钢琴名曲群英荟' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
10SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '儿童剧《海底小纵队之火山大冒险》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
11SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '《百老汇魅力之星——美国遥不可及乐队演唱会》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
12SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '“天空之城”久石让&宫崎骏经典动漫作品视听音乐会' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
13SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '百老汇经典音乐剧《音乐之声》中文版' ORDER BY `Show`.`showtime2` ASC LIMIT 1113
14SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '2017年小野丽莎中国巡回演唱会深圳站' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
15SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '俄罗斯国立芭蕾舞团芭蕾舞《天鹅湖》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
16SELECT * FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" ) AND `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
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 = 1824111
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` = 1020 AND `Pricelevel`.`active` = 1552
19SELECT 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
20SELECT `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` WHERE `Show`.`name` = '大型原生态歌舞集《云南映象》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC551
21SELECT `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` WHERE `Show`.`name` = '大型原生态歌舞集《云南映象》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
22SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1824 ORDER BY pricelevels.price ASC552
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 = 1852111
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` = 1048 AND `Pricelevel`.`active` = 1552
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 = '1852'112
26SELECT `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` WHERE `Show`.`name` = '北京文化艺术基金2016年度资助项目 话剧《新原野》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC221
27SELECT `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` WHERE `Show`.`name` = '北京文化艺术基金2016年度资助项目 话剧《新原野》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
28SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1852 ORDER BY pricelevels.price ASC552
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 = 1865111
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` = 1057 AND `Pricelevel`.`active` = 1552
31SELECT 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
32SELECT `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` WHERE `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
33SELECT `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` WHERE `Show`.`name` = '伊扎克·帕尔曼小提琴独奏音乐会' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
34SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1865 ORDER BY pricelevels.price ASC552
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 = 1857111
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` = 1049 AND `Pricelevel`.`active` = 1441
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 = '1857'111
38SELECT `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` WHERE `Show`.`name` = '闽南风情舞蹈诗《沉沉的厝里情》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
39SELECT `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` WHERE `Show`.`name` = '闽南风情舞蹈诗《沉沉的厝里情》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
40SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1857 ORDER BY pricelevels.price ASC442
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 = 1864111
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` = 1056 AND `Pricelevel`.`active` = 1662
43SELECT 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 = '1864'111
44SELECT `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` WHERE `Show`.`name` = '中外钢琴名曲群英荟' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
45SELECT `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` WHERE `Show`.`name` = '中外钢琴名曲群英荟' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
46SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1864 ORDER BY pricelevels.price ASC662
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 = 1739112
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` = 942 AND `Pricelevel`.`active` = 1552
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 = '1739'112
50SELECT `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` WHERE `Show`.`name` = '儿童剧《海底小纵队之火山大冒险》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC221
51SELECT `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` WHERE `Show`.`name` = '儿童剧《海底小纵队之火山大冒险》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
52SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1739 ORDER BY pricelevels.price ASC552
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 = 1856111
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` = 1046 AND `Pricelevel`.`active` = 1552
55SELECT 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 = '1856'112
56SELECT `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` WHERE `Show`.`name` = '《百老汇魅力之星——美国遥不可及乐队演唱会》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
57SELECT `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` WHERE `Show`.`name` = '《百老汇魅力之星——美国遥不可及乐队演唱会》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
58SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1856 ORDER BY pricelevels.price ASC552
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 = 1804111
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` = 1002 AND `Pricelevel`.`active` = 1552
61SELECT 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 = '1804'111
62SELECT `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` WHERE `Show`.`name` = '“天空之城”久石让&宫崎骏经典动漫作品视听音乐会' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
63SELECT `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` WHERE `Show`.`name` = '“天空之城”久石让&宫崎骏经典动漫作品视听音乐会' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
64SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1804 ORDER BY pricelevels.price ASC552
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 = 1825111
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` = 1032 AND `Pricelevel`.`active` = 1662
67SELECT 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 = '1825'111
68SELECT `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` WHERE `Show`.`name` = '百老汇经典音乐剧《音乐之声》中文版' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC12122
69SELECT `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` WHERE `Show`.`name` = '百老汇经典音乐剧《音乐之声》中文版' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
70SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1825 ORDER BY pricelevels.price ASC662
71SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1851111
72SELECT `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
73SELECT 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 = '1851'112
74SELECT `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` WHERE `Show`.`name` = '2017年小野丽莎中国巡回演唱会深圳站' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
75SELECT `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` WHERE `Show`.`name` = '2017年小野丽莎中国巡回演唱会深圳站' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
76SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1851 ORDER BY pricelevels.price ASC772
77SELECT `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
78SELECT `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
79SELECT 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 = '1844'112
80SELECT `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` WHERE `Show`.`name` = '俄罗斯国立芭蕾舞团芭蕾舞《天鹅湖》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC111
81SELECT `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` WHERE `Show`.`name` = '俄罗斯国立芭蕾舞团芭蕾舞《天鹅湖》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
82SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1844 ORDER BY pricelevels.price ASC662
83SELECT `Section`.`id` FROM `eticketing_szbl`.`sections` AS `Section` LEFT JOIN `eticketing_szbl`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 1861111
84SELECT `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
85SELECT 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
86SELECT `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` WHERE `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-21 21:46:18' ORDER BY `Show`.`showtime` ASC442
87SELECT `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` WHERE `Show`.`name` = '百老汇原版音乐剧《律政俏佳人》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
88SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 1861 ORDER BY pricelevels.price ASC552
89SELECT `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 foretells=5001
90SELECT DISTINCT `Show`.`name` FROM `eticketing_szbl`.`shows` AS `Show` WHERE 1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18" ORDER BY `Show`.`showtime` DESC LIMIT 1010102
91SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '天利策划·千与千寻 久石让·宫崎骏动漫视听大型交响音乐会' ORDER BY `Show`.`showtime` DESC LIMIT 1111
92SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '爱尔兰全新踢踏舞剧《泰坦尼克》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
93SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '大型原创话剧《董必武》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
94SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '北京德云社“德云三宝”相声专场演出' ORDER BY `Show`.`showtime` DESC LIMIT 1111
95SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '经典原版音乐剧《保镖 Bodyguard》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
96SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = 'SLAVLS SNOW SHOW-《斯拉法下雪秀》' ORDER BY `Show`.`showtime` DESC LIMIT 1001
97SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '金星舞蹈团《迷魅上海》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
98SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '《金星脱口秀》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
99SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '七幕出品 百老汇殿堂之作 音乐剧《我,堂吉诃德》中文版' ORDER BY `Show`.`showtime` DESC LIMIT 1111
100SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_szbl`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-20 21:46:18" AND `Show`.`showtime2`>"2017-07-23 21:46:18") AND `Show`.`name` = '第十届“打开艺术之门”暑期亲子系列《用音乐70分钟环游世界》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
101SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_szbl`.`news` AS `News` WHERE `News`.`status`=1 ORDER BY `News`.`created` desc LIMIT 1010106
102SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
103select distinct showtime_start from shows where showtime_start >= '2017-10-01' and showtime_start <= '2017-10-31' and active = 1 771
104SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
105SELECT `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 10331
106SELECT `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` asc001
107SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_szbl`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
108SELECT `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 6001
109SELECT `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` asc001
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` WHERE 1 AND `Show`.`showtime2`>"2017-10-22 21:46:18" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010101
111SELECT `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
112SELECT `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 1111
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` DESC LIMIT 1111
114SELECT `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
115SELECT `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 1111
116SELECT `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 1111
117SELECT 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'112
118SELECT `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
119SELECT `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 1111
120SELECT `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 1111
121SELECT 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'112
122SELECT `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
123SELECT `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 1111
124SELECT `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 1111
125SELECT 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
126SELECT `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
127SELECT `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 1111
128SELECT `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 1111
129SELECT 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'111
130SELECT `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
131SELECT `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 1111
132SELECT `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 1111
133SELECT 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'111
134SELECT `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
135SELECT `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 1111
136SELECT `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 1111
137SELECT 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'111
138SELECT `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
139SELECT `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 1111
140SELECT `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 1111
141SELECT `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
142SELECT `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 1111
143SELECT `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 1111
144SELECT 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
145SELECT `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
146SELECT `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 1111
147SELECT `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 1111