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.date>='2024-12-27' AND tmp.date<='2023-04-30')UNION( SELECT '', tt1.toursRegionID as city_id,'5' as theatre_id,d.d as date,'19:00:00' as time,'','','','','','','','','', tt1.code, tt1.name, 'alert' perf_code , '' as perf_name, date_format(d.d, '%e,%M,%W') as date_first, '19:00' as time_column,'', '', '', IF(year(curdate())=year(d.d),'',year(d.d) ) as year, tt1.ves as ves,'','','' FROM `ZD_daily` d LEFT JOIN U_ticketsTmp tt ON tt.date=d.d AND theatre_id=5 LEFT JOIN ticket_theatre tt1 ON tt1.id=5 WHERE d.d>='2024-12-27' AND d.d<='2023-04-30' AND tt.id IS NULL GROUP BY d.d )UNION( SELECT '', tt1.toursRegionID as city_id,'272' as theatre_id,d.d as date,'19:00:00' as time,'','','','','','','','','', tt1.code, tt1.name, 'alert' perf_code , '' as perf_name, date_format(d.d, '%e,%M,%W') as date_first, '19:00' as time_column,'', '', '', IF(year(curdate())=year(d.d),'',year(d.d) ) as year, tt1.ves as ves,'','','' FROM `ZD_daily` d LEFT JOIN U_ticketsTmp tt ON tt.date=d.d AND theatre_id=272 LEFT JOIN ticket_theatre tt1 ON tt1.id=272 WHERE d.d>='2024-12-27' AND d.d<='2023-04-30' AND tt.id IS NULL GROUP BY d.d ) ORDER BY date ASC, ves DESC, time ASC
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





	Theaters - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters

Theaters The Stars of the White Nights 2018

 

Sorry, no events are scheduled for these dates at this venue