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 (590693,590753,592314,592374,593953,594013,595658,595719,597355,597416,599042,599102,600717,600778,602399,602459,604070,604131,605733,605794,607387,607448,609032,609093,610681,610743,612365,612427,614042,614104,615709,615771,617365,617423,619006,619068,620639,620701,622267,622324,623885,623947,625514,625576,627135,627197,628746,628808,630346,630408,631939,632001,633526,633588,635104,635166,636671,636733,638229,638291,639775,639835,641311,641373,642834,642896,644351,644413,645864,645923,647366,647428,648861,648923,650360,650422,651848,651910,653329,653391,654801,654863,656262,656324,657713,657775,659168,659230,660610,660671,662043,662105,663467,663529,664884,664946,666294,666356,667734,667793,669163,669225,670604,670666,672036,672098,673460,673522,674871,674933,676273,676335,677665,677725,679078,679140,680479,680541,681871,681933,683253,683315,684625,684687,685977,686039,687317,687379,688624,688686,689923,689985,691209,691271,692485,692547,693753,693812,695007,695069,696246,696308,697472,697534,698685,698747,699887,699949,701081,701143,702277,702343,703469,703535,704650,704716,705814,705880,706964,707030,708103,708169,709230,709296,710383,710449,711531,711597,712669,712742,713802,713873,714922,714995,716031,716104,717129,717202,718217,718290,719295,719368,720361,720434,721416,721489,722474,722547,723536,723609,724588,724661,725631,725704,726664,726737,727690,727763,728707,728780,729714,729787,730714,730787,731706,731779,732693,732766,733687,733760,734674,734747,735653,735726,736620,736693,737592,737665,738556,738629,739514,739585,740466,740534,742433,742502,744407,744475,746372,746440,748337,748422,750319,750404,752301,752386,755183,755265,758056,758138,760922,761004,763783,763871,766642,766730,769497,769580,772343,772425,775183,775265,778018,778100,780850,780934,783682,783771,786515,786599,789341,789425,792163,792247,794976,795054,797785,797864,800588,800669,803389,803472,806186,806266,808974,809055,811756,811837,814535,814616,817309,817390,820076,820157,822836,822919,825587,825668,828334,828420,831075,831161,833814,833900,836546,836629,839275,839361,842000,842086,844718,844800,847456,847539,850189,850278,852918,853007,855648,855738,858373,858463,861093,861183,863806,863894,866507,866595,869198,869285,871883,871970,874567,874656,877245,877336,879929,880020,882608,882700,885292,885383,887964,888051,890627,890718,893287,893377,895946,896036,898596,898683,901241,901330,903877,903964,906501,906588,909116,909203,911729,911815,914366,914452,917076,917164,919774,919859,922461,922545,925160,925246,927852,927939,930565,930652,933272,933361,935981,936069,938704,938785,941428,941509,944141,944228,946846,946926,949549,949640,952253,952340,954948,955039,957630,957724,960292,960384,962938,963030,965577,965668,968212,968303,970843,970935,973466,973558,976083,976172,978696,978786,981294,981384,983883,983973,986510,986599,989131,989221,991746,991838,994356,994446,996954,997044,999543,999631,1002123,1002213,1004704,1004796,1007273,1007365,1009837,1009925,1012388,1012480,1014958,1015049,1017514,1017606,1020061,1020153,1022604,1022694,1025144,1025236,1027675,1027771,1030199,1030294,1032711,1032808,1035206,1035303,1037694,1037788,1040179,1040273,1042750,1045221,1047682,1050133,1052575,1055001,1057427,1059846,1062253,1064648,1067035,1069412,1071773,1074174,1076560,1078936,1081298,1083649,1401596,1401615,1403338,1403357,1405071,1405090,1406795,1406814,1408516,1408535,1410253,1410272,1411980,1411999,1413749,1413768,1415509,1415528,1417257,1417276,1418994,1419013,1420721,1420740,1422438,1422457,1424141,1424160,1425830,1425849,1427504,1427523,1429168,1429187,1430818,1430837,1432458,1432477,1434089,1434108,1434160,1435705,1435724,1435776,1437331,1437359,1437411,1438952,1438980,1439032,1440560,1440588,1440640,1442162,1442190,1442242,1443756,1443785,1443837,1445340,1445369,1445421,1446913,1446942,1446994,1448477,1448506,1448558,1450029,1450058,1450110,1451569,1451598,1451650,1453099,1453128,1453180,1454619,1454648,1454700,1456137,1456171,1456217,1457643,1457678,1457722,1459135,1459170,1459216,1460614,1460649,1460695,1462080,1462115,1462161,1463536,1463571,1463617,1464982,1465017,1465063,1466414,1466449,1466495,1467836,1467871,1467917,1469245,1469280,1469326,1470639,1470674,1470720,1472020,1472055,1472101,1473388,1473423,1473469,1474747,1474782,1474828,1476093,1476128,1476174,1477444,1477479,1477525,1478792,1478827,1478892,1480176,1480211,1480276,1481548,1481583,1481648,1482909,1482944,1483009,1484265,1484300,1484365,1485609,1485644,1485709,1486944,1486979,1487044,1488268,1488303,1488368,1489574,1489609,1489674,1490869,1490904,1490969,1492155,1492190,1492255,1493469,1493504,1493569,1494774,1494809,1494874,1496071,1496106,1496171,1497366,1497401,1497468,1498669,1498704,1498771,1499962,1499997,1500064,1501245,1501280,1501347,1502521,1502556,1502623,1503789,1503824,1503891,1505050,1505085,1505152,1506303,1506338,1506405,1507550,1507585,1507652,1508787,1508822,1508889,1510015,1510050,1510117,1511237,1511272,1511345,1512462,1512497,1512570,1513690,1513725,1513798,1514911,1514946,1515019,1516134,1516169,1516242,1517349,1517384,1517457,1518555,1518590,1518663,1519756,1519793,1519866,1520952,1520989,1521062,1522142,1522179,1522252,1523325,1523362,1523434,1524500,1524537,1524609,1525668,1525705,1525777,1526829,1526866,1526938,1527984,1528021,1528093,1529133,1529170,1529242,1530278,1530315,1530387,1531419,1531456,1531528,1532555,1532591,1532664,1533687,1533723,1533796,1534815,1534851,1534924,1535939,1535975,1536048,1537058,1537094,1537167,1538171,1538207,1538280,1539308,1539344,1539417,1540438,1540474,1540547,1541563,1541599,1541672,1542682,1542718,1542791,1543793,1543829,1543902,1544898,1544934,1545007,1545996,1546032,1546105,1547081,1547117,1547190,1548154,1548190,1548263,1549217,1549253,1549326,1550274,1550311,1550383,1551322,1551359,1551431,1552361,1552398,1552470,1553402,1553439,1553511,1554437,1554474,1554546,1555464,1555501,1555573,1556482,1556519,1556591,1557492,1557529,1557601,1558500,1558537,1558609,1559498,1559535,1559607,1560856,1560893,1560965,1562205,1562242,1562314,1564048,1564085,1564157,1565881,1565918,1565990,1567707,1567742,1567815,1570627,1570662,1570736,1573520,1573555,1573628,1576402,1576439,1576511,1579277,1579312,1579383,1582136,1582173,1582245,1584983,1585020,1585092,1587824,1587859,1587930,1590656,1590693,1590765,1593481,1593518,1593590,1596338,1596375,1596447,1599209,1599246,1599318,1602072,1602106,1602177,1604917,1604954,1605026,1607756,1607792,1607869,1610594,1610629,1610700,1613418,1613454,1613525,1616237,1616269,1616345,1619039,1619076,1619148,1621831,1621866,1621940,1624605,1624642,1624714,1627374,1627411,1627483,1630131,1630168,1630244,1632915,1632991,1635716,1635788,1638544,1638616,1641385,1641457,1644211,1644283,1647025,1647097,1649910,1652779,1655639,1658487,1661324,1664147,1666963,1669766,1672625,1675477,1678323,1681163,1683988,1686805,1689659,1692514,1695281,2342973,2346080,2349181,2352310,2355429,2358536,2361640,2364735,2367820,2370894,2373959,2377009,2380047,2383079,2386105,2389173,2392236,2395292,2398335,2401364,2404382,2407396,2410401,2413396,2416383,2419397,2422399,2425390,2428376,2431353,2434320,2437277,2440223,2443158,2446085,2449006,2451916,2454809,2457693,2460572,2463436,2466291,2469169,2472107,2475021,2477964,2480896,2483814,2486722,2489668,2492601,2495526,2498440,2501341,2504229,2507105,2509971,2512833,2515690,2518541,2521384,2524216,2527036,2529849,2532657,2535458,2538253,2541047,2543831,2546604,2549370,2552175,2554971,2557782,2560585,2563374,2566151,2568957,2571788,2574610,2577424,2580237,2583034,2585816,2588587,2591355,2594114,2596865,2599607,2602336,2605052,2607759,2610462,2613198,2615922,2618639,2621346,2624038,2626719,2629399,2632064,2634731,2637379,2640013,2642634,2645247,2647848,2650436,2653015,2655582,2658134,2660668,2663183,2665684,2668171,2670634,2673085,2675516,2677928,2680320,2682696,2685063,2687425,2689779,2692123,2694451,2696901,2699984,2703064,2706142,2709189,2712232,2715262,2718311,2721383,2724491,2727590,2730677,2733793,2736896,2739983,2743061,2746121,2749162,2752191,2755218,2758238,2761260,2764275,2767274,2770258,2773231,2776196,2779185,2782165,2785253,2788339,2791409,2794467,2797542,2800605,2803660,2806634,2809590,2812524,2815446,2818429,2821405,2824377,2827353,2830312,2833254,2836181,2839115,2842039,2850613,2863247,2866024,2881095,2883867,2886625,2889360,2892083,2894786,2897475,2900172,2902863,2905447,2908039,2910656,2913254,2915842,2918432,2921005,2923570,2926124,2928660,2931179,2933687,2936187,2938695,2941198,2943692,2946170,2948632,2951079,2953526,2956015,2958498,2960967,2963416,2965847,2968266,2970682,2973082,2975471,2977848,2980238,2982614,2984984,2987368,2989746,2992122,2994485,2996835,2999169,3001487,3003803,3006093,3008319,3010505,3012673,3014825,3016969,3465287,3467431,3469604,3471766,3473920,3476076,3478226,3480368,3482500,3484627,3486745,3488855,3490988,3493114,3495234,3497391,3499538,3501678,3503811,3505939,3508062,3510178,3512290,3514392,3516486,3518573,3520659,3522733,3524807,3526863,3528928,3530980,3533022,3535062,3537096,3539122,3541161,3543222,3545270,3547308,3549343,3551385,3553422,3555463,3557493,3559511,3561520,3563520,3565540,3567556,3569579,3571587,3573607,3594288,3596284,3598266,3600233,3602185,3604128,3606059,3607982,3609895,3611796,3613725,3615642)) 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





	Grand Choir the Masters of Choral Singing (Choir) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Grand Choir the Masters of Choral Singing (Choir)

Grand Choir the Masters of Choral Singing (Choir)