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

大剧院临时票务中心地址:梅溪湖国际文化艺术中心大剧院大堂总服务台。咨询电话:0731-89518800/8811
网上售票
孟京辉话剧《我爱XXX》
2017-11-19 14:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
经典原版音乐剧《保镖》THE BODYGUARD THE MUSICAL雪佛兰迈锐宝XL倾情呈现
2017-11-19 14:30
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480   680  
海底小纵队3:惊涛骇浪
2017-12-02 15:00
 梅溪湖文化艺术中心大剧院小剧场
100   180   280   380   480  
海底小纵队3:惊涛骇浪
2017-12-02 19:30
 梅溪湖文化艺术中心大剧院小剧场
100   180   280   380   480  
经典版话剧《暗恋桃花源》
2017-12-02 20:00
 梅溪湖文化艺术中心大剧院大剧场
280   480   680   880   1280  
海底小纵队3:惊涛骇浪
2017-12-03 10:30
 梅溪湖文化艺术中心大剧院小剧场
100   180   280   380   480  
海底小纵队3:惊涛骇浪
2017-12-03 15:00
 梅溪湖文化艺术中心大剧院小剧场
100   180   280   380   480  
经典版话剧《暗恋桃花源》
2017-12-03 20:00
 梅溪湖文化艺术中心大剧院大剧场
280   480   680   880   1280  
孟京辉话剧《两只狗的生活意见》
2017-12-06 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《两只狗的生活意见》
2017-12-07 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《两只狗的生活意见》
2017-12-08 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《两只狗的生活意见》
2017-12-09 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《两只狗的生活意见》
2017-12-10 14:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
《圣诞狂欢秀》
2017-12-11 20:00
 梅溪湖文化艺术中心大剧院大剧场
120   180   280   380   480   680  
《圣诞狂欢秀》
2017-12-12 20:00
 梅溪湖文化艺术中心大剧院大剧场
120   180   280   380   480   680  
《嘻哈包袱铺》
2017-12-13 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480   580  
爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务
2017-12-15 19:30
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480  
爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务
2017-12-16 10:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480  
爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务
2017-12-16 15:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480  
爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务
2017-12-16 19:30
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480  
爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》
2017-12-26 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   580   680   880  
孟京辉话剧《恋爱的犀牛》
2017-12-27 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
爱乐汇·俄罗斯芭蕾国家剧院芭蕾舞《天鹅湖》
2017-12-27 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   580   680   880  
孟京辉话剧《恋爱的犀牛》
2017-12-28 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
美国Pilobolus 影子舞《幻影王国》
2017-12-28 20:00
 梅溪湖文化艺术中心大剧院大剧场
120   180   280   380   480   680  
孟京辉话剧《恋爱的犀牛》
2017-12-29 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
美国Pilobolus 影子舞《幻影王国》
2017-12-29 20:00
 梅溪湖文化艺术中心大剧院大剧场
120   180   280   380   480   680  
孟京辉话剧《恋爱的犀牛》
2017-12-30 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
会员办理
2017-12-31 12:12
 梅溪湖文化艺术中心大剧院大剧场
500  
孟京辉话剧《恋爱的犀牛》
2017-12-31 14:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
话剧《戏台》
2017-12-31 20:00
 梅溪湖文化艺术中心大剧院大剧场
180   280   380   480   680   880   1080  
话剧《戏台》
2018-01-01 20:00
 梅溪湖文化艺术中心大剧院大剧场
180   280   380   480   680   880   1080  
斯洛伐克国家交响乐团新年音乐会
2018-01-02 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480   680  
浪漫辉煌四十年—理查德~克莱德曼全球巡演[长沙站]
2018-01-04 20:00
 梅溪湖文化艺术中心大剧院大剧场
280   480   680   880   1180   1580  
德国汉堡节日交响新年音乐会
2018-01-11 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480   680  
俄罗斯经典芭蕾舞剧《天鹅湖》
2018-01-13 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480  
俄罗斯经典芭蕾舞剧《天鹅湖》
2018-01-14 20:00
 梅溪湖文化艺术中心大剧院大剧场
100   180   280   380   480  
孟京辉话剧《一个陌生女人的来信》
2018-01-31 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《一个陌生女人的来信》
2018-02-01 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《一个陌生女人的来信》
2018-02-02 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《一个陌生女人的来信》
2018-02-03 19:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
孟京辉话剧《一个陌生女人的来信》
2018-02-04 14:30
 梅溪湖文化艺术中心大剧院小剧场
80   180   280   380   480   680  
  友情链接 >>
                           

(default) 135 queries took 271 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 1112
2SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`img_b`, `Show`.`img_m`, `Show`.`img_s`, `Show`.`img_t`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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`.`showtime2`>'2017-11-19 03:44:31' ORDER BY `Show`.`showtime2` asc42423
3SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 33112
4SELECT `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` = 26 AND `Pricelevel`.`active` = 1662
5SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 50112
6SELECT `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` = 43 AND `Pricelevel`.`active` = 1882
7SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 80112
8SELECT `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` = 1552
9SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 83112
10SELECT `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` = 66 AND `Pricelevel`.`active` = 1552
11SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 3112
12SELECT `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` = 1552
13SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 84112
14SELECT `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` = 65 AND `Pricelevel`.`active` = 1552
15SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 81112
16SELECT `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` = 68 AND `Pricelevel`.`active` = 1552
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 = 10112
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` = 7 AND `Pricelevel`.`active` = 1552
19SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 34112
20SELECT `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` = 1662
21SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 35112
22SELECT `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` = 31 AND `Pricelevel`.`active` = 1662
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 = 36112
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` = 28 AND `Pricelevel`.`active` = 1662
25SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 37112
26SELECT `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` = 29 AND `Pricelevel`.`active` = 1662
27SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 38112
28SELECT `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` = 30 AND `Pricelevel`.`active` = 1662
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 = 57112
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` = 49 AND `Pricelevel`.`active` = 1662
31SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 58112
32SELECT `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` = 48 AND `Pricelevel`.`active` = 1662
33SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 71112
34SELECT `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` = 1662
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 = 67112
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` = 52 AND `Pricelevel`.`active` = 1552
37SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 63112
38SELECT `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` = 56 AND `Pricelevel`.`active` = 1552
39SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 64112
40SELECT `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` = 55 AND `Pricelevel`.`active` = 1552
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 = 65112
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` = 54 AND `Pricelevel`.`active` = 1552
43SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 75112
44SELECT `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` = 1772
45SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 39112
46SELECT `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` = 1662
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 = 77112
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` = 57 AND `Pricelevel`.`active` = 1772
49SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 40112
50SELECT `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` = 33 AND `Pricelevel`.`active` = 1662
51SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 59112
52SELECT `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` = 1662
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 = 41112
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` = 34 AND `Pricelevel`.`active` = 1662
55SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 60112
56SELECT `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` = 46 AND `Pricelevel`.`active` = 1662
57SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 42112
58SELECT `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` = 40 AND `Pricelevel`.`active` = 1662
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 = 19112
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` = 16 AND `Pricelevel`.`active` = 1112
61SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 43112
62SELECT `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` = 38 AND `Pricelevel`.`active` = 1662
63SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 8112
64SELECT `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` = 1772
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 = 11112
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` = 6 AND `Pricelevel`.`active` = 1772
67SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 73112
68SELECT `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` = 1662
69SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 55112
70SELECT `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` = 45 AND `Pricelevel`.`active` = 1662
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 = 72112
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` = 62 AND `Pricelevel`.`active` = 1662
73SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 74112
74SELECT `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` = 60 AND `Pricelevel`.`active` = 1552
75SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 76112
76SELECT `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` = 58 AND `Pricelevel`.`active` = 1552
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 = 44112
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` = 36 AND `Pricelevel`.`active` = 1662
79SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 45112
80SELECT `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` = 39 AND `Pricelevel`.`active` = 1662
81SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 46112
82SELECT `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` = 37 AND `Pricelevel`.`active` = 1662
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 = 47112
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` = 41 AND `Pricelevel`.`active` = 1662
85SELECT `Section`.`id` FROM `eticketing_mxh`.`sections` AS `Section` LEFT JOIN `eticketing_mxh`.`shows` AS `Show` ON (`Section`.`show_id` = `Show`.`id`) WHERE show_id = 48112
86SELECT `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` = 35 AND `Pricelevel`.`active` = 1662
87SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
88select distinct showtime_start from shows where showtime_start >= '2017-11-01' and showtime_start <= '2017-11-31' and active = 1 552
89SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
90SELECT `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
91SELECT `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` asc222
92SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`remarks` FROM `eticketing_mxh`.`settings` AS `Setting` WHERE `Setting`.`key` = 'notice' LIMIT 1112
93SELECT `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 6002
94SELECT `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` asc002
95SELECT `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:44:31" and `Show`.`active` = 1 ORDER BY `Show`.`precedence` desc LIMIT 1010102
96SELECT `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
97SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
98SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
99SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '8'112
100SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
101SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
102SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
103SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '74'112
104SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
105SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
106SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
107SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '76'112
108SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
109SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
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` 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
111SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '11'112
112SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
113SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
114SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
115SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '73'112
116SELECT `Node`.`id`, `Node`.`created`, `Node`.`modified`, `Node`.`name`, `Node`.`owner_code`, `Node`.`node_code`, `Node`.`soap_server`, `Node`.`active`, `Node`.`lock` FROM `eticketing_mxh`.`nodes` AS `Node` WHERE `Node`.`id` = 5 LIMIT 1112
117SELECT `Show`.`id`, `Show`.`created`, `Show`.`name`, `Show`.`city_id`, `Show`.`product_code`, `Show`.`venue_code`, `Show`.`venue_name`, `Show`.`node_id`, `Show`.`showcate_id`, `Show`.`category_id`, `Show`.`showtime`, `Show`.`showtime2`, `Show`.`showtime_start`, `Show`.`showtime_end`, `Show`.`product_class`, `Show`.`artist`, `Show`.`genre`, `Show`.`precedence`, `Show`.`phoneticket`, `Show`.`active`, `Show`.`coming_soon`, `Show`.`soap_server`, `Show`.`visa_discount`, `Show`.`notice`, `Show`.`eticket_discount`, `Show`.`ewm_is` FROM `eticketing_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
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_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
119SELECT MIN(price) AS lowest, MAX(price) as highest FROM sections, pricelevels where pricelevels.section_id = sections.id AND pricelevels.active = 1 AND price > 0 AND sections.show_id = '77'112
120SELECT `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
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_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 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_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 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 = '83'112
124SELECT `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
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_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 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_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 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 = '63'112
128SELECT `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
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_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 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_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 1112
131SELECT 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'112
132SELECT `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
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_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 1112
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` = '爱乐汇·2017年豪华亲子舞台剧《超级飞侠》乐迪的秘密任务' ORDER BY `Show`.`showtime` DESC LIMIT 1112
135SELECT 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'112