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

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

【2017-09-26】
【2017-03-22】
【2017-03-22】
【2016-07-20】
【2016-07-20】
【2016-05-05】
【2016-04-14】
【2016-03-17】
【2016-03-14】
【2016-03-14】
单位:主演:严晓频
时间:2017-10-24 19:30
地点:昆山文化艺术中心大剧场
票价:100 - 380 元
单位:
时间:2017-10-26 19:30
地点:昆山文化艺术中心大剧场
票价:100 - 480 元
单位:中国戏剧家协会 江苏...
时间:2017-11-01 19:00
地点:昆山文化艺术中心大剧场
票价:280 - 1880 元
单位:上海皖约黄梅戏剧团
时间:2017-11-12 14:00
地点:昆山文化艺术中心多功能厅
票价:49 元
单位:央华时代
时间:2017-11-14 19:30
地点:昆山文化艺术中心大剧场
票价:100 - 480 元
单位:主演:朱亦兵、董潇、...
时间:2017-11-18 19:30
地点:昆山文化艺术中心大剧场
票价:30 - 100 元
单位:张家港市锡剧艺术中心
时间:2017-11-24 19:30
地点:昆山文化艺术中心大剧场
票价:80 - 180 元
单位:上海艾亚文化传播有限...
时间:2017-11-25 至 11-25
地点:昆山文化艺术中心大剧场
票价:80 - 380 元
单位:上海盈凯文化艺术团
时间:2017-11-26 14:00
地点:昆山文化艺术中心多功能厅
票价:49 元
单位:主演:戴军、闫楠等
时间:2017-12-02 至 12-03
地点:昆山文化艺术中心大剧场
票价:100 - 680 元
单位:主演:陈佩斯、杨立新...
时间:2017-12-08 至 12-09
地点:昆山文化艺术中心大剧场
票价:100 - 880 元
单位:上海晓韵文化艺术团
时间:2017-12-10 14:00
地点:昆山文化艺术中心多功能厅
票价:49 元
  友情链接 >>
新浪微博   昆山论坛   人人网   视听网   昆山视窗   昆山新闻   乐居昆山

