2017-11    
S M T W T F S
   01020304
05060708091011
12131415161718
19202122232425
2627282930  
  

大剧院临时票务中心地址:梅溪湖国际文化艺术中心大剧院大堂总服务台。咨询电话:0731-89518800/8811
【2017-11-01】
【2017-10-20】
【2017-10-20】
【2017-10-19】
【2017-10-18】
【2017-10-18】
【2017-10-18】
【2017-10-17】
【2017-10-17】
【2017-10-16】
单位:天津宝艺文化传播有限...
时间:2017-12-02 至 12-03
地点:梅溪湖文化艺术中心大剧院小剧场
票价:100 - 480 元
单位:何炅、黄磊、孙莉等
时间:2017-12-02 至 12-03
地点:梅溪湖文化艺术中心大剧院大剧场
票价:280 - 1280 元
单位:
时间:2017-12-06 至 12-10
地点:梅溪湖文化艺术中心大剧院小剧场
票价:80 - 680 元
单位:美国电光火线剧团
时间:2017-12-11 至 12-12
地点:梅溪湖文化艺术中心大剧院大剧场
票价:120 - 680 元
单位:高晓攀等
时间:2017-12-13 20:00
地点:梅溪湖文化艺术中心大剧院大剧场
票价:100 - 580 元
单位:爱乐汇文化艺术(北京...
时间:2017-12-15 至 12-16
地点:梅溪湖文化艺术中心大剧院大剧场
票价:100 - 480 元
单位:俄罗斯芭蕾国家剧院
时间:2017-12-26 至 12-27
地点:梅溪湖文化艺术中心大剧院大剧场
票价:100 - 880 元
单位:
时间:2017-12-27 至 12-31
地点:梅溪湖文化艺术中心大剧院小剧场
票价:80 - 680 元
单位:美国魅影舞团
时间:2017-12-28 至 12-29
地点:梅溪湖文化艺术中心大剧院大剧场
票价:120 - 680 元
单位:
时间:2017-12-31 12:12
地点:梅溪湖文化艺术中心大剧院大剧场
票价:500 元
单位:陈佩斯等
时间:2017-12-31 至 01-01
地点:梅溪湖文化艺术中心大剧院大剧场
票价:180 - 1080 元
单位:斯洛伐克国家交响乐团
时间:2018-01-02 20:00
地点:梅溪湖文化艺术中心大剧院大剧场
票价:100 - 680 元
  友情链接 >>
                           

(default) 148 queries took 164 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
2SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'getproducts_validity' LIMIT 1111
3SELECT `Updatecache`.`id`, `Updatecache`.`created`, `Updatecache`.`modified`, `Updatecache`.`procedure`, `Updatecache`.`last_updated` FROM `eticketing_mxh`.`updatecaches` AS `Updatecache` WHERE `Updatecache`.`procedure` = 'updateshows()' LIMIT 1111
4SELECT DISTINCT `Show`.`name` FROM `eticketing_mxh`.`shows` AS `Show` WHERE 1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ORDER BY `Show`.`showtime2` ASC LIMIT 1212121
5SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '海底小纵队3:惊涛骇浪' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
6SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '经典版话剧《暗恋桃花源》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
7SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '孟京辉话剧《两只狗的生活意见》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
8SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '《圣诞狂欢秀》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
9SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '《嘻哈包袱铺》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
10SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
11SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
12SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '孟京辉话剧《恋爱的犀牛》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
13SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '美国Pilobolus 影子舞《幻影王国》' ORDER BY `Show`.`showtime2` ASC LIMIT 1112
14SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '会员办理' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
15SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '话剧《戏台》' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
16SELECT * FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND `Show`.`active`=1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" ) AND `Show`.`name` = '斯洛伐克国家交响乐团新年音乐会' ORDER BY `Show`.`showtime2` ASC LIMIT 1111
17SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 80111
18SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 67 AND `Pricelevel`.`active` = 1551
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 = '80'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '海底小纵队3:惊涛骇浪' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC441
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '海底小纵队3:惊涛骇浪' 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 = 80 ORDER BY pricelevels.price ASC551
23SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 3111
24SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 8 AND `Pricelevel`.`active` = 1551
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 = '3'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '经典版话剧《暗恋桃花源》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' 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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '经典版话剧《暗恋桃花源》' 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 = 3 ORDER BY pricelevels.price ASC551
29SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 34111
30SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 32 AND `Pricelevel`.`active` = 1661
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 = '34'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '孟京辉话剧《两只狗的生活意见》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC551
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_mxh`.`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 = 34 ORDER BY pricelevels.price ASC661
35SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 57111
36SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 49 AND `Pricelevel`.`active` = 1661
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 = '57'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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '《圣诞狂欢秀》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC221
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_mxh`.`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 = 57 ORDER BY pricelevels.price ASC661
41SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 71111
42SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 63 AND `Pricelevel`.`active` = 1661
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 = '71'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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '《嘻哈包袱铺》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' 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_mxh`.`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 = 71 ORDER BY pricelevels.price ASC661
47SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 67111
48SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 52 AND `Pricelevel`.`active` = 1551
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 = '67'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC441
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' 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 = 67 ORDER BY pricelevels.price ASC551
53SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 75111
54SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 59 AND `Pricelevel`.`active` = 1771
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 = '75'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC221
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_mxh`.`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 = 75 ORDER BY pricelevels.price ASC771
59SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 39111
60SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 27 AND `Pricelevel`.`active` = 1661
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 = '39'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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '孟京辉话剧《恋爱的犀牛》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC551
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '孟京辉话剧《恋爱的犀牛》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
64SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 39 ORDER BY pricelevels.price ASC661
65SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 59111
66SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 47 AND `Pricelevel`.`active` = 1661
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 = '59'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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '美国Pilobolus 影子舞《幻影王国》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC222
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '美国Pilobolus 影子舞《幻影王国》' AND `Show`.`active` = 1 ORDER BY `Show`.`showtime2` DESC LIMIT 1111
70SELECT DISTINCT pricelevels.price FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = 59 ORDER BY pricelevels.price ASC661
71SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 19111
72SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 16 AND `Pricelevel`.`active` = 1111
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 = '19'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '会员办理' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' 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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '会员办理' 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 = 19 ORDER BY pricelevels.price ASC111
77SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 8111
78SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 14 AND `Pricelevel`.`active` = 1771
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 = '8'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '话剧《戏台》' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC221
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_mxh`.`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 = 8 ORDER BY pricelevels.price ASC771
83SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 73111
84SELECT `Pricelevel`.`price`, `Pricelevel`.`name` FROM `eticketing_mxh`.`pricelevels` AS `Pricelevel` LEFT JOIN `eticketing_mxh`.`sections` AS `Section` ON (`Pricelevel`.`section_id` = `Section`.`id`) WHERE `Pricelevel`.`section_id` = 61 AND `Pricelevel`.`active` = 1661
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 = '73'111
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_mxh`.`shows` AS `Show` WHERE `Show`.`name` = '斯洛伐克国家交响乐团新年音乐会' AND `Show`.`active`=1 and `Show`.`showtime2`>'2017-11-19 03:46:57' ORDER BY `Show`.`showtime` ASC111
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_mxh`.`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 = 73 ORDER BY pricelevels.price ASC661
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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE foretells=5001
90SELECT DISTINCT `Show`.`name` FROM `eticketing_mxh`.`shows` AS `Show` WHERE 1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57" ORDER BY `Show`.`showtime` DESC LIMIT 1010101
91SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") AND `Show`.`name` = '孟京辉话剧《我爱XXX》' 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") AND `Show`.`name` = '经典原版音乐剧《保镖》THE BODYGUARD THE MUSICAL雪佛兰迈锐宝XL倾情呈现' 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") AND `Show`.`name` = '芭蕾舞剧《美女与野兽》' 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") AND `Show`.`name` = '中国击打' ORDER BY `Show`.`showtime` DESC LIMIT 1111
97SELECT `Show`.`img_s`, `Show`.`img_m`, `Show`.`img_b`, `Show`.`name`, `Show`.`showtime`, `Show`.`venue_name`, `Show`.`id` FROM `eticketing_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") 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_mxh`.`shows` AS `Show` WHERE (1 AND img_s <> "" AND `Show`.`showtime2`<"2017-11-18 03:46:57" AND `Show`.`showtime2`>"2017-08-21 03:46:57") AND `Show`.`name` = '英文版歌剧《红楼梦》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
101SELECT `News`.`id`, `News`.`title`, `News`.`atype`, `News`.`content`, `News`.`status`, `News`.`created` FROM `eticketing_mxh`.`news` AS `News` WHERE `News`.`status`=1 ORDER BY `News`.`created` desc LIMIT 1010105
102SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1111
103select distinct showtime_start from shows where showtime_start >= '2017-11-01' and showtime_start <= '2017-11-31' and active = 1 551
104SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-11-19') 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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-11-19') and foretells = 2 ORDER BY `orderby` asc221
107SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby>0 and (attime='0000-00-00' OR attime > '2017-11-19') 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_mxh`.`ads` AS `Ad` LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Ad`.`category_id` = `Category`.`id`) WHERE orderby=0 and (attime='0000-00-00' OR attime > '2017-11-19') 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_mxh`.`shows` AS `Show` WHERE 1 AND `Show`.`showtime2`>"2017-11-20 03:46:57" 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_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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 = '74'111
118SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '俄罗斯经典芭蕾舞剧《天鹅湖》' ORDER BY `Show`.`showtime` DESC LIMIT 1112
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 = '76'113
122SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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 = '11'111
126SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '斯洛伐克国家交响乐团新年音乐会' ORDER BY `Show`.`showtime` DESC LIMIT 1111
129SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1111
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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》' ORDER BY `Show`.`showtime` ASC 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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》' ORDER BY `Show`.`showtime` DESC LIMIT 1111
132SELECT 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 = '77'111
133SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1111
134SELECT `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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '海底小纵队3:惊涛骇浪' ORDER BY `Show`.`showtime` ASC 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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '海底小纵队3:惊涛骇浪' ORDER BY `Show`.`showtime` DESC LIMIT 1111
136SELECT 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 = '83'111
137SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1111
138SELECT `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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' ORDER BY `Show`.`showtime` ASC 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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' ORDER BY `Show`.`showtime` DESC LIMIT 1111
140SELECT 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 = '63'111
141SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' 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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' 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 = '64'111
145SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' 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_mxh`.`shows` AS `Show` LEFT JOIN `eticketing_mxh`.`nodes` AS `Node` ON (`Show`.`node_id` = `Node`.`id`) LEFT JOIN `eticketing_mxh`.`cities` AS `City` ON (`Show`.`city_id` = `City`.`id`) LEFT JOIN `eticketing_mxh`.`categories` AS `Category` ON (`Show`.`category_id` = `Category`.`id`) WHERE `Show`.`active` = 1 AND `Show`.`name` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' ORDER BY `Show`.`showtime` DESC LIMIT 1111
148SELECT 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 = '65'111