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 (712324,713456,714577,715686,716784,717872,718950,720016,721071,722129,723191,724243,725286,726319,727344,728361,729368,730368,731360,732347,733341,734328,735307,736274,737246,738210,739165,740115,742084,744057,746021,747983,749965,751947,754826,757699,760565,763428,766287,769139,771985,774825,777660,780491,783326,786156,788982,791803,794622,797431,800236,803038,805832,3518351,3518355,3520441,3549466,3549482,3551508,3551522,3553545,3553559,3555586,3555600,3557616,3557630,3559634,3559648,3561643,3561657,3563646,3563660,3565666,3565680,3567682,3567696,3569705,3569719,3571713,3571730,3573733,3573750,3575641,3575658,3577548,3577565,3579451,3579468,3581350,3581367,3583209,3583226,3585069,3585086,3586926,3586943,3588780,3588797,3590632,3590649,3592481,3592498,3594432,3594449,3596428,3596445,3598410,3598427,3600377,3600394,3602329,3602346,3604272,3604289,3606203,3606220,3608126,3608143,3610039,3610056,3611940,3611957,3613869,3613886,3615786,3615803,3617696,3617713,3619600,3619617,3621503,3621520,3623398,3623415,3625281,3625298,3627153,3627170,3629017,3629034,3630877,3630894,3632731,3632748,3634577,3634594,3636416,3636433,3638245,3638262,3640061,3640078,3641867,3641884,3643665,3643682,3645455,3645472,3647238,3647255,3649013,3649030,3650775,3650792,3652526,3652543,3654269,3654286,3656005,3656022,3657731,3657748,3659456,3659473,3661187,3661204,3662905,3662922,3664613,3664630,3666315,3666332,3668010,3668027,3669710,3671386,3673057,3674716)) 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





	Mikhail Petrenko (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Mikhail Petrenko (Bass)

Mikhail Petrenko (Bass)