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 (539310,540727,542158,543604,545074,546528,547984,549434,550877,552312,553739,555155,709611,710757,711023,711898,712164,713036,713302,714163,714428,715274,715541,716377,716644,717472,717736,718552,718818,719625,719889,720684,720948,721733,722009,722784,723073,723840,724129,724888,725178,725928,726215,726956,727243,727977,728264,728989,729277,729991,730278,730987,731274,731975,732266,732957,733247,733946,734237,734929,735220,735903,736191,736880,737168,737848,738136,738808,739096,739761,740049,741732,742020,743708,743996,745677,745964,747638,747926,749623,749910,751605,751892,753587,753874,756463,756750,759332,759620,762199,762487,765062,765350,767918,768206,770767,771055,773610,773898,776447,776735,779280,779568,782116,782404,784949,785237,787777,788065,790601,790889,793421,793709,796227,796520,799034,799327,801837,802130,804635,804928,807428,807720,810215,810507,812996,813288,815771,816064,818542,818835,821306,821599,824062,824355,826811,827104,829555,829848,832296,832587,835325,838055,840782,843507,846252,848987,851718,854451,857180,859902,862619,865326,868021,870705,873391,876075,878762,881446,884132,886807,889473,892135,894796,897449,900099,902742,905370,907987,910601,913213,915844,918548,918561,918609,918644,921240,921255,921302,921337,923921,923940,924000,924043,926610,926633,926694,926733,929327,929348,929408,929451,932033,932054,932116,932159,934741,934761,934823,934867,937446,937466,937528,937571,940176,940197,940259,940302,942894,942916,942978,943021,945599,945621,945683,945726,948301,948323,948385,948428,951007,951031,951092,951135,953707,953731,953792,953835,956397,956421,956481,956525,959073,959098,959158,959201,961732,961753,961812,961855,964372,964393,964452,964495,967008,967029,967088,967131,969640,969661,969720,969764,972268,972289,972348,972392,974888,974909,974968,975012,977500,977521,977580,977636,980107,980128,980187,980244,982699,982720,982779,982837,985282,985306,985368,985422,987906,987930,987992,988047,990525,990549,990610,990666,993140,993162,993224,993280,995746,995771,995832,995889,998340,998366,998427,998485,1000924,1000950,1001011,1001068,1003505,1003531,1003592,1003649,1006082,1006104,1006165,1006222,1008649,1008671,1008732,1008789,1011208,1011230,1011290,1011348,1013788,1013810,1013870,1013928,1016348,1016370,1016433,1016489,1018899,1018922,1018982,1019042,1021446,1021469,1021529,1021589,1023991,1024014,1024074,1024134,1026548,1026608,1026669,1029078,1029138,1029199,1031604,1031664,1031725,1034107,1034170,1034228,1036660,1036718,1039149,1039207,1041633,1041691,1044109,1044167,1046576,1046634,1049033,1049091,1051477,1051535,1053907,1053965,1056334,1056392,1058755,1058814,1061164,1061223,1063564,1063624,1065958,1066018,1068340,1068400,1070709,1070768,1073109,1073168,1075561,1077944,1080315,1082674,1085019,1087350,1089667,1091997,1094319,1096631,1098928,1325156,1327032,1328894,1330754,1911029,1911119,1913174,1913262,1913325,1913354,1915332,1915426,1915485,1915518,1917548,1917637,1917699,1917730,1919748,1919835,1919899,1919930,1921945,1922031,1922097,1922129,1924226,1924287,1924319,1926474,1926535,1926567,1928714,1928776,1928808,1930943,1931005,1931037,1933157,1933219,1933251,1935356,1935418,1935448,1937552,1937614,1937644,1939740,1939803,1939832,1941918,1941982,1942011,1944089,1944153,1944182,1946254,1946313,1946342,1948403,1948460,1948496,1950539,1950596,1950632,1952671,1952728,1952764,1954795,1954852,1954886,1956871,1956928,1956962,1958935,1958992,1959026,1960989,1961048,1961080,1963027,1963086,1963117,1965108,1965147,1967133,1967167,1969148,1969187,1971159,1971193,1973166,1973205,1975166,1975200,1977149,1977186,1979123,1979157,1981118,1981154,1983110,1983146,1985098,1985132,1987073,1987108,1989043,1989079,1991034,1992974,1994911,1996840,1998762,2000676,2002580,2176626,2176730,2178237,2178333,2179829,2179932,2181407,2181510,2182977,2183079,2184533,2184630,2186073,2186176,2187723,2189255,2190779,2192296,2193804,2195337,2196861,2198390,2199906,2201425,2202965,2204497,2206019,2207549,2209064,2210567,2362428,2365519,2368601,2371671,3449478,3451617,3453748,3455868,3457993,3460117,3462253,3464380,3466530,3468709,3470877,3473033,3475189,3477342,3479488,3481626,3483758,3485880,3487991,3490098,3492227,3494349,3496466,3498618,3500762,3502897,3505029,3507154,3509274,3511387,3511416,3513496,3513522,3515593,3515620,3517680,3517709,3519766,3519794,3521844,3521873,3523914,3523943,3525975,3526004,3528027,3528055,3530087,3530116,3532132,3532161,3534199,3536240,3538270,3540292,3542362,3544418,3546460,3548497,4051530,4052407,4053282,4054157,4055025,4055888,4056754,4057613,4058467,4059318,4060165,4061012,4061852,4062687,4125937,4126626,4127304,4127985,4128663,4129343,4130013,4130680)) 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





	Boris Stepanov (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Boris Stepanov (Tenor)

Boris Stepanov (Tenor)