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 (1406914,1406917,1408635,1408638,1410372,1410375,1412099,1412102,1413868,1413871,1415628,1415631,1417375,1417379,1419113,1419116,1420840,1420843,1422557,1422560,1424260,1424263,1425949,1425952,1427623,1427626,1429287,1429290,1430937,1430940,1432577,1432580,1434204,1434207,1435820,1435823,1437455,1437458,1439076,1439079,1440684,1440687,1442286,1442289,1443881,1443884,1445465,1445468,1447038,1447041,1448603,1448606,1450155,1450158,1451695,1451698,1453226,1453229,1454746,1454749,1456258,1456261,1457763,1457766,1459257,1459260,1460736,1460739,1462202,1462205,1463658,1463661,1465104,1465107,1466536,1466539,1467958,1467961,1469367,1469370,1470761,1470764,1472142,1472145,1473510,1473513,1474869,1474872,1476215,1476218,1477566,1477569,1478941,1478945,1480325,1480329,1481697,1481701,1483059,1483063,1484415,1484419,1485759,1485763,1487094,1487098,1488418,1488422,1489724,1489728,1491019,1491023,1492305,1492309,1493619,1493623,1494924,1494928,1496221,1496225,1497517,1497522,1498820,1498825,1500113,1500118,1501396,1501401,1502672,1502677,1503940,1503945,1505201,1505206,1506454,1506459,1507701,1507706,1508938,1508943,1510166,1510171,1511397,1511403,1512622,1512628,1513850,1513856,1515071,1515077,1516294,1516300,1517509,1517515,1518715,1518721,1519918,1519924,1521114,1521120,1522304,1522310,1523485,1523491,1524660,1524666,1525828,1525834,1526989,1526995,1528144,1528150,1529293,1529299,1530438,1530444,1531579,1531585,1532714,1532718,1533846,1533850,1534974,1534978,1536098,1536102,1537217,1537221,1538330,1538334,1539467,1539471,1540597,1540601,1541722,1541726,1542841,1542845,1543952,1543956,1545057,1545061,1546155,1546159,1547240,1547244,1548313,1548317,1549376,1549380,1550434,1550440,1551482,1551488,1552521,1552527,1553562,1553568,1554597,1554603,1555624,1555630,1556642,1556648,1557652,1557658,1558660,1558666,1559658,1559664,1561016,1561022,1562365,1562371,1564208,1564214,1566041,1566047,1567867,1567868,1570788,1570793,1573679,1573684,1576561,1576567,1579434,1579440,1582295,1582301,1585142,1585148,1587981,1587987,1590815,1590821,1593640,1593646,1596497,1596503,1599368,1599374,1602229,1602235,1605076,1605082,1607916,1607921,1610752,1610759,1613577,1613584,1616392,1616397,1619198,1619204,1621990,1621996,1624764,1624770,1627533,1627539,1630291,1630295,1633037,1633041,1635840,1635846,1638666,1638672,1641507,1641513,1644333,1644338,1647148,1647152,1649962,1649968,1652831,1652837,1655689,1655695,1658537,1658543,1661374,1661380,1664197,1664203,1667012,1667017,1669816,1669822,1672675,1672681,1675527,1675533,1678374,1678379,1681212,1681218,1684037,1684042,1686855,1686861,1689711,1689717,1692564,1692570,1695332,1695338,1698091,1698097,1700844,1700850,1703588,1703594,1706328,1706334,1709099,1709105,1711859,1711865,1714643,1714649,1717418,1717424,1720180,1720186,1722929,1722935,1725668,1725674,1728409)) 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





	Ballett Zurich (Ballet company) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Ballett Zurich (Ballet company)
			

																
Ballett Zurich (Ballet company)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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