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 (380997,381000,381003,381004,381008,382822,382825,382828,382829,382833,384644,384647,384648,384652,384690,386459,386460,386464,386503,388268,388307,390115,391915,393714,395509,397298,399080,400854,402619,404380,406133,407884,409628,411369,413131,414882,416624,418365,474107,474109,474111,474113,474118,474119,475687,475689,475691,475693,475698,475699,477264,477266,477268,477271,477275,477276,478838,478839,478841,478843,478849,478850,480405,480406,480408,480411,480416,480417,481157,481159,481161,481164,481168,481169,481902,481903,481905,481907,481912,481913,482639,482640,482642,482644,482649,482650,483375,483377,483379,483384,483385,484119,484121,484126,484127,484870,484875,484876,485618,485619,541504,541507,541511,541512,542953,542958,542961,542962,544432,544435,544439,544440,545898,545903,545906,545907,547352,547357,547360,547361,548807,548811,548814,548815,550256,550261,550264,550265,551697,551702,551705,551706,553130,553134,553137,553138,554551,554556,554559,554560,555963,555968,555971,555972,557369,557373,557377,557378,558769,558773,558777,558778,560166,560170,560174,560175,561560,561564,561565,562951,562952,725328,725330,726361,726363,727386,727388,728403,728405,729410,729412,730410,730412,731402,731404,732389,732391,733383,733385,734370,734372,735349,735351,736316,736318,737288,737290,738252,738254,739209,739210,740160,740161,742128,742129,744101,744102,746066,746067,748023,748024,750005,750006,751987,751988,754866,754867,757739,757740,760605,760606,763469,763474,766328,766333,769180,769181,772026,772027,774866,774867,777705,777706,780532,780533,783367,783372,786197,786198,789023,789024,791845,791846,794664,794669,797473,797478,800282,800283,803079,803084,805874,805879,808663,808668,811446,811451,814225,814230,816999,817004,819770,819771,822525,822530,825277,825282,828023,828028,830764,830769,833503,833508,836235,836240,838965,838970,841690,841695,844409,844414,919684,919690,922370,922376,925071,925078,927763,927770,930476,930483,933181,933189,935890,935898,938605,938611,941329,941335,944041,944047,946744,946752,949451,949460,952152,952158,954850,954859,957528,957535,960189,960195,962836,962843,965474,965481,968106,968113,970744,970753,973366,973375,975976,975984,978590,978597,981188,981193,983778,983783,986404,986410,989026,989033,991646,991655,994258,1381562,1381563,1383378,1383379,1385187,1385188,1386991,1386992,1388785,1388786,1390565,1390566,1392334,1392335,1394094,1394095,1395872,1395873,1397638,1397639,1399395,1399396,1401147,1401148,1402889,1402890,1404622,1404623,1406345,1406346,1408066,1408067,1409790,1409791,1411517,1411518,1413267,1413268,1415027,1415028,1416777,1416778,1418512,1418513,1420239,1420240,1421956,1421957,1423659,1423660,1425348,1425349,1427022,1427023,1428686,1428687,1430336,1430337,1431976,1431977,1433607,1433608,1435223,1435224,1436828,1436829,1463108,1463113,1463120,1463124,1464559,1464566,1464570,1465998,1466002,1467424,1545851,1545856,1546936,1546941,1548009,1548014,1549072,1549077,1550128,1550132,1551180,1783669,1835845,1835849,1838037,2115710,2115712,2117605,2117607,2117615,2119492,2119494,2119502,2121369,2121371,2121379,2123236,2123238,2123246,2125098,2323355,2323363,2323369,2326493,2326501,2326507,2329623,2329631,2329637,2332734,2332742,2332748,2335836,2335844,2335850,2338932,2338940,2338946,2342028,2342036,2342042,2345135,2345143,2345149,2348234,2348242,2348248,2351330,2351338,2351344,2354449,2354457,2354463,2357556,2357564,2357570,2360657,2360665,2360671,2363752,2363760,2363766,2366837,2366845,2366851,2369911,2369919,2369925,2372976,2372984,2372990,2376040,2451047,2453950,2456834,2459713,2462577,2465432,2468309,2471247,2474161,2477104,2509217,2512078,2512082,2514933,2514937,2517783,2517787,2520626,2520630,2523458,2523462,2526278,2526282,2529091,2529095,2531899,2531903,2534700,2534704,2537494,2537498,2540288,2540292,2543072,2543076,2545845,2545849,2548610,2548614,2551415,2551419,2554211,2554215,2557022,2557026,2559823,2559827,2562612,2562616,2562730,2565385,2565390,2565502,2568151,2568156,2568268,2570988,2571102,2573924,2576738,2579539,2582336,2585118,2587889,2590657,2593416,2596167,2598909,2601638,2604354,2607061,2609764,2612458,2615182,2617899,2620606,2623298,2625980,2628661,2754682,2757704,2760725,2763741,2766740,2769724,2772697,2775662,2778651)) 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





	Roman Simachev (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Roman Simachev (Dancer)

Roman Simachev (Dancer)