QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.id IN (20038,20051,20054,20222,20233,21473,21486,21488,21525,21538,21540,21709,21721,22979,22992,22994,23163,23175,24431,24444,24447,24619,24631,25916,25929,25932,26104,26116,26303,26351,26361,26717,26738,27715,27778,27785,28233,28260,30377,30390,30393,30565,30577,31869,31883,31886,32081,32094,33376,33389,33392,33583,33595,35053,35066,36621,36634,38179,38192,39646,39659,41036,41049,42447,42460,43831,43845,45188,45202,46537,46551,47880,47894,49217,49231,50549,50563,51873,51887,53190,53204,54503,54517,55810,55824,57177,57191,59252,59266,61321,61335,63382,63396,65434,65448,67481,67495,69527,69541,71567,71581,73614,75639,77653,79662,116765,116767,116772,118643,118645,118650,120516,120518,120523,122386,122388,122393,124249,124251,124256,126104,126106,126111,127949,127951,127956,129785,129787,129792,131614,131616,131621,133447,133449,133454,135276,135278,135283,137099,137101,137106,138919,138921,138926,140733,140735,140740,142538,142540,142546,144334,144336,144342,146119,146121,146127,147894,147896,147902,149662,149664,149669,151418,151420,151425,153164,153166,153171,154900,154902,154907,156627,156629,156634,158343,158345,158350,160051,160053,160059,161774,161776,161782,163495,163497,163503,165242,165244,165249,166978,166980,166985,168705,168707,168712,170421,170424,170430,172129,172131,172136,173829,173831,173836,175520,175522,175527,177199,177201,177206,178868,178870,178875,180527,180529,180534,182178,182180,182185,183822,183824,183829,185460,185462,185467,187088,187090,187095,188706,188708,188713,190313,190315,190320,191908,191910,191915,193492,193494,193499,195078,195081,195086,195460,195463,195468,195842,195845,195850,196224,196227,196232,201852,201855,201860,203530,203533,203538,205202,205205,205210,206906,206909,206914,208600,208603,208608,210259,210261,210266,211825,211829,211834,213358,213362,213367,214896,214900,214905,216429,216432,216438,217960,217964,217969,219485,219489,219494,221006,221010,221015,222523,222527,222532,224035,224039,224044,225543,225547,225552,227051,227055,227060,228554,228558,228563,230052,230055,230060,232036,232039,232044,234030,234033,234038,236018,236021,236026,237998,238001,238006,239968,239971,239976,241931,241934,241939,243891,243893,243899,245849,245852,245857,247802,247807,249748,249753,251695,253675,898995,901639,904275,906900,909514,912127,914764,917474,920172,922858,925558,928275,930989,933699,936409,939143,941867,944580,947283,949993,952698,955392,958076,960737,963384,966021,968656,971288,973911,976526,979140,981738,984326,986954,989576,992191,994804,997403,999991,1002573,1005152,1007722,1010287,1012852,1015425,1017978,1020525,1023073,1025610,1028145,1030677,1033186,1035681,1038174,1040660,1043139,1045611,1048072,1050523,1052959,1055385,1057811,1060221,1062628,1065023,1067413,1069786,1072152,1074548,1076935,1079311,1081677,1084029,1086367,1088690,1091023,1093350,1095665,1097965,1100248,1102520,1104778,1107015,1109233,1111428,1113606,1115764,1117903,1120037,1122171,1124309,1126504,1128723,1130939,1133134,1135322,1137528,1139729,1141923,1144109,1146285,1148449,1150604,1152755,1154901,1157038,1159207,1161361,1163501,1165634,1167770,1169901,1172023,1174137,1176283,1178418,1180546,1182665,1184775,1186886,1188992,1191091,1193179,1195258,1197334,1199400,1201461,1203515,1205564,1207601,1209630,1211670,1213700,1215722,1217731,1219725,1221708,1223684,1225655,1227648,1229662,1231673,1233668,1235656,1237636,1239604,1241560,1243543,1245518,1247478,1249461,1251439,1253420,1255397,2308440,2311608,2314771,2317930,2321084,2324231,2327369,2330499,2333610,2336712,2339816,2342906,2346013,2349114,2352243,2355362,2358469,2361573,2364668,2367753,2370827,2373892,2376942,2379980,2383012,2386038,2389106,2392169,2395225,2398268,2401297,2404315,2407329,2410334,2413329,2416316,2419330,2422332,2425323,2428309,2431286,2434253,2437210,2440156,2443091,2446018,2448939,2451849,2454742,2457626,2460505,2463369,2466224,2469102,2472040,2474954,2477897,2480829,2483747,2486655,2489601,2492534,2495459,2498373,2501274,2504162,2507038,2509904,2512766,2515623,2518474,2521317,2524149,2526969,2529782,2532590,2535391,2538186,2540980,2543764,2546537,2549303,2552108,2554904,2557715,2560518,2563307,2566083,2568889,2571721,2574543,2577357,2580170,2582967,2585749,2588520,2591288,2594047,2596798,2599540,2602269,2604985,2607692,2610395,2613119,2615843,2618560,2621267,2623959,2626640,2629320,2631985,2634652,2637300,2639934,2642555,2645168,2647769,2650357,2652936,2655503,2658055,2660589,2663104,2665605,2668092,2670555,2673006,2675437,2677849,2680241,2682617,2684984,2687343,2689697,2692041,2694369,2696802,2699886,2702969,2706044,2709091,2712134,2715164,2718185,2721250,2724358,2727457,2730544,2733659,2736762,2739849,2742927,2745987,2749028,2752057,2755084,2758104,2761128,2764143,2767142,2770126,2773099,2776064,2779053,2782034,2785122,2788208,2791278,2794336,2797411,2800473,2803528,2806502,2809458,2812392,2815314,2818297,2821273,2824245,2827221,2830180,2833122,2836049,2838983,2841907,2850481,2863118,2865895,2880964,2883736,2886494,2889229,2891952,2894655,2897344,2900041,2902732,2905316,2907908,2910525,2913123,2915711,2918301,2920874,2923439,2925994,2928530,2931049,2933557,2936057,2938565,2941068,2943562,2946040,2948502)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1





	Michail Jurowski (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Michail Jurowski (Conductor)

Michail Jurowski (Conductor)