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 (1483402,1484751,1486089,1487418,1488735,1490035,1491325,1492607,1493917,1495218,1496511,1497804,1499102,1500388,1501666,1502940,1504202,1505462,1506711,1507953,1509183,1510410,1511639,1512861,1514084,1515311,1516530,1517742,1518945,1520143,1521338,1522525,1523704,1524876,1526038,1527199,1528351,1529498,1530641,1531780,1532914,1534044,1535170,1536292,1537408,1538548,1539681,1540809,1541931,1543047,1971145,1973156,1975152,1977139,1979109,1981108,1983100,2067966,2069978,2071970,3015956,3016085,3018095,3018224,3018323,3020288,3020416,3020515,3088255,3089889,3091513,3093121,3094722,3096317,3097901,3099480,3101048,3102609,3104153,3105690,3107243,3108785,3110354,3111916,3113463,3114995,3116514,3118029,3119541,3121042,3122575,3124268,3125955,3127629,3129294,3130950,3132597,3134237,3135877,3137510,3139131,3140743,3142347,3143941,3145531,3147111,3147747,3148377,3149001,3149625,3151172,3152711,3154244,3155767,3157283,3158790,3160284,3161769,3163246,3164718,3166181,3167629,3167853,3169023,3169247,3170408,3170632,3171785,3172009,3173156,3173380,3174521,3174744,3175921,3176146,3177319,3177544,3177696,3178709,3178933,3179090,3180181,3180405,3180562,3181649,3181873,3182030,3183115,3183339,3183491,3184578,3184804,3184956,3186039,3186265,3186417,3187496,3187722,3187874,3188947,3189173,3189325,3190390,3190620,3190770,3191831,3192061,3192211,3193269,3193497,3193685,3194959,3195188,3195376,3196745,3196973,3197161,3198718,3198947,3199134,3200687,3200916,3201067,3202384,3202613,3202764,3204079,3204308,3204458,3205770,3205995,3206147,3207455,3207685,3207834,3209136,3209365,3209514,3210810,3211035,3211188,3212528,3212754,3212907,3214230,3214460,3214610,3215924,3216154,3216306,3217620,3217848,3218000,3219306,3219535,3219689,3220985,3221217,3221368,3222883,3223040,3224547,3224706,3226176,3226334,3227795,3227950,3229412,3229567,3231035,3231191,3232650,3232807,3234257,3234416,3235856,3236014,3237440,3237598,3239013,3239168,3240577,3240735,3242182,3242338,3243774,3243929,3245356,3245511,3246956,3247113,3248542,3248699,3250114,3250269,3251677,3251835,3253239,3253438,3254838,3255113,3256847,3257124,3258860,3259135,3260854,3261134,3262836,3263115,3264820,3265095,3266796,3267091,3268782,3269084,3270828,3271176,3272958,3273302,3275068,3275410,3277161,3277505,3279249,3279594,3281384,3281730,3283510,3283857,3285633,3285978,3287783,3288128,3289914,3290262,3292032,3292377,3294136,3294482,3296235,3296582,3298329,3298675,3300413,3300759,3302491,3302835,3304554,3304900,3306600,3306948,3308646,3308995,3310687,3311034,3312721,3313063,3314743,3314773,3314822,3314837,3314882,3315081,3316751,3316783,3316836,3316850,3316890,3317093,3318754,3318785,3318836,3318849,3318894,3319094,3320740,3320772,3320824,3320839,3320881,3321082,3322726,3322759,3322808,3322822,3322864,3323068,3324874,3324907,3324955,3324967,3325015,3325213,3327141,3327176,3327224,3327238,3327284,3327485,3329530,3329563,3329613,3329626,3329669,3329875,3331913,3331945,3331995,3332009,3332048,3332253,3334279,3334311,3334358,3334374,3334415,3334619,3336628,3336660,3336713,3336726,3336767,3336972,3338978,3339012,3339062,3339073,3339115,3339323,3341322,3341352,3341402,3341417,3341461,3341666,3343658,3343690,3343739,3343756,3343798,3344003,3346049,3346099,3346111,3346152,3346357,3348400,3348449,3348462,3348509,3348710,3350737,3350788,3350797,3350846,3351049,3353059,3353109,3353124,3353168,3353371,3355380,3355430,3355440,3355483,3355689,3357710,3357757,3357774,3357815,3358035,3360055,3360104,3360118,3360158,3360378,3362417,3362467,3362478,3362521,3362740,3364769,3364820,3364835,3364877,3365094,3367158,3367171,3367219,3367434,3369491,3369502,3369548,3369765,3371815,3371824,3371873,3372090,3374131,3374146,3374188,3374409,3376446,3376459,3376501,3376720,3378749,3378765,3378807,3379028,3381049,3381059,3381107,3381325,3383316,3383329,3383376,3383593,3385603,3385618,3385658,3385877,3387873,3387881,3387929,3388147,3390131,3390140,3390188,3390198,3390404,3392397,3392437,3392447,3392657,3394633,3394672,3394682,3394895,3396899,3396902,3397114,3399112,3399118,3399331,3401311,3401319,3401531,3403502,3403510,3403724,3405686,3405695,3405904,3407854,3407863,3408072,3410020,3410022,3410236,3412160,3412171,3412381,3414330,3414339,3414551,3416486,3416698,3418625,3418838,3420958,3423060,3425142,3427201,3429246,3431269,3433281,3435285,3437280,3439261,3441224,3443187,3445162,3447316,3449462,3451603,3453732,3455853,3457977,3460104,3462240,3464366,3466514,3468694,3470863,3473019,3475175,3477325,3479471,3481610,3483741,3485865,3487977,3490084,3492211,3494334,3496451,3498603,3500746,3502883,3505014,3507137,3509258,3511372,3513479,3515579,3517667,3519753,3521829,3523899,3525962,3807827,3808203,3808576,3918249,3918923,3919612,3920300,3920978,3921658,3953321,3953935,3954555,3955159,3955767,3956366,3956406,3957032,3957647,3958265,3958884,3959490,3960094,3960697,3961297,3961891,3969973,3970545,3979897,3980480,3981063,3981638,3982211,3982784,3983354,3983926,3984493)) 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





	Dmitry Grigoriev (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Dmitry Grigoriev (Bass)

Dmitry Grigoriev (Bass)