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 (1483007,1483014,1484363,1484370,1485707,1485714,1487042,1487049,1488366,1488373,1489672,1489679,1490967,1490974,1492253,1492260,1493567,1493574,1494872,1494879,1496169,1496176,1497466,1497473,1498769,1498776,1500062,1500069,1501345,1501352,1502621,1502628,1503889,1503896,1505150,1505157,1506403,1506410,1507650,1507657,1508887,1508894,1510115,1510122,1511343,1511351,1512568,1512576,1513796,1513804,1515017,1515025,1516240,1516248,1517455,1517463,1518661,1518669,1519864,1519872,1521060,1521068,1522250,1522258,1523432,1523441,1524607,1524616,1525775,1525784,1526936,1526945,1528091,1528100,1529021,1529029,1529240,1529249,1530166,1530174,1530385,1530394,1531307,1531315,1531526,1531535,1532445,1532452,1532662,1532672,1533577,1533584,1533794,1533804,1534705,1534712,1534922,1534932,1535829,1535836,1536046,1536056,1536948,1536955,1537165,1537175,1538061,1538068,1538278,1538288,1539198,1539205,1539415,1539425,1540328,1540335,1540545,1540555,1541453,1541460,1541670,1541680,1542572,1542579,1542789,1542799,1543683,1543690,1543900,1543910,1544788,1544795,1545005,1545015,1545886,1545893,1546103,1546113,1546971,1546978,1547188,1547198,1548044,1548051,1548261,1548271,1549107,1549114,1549324,1549334,1550162,1550170,1550381,1550390,1551210,1551218,1551429,1551438,1552249,1552257,1552468,1552477,1553290,1553298,1553509,1553518,1554325,1554333,1554544,1554553,1555352,1555360,1555571,1555580,1556370,1556378,1556589,1556598,1557380,1557388,1557599,1557608,1558388,1558396,1558607,1558616,1559394,1559605,1559614,1560752,1560963,1560972,1562312,1562321,1564155,1564164,1565988,1565997,1567813,1567819,1570733,1570744,1573626,1573637,1576509,1576518,1579382,1579392,1582243,1582252,1585090,1585099,1587929,1587939,1590763,1590772,1593588,1593597,1596445,1596454,1599316,1599325,1602176,1602186,1605024,1605033,1607863,1607871,1610699,1610709,1613524,1613533,1616339,1616348,1619146,1619155,1621934,1621943,1624712,1624721,1627481,1627490,1630238,1630248,1632985,1632994,1635785,1635794,1638614,1638623,1641455,1641464,1644282,1644292,1647096,1647106,1649907,1649917,1652776,1652786,1655637,1655646,1658485,1658494,1661322,1661331,1664145,1664154,1666955,1666964,1669764,1669773,1672623,1672632,1675475,1675484,1678320,1678330,1681159,1681169,1683986,1683992,1686803,1686812,1689658,1689667,1692512,1692521,1695289,1698048,2323311,2323321,2326449,2326459,2329579,2329589,2332690,2332700,2335792,2335802,2338888,2338898,2341984,2341994,2345101,2348200,2551784,2551790,2554580,2554586,2557391,2557397,2560194,2560200,2562983,2562989,2565756,2565764,2568522,2568530,2571356,2571362,2574178,2574181,2574184,2574193,2576992,2576995,2576998,2577007,2579801,2579804,2579807,2579816,2582598,2582601,2582604,2582613,2585380,2585383,2585386,2585395,2588151,2588154,2588157,2588166,2590919,2590922,2590925,2590934,2593678,2593681,2593684,2593693,2596429,2596432,2596435,2596444,2599171,2599174,2599177,2599186,2601900,2601903,2601906,2601915,2604616,2604619,2604622,2604631,2607323,2607326,2607329,2607338,2610026,2610029,2610032,2610041,2612720,2612723,2612726,2612735,2615444,2615447,2615450,2615459,2618161,2618164,2618167,2618176,2620868,2620871,2620874,2620883,2623560,2623563,2623566,2623575,2626241,2626244,2626247,2626256,2628922,2628925,2628928,2628937,2631587,2631590,2631593,2631602,2634254,2634257,2634260,2634269,2636900,2636903,2636906,2636915,2639534,2639537,2639540,2639549,2642155,2642158,2642161,2642170,2644764,2644767,2644770,2644779,2647365,2647368,2647371,2647380,2649953,2649956,2649959,2649968,2652532,2652535,2652538,2652547,2655099,2655102,2655105,2655114,2657651,2657654,2657657,2657666,2660185,2660188,2660191,2660200,2662700,2662703,2662706,2662715,2665201,2665204,2665207,2665216,2667688,2667691,2667694,2667703,2670151,2670154,2670157,2670166,2672602,2672605,2672608,2672617,2675033,2675036,2675039,2675048,2677445,2677448,2677451,2677460,2679837,2679840,2679843,2679852,2682213,2682216,2682219,2682228,2684580,2684583,2684586,2684595,2686942,2686945,2686948,2686957,2689297,2689300,2689303,2689312,2691641,2691644,2691647,2691656,2693969,2693972,2693975,2693984,2696308,2696312,2696316,2696326,2699391,2699395,2699399,2699409,2702461,2702465,2702469,2702479,2705537,2705541,2705545,2705555,2708584,2708588,2708592,2708602,2711627,2711631,2711635,2711645,2714662,2714666,2714676,2717686,2717696,2720761)) 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





	Rafal Siwek (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Rafal Siwek (Bass)

Rafal Siwek (Bass)

Polish bass Rafal Siwek made his stage debut at the National Opera in Warsaw as Gremin in Eugene Onegin in 2002. Mr.Siwek appears frequently in Italian theatres, where he has sung Colline in La bohème at the Arena di Verona and at Teatro Maggio Musicale Fiorentino, Count Rodolfo in La Sonnambula at Teatro Verdi in Trieste, King Mark in a new production of Tristan und Isolde at Teatro dell’Opera in Rome, Oroveso in Norma at Teatro Comunale in Bologna, Don Basilio in Il Barbiere di Siviglia in the theatres of Bari, Palermo and Piacenza, Timur in Turandot at the Puccini Festival in Torre del Lago. 

Rafal Siwek has distinguished himself as an interpreter of Verdi roles including Filippo II in Don Carlo with Israel Philharmonic Orchestra, conducted by Zubin Mehta and at Teatro Regio in Turin with Semyon Bychkov, Ramfis in Aida under the baton of Lorin Maazel in Sao Paulo and Rio de Janeiro, Zaccaria in Nabucco at the Warsaw Opera, Wurm in Luisa Miller in Valencia under Lorin Maazel, at Teatro Regio in Parma and in Teatro Comunale in Modena, Padre Guardiano in La forza del destino in Lodz Opera (Poland). He sang his first performances of Silva in Ernani at Teatro Massimo Bellini in Catania. 

Rafal Siwek’s career has included Thibaut d’Arc in Tchaikovski’s The Maid of Orleans for his debut at Amsterdam Concertgebouw, Archbishop in Szymanowski’s King Roger at Théâtre du Châtelet in Paris, Commendatore in Don Giovanni at Théâtre Royal de la Monnaie in Brussels, at Lille Opera and at Grand Théâtre de la Ville de Luxembourg. He made his debut at the Bolshoi Opera as Gremin in Eugene Onegin. Other engagements include Giorgio in I Puritani at Lodz Opera, Sparafucile in Rigoletto at the Savonlinna Festival, Timur in Turandot and at Bunka Kaikan in Tokio. Audiences in Warsaw have heard Mr. Siwek as Hunding in Die Walküre with Plcido Domingo, Seneca in L’incoronazione di Poppea, Sarastro in The Magic Flute, Raimondo in Lucia di Lammermoor, Don Basilio in Il Barbiere di Siviglia, Zaccaria in Nabucco, Sparafucile in Rigoletto, Timur in Turandot and in several Polish operas. 

Among his engagements in 2010/11 — 2011/12: 
Berlin State Opera: Don Carlo (Inquisitiore), Opera Rome: Aida (Ramfis), Warsaw Opera: Turandot, Incoronazione di Poppea, Lucia di Lammermoor, Nabucco, Munich State Opera: Aida (Ramfis) and Turandot, Luisa Miller as well as the new production of Siegfried (role debut of Fafner) as well as several concerts. 

Season 2012/13: new production of Fürst Igor at Hamburg State Opera, Don Carlo and Aida at Berlin State Opera, new production of Don Carlo in Warsaw (Filippo), new production of Don Giovanni at Zurich Opera House, Flying Dutchman at Munich State Opera. 
In 2013 he took part in the production of Don Carlo at the Bolshoi Theatre, singing the part of Philip II (conductor Robert Treviño, director Adrian Noble).

Mr.Siwek is also active concert artist. Under the baton of Lorin Maazel he has sung Verdi’s Requiem in Milan, Venice, Casablanca, Busseto as well as Jerusalem and Beethoven’s IX Symphony in Rome, Milan, Brussels and Taormina. He has also worked with Zubin Mehta both at Accademia di Santa Cecilia in Rome singing Verdi’s Requiem and at Teatro Maggio Musicale Fiorentino in a performance of Beethoven’s IX Symphony. Audiences of Verona have heard Mr.Siwek in Rossini’s Stabat Mater conducted by Alberto Zedda. Janek’s Glagolitic Mass he sang at Prague Spring Festival, at Beethoven Festival in Bonn, in Bratislava, Brno and Linz. At the Warsaw Philharmonic he appeared in Verdi’s Requiem, Dvorak’s Stabat Mater, Beethoven’s Missa Solemnis, Rossini’s Petite Messe Solennelle, Mozart’s Coronation Mass and Requiem under Frans Brüggen and Bach’s Mass in B Minor conducted by Helmuth Rilling. In Riga he performed Penderecki’s Credo under the baton of the composer. 

Rafal Siwek has won awards in several international vocal competitions, including 2001 Moniuszko International Competition in Warsaw, 2001 Hans Gabor/Belvedere Competition in Vienna and 2002 Competizione dell’Opera in Dresden.