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.date>='2025-04-27' AND tmp.date<='2023-11-30')UNION( SELECT '', tt1.toursRegionID as city_id,'5' as theatre_id,d.d as date,'19:00:00' as time,'','','','','','','','','', tt1.code, tt1.name, 'alert' perf_code , '' as perf_name, date_format(d.d, '%e,%M,%W') as date_first, '19:00' as time_column,'', '', '', IF(year(curdate())=year(d.d),'',year(d.d) ) as year, tt1.ves as ves,'','','' FROM `ZD_daily` d LEFT JOIN U_ticketsTmp tt ON tt.date=d.d AND theatre_id=5 LEFT JOIN ticket_theatre tt1 ON tt1.id=5 WHERE d.d>='2025-04-27' AND d.d<='2023-11-30' AND tt.id IS NULL GROUP BY d.d )UNION( SELECT '', tt1.toursRegionID as city_id,'272' as theatre_id,d.d as date,'19:00:00' as time,'','','','','','','','','', tt1.code, tt1.name, 'alert' perf_code , '' as perf_name, date_format(d.d, '%e,%M,%W') as date_first, '19:00' as time_column,'', '', '', IF(year(curdate())=year(d.d),'',year(d.d) ) as year, tt1.ves as ves,'','','' FROM `ZD_daily` d LEFT JOIN U_ticketsTmp tt ON tt.date=d.d AND theatre_id=272 LEFT JOIN ticket_theatre tt1 ON tt1.id=272 WHERE d.d>='2025-04-27' AND d.d<='2023-11-30' AND tt.id IS NULL GROUP BY d.d ) ORDER BY date ASC, ves DESC, time ASC
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
Theaters - uVisitRussia
Even in the best venues viewing conditions can vary greatly, especially at the historic buildings, built in 18th-19th centuries. Just looking at the hall plan do not give you an idea of the viewing conditions. Sometimes seats in the same section or even the same box have very different view.
We guarantee that you will receive full view seats only. You can be sure you will got the best ballet or opera experience. We will refund you the money that you paid in full if you will get a limited view seats (but this never happened before)
After the order you will get our 24/7 toll-free telephone support number in Russia. We are available any time to support you in the unlikely event you encounter any difficulties.
We provide theatre tickets for all the cruise ship passengers both in St. Petersburg and in Moscow. We are fully licenced tour operator, accredited by Russian Consular service and have contracts with the Sea Port of St. Petersburg and river ports both in Moscow and St. Petersburg.
If you have any questions, please contact us and we will be happy to assist you.
All the prices on the website are final, with all the taxes included. You will not pay any fees, charges or taxes above the price you see. Most of the delivery options are free, as well as the office pick-up. Nothing else will be added during the checkout.
Most of the theatre tickets are claimed as non-refundable. But with UVisitRussia, you can change or cancel your theatre tickets for any reason up to 2 weeks (14 days) prior to the event date.
Why do you need it ? When you buy tickets in advance, you get best seats and advance booking discounts. So you can buy them when you do not have a specific schedule, even before you booked a hotel or airline tickets.
If your trip dates are changed, or trip is cancelled, or you decided to change your schedule - you just cancel and got all your money back. Or you can change your tickets for any others - another date, another theater or even another city - and keep the same discount. In case you want cheaper tickets - you got the price difference back in full.
And it's easy - you can cancel your order within a minute - just call us or e-mail us. No any paperwork or faxes are needed.
If you have any questions, please contact us and we will be happy to assist you.
Waiting until you arrive in Russia to buy theatre tickets is too risky. Usually most of the seats are sold out several days before the event date, or even several weeks for top theatres like Bolshoi and Mariinsky.
If you by tickets in advance, you get early booking discounts:
23% for bookings made up to 3 months before the event date.
18% for bookings made up to 2 months before the event date.
12% for bookings made up to 1 month before the event date.
Within your category, you got the best seats for the same price - centrally located and front rows. Usually these seats are sold out soon and available for early bookers only.
Later you can cancel or change your tickets for any reason and get a full refund. So no any risk for you, guaranteed.
If you have any questions, please contact us and we will be happy to assist you.
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.
The Stars of the White Nights 2018 
