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 (3341500,3341620,3341690,3343837,3343956,3344027,3346193,3346312,3346384,3348545,3348665,3348736,3350879,3351001,3351074,3353204,3353327,3353398,3355522,3355645,3355717,3357754,3357765,3357855,3357979,3358038,3358064,3360100,3360108,3360200,3360324,3360382,3360412,3362461,3362470,3362558,3362685,3362745,3362772,3364817,3364822,3364916,3365042,3365099,3365125,3367156,3367164,3367256,3367382,3367438,3367465,3369486,3369494,3369585,3369710,3369771,3369797,3371812,3371822,3371909,3372036,3372097,3372122,3374130,3374141,3374228,3374354,3374415,3374441,3376441,3376449,3376537,3376664,3376724,3376752,3378748,3378758,3378846,3378973,3379033,3379058,3381045,3381056,3381141,3381269,3381327,3381355,3383314,3383323,3383411,3383538,3383598,3383624,3385602,3385607,3385695,3385821,3385884,3385907,3387870,3387875,3387966,3388089,3388152,3388175,3390137,3390226,3390351,3390408,3390435,3392388,3392476,3392601,3392659,3392686,3394712,3394839,3394899,3394926,3396936,3397062,3397120,3397145,3399151,3399276,3399336,3399363,3401349,3401478,3401536,3401563,3403542,3403667,3403729,3403755,3405722,3405847,3405910,3405934,3407890,3408018,3408077,3408101,3410056,3410183,3410241,3410266,3412198,3412325,3412383,3412412,3414366,3414494,3414556,3414580,3414663,3414687,3416516,3416643,3416702,3416727,3416809,3416833,3418657,3418783,3418844,3418868,3418951,3418974,3420776,3420903,3420962,3420992,3421074,3421096,3422881,3423006,3423066,3423091,3423177,3423196,3424960,3425088,3425146,3425172,3425256,3425278,3427020,3427145,3427204,3427231,3427317,3427338,3429190,3429249,3429275,3429357,3429379,3431213,3431273,3431302,3431384,3431406,3433222,3433282,3433311,3433395,3433414,3435229,3435290,3435313,3435396,3435417,3437225,3437285,3437308,3437394,3437416,3439203,3439265,3439290,3439372,3439393,3441168,3441230,3441256,3441340,3441359,3443134,3443193,3443216,3443300,3443324,3445107,3445168,3445194,3445277,3445297,3447262,3447322,3447345,3447429,3447452,3449407,3449466,3449495,3449576,3449598,3451547,3451608,3451632,3451716,3451737,3453681,3453738,3453762,3453845,3453871,3455800,3455858,3455882,3455965,3455991,3457924,3457981,3458008,3458089,3458116,3460048,3460109,3460132,3460217,3460239,3462184,3462245,3462270,3462351,3462374,3464309,3464369,3464396,3464475,3464502,3466459,3466517,3466546,3466625,3466652,3468639,3468698,3468725,3468808,3468830,3470806,3470864,3470893,3470973,3470999,3472962,3473024,3473049,3473128,3473152,3475120,3475180,3475204,3475284,3475308,3477271,3477330,3477358,3477439,3477462,3479419,3479476,3479505,3479585,3479607,3481556,3481613,3481642,3481718,3481741,3483689,3483746,3483775,3483852,3483875,3485809,3485867,3485893,3485972,3485998,3487921,3487980,3488007,3488083,3488106,3490028,3490086,3490113,3490193,3490216,3492160,3492219,3492243,3492320,3492343,3494281,3494339,3494366,3494444,3494468,3496454,3496481,3496560,3496582,3498608,3498635,3498713,3498733,3500751,3500780,3500857,3500879,3502888,3502915,3502992,3503012,3505019,3505046,3505123,3505143,3507145,3507167,3507248,3507269,3509262,3509289,3509369,3509391,3511377,3511405,3511482,3511503,3513483,3513512,3513589,3513613,3515584,3515607,3515684,3515711,3517669,3517697,3517776,3517799,3519757,3519782,3519859,3519882,3521834,3521862,3521939,3521961,3523904,3523931,3524010,3524030,3525967,3525989,3526068,3526093,3528019,3528045,3528119,3528143,3530104,3530179,3530206,3532146,3532226,3532251,3534186,3534266,3534290,3536227,3536303,3536330,3538256,3538335,3538357,3540281,3540357,3540382,3542348,3542430,3542453,3544483,3544508,3546525,3546550,3548564,3548588,3550594,3550617,3552634,3552661,3554668,3554693,3556710,3556734,3558733,3558759,3560747,3560768,3562749,3562773,3564753,3564774,3566768,3566794,3568781,3568806,3570800,3570822,3572810,3572833,3574823,3574844,3576731,3576752,3578630,3578656,3580530,3580554,3582426,3582444,3584286,3584303,3586161,3588014,3589868,3591714,3593561,3595513)) 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





	Sergei Aleksashkin (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Sergei Aleksashkin (Bass)

Sergei Aleksashkin (Bass)