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 (20631,20717,20720,22116,22209,22213,23570,23663,23667,25033,25134,25138,26782,26973,26982,27683,28065,28081,29111,29325,29333,30981,31082,31086,32493,32601,32604,34122,34124,35520,35523,539310,540727,542158,543604,545074,546528,547984,549434,550877,552312,553739,555155,918567,921260,923947,926642,929355,932061,934768,937473,940204,942923,945627,948329,951039,953739,956429,959105,961760,964399,967035,969668,972295,974915,977528,980135,982726,985314,987938,990557,993170,995779,998373,1000957,1003538,1006111,1008678,1011237,1013817,1016379,1018930,1021477,1024022,1026555,1029087,1031612,1034114,1036603,1039092,1041576,2365607,2368687,2371756,2374816,2377860,2380894,2383923,2386942,2390005,2393065,2396117,2399152,2402174,2405189,2408197,2411198,2414189,2417172,2420180,2423172,2426162)) 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





	Stanislav Shvets (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Stanislav Shvets (Bass)

Stanislav Shvets (Bass)