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 (1913290,1915451,1917661,1919866,1922062,1924249,1926497,1928738,1930973,1933187,1935386,1937582,1939770,1941948,1944118,1946278,1948426,1950561,1952693,1954822,1956897,1958961,1961014,1963052,1965077,1967100,1969120,1971126,1973137,1975133,2176636,2178240,2179838,2181414,2182985,2184539,2186085,2187624,2362433,2365527,2365654,2368605,2368735,2371675,2371804,2374736,2374862,2377906,2380940,2383969,2386990,2390051,2393111,2396162,2399201,2402219,2405233,2408245,2411244,2414235,2417217,2420225,2423222,2426208,2429190,2432165,2435125,2438080,2441017,2443945,2446868,2449784,2452687,2704182,2707254,2710291,2713330,2716354,2719419,2722493,2725592,2728681,2731766,2734877,2737968,2741050,2744122,2747173,2750203,2753230,2756254,2759267,2762282,2765291,2768281,2771255,3449379,3451518,3453653,3455772,3457895,3460018,3462154,3464281,3466431,3468611,3470779,3472935,3475090,3477242,3479388,3509281,3511395,3513503,3515601,3517689,3519773,3521852,3523923,3525982,3528036,3530095,3532139,3534179,3536220,3538249,3558724,3560735,3562740,3564741,3566759,3568772,3570792,3572798,3574811,3576720,3578622)) 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





	Andrey Kasyanenko (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Andrey Kasyanenko (Dancer)

Andrey Kasyanenko (Dancer)