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 (590287,590655,591908,592275,593547,593914,595254,595620,596951,597317,598635,599003,600313,600679,601994,602360,603666,604032,605327,605696,606983,607349,608628,608994,610266,610642,611950,612326,613627,614003,615294,615670,616946,617326,618591,618967,620224,620600,621851,622227,623470,623846,625080,625475,626701,627096,628312,628707,629912,630307,631505,631900,633092,633487,634670,635065,636237,636632,637795,638190,639339,639736,640877,641272,642402,642796,643919,644313,645432,645824,646937,647327,648432,648822,649931,650321,651419,651809,652900,653290,654372,654762,655833,656223,657284,657674,658739,659129,660180,660571,661614,662004,663038,663428,664455,664845,665865,666255,667303,667695,668736,669124,670177,670565,671609,671997,673033,673421,674444,674832,675846,676234,677238,677626,678618,679039,680019,680440,681411,681832,682793,683214,684165,684586,685524,685938,686864,687278,688190,688585,689489,689884,690775,691170,692051,692446,693318,693714,694573,694968,695812,696207,697038,697433,698251,698646,699453,699848,700647,701042,701834,702233,703026,703425,704207,704606,705377,705770,706527,706920,707666,708059,708794,709186,709912,710329,711060,711477,712198,712615,713330,713748,714451,714868,715560,715977,716658,717075,717746,718163,718824,719241,720307,721362,722420,723482,724534,725577,726610,727636,728653,729660,730660,731652,732639,733633,734620,735599,736566,737538,738502,739460,740410,742378,744351,746316,748277,750259,752241,755120,757993,760859,763721,766580,769434,772280,775120,777954,780786,783619,786451,789277,792098,794910,797719,800524,803324,806121,808909,811692,814471,817245,820012,822771,825526,828272,831013,833752,836481,839213,841938,844655,847397,850130,852859,855589,858314,861034,863746,866446,869135,871819,874504,877184,879868,882548,885232,887900,890566,893226,895884,898532,901179,903814,906438,909053,911665,914302,917012,919710,922396,925096,927790,930503,933209,935918,938637,941361,944073,946776,949477,952184,954876,957560,960220,962867,965505,968137,970769,973392,976007,978620,981221,983810,986437,989059,991672,994284,996882,999469,1002051,1004630,1007199,2305144,2308288,2311456,2314619,2317778,2320932,2324079,2327217,2330347,2333458,2336560,2339664,2342754,2345861,2348962,2352091,2355210,2358317,2361421,2364516,2367601,2370675,2373740,2376790,2379828,2382860,2385886,2388954,2392017,2395073,2398116,2401145,2404163,2407177,2410182,2413177,2416164,2419178,2422180,2425171,2428157,2431134,2434101,2437058,2440004,2442939,2445866,2448787,2451697,2454590,2457474,2460353,2463217,2466072,2468950,2471888,2474802,2477745,2480677,2483595,2486503,2489449,2492382,2495307,2498221,2501122,2504010,2506886,2509752,2512614,2515471,2518322,2521165,2523997,2526817,2529630,2532438,2535239,2538034,2540828,2543612,2546385,2549151,2551956,2554752,2557563,2560366,2563155,2565932,2568703,2571534,2574356,2577170,2579979,2582776,2585558,2588329,2591097,2593856,2596607,2599349,2602078,2604794,2607501,2610204,2612898,2615622,2618339,2621046,2623738,2626419,2629100,2631765,2634432,2637080,2639714,2642335,2644945,2647546,2650134,2652713,2655280,2657832,2660366,2662881,2665382,2667869,2670332,2672783,2675214,2677626,2680018,2682394,2684761,2687123,2689477,2691821,2694149,2696541,2699626,2702704,2705781,2708828,2711871,2714902,2717922,2720987,2724095,2727194,2730281,2733382,2736485,2739572,2742649,2745709,2748750,2751779,2754805,2757825,2760846,2763862,2766861,2769845,2772818,2775783,2778772,2781753,2784841,2787927,2790997,2794055,2797130,2800192,2803247,2806221,2809177,2812111,2815033,2818016,2820992,2823964,2826940,2829899,2832841,2835768,2838702,2841626)) 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





	Vadim Eilenkrig (Soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vadim Eilenkrig (Soloist)

Vadim Eilenkrig (Soloist)