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 (234059,234066,234073,236047,236053,236061,238027,238033,238041,239997,240003,240010,241960,241966,241973,243920,243926,243933,245878,245884,245891,247828,247834,247841,249774,249780,249787,251716,251723,251730,253696,253703,253710,255668,255675,255682,257632,257639,257646,259603,259610,259617,261568,261575,261582,263526,263532,263540,265490,265496,265504,267446,267452,267460,269393,269399,269407,271333,271339,271347,273271,273277,273285,275208,275215,277138,277145,279067,280940,288636,288640,288643,290478,290482,290485,292379,292383,292386,294273,294277,294280,296160,296164,296167,298039,298043,298046,299914,299918,299921,301809,301813,301816,303697,303701,303704,305628,305632,305635,307558,307562,307565,309481,309485,309488,311399,311403,311406,313313,313317,313320,315221,315225,315228,317123,317127,317130,319017,319021,319024,320901,320905,320908,322777,322781,322784,324645,324649,324653,326549,326553,326557,328453,328457,328461,330349,330353,330357,332241,332245,332248,334122,334126,334129,335993,335997,336000,337858,337862,337865,339738,339742,339745,341666,341670,341673,343590,343594,343597,345510,345514,345517,347429,347433,347436,349331,349335,349339,351217,351221,351225,353095,353099,353103,354971,354975,354979,356851,356855,356859,358725,358730,358734,360628,360632,360637,362525,362529,362534,364414,364418,364422,366295,366299,366303,368174,368179,368183,370050,370054,370058,371918,371922,371926,373777,373781,373786,375627,375631,375636,377468,377472,377477,379302,379306,379311,381134,381137,381142,382959,382963,382967,384778,384782,384786,386590,386594,386598,388394,388398,388402,390202,390206,390210,392002,392006,392010,393801,393805,393809,395596,395600,395604,397385,397389,397393,399167,399172,399176,400942,400946,400950,402707,402711,402715,404465,404469,404473,406221,406225,406229,407972,407976,407980,409716,409720,409724,411454,411458,411463,413216,413220,413225,414967,414971,414976,416709,416713,416718,418450,418454,418459,420186,420190,420195,421916,421920,421925,423645,423649,423654,425367,425371,425376,427075,427079,427084,428773,428777,428782,430466,430470,430475,432173,432177,432182,433877,433881,433886,435572,435577,435581,437261,437264,437269,438937,438941,438945,440601,440605,440609,442251,442256,442260,443889,443893,443898,445516,445521,445525,447138,447143,447147,448747,448752,448756,450344,450349,450353,451935,451940,451944,453525,453530,453534,455116,455120,456694,456698,458270,459834,2880973,2880983,2880985,2880995,2883745,2883755,2883757,2883767,2886503,2886513,2886515,2886525,2889238,2889248,2889250,2889260,2891961,2891971,2891973,2891983,2894664,2894674,2894676,2894686,2897353,2897363,2897365,2897375,2900050,2900060,2900062,2900072,2902741,2902751,2902753,2902763,2905325,2905335,2905337,2905347,2907917,2907927,2907929,2907939,2910534,2910544,2910546,2910556,2913132,2913142,2913144,2913154,2915720,2915730,2915732,2915742,2918310,2918320,2918322,2918332,2920883,2920893,2920895,2920905,2923448,2923458,2923460,2923470,2926003,2926013,2926015,2926025,2928539,2928549,2928551,2928561,2931058,2931068,2931070,2931080,2933566,2933576,2933578,2933588,2936066,2936076,2936078,2936088,2938574,2938584,2938586,2938596,2941077,2941087,2941089,2941099,2943571,2943581,2943583,2943593,2946049,2946059,2946061,2946071,2948511,2948521,2948523,2948533,2950958,2950968,2950970,2950980,2953405,2953415,2953417,2953427,2955904,2955906,2955916,2958387,2958389,2958399,2960858,2960868)) 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





	Sergei Romanovsky (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Sergei Romanovsky (Tenor)
			

																
Sergei Romanovsky (Tenor)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy