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 (709718,709727,710863,710873,712003,712013,713139,713151,714267,714276,715383,715391,716487,716494,717576,717585,718662,718668,719729,719738,720788,720797,721837,721846,722894,722899,723950,723956,724997,725003,726032,726041,727060,727069,728081,728090,729095,729100,730095,730104,731091,731100,732081,732087,733062,733071,734051,734058,735034,735041,736008,736013,736986,736991,737954,737959,738915,738919,739867,739872,741838,741842,743814,743818,745783,745787,747741,747753,749729,749737,751711,751719,753693,753701,756569,756577,759438,759447,762303,762314,765166,765177,768022,768033,770870,770882,773713,773725,776550,776562,779382,779395,782218,782230,785051,785063,787879,787891,790703,790715,793523,793535,796332,796344,799139,799151,801942,801954,804740,804752,807539,807545,810326,810331,813107,813112,815883,815888,818654,818660,821418,821423,824174,824179,826923,826928,829667,829672,832400,832413,835142,835147,837871,837877,840598,840604,843320,843327,846065,846072,848799,848808,851530,851538,854263,854271,856992,857000,859714,859722,862432,862439,865139,865146,867832,867840,870518,870524,873200,873207,875883,875890,878570,878577,881255,881261,883941,883947,886616,886622,889282,889293,891944,891955,894598,894610,897251,897264,899899,899912,902543,902550,905169,905182,907800,910414,1476712,1478062,1479456,1480835,1482200,1483557,1484905,1486243,1487572,1488889,1490192,1491482,1492788,1494096,1495397,1496692,1497985,1499283,1500568,1501847,1503121,1504383,1505643,1506892,1508134,1509367,1510591,1511820,1513043,1514269,1515497,1516716,1517924,1519126,1520328,1521519,1522706,1523885,1525057,1526222,1527380,1528532,1529679,1530822,1531961,1533095,1534224,1535351,1536472,1537588,1538728,1539861,1540987,1542109,1543227,1544334,1545436,1546528,1547608,1548676,1549737,1550789,1551832,1552877,1553918,1554952,1555972,1556985,1557995,1558998,1559993,1561346,1563041,1564876,1566702,1569339,1572237,1575124,1578001,1580869,1583723,1586563,1589398,1592232,1595048,1597923,1600789,1603643,1606485,1609322,1612152,1614973,1617785,1620585,1913444,1913458,1915604,1915620,1917815,1917831,1920015,1920031,1922214,1922230,1924404,1924418,1926651,1926666,1928892,1928908,1931120,1931137,1933334,1933351,1935533,1935550,1937729,1937745,1939918,1939934,1942097,1942112,1944268,1944283,1946428,1946443,1948576,1948593,1950712,1950730,1952848,1952862,1954971,1954984,1957046,1957060,1959110,1959124,1961165,1961178,1963202,1963216,1965227,1965242,1967251,1967266,1969266,1969280,1971280,1971295,1973287,1973301,1975287,1975302,1977270,1977284,1979244,1979259,1981239,1981253,1983231,1983245,1985219,1985234,1987194,1987208,1989164,1989178,1991118,1991137,1993061,1993076,1994998,1995014,1996927,1996943,1998849,1998864,2000763,2000778,2002666,2002681,2004556,2004572,2006432,2006447,2008317,2008333,2010202,2010218,2012078,2012095,2013946,2013961,2015786,2015801,2017612,2017628,2019423,2019438,2021230,2021245,2023031,2023046,2024824,2024835,2026816,2026831,2028806,2028821,2030785,2030800,2032749,2032761,2034709,2034724,2036675,2038620,2040558)) 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





	Valery Kirianov (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Valery Kirianov (Conductor)
			

																
Valery Kirianov (Conductor)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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