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 (3114106,3114151,3115632,3115678,3117150,3117196,3118664,3118706,3120170,3120216,3121672,3121718,3123230,3123313,3124922,3125005,3126602,3126685,3128272,3128355,3129931,3130014,3131583,3131666,3133227,3133310,3134863,3134946,3136499,3136582,3138124,3138207,3139740,3139823,3141349,3141432,3142949,3143032,3144543,3144626,3146128,3146211,3150205,3150288,3151749,3151832,3153286,3153369,3154814,3154897,3156334,3156417,3157846,3157929,3159346,3159429,3160835,3160918,3162317,3162400,3163793,3163876,3165260,3165343,3166742,3166825,3168139,3168222,3169526,3169609,3170906,3170989,3172280,3172363,3173648,3173731,3175008,3175091,3176409,3176492,3177805,3177888,3179279,3179362,3180749,3180832,3182216,3182299,3183677,3183760,3185140,3185223,3186598,3186681,3188052,3188135,3189499,3189582,3190942,3191025,3192381,3192464,3194074,3194157,3195761,3195844,3197544,3197627,3199514,3199597,3201215,3201298,3202909,3202992,3204601,3204684,3206289,3206373,3208055,3209729,3211399,3213108,3214808,3216502,3218193,3219877,3221552,3223224,3224859,3226481,3228095,3229710,3231327,3232940,3234542)) 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





	Elena Guseva (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Elena Guseva (Soprano)

Elena Guseva (Soprano)