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 (20105,20108,20111,21592,21595,21598,23046,23049,23052,24499,24503,24507,25984,25988,25991,26464,26473,26481,27912,27929,27939,30445,30449,30452,31946,31950,31953,33453,33456,33461,34926,34930,34935,36495,36498,36503,38051,38056,38061,358804,358807,358809,358813,358817,360707,360710,360712,360716,360721,362604,362607,362610,362614,362619,364491,364495,364497,364501,364506,366372,366375,366378,366382,366386,368254,368257,368259,368263,368268,370128,370131,370133,370137,370142,371995,371998,372001,372005,372009,373856,373859,373861,373865,373870,375706,375709,375711,375715,375720,377547,377550,377552,377556,377560,379381,379384,379386,379390,379394,381212,381215,381217,381221,381225,383037,383040,383042,383046,383050,384855,384858,384861,384865,384869,386667,386671,386673,386677,386681,388484,388487,388489,388493,388497,390291,390295,390297,390301,390305,392092,392096,392098,392102,392106,393891,393894,393897,393901,393905,395686,395689,395692,395696,395700,397475,397478,397481,397485,397489,399260,399263,399265,399270,399274,401032,401035,401038,401042,401046,402797,402800,402803,402807,402811,404556,404559,404563,404567,404571,406311,406314,406317,406321,406325,408062,408065,408069,408073,408077,409806,409809,409813,409817,409821,411547,411551,411554,411558,411563,413309,413312,413315,413319,413325,415060,415063,415066,415070,415074,416802,416805,416808,416812,416816,418543,418546,418549,418553,418557,420279,420282,420285,420289,420293,422009,422011,422014,422018,422022,423738,423741,423743,423747,423751,425461,425464,425466,425470,425474,427168,427171,427174,427178,427182,428866,428868,428871,428875,428879,430559,430561,430564,430568,430572,432266,432268,432271,432275,432279,433970,433972,433975,433979,433983,435665,435667,435670,435674,435679,437354,437355,437358,437362,437366,439030,439033,439037,439038,439042,440694,440697,440701,440704,440706,442345,442348,442352,442356,442360,443982,443984,443987,443991,443995,445610,445613,445617,445621,445625,447232,447235,447239,447243,447247,448841,448844,448848,448852,448856,450438,450441,450444,450448,450453,452029,452032,452035,452039,452044,453619,453622,453625,453629,453634,455205,455208,455211,455215,455219,456783,456786,456789,456793,456797,458355,458358,458361,458365,458369,459919,459922,459926,459930,459934,461474,461477,461481,461485,461489,463022,463025,463028,463032,463036,464574,464577,464580,464584,464588,466121,466124,466127,466131,466135,467661,467664,467668,467672,467676,469366,469369,469373,469377,469381,471081,471084,471087,471091,471095,472630,472632,472636,472640,472644,474171,474173,474176,474180,474186,475751,475753,475756,475760,475766,477328,477331,477333,477338,477343,478902,478905,478910,478911,478916,480469,480471,480475,480478,480483,481222,481224,481228,481232,481237,481966,481969,481972,481977,481981,482703,482706,482709,482714,482718,483438,483440,483443,483447,483453,484183,484184,484187,484192,484196,484932,484935,484936,484940,484945,485675,485678,485682,485683,485687,486405,486408,486412,486416,486419,487126,487129,487133,487137,487141,487840,487843,487844,487848,487853,488552,488555,488559,488563,488564,489264,489267,489271,489275,489276,489971,489974,489978,489982,489983,490671,490674,490678,490682,490686,491366,491369,491373,491377,491378,492051,492054,492058,492062,492063,492734,492737,492741,492745,492746,493416,493419,493423,493427,493428,494092,494095,494098,494103,494107,494761,494764,494767,494772,494776,495422,495425,495429,495433,495437,496071,496074,496077,496080,496085,496709,496712,496715,496719,496724,498179,498182,498185,498189,498193,499641,499644,499647,499651,499655,501096,501099,501102,501106,501110,502543,502546,502549,502554,502557,504028,504030,504033,504037,504042,505505,505508,505511,505516,505521,506976,506978,506981,506985,506989,508448,508450,508453,508457,508461,509917,509921,509924,509928,511380,511384,511388,512837,512842,514319,2298826,2301947,2305074,2308218,2311386,2314549,2317708,2320862,2324009,2327147,2330277,2333388,2336490,2339594,2342684,2345791,2348892,2352021,2355140,2358247,2361351,2364446,2367531,2370605,2373670,2376720,2379758,2382790,2385816,2388884,2391947,2395003,2398046,2401075,2404093,2407107,2410112,2413107,2416094,2419108,2422110,2425101,2428087,2431064,2434031,2436988,2439934,2442869,2445796,2448717,2451627,2454520,2457404,2460283,2463147,2466002,2468880,2471818,2474732,2477675,2480607,2483525,2486433,2489350,2492283,2495207,2498121,2501022,2503910,2506786,2509652,2512514,2515371,2518222,2521065,2523897,2526717,2529530,2532338,2535139,2537934,2540728,2543512,2546285,2549051,2551856,2554652,2557463,2560266,2563055,2565828,2568594,2571428,2574250,2577064,2579873,2582670,2585452,2588223,2590991,2593750,2596501,2599243,2601972,2604688,2607395,2610098,2612792,2615516,2618233,2620940,2623632,2626313,2628994,2631659,2634326,2636972,2639606,2642227,2644836,2647437,2650025,2652604,2655171,2657723,2660257,2662772,2665273,2667760,2670223,2672674,2675105,2677517,2679909,2682285,2684652,2687014,2689369,2691713,2694041,2696402,2696773,2699487,2699857,2702558,2702940,2705634,2706015,2708681,2709062,2711724,2712105,2714755,2715135,2717775,2718156,2720840,2721221,2723948,2724329,2727047,2727428,2730134,2730515,2733233,2733630,2736336,2736733,2739423,2739820,2742500,2742898,2745560,2745958,2748601,2748999,2751630,2752028,2754656,2755055,2757678,2758075,2760699,2761097,2763715,2764112,2767111,2770095,2773068,2776033,2779022,2782003,2785091,2788177,2791247,2794305,2797380,2800442,2803497,2806471,2809427,2812361,2815283,2818266,2821242,2824214,2827190,2830149,2833091,2836018,2838952,2841876,2850450,2863087,2865864,2880933,2883705,2886463,2889198,2891921,2894624,2897313,2900010,2902701,2905285,2907877,2910494,2913092,2915680,2918270,2920843,2923408,2925963,2928499,2931018,2933526,2936026)) 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





	Alexander Lazarev (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Alexander Lazarev (Conductor)

Alexander Lazarev (Conductor)