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 (1399799,1401553,1401560,1403295,1403302,1405028,1405035,1406752,1406759,1408472,1408479,1410209,1410216,1411936,1411943,1413705,1413712,1415465,1415472,1417213,1417221,1418950,1418957,1420677,1420684,1422394,1422401,1424097,1424104,1425786,1425793,1427460,1427467,1429124,1429131,1430774,1430781,1432414,1432421,1434045,1434052,1435661,1435668,1437276,1437283,1438897,1438904,1440505,1440512,1442107,1442114,1443701,1443708,1445285,1445292,1446858,1446865,1448422,1448429,1449974,1449981,1451514,1451521,1453044,1453051,1454564,1454571,1456081,1456089,1457586,1457593,1459078,1459085,1460557,1460564,1462023,1462030,1463479,1463486,1464925,1464932,1466357,1466364,1467779,1467786,1469188,1469195,1470582,1470589,1471963,1471970,1473331,1473338,1474690,1474697,1476036,1476043,1477387,1477394,1478735,1478742,1480119,1480126,1481491,1481498,1482852,1482859,1484208,1484215,1485552,1485559,1486887,1486894,1488211,1488218,1489517,1489524,1490812,1490819,1492098,1492105,1493412,1493419,1494717,1494724,1496014,1496021,1497309,1497316,1498612,1498619,1499905,1499912,1501188,1501195,1502464,1502471,1503732,1503739,1504993,1505000,1506246,1506253,1507493,1507500,1508730,1508737,1509958,1509965,1511180,1511187,1512405,1512412,1513633,1513640,1514854,1514861,1516077,1516084,1517292,1517299,1518498,1518505,1519697,1519704,1520893,1520900,1522083,1522090,1523266,1523273,1524441,1524448,1525609,1525616,1526770,1526777,1527925,1527932,1529074,1529081,1530219,1530226,1531360,1531367,1532496,1532505,1533628,1533637,1534756,1534765,1535880,1535889,1536999,1537008,1538112,1538121,1539249,1539258,1540379,1540388,1541504,1541513,1542623,1542632,1543734,1543743,1544839,1544848,1545937,1545946,1547022,1547031,1548095,1548104,1549158,1549167,1550215,1550222,1551263,1551270,1552302,1552309,1553343,1553350,1554378,1554385,1555405,1555412,1556423,1556430,1557433,1557440,1558441,1558448,1559439,1559446,1560797,1560804,1562146,1562153,1563989,1563996,1565822,1565829,1567647,1567657,1570568,1570577,1573461,1573470,1576343,1576350,1579217,1579226,1582077,1582084,1584924,1584931,1587763,1587774,1590597,1590604,1593422,1593429,1596286,1599157,2283112,2283114,2286258,2286260,2289396,2289398,2292526,2292528,2295647,2295649,2298762,2298764,2301883,2301885,2305010,2305012,2308154,2308156,2311322,2311324,2314485,2314487,2317644,2317646,2320798,2320800,2323945,2323947,2327083,2327085,2330213,2330215,2333324,2333326,2336426,2336428,2339530,2339532,2342620,2342622,2345727,2345729,2348828,2348830,2351957,2351959,2355076,2355078,2358183,2358185,2361287,2361289,2364382,2364384,2367467,2367469,2370541,2370543,2373606,2373608,2376656,2376658,2379694,2379696,2382726,2382728,2385752,2385754,2388794,2388799,2391854,2391859,2394910,2394915,2397953,2397958,2400982,2400987,2404000,2404005,2407014,2407019,2410019,2410024,2413014,2413019,2416001,2416006,2419015,2419020,2422017,2422022,2425008,2425013,2427994,2427999,2430971,2430976,2433938,2433943,2436895,2436900,2439841,2439846,2442777,2442783,2445704,2445710,2448625,2448631,2451535,2451541,2454426,2454432,2457310,2457316,2460189,2460195,2463053,2463059,2465908,2465914,2468786,2468792,2471724,2471730,2474638,2474644,2477581,2477587,2480513,2480519,2483431,2483437,2486339,2486345,2489242,2489248,2492175,2492181,2495099,2495105,2498013,2498019,2500914,2500920,2503802,2503808,2506678,2506684,2509544,2509550,2512405,2512411,2515262,2515268,2518113,2518119,2520956,2520962,2523788,2523794,2526608,2526614,2529421,2529427,2532229,2532235,2535030,2535036,2537825,2537831,2540619,2540625,2543403,2543409,2546176,2546182,2548942,2548948,2551747,2551753,2554543,2554549,2557354,2557360,2560157,2560163,2562946,2562952,2565720,2565726,2568486,2568492,2571319,2571325,2574141,2574147,2576955,2576961,2579764,2579770,2582561,2582567,2585343,2585349,2588114,2588120,2590882,2590888,2593641,2593647,2596392,2596398,2599134,2599140,2601863,2601869,2604579,2604585,2607286,2607292,2609989,2609995,2612683,2612689,2615407,2615413,2618124,2618130,2620831,2620837,2623523,2623529,2626204,2626210,2628885,2628891,2631550,2631556,2634217,2634223,2636863,2636869,2639497,2639503,2642118,2642124,2644727,2644733,2647328,2647334,2649916,2649922,2652495,2652501,2655062,2655068,2657614,2657620,2660148,2660154,2662663,2662669,2665164,2665170,2667651,2667657,2670114,2670120,2672565,2672571,2674996,2675002,2677408,2677414,2679800,2679806,2682176,2682182,2684543,2684549,2686905,2686911,2689260,2689266,2691604,2691610,2693932,2693938,2696268,2699351)) 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





	Pierre-Laurent Aimard (Piano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Pierre-Laurent Aimard (Piano)
			

																
Pierre-Laurent Aimard (Piano)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy