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 (14688,14695,14725,14728,14753,16138,16143,16177,16180,16205,17748,17753,17787,17790,17815,19161,19184,19186,19211,20627,20629,20654,22111,22112,22137,23565,23566,23591,25028,25029,25054,26770,26773,26825,27657,27665,27758,29098,29101,29160,30976,30977,31002,32487,32488,32518,35516,35545,37144,37149,37155,37170,37187,38695,38697,38702,38718,38737,40144,40146,40156,40167,40189,40211,56429,56528,57787,57887,59857,59957,61925,62024,63977,64079,66027,66126,68072,68172,70114,70214,72151,72251,74181,74281,76199,76299,78209,78309,80215,80315,82214,82313,84207,84306,86192,86291,88170,88269,90138,90237,92096,92195,94045,94148,95998,96097,97937,98036,99866,99965,101787,101886,103695,103795,105695,105717,105721,105740,107589,107611,107615,107634,107704,107710,107937,107996,108063,108075,108134,108144,109475,109498,109502,109521,109591,109597,109823,109883,109950,109962,110021,110031,110130,111352,111375,111379,111398,111468,111474,111700,111760,111827,111839,111898,111908,112007,113221,113244,113249,113267,113338,113344,113570,113630,113697,113709,113768,113778,113877,115082,115105,115110,115128,115199,115205,115431,115491,115558,115569,115629,115639,115738,116958,116981,116986,117004,117075,117081,117307,117367,117434,117445,117505,117515,117614,118832,118856,118861,118879,118950,118956,119182,119242,119309,119320,119380,119390,119489,120705,120727,120732,120749,120821,120827,121053,121113,121180,121191,121251,121261,121360,122570,122592,122598,122615,122687,122693,122924,122979,123048,123057,123117,123127,123226,124428,124450,124456,124473,124545,124551,124782,124837,124906,124915,124975,124985,125084,126277,126299,126305,126322,126394,126400,126631,126686,126755,126764,126824,126834,126933,128117,128139,128145,128161,128234,128240,128471,128526,128595,128604,128664,128674,128773,129946,129968,129974,129990,130063,130069,130300,130355,130424,130433,130493,130503,130602,131775,131797,131803,131819,131892,131898,132129,132184,132253,132262,132322,132332,132431,133608,133630,133636,133652,133725,133731,133962,134017,134086,134095,134155,134165,134264,135433,135455,135460,135477,135549,135555,135787,135842,135911,135920,135980,135990,136089,137254,137276,137281,137297,137370,137376,137608,137663,137732,137741,137801,137811,137910,139071,139094,139099,139115,139188,139194,139426,139481,139550,139559,139618,139629,139728,140881,140904,140909,140925,140998,141003,141235,141291,141359,141369,141428,141439,141538,142682,142705,142710,142726,142798,142804,143036,143092,143160,143170,143229,143240,143339,144472,144495,144500,144516,144588,144594,144825,144882,144950,144960,145019,145030,145129,146252,146275,146280,146296,146368,146374,146605,146662,146730,146740,146799,146810,146909,148023,148046,148051,148067,148139,148145,148376,148433,148501,148511,148570,148581,148678,149803,149808,149824,149896,149902,150134,150190,150259,150269,150328,150339,150436,151553,151558,151574,151646,151652,151884,151940,152009,152019,152078,152089,152186,153292,153298,153314,153387,153393,153464,153625,153681,153750,153760,153819,153830,153927,155027,155043,155117,155123,155195,155355,155411,155481,155491,155550,155561,155658,156764,156838,156844,156916,157076,157132,157201,157212,157271,157282,157379,158475,158549,158555,158627,158786,158843,158912,158923,158982,158992,159090,160201,160275,160281,160353,160511,160569,160638,160649,160708,160718,160816,162002,162008,162080,162238,162296,162365,162376,162435,162445,162543,163731,163738,163821,163992,164047,164116,164127,164186,164197,164295,165473,165479,165563,165733,165788,165857,165868,165927,165938,166035,167204,167210,167294,167464,167519,167588,167599,167658,167669,167766,168925,168931,169014,169183,169240,169309,169320,169379,169390,169487,170636,170642,170726,170895,170952,171021,171032,171091,171102,171199,172340,172346,172430,172600,172657,172726,172737,172796,172806,172904,174034,174040,174128,174294,174351,174420,174431,174490,174500,174598,175718,175724,175812,175978,176038,176104,176118,176174,176186,176282,177391,177397,177485,177651,177711,177777,177791,177847,177859,177957,179054,179060,179147,179313,179374,179440,179454,179510,179522,179620,180707,180713,180800,180966,181027,181093,181107,181163,181175,181274,182359,182366,182447,182618,182674,182742,182754,182810,182822,182921,183999,184006,184088,184259,184315,184383,184395,184451,184463,184562,185630,185637,185719,185890,185945,186014,186026,186082,186094,186193,187252,187259,187342,187511,187567,187636,187648,187704,187716,187815,188871,188954,189123,189178,189248,189260,189316,189328,189427,190554,190723,190777,190848,190860,190917,190928,191027,192143,192312,192366,192437,192448,192506,192517,192616,193721,193893,193947,194018,194029,194087,194098,194197,195268,195271,195650,195653,196032,196035,196480,196664,196739,196766,196827,196841,196878,196900,196912,197012,197792,197976,198053,198080,198143,198157,198194,198216,198228,198328,198391,198421,199109,199293,199370,199397,199460,199474,199511,199533,199545,199645,199708,199738,200426,200610,200687,200714,200777,200791,200828,200850,200862,200962,201025,201055,202108,202292,202369,202396,202459,202473,202510,202532,202544,202644,202707,202737,203780,203964,204040,204068,204131,204145,204182,204204,204216,204316,204378,204409,205453,205639,205713,205741,205806,205822,205908,205919,206018,206085,206116,207151,207337,207411,207438,207504,207520,207606,207617,207716,207782,207814,208839,209025,209099,209125,209192,209207,209294,209304,209404,209470,209502,210502,210687,210764,210789,210858,210875,210958,210970,211070,211134,211165,212193,212271,212301,212344,212348,212368,212385,212445,212477,212492,212603,212668,212698,213729,213806,213836,213879,213884,213905,213921,213982,214017,214031,214142,214207,214238,215264,215342,215372,215415,215420,215441,215457,215518,215553,215567,215678,215743,215774,216795,216873,216903,216946,216951,216972,216988,217049,217084,217098,217209,217274,217305,218324,218402,218432,218475,218479,218501,218517,218578,218612,218627,218738,218803,218834,219847,219925,219955,219998,220002,220023,220040,220101,220135,220150,220261,220326,220357,221366,221443,221474,221517,221521,221542,221559,221620,221654,221669,221780,221845,221876,222880,222957,222988,223031,223035,223056,223073,223134,223168,223183,223294,223359,223389,224389,224466,224497,224540,224544,224565,224582,224643,224677,224692,224802,224868,224898,225893,225973,226007,226051,226055,226076,226093,226154,226188,226203,226313,226379,226409,227399,227478,227512,227556,227560,227581,227598,227659,227693,227708,227819,227884,227914,228898,228976,229011,229055,229059,229080,229097,229158,229192,229207,229317,229383,229413,230883,230961,230996,231040,231044,231065,231082,231143,231177,231192,231302,231368,231398,232877,232956,232991,233035,233039,233060,233077,233138,233172,233187,233297,233363,233393,234866,234946,234980,235025,235029,235050,235067,235128,235163,235177,235287,235353,235383,236857,236931,236964,237010,237014,237038,237052,237116,237148,237162,237272,237338,237368,238832,238905,238939,238984,238988,239012,239026,239090,239122,239136,239246,239312,239342,240798,240871,240905,240950,240953,240978,240992,241056,241088,241102,241212,241278,241308,242759,242832,242867,242911,242914,242939,242953,243017,243049,243063,243173,243239,243269,244716,244789,244824,244868,244872,244898,244912,244976,245009,245022,245133,245200,245230,246670,246743,246778,246825,246830,246851,246865,246929,246961,246974,247085,247152,247182,248617,248690,248725,248772,248777,248798,248812,248876,248908,248921,249032,249099,249129,250559,250639,250669,250716,250721,250742,250756,250820,250852,250868,250976,251043,251073,252543,252622,252653,252699,252704,252725,252739,252803,252835,252851,252959,253026,253056,254515,254596,254627,254673,254678,254699,254712,254777,254809,254825,254933,255000,255031,256560,256591,256638,256642,256664,256682,256742,256773,256790,256900,256964,256996,258521,258552,258598,258603,258624,258638,258702,258734,258750,258868,258938,258968,260487,260519,260565,260569,260591,260604,260669,260700,260717,260835,260905,260936,262447,262478,262525,262529,262551,262564,262629,262660,262677,262795,262864,262896,264414,264445,264491,264496,264517,264530,264595,264627,264643,264761,264831,264862,266374,266405,266451,266456,266477,266490,266555,266587,266603,266721,266791,266822,268326,268357,268403,268408,268429,268441,268506,268538,268554,268672,268742,268773,270267,270298,270344,270348,270370,270382,270447,270478,270495,270613,270683,270714,272206,272237,272283,272286,272309,272321,272386,272417,272434,272552,272622,272653,274139,274170,274215,274219,274242,274259,274277,274319,274350,274367,274487,274555,274586,276073,276104,276149,276153,276176,276193,276211,276253,276284,276301,276421,276489,276520,277996,278029,278075,278079,278101,278118,278138,278180,278211,278228,278348,278416,278447,279873,279906,279952,279955,279978,279994,280014,280057,280088,280105,280225,280293,280324,281741,281774,281819,281823,281846,281862,281882,281925,281956,281973,282093,282161,282192,283600,283633,283677,283682,283705,283721,283741,283784,283816,283832,283952,284019,284051,285457,285489,285534,285539,285562,285578,285598,285641,285673,285689,285809,285876,285908,287311,287344,287389,287393,287416,287433,287453,287496,287528,287544,287663,287730,287762,289186,289234,289239,289261,289276,289295,289338,289371,289386,289508,289575,289606,291025,291072,291075,291098,291115,291132,291177,291208,291225,291364,291461,291500,292921,292968,292971,292994,293011,293028,293073,293105,293121,293260,293357,293397,294810,294856,294859,294882,294900,294917,294962,294994,295010,295149,295246,295285,296690,296736,296739,296763,296780,296797,296842,296874,296890,297029,297126,297165,298565,298610,298614,298635,298652,298672,298715,298748,298764,298903,299002,299041,300481,300484,300507,300523,300542,300585,300619,300634,300774,300873,300913,302371,302375,302398,302416,302433,302478,302510,302526,302666,302763,302802,304253,304256,304277,304297,304317,304360,304392,304408,304548,304645,304684,306179,306182,306203,306222,306245,306292,306324,306340,306480,306577,306616,308103,308106,308131,308146,308169,308216,308248,308264,308404,308501,308540,310021,310024,310048,310065,310086,310134,310166,310182,310322,310419,310458,311938,311943,311963,312000,312048,312080,312096,312236,312333,312372,313846,313852,313872,313908,313957,313989,314004,314145,314242,314281,315751,315757,315777,315813,315862,315894,315909,316050,316147,316186,317649,317655,317675,317711,317760,317792,317807,317948,318045,318084,319545,319565,319601,319650,319682,319697,319838,319935,319974,321444,321480,321529,321561,321576,321717,321814,321853,323314,323350,323399,323431,323444,323587,323684,323723,325209,325245,325294,325326,325341,325492,325589,325628,327107,327148,327194,327224,327241,327395,327497,327536,329008,329044,329093,329125,329140,329298,329395,329434,330935,330984,331016,331030,331191,331288,331327,332821,332870,332902,332915,333077,333174,333213,334696,334745,334777,334790,334952,335049,335088,336562,336611,336643,336656,336818,336915,336954,338428,338477,338509,338525,338695,338795,338835,340311,340358,340389,340407,340601,340725,340765,342235,342282,342313,342331,342396,342530,342649,342689,344155,344204,344237,344255,344320,344454,344573,344613,346071,346120,346153,346171,346236,346376,346496,346536,347978,348027,348061,348078,348143,348284,348403,348443,349917,349951,349968,350033,350173,350293,350334,351798,351829,351846,351911,352047,352173,352213,353673,353707,353724,353788,353928,354049,354090,355545,355580,355597,355661,355800,355929,355973,357423,357457,357474,357538,357678,357806,357850,359332,359364,359381,359445,359585,359713,359757,361231,361263,361280,361344,361485,361614,361658,363121,363153,363170,363237,363372,363505,363548,365004,365037,365052,365119,365256,365388,365431,366884,366915,366934,367001,367135,367269,367311,368762,368791,368810,368876,369014,369145,369188,370632,370664,370679,370746,370883,371016,371059,372528,372543,372610,372748,372880,372923,374384,374401,374465,374603,374735,374778,376228,376245,376313,376447,376580,376623,378063,378081,378148,378283,378415,378458,379896,379914,379981,380116,380248,380291,381724,381742,381809,381944,382076,382119,383544,383561,383630,383770,383898,383941,385359,385377,385445,385579,385713,385756,387184,387253,387393,387521,387564,388996,389064,389199,389332,389375,390796,390864,391004,391133,391176,392596,392664,392804,392932,392976,394459,394594,394727,394770,396250,396391,396519,396562,398035,398176,398304,398347,399811,399949,400082,400124,401581,401721,401850,401894,403339,403477,403610,403653,405096,405236,405366,405410,406848,406989,407118,407162,408595,408736,408865,408909,410335,410476,410605,410648,412102,412243,412372,412415,413859,414000,414129,414173,415602,415743,415872,415916,417341,417481,417612,417657,419081,419223,419352,419397,420814,420954,421085,421128,422684,422815,422859,424277,424287,424308,424408,424540,424583,426001,426022,426124,426254,426299,427721,427822,427953,427997,429415,429517,429647,429691,431103,431205,431358,431405,432806,432909,433060,433108,434606,434758,434806,436299,436452,436499,437983,438135,438182,439651,439803,439850,441305,441460,441507,442951,443102,443149,444581,444732,444778,446200,446354,446400,447812,447968,448016,449416,449570,449618,451007,451162,451210,452597,452752,452800,454185,454340,454388,455765,455920,455967,457323,457338,457371,457387,457394,457400,457494,457541,458904,458938,458953,458960,458966,459061,459107,460461,460494,460509,460515,460525,460617,460664,462042,462057,462064,462072,462165,462212,463594,463609,463616,463623,463717,463764,465140,465157,465163,465171,465265,465311,466682,466699,466706,466713,466807,466854,468379,468397,468404,468411,468511,468557,470082,470098,470105,470113,470216,470265,471633,471648,471656,471664,471767,471816,473190,473197,473204,473309,473357,474770,474777,474784,474889,474938,476347,476354,476361,476466,476515,477919,477925,477933,477970,477982,477993,478041,478090,479492,479498,479499,479539,479552,479559,479611,479661,481057,481066,481105,481117,481128,481808,481849,481866,481869,482587,482604,482613,483324,483338,483347,484063,484077,484089,484814,484828,484840,485559,485573,485585,486297,486311,486323,487021,487035,487047,487738,487750,487762,488450,488464,488473,489163,489178,489186,489887,489895,490589,490597,491288,491296,491984,497338,497342,497368,497369,497399,497402,497410,497423,497431,497473,498802,498806,498837,498838,498863,498867,498874,498888,498895,498936,500258,500260,500293,500294,500318,500323,500330,500344,500350,500391,501712,501715,501747,501748,501772,501777,501784,501798,501804,501845,503237,503238,503264,503269,503273,503290,503297,503334,504718,504719,504743,504750,504755,504769,504774,504816,506190,506191,506217,506222,506225,506241,506246,506287,507660,507661,507688,507691,507697,507712,507718,507759,509130,509131,509150,509155,509162,509166,509181,509187,509227,510594,510595,510612,510621,510625,510631,510645,510651,510690,512049,512050,512067,512077,512079,512085,512100,512106,512146,513496,513497,513518,513523,513527,513535,513548,513556,513596,514989,514994,515001,515002,515019,515027,515066,516453,516457,516464,516470,516483,516490,516530,517906,517911,517918,517924,517937,517943,517983,519358,519361,519368,519381,519387,519427,520800,520803,520809,520823,520829,520869,522239,522246,522260,522266,522306,523675,523689,523697,523740,523808,523831,525108,525116,525157,525226,525250,526517,526525,526567,526637,526658,527921,527929,527971,528042,528062,529332,529374,529445,529466,530732,530774,530845,530866,532170,532240,532259,533550,533624,533647,534987,535058,535081,536412,536483,536505,537843,537912,537934,539266,539338,539359,540681,540754,540775,542116,542186,542207,543557,543631,543649,545101,545119,546555,546573,548011,548029,549461,549483,549495,550904,550926,550937,552340,552362,552373,553764,553786,553798,555181,555202,555214,556588,556609,556621,557991,558011,558023,559388,559408,559420,560780,560801,560813,562167,562187,562199,563549,563569,563582,564939,564952,566302,566312,567661,567669,569012,569025,570362,570373,571709,573091,592419,594048,615936,617584,619222,620853,622476,624090,625715,627331,628936,630532,632121,633705,635278,636838,638391,639930,641460,642982,644493,644522,646000,646028,647524,649015,650510,651991,653467,732014,733000,733985,734968,735946,736039,736921,737016,737889,737984,738849,738944,739802,739897,741773,741868,743749,743844,745718,745813,747680,747778,749664,749758,751646,751740,753628,753722,756504,756603,759374,759473,762241,762340,765104,765203,767960,768059,770809,770908,773653,773751,776490,776588,779323,779421,782159,782256,784992,785088,787820,787916,790644,790740,793464,793560,796271,796372,799078,799179,801879,801982,804677,804780,807469,807573,810256,810360,813037,813141,815813,815917,818584,818688,821347,821452,824103,824208,826852,826957,829596,829701,832339,832441,835071,835176,837800,837908,840527,840635,843250,843358,845995,846103,848731,848839,851462,851570,854195,854301,856929,857030,859650,859752,862367,862469,865074,865176,867769,867871,870556,873239,875922,878609,881293,883979,886654,889320,891982,894637,897290,899940,902582,902623,902644,902690,905210,905256,905278,905320,907827,907873,907894,907940,910441,910487,910508,910554,910573,913052,913098,913116,913164,913183,915684,915729,915749,915795,915815,918387,918433,918453,918499,918519,921080,921126,921144,921192,921212,923758,923802,923828,923872,923891,926496,926520,926565,926583,929213,929233,929280,929299,931921,931940,931989,932006,934629,934649,934696,934713,937334,937353,937400,937418,940065,940083,940130,940149,942782,942807,942848,942867,945487,945512,945553,945572,948189,948214,948255,948274,950895,950920,950961,950980,953618,953660,953680,956307,956353,956370,958984,959029,959047,961639,961684,961701,964324,964340,966960,966976,969592,969608,972220,972236,974840,974856,977452,977468,977477,977483,980059,980075,980084,980090,982651,982667,982677,982681,985237,985255,985262,985269,987861,987879,987886,987893,987929,987932,990480,990498,990505,990512,990548,990551,993091,993108,993116,993122,993161,993165,995719,995726,995733,995770,995773,998313,998321,998328,998365,998368,1000897,1000906,1000912,1000949,1000952,1003478,1003486,1003493,1003530,1003533,1006053,1006061,1006068,1006103,1006106,1008628,1008634,1008670,1008673,1011188,1011193,1011229,1011232,1013772,1013809,1013812,1016372,1016375,1018921,1018925,1021468,1021472,1024013,1024017,1024185,1024199,1024217,1026547,1026551,1026720,1026734,1026752,1029077,1029081,1029250,1029264,1029282,1031602,1031607,1031632,1031647,1031709,1031724,1031781,1031788,1031809,1034105,1034109,1034135,1034150,1034212,1034227,1034284,1034291,1034312,1036599,1036625,1036640,1036702,1036717,1036774,1036780,1036800,1039114,1039129,1039191,1039206,1039263,1039269,1039289,1041578,1041597,1041613,1041674,1041690,1041747,1041753,1041772,1044073,1044089,1044101,1044150,1044166,1044222,1044233,1044248,1044301,1044308,1046540,1046556,1046568,1046617,1046633,1046689,1046700,1046715,1046768,1046775,1048996,1049013,1049025,1049074,1049090,1049146,1049157,1049173,1049225,1049231,1051440,1051455,1051469,1051518,1051534,1051590,1051601,1051617,1051669,1051680,1053885,1053899,1053948,1053964,1054018,1054031,1054046,1054099,1054110,1056312,1056326,1056375,1056391,1056445,1056458,1056473,1056526,1056537,1058734,1058746,1058797,1058813,1058866,1058880,1058895,1058948,1058959,1061143,1061155,1061205,1061222,1061274,1061289,1061304,1061357,1061366,1063556,1063605,1063623,1063675,1063690,1063705,1063758,1063767,1065949,1065999,1066017,1066069,1066084,1066099,1066152,1066161,1068331,1068385,1068399,1068457,1068466,1068481,1068534,1068542,1070755,1070767,1070827,1070836,1070851,1070904,1070912,1073155,1073167,1073227,1073236,1073251,1073304,1073312,1075547,1075560,1075619,1075629,1075644,1075697,1075704,1077930,1077943,1078001,1078012,1078028,1078079,1078087,1080301,1080314,1080372,1080383,1080399,1080450,1080457,1082660,1082673,1082731,1082743,1082759,1082810,1082817,1085005,1085018,1085076,1085088,1085104,1085155,1085162,1087333,1087347,1087405,1087416,1087433,1087484,1087491,1089653,1089666,1089725,1089735,1089753,1089803,1089810,1091983,1091996,1092055,1092065,1092084,1092133,1092140,1094318,1094377,1094387,1094406,1094455,1094462,1096628,1096687,1096697,1096717,1096765,1096772,1098925,1098981,1098993,1099012,1099061,1099074,1101258,1101270,1101291,1101339,1101351,1103529,1103541,1103562,1103610,1103622,1105779,1105791,1105811,1105860,1105872,1108006,1108019,1108039,1108088,1108099,1110218,1110226,1110246,1110296,1110306,1112404,1112411,1112430,1112482,1112493,1114571,1114579,1114601,1114651,1114660,1116726,1116735,1116749,1116800,1116814,1118868,1118889,1118939,1118948,1121001,1121015,1121066,1121080,1123138,1123160,1123209,1123219,1125292,1125342,1125349,1127484,1127533,1127539,1129704,1129754,1129765,1131958,1131969,1134151,1134160,1136355,1136364,1138557,1138563,1140755,1140761,1142945,1142952,1145128,1145134,1147298,1147304,1149455,1149460,1151608,1151613,1153752,1153766,1155896,1155901,1158074,1160239,1915675,1917886,1920086,1922285,1924475,1926723,1928965,1931194,1933408,1935607,1937803,1939991,1942170,1944341,1946501,1948650,1950785,1952917,1955044,1957120,1959184,1961233,1963271,1965299,1967320,1969338,1971350,1973361,1975357,1977343,1979314,1981312,1983304,1985289,1987267,1989237,1991193,1993131,1995069,1996999,1998919,2000833,2002736,2004629,2006502,2008390,2010275,2012152,2014016,2015856,2017684,2019493,2021300,2023101,2024895,2026887,2028877,2030856,2032822,2034780,2036736,2038681,2040619,2042545,2044455,2046354,2048242,2050125,2051998,2053861,2055812,2057848,2059881,2061908)) 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





	Edward Tsanga (Bass-baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Edward Tsanga (Bass-baritone)

Edward Tsanga (Bass-baritone)

Honoured Artist of the Republic of Komi.
Prize-winner at the IV International Rimsky-Korsakov Young Opera Singers? Competition (St Petersburg, 2000).
Prize-winner at the International Boris Christov Competition (special audience prize).
Prize-winner at the International Elena Obraztsova Competition (2nd prize).
Prize-winner at the International Lisitsian Competition (Vladikavkaz, 2003).
Prize-winner at the International Placido Domingo Operalia Competition (2003).
Honoured Artist of the Republic of Komi.
Prize-winner at the IV International Rimsky-Korsakov Young Opera Singers? Competition (St Petersburg, 2000).
Prize-winner at the International Boris Christov Competition (special audience prize).
Prize-winner at the International Elena Obraztsova Competition (2nd prize).
Prize-winner at the International Lisitsian Competition (Vladikavkaz, 2003).
Prize-winner at the International Placido Domingo Operalia Competition (2003).

Entered the Nizhny Novgorod Glinka Conservatoire in 1998 (class of Professor Sedov).

Soloist with the Mariinsky Academy of Young Singers since 2000.

Repertoire includes:
Ruslan (Ruslan and Lyudmila);
Kichiga (The Enchantress);
General Polkan (The Golden Cockerel);
Father Frost (The Snow Maiden);
Jester (The Tale of Tsar Saltan);
Creon (Oedipus Rex);
Newspaper Official (The Nose);
Raimondo (Lucia di Lammermoor);
Lord Sidney (Il viaggio a Reims);
Colline (La boheme);
Mandarin (Turandot);
Abimelech (Samson et Dalila);
Figaro (Le nozze di Figaro);
Don Giovanni (Don Giovanni)
and Donner (Das Rheingold).

© State Academic Mariinkiy Opera and Ballet theatre