Размер шрифта: A A A
Цвет сайта: A A A A

About city

We're happy to introduce you an old and beautiful Russian city – gorod, which was founded in 1221 at the confluence of the two great rivers – the Volga and the Oka.
Till the beginning of XX century city used to be called “the pocket of Russia”, due to the well known Trade Fair that gathered merchants from Europe and Asia.
In Soviet times our city was famous for the “Volga” cars, “MIG” planes and hydrofoil ships. At that time it was renamed after a famous Russian writer Maxim Gorky.
The modern city combines the traditions of merchants and the industrial progress. With its scientific, industrial, cultural and educational potential city is recognized as the capital of the Volga Federal District. Here you can enjoy comfortable conditions for business and investment.
Visit our city and open “a Nizhny of your own”! It’s worth seeing boundless trans-Volga territories from the river embankment, walking across the main street Bolshaya Pokrovskaya, exploring the old Kremlin, visiting the outstanding gorod Trade Fair. We’re sure you will fall in love with this wonderful city!

Module: advertising
Class: CAdvBanner
File: /var/www/vhosts/okt-poselenie.ru/httpdocs/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetList
Line: 613
MySQL Query Error: SELECT DISTINCT if (( (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0) and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.ACTIVE='Y') and (B.STATUS_SID='PUBLISHED') and (T.ACTIVE='Y') and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0) and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.ACTIVE='Y') ), 'green', 'red') LAMP, B.*, B.FIRST_SITE_ID, B.FIRST_SITE_ID LID, if(B.SHOW_COUNT<=0,0,round((B.CLICK_COUNT*100)/B.SHOW_COUNT,2)) CTR, DATE_FORMAT(B.DATE_LAST_SHOW, '%d.%m.%Y %H:%i:%s') DATE_LAST_SHOW, DATE_FORMAT(B.DATE_LAST_CLICK, '%d.%m.%Y %H:%i:%s') DATE_LAST_CLICK, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_CREATE, '%d.%m.%Y %H:%i:%s') DATE_CREATE, DATE_FORMAT(B.DATE_MODIFY, '%d.%m.%Y %H:%i:%s') DATE_MODIFY, C.NAME CONTRACT_NAME, T.NAME TYPE_NAME FROM b_adv_banner B INNER JOIN b_adv_type T ON (T.SID = B.TYPE_SID) INNER JOIN b_adv_contract C ON (C.ID = B.CONTRACT_ID) LEFT JOIN b_adv_banner_2_site BS ON (B.ID = BS.BANNER_ID) WHERE (1=1 AND ( if (( (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0) and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.ACTIVE='Y') and (B.STATUS_SID='PUBLISHED') and (T.ACTIVE='Y') and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0) and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.ACTIVE='Y') ), 'green', 'red') = 'green' ) AND ( ( (upper(B.TYPE_SID) like upper('BOTTOM_CARUCEL') and B.TYPE_SID is not null) ) ) AND ( ( (BS.SITE_ID='s1' and BS.SITE_ID is not null) ) ) ) ORDER BY B.ID desc [Incorrect key file for table '/tmp/#sql_4708_0.MYI'; try to repair it]

DB query error.
Please try later.