(default) 144 queries took 377 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
2SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'getproducts_validity' LIMIT 1112
3SELECT `Updatecache`.`id`, `Updatecache`.`created`, `Updatecache`.`modified`, `Updatecache`.`procedure`, `Updatecache`.`last_updated` FROM `eticketing_kscac`.`updatecaches` AS `Updatecache` WHERE `Updatecache`.`procedure` = 'updateshows()' LIMIT 1112
4SELECT DISTINCT `Show`.`name` FROM `eticketing_kscac`.`shows` AS `Show` WHERE 1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ORDER BY `Show`.`showtime2` ASC LIMIT 1212122
5SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '话剧《戴茜今晚嫁给谁》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
6SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' ORDER BY `Show`.`showtime2` ASC LIMIT 1113
7SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '“2017·戏相逢”--中国锡剧届艺术盛会' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
8SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之黄梅戏经典大戏《天仙配》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
9SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '《圆环物语》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
10SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '《梦之旅,朱亦兵大提琴乐团保利巡演》' ORDER BY `Show`.`showtime2` ASC LIMIT 1113
11SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '锡剧《三三》' ORDER BY `Show`.`showtime2` ASC LIMIT 1113
12SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime2` ASC LIMIT 1113
13SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之越剧经典大戏《红楼梦》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
14SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '话剧《那一夜,在旅途中说相声》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
15SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
16SELECT * FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-10-23 21:46:22" ) AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
17SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 597112
18SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 369 AND `Pricelevel`.`active` = 1445
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 = '597'114
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《戴茜今晚嫁给谁》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《戴茜今晚嫁给谁》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
22SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 597 ORDER BY pricelevels.price ASC444
23SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 586112
24SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 354 AND `Pricelevel`.`active` = 1555
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 = '586'115
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
28SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 586 ORDER BY pricelevels.price ASC554
29SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 619112
30SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 387 AND `Pricelevel`.`active` = 1663
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 = '619'113
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '“2017·戏相逢”--中国锡剧届艺术盛会' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '“2017·戏相逢”--中国锡剧届艺术盛会' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
34SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 619 ORDER BY pricelevels.price ASC663
35SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 611112
36SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 374 AND `Pricelevel`.`active` = 1114
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 = '611'113
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之黄梅戏经典大戏《天仙配》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之黄梅戏经典大戏《天仙配》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
40SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 611 ORDER BY pricelevels.price ASC113
41SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 620112
42SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 384 AND `Pricelevel`.`active` = 1553
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 = '620'113
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '《圆环物语》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '《圆环物语》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
46SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 620 ORDER BY pricelevels.price ASC553
47SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 622112
48SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 385 AND `Pricelevel`.`active` = 1443
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 = '622'113
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '《梦之旅,朱亦兵大提琴乐团保利巡演》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '《梦之旅,朱亦兵大提琴乐团保利巡演》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
52SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 622 ORDER BY pricelevels.price ASC443
53SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 621112
54SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 386 AND `Pricelevel`.`active` = 1332
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 = '621'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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '锡剧《三三》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '锡剧《三三》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
58SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 621 ORDER BY pricelevels.price ASC332
59SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 605112
60SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 371 AND `Pricelevel`.`active` = 1555
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 = '605'114
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC222
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' 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 = 605 ORDER BY pricelevels.price ASC555
65SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 612112
66SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 373 AND `Pricelevel`.`active` = 1114
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 = '612'113
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之越剧经典大戏《红楼梦》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`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 = 612 ORDER BY pricelevels.price ASC113
71SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 617112
72SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 379 AND `Pricelevel`.`active` = 1664
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 = '617'114
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《那一夜,在旅途中说相声》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC223
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《那一夜,在旅途中说相声》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
76SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 617 ORDER BY pricelevels.price ASC664
77SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 615112
78SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 381 AND `Pricelevel`.`active` = 1776
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 = '615'117
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《戏台》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC222
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《戏台》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
82SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 615 ORDER BY pricelevels.price ASC776
83SELECT `Section`.`id` FROM `eticketing_kscac`.`sections` AS `Section` LEFT JOIN `eticketing_kscac`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 613112
84SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_kscac`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_kscac`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 372 AND `Pricelevel`.`active` = 1113
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 = '613'113
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-10-22 21:46:22' ORDER BY `Show`.`showtime` ASC112
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_kscac`.`shows` AS `Show` WHERE `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1112
88SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 613 ORDER BY pricelevels.price ASC113
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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE foretells=5002
90SELECT DISTINCT `Show`.`name` FROM `eticketing_kscac`.`shows` AS `Show` WHERE 1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22" 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_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之“瘦西湖畔的曼妙”扬剧折子戏专场' ORDER BY `Show`.`showtime` DESC LIMIT 1112
92SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '大型魔幻惊悚话剧《盗墓笔记Ⅲ》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
93SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之“梧桐叶上见寒露”沪剧折子戏专场' ORDER BY `Show`.`showtime` DESC LIMIT 1112
94SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '梦至凌霄 音越流云 钢琴音乐会' ORDER BY `Show`.`showtime` DESC LIMIT 1112
95SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '《我,堂吉诃德》 1.2M谢绝入场' ORDER BY `Show`.`showtime` DESC LIMIT 1112
96SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '俄罗斯爱乐交响乐团音乐会' ORDER BY `Show`.`showtime` DESC LIMIT 1112
97SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '儿童剧《小王子之星际旅行》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
98SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '七彩童年,建行相伴--《小丑嘉年华》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
99SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '大型经典童话音乐剧《灰姑娘》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
100SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_kscac`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-10-21 21:46:22" AND `Show`.`showtime2`>"2017-07-24 21:46:22") AND `Show`.`name` = '七彩童年,建行相伴--《故事王国奇遇记·绘本音乐会》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
101SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_kscac`.`news` AS `News` WHERE `News`.`status`=1 ORDER BY `News`.`created` desc LIMIT 10101019
102SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
103select distinct showtime_start from shows where showtime_start >= '2017-10-01' and showtime_start <= '2017-10-31' and active = 1 442
104SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells=2 ORDER BY `orderby` asc LIMIT 5002
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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells = 2 ORDER BY `orderby` asc002
107SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_kscac`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells=3 ORDER BY `orderby` asc LIMIT 6002
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_kscac`.`ads` AS `Ad` LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-10-22') and foretells = 3 ORDER BY `orderby` asc002
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_kscac`.`shows` AS `Show` WHERE 1 AND `Show`.`showtime2`>"2017-10-23 21:46:23" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010102
111SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '《梦幻之夜--世界著名舞台魔术大师展演》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
114SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戴茜今晚嫁给谁》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戴茜今晚嫁给谁》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
117SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
120SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
121SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
122SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '加拿大多媒体3D儿童音乐剧《爱丽丝梦游仙境》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
123SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '606'113
124SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
125SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之圣诞戏曲大联欢' ORDER BY `Show`.`showtime` ASC LIMIT 1112
126SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之圣诞戏曲大联欢' ORDER BY `Show`.`showtime` DESC LIMIT 1112
127SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '608'113
128SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
129SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之越剧经典大戏《红楼梦》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
130SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之越剧经典大戏《红楼梦》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
131SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' ORDER BY `Show`.`showtime` ASC LIMIT 1112
133SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '中国光大银行携手昆艺百姓百戏堂之《说学逗唱》欢乐戏曲专场' ORDER BY `Show`.`showtime` DESC LIMIT 1112
134SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '相声剧《品欢相声会馆》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '相声剧《品欢相声会馆》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
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 = '614'113
138SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
141SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_kscac`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime` ASC LIMIT 1112
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_kscac`.`shows` AS `Show` LEFT JOIN `eticketing_kscac`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_kscac`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_kscac`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
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 = '616'114