exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.hot_id' in 'where clause'' in /www/hory.cz/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /www/hory.cz/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /www/hory.cz/lib/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /www/hory.cz/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT h.`pre_i...', Array)
#4 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query('SELECT h.`pre_i...', Array)
#5 /www/hory.cz/app/models/BaseModel.php(85): Zend_Db_Adapter_Abstract->fetchAll('SELECT h.`pre_i...', Array)
#6 /www/hory.cz/app/models/GetHotel.php(2448): BaseModel->fetchAllCached('SELECT h.`pre_i...', Array, 'Model_GetHotel_...', Array)
#7 /www/hory.cz/app/controllers/horycz/HotelController.php(50): Model_GetHotel->getData()
#8 /www/hory.cz/lib/Zend/Controller/Action.php(133): Horycz_HotelController->init()
#9 /www/hory.cz/lib/Zend/Controller/Dispatcher/Standard.php(281): Zend_Controller_Action->__construct(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http), Array)
#10 /www/hory.cz/lib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#11 /www/hory.cz/lib/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
#12 /www/hory.cz/lib/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#13 /www/hory.cz/www/index.php(45): Zend_Application->run()
#14 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.hot_id' in 'where clause', query was: SELECT h.`pre_id`, 
			h.`hot_id`, 
			hp.`hpr_recommended` as projectRecommended, 
			(SELECT SUM(acp.`acc_price` * DATEDIFF(LEAST(s.sea_to, :departure), GREATEST(s.sea_from, :arrival))) AS sum
                    FROM `Season` s
                    LEFT JOIN `AccommodationPrice` acp
                       ON s.`pri_id` = acp.`pri_id`
                          AND acp.`obk_id` = (SELECT o.`obk_id`
                                             FROM `ObjectKind` o

                                                LEFT JOIN `Hotel` hotel
                                                   ON o.`pre_id` = hotel.`pre_id`
                                                      AND o.`hot_id` = hotel.`hot_id`
                                                LEFT JOIN `Season` season
                                                   ON season.`pre_id` = hotel.`pre_id`
                                                      AND season.`hot_id` = hotel.`hot_id`
                                                         AND CURDATE() BETWEEN season.`sea_from` AND season.`sea_to`
                                                LEFT JOIN `AccommodationPrice` ap
                                                   ON season.`pri_id` = ap.`pri_id`
                                                      AND ap.`cur_id` = hotel.`cur_id_default`
                                                         AND IF(1 = hotel.`prm_id`, ap.`acc_occupancy` = o.`obk_numOfBeds`, ap.`acc_occupancy` = 1)
                                                           AND ap.obk_id = o.obk_id
                                              WHERE o.`hot_id` = h.`hot_id`
                                                AND o.`pre_id` = h.`pre_id`
                                                AND o.`obk_numOfBeds` = 2

                                                AND ap.`acc_price` <> 0

                                            ORDER BY ap.`acc_price` ASC

                                            LIMIT 0,1)
                                AND acp.`acc_occupancy` = 2
                  WHERE s.`hot_id` = h.`hot_id`
                    AND s.pre_id = h.`pre_id`
                    AND acp.`cur_id` = h.`cur_id_default`
                    AND
                       ((:arrival BETWEEN s.sea_from AND s.sea_to)
                       OR (:departure BETWEEN s.sea_from AND s.sea_to)
                       OR ((s.sea_from BETWEEN :arrival AND :departure) AND (s.sea_to BETWEEN :arrival AND :departure)))
                     AND
                       IF (s.sea_from < :arrival, s.sea_to > :arrival, TRUE)
                       AND s.sea_from < :departure) as baseDoubleRoom, 
			h.`hot_name`, 
			h.`hot_street`, 
			h.`hot_gpsLatitude`, 
			h.`hot_gpsLongitude`, 
			h.`hot_class`, 
			h.`hot_classConfirmed`, 
			h.`hot_hotelCzTip`, 
			h.`hot_customerTip`, 
			h.`hoy_id`, 
			h.`hot_clientPayment`, 
			h.`hot_onlyWeeks`, 
			h.`hot_partnerCatalog`, 
			h.`hot_importedPartner`, 
			h.`cur_id_default`, 
			h.`cot_id`, 
			h.`reg_id`, 
			h.`hot_arrival`, 
			h.`hot_departure`, 
			h.`hot_email`, 
			h.`hot_phone`, 
			h.`hot_seoName`, 
			h.`hot_onlineReservation`, 
			h.`hot_deactivate`, 
			h.`hot_url`, 
			h.`hot_commission`, 
			h.`hot_adminDescription`, 
			h.`hot_ownerEmail`, 
			t.`tow_id`, 
			t.`tow_seo`, 
			county.`cot_name`, 
			county.`cot_seo`, 
			locality.`lct_name`, 
			locality.`lct_seo`, 
			locality.`lct_id`, 
			IF(tr.`tra_translation` IS NULL, reg.`reg_name`, tr.`tra_translation`) AS reg_name, 
			IF(trtown.`tra_translation` IS NULL, t.`tow_name`, trtown.`tra_translation`) AS tow_name, 
			IF(tr.`tra_seo` IS NULL, reg.`reg_seo`, tr.`tra_seo`) AS reg_seo, 
			h.`hot_city`, 
			z.`zip_zip` AS hot_zip, 
			short.`tra_translation` AS hot_shortDescription, 
			short.`tra_protected` AS hot_shortDescription_protected, 
			longd.`tra_translation` AS hot_longDescription, 
			short.`tra_protected` AS hot_longDescription_protected, 
			cond.`tra_translation` AS hot_conditions, 
			previoshort.`tra_translation` AS previo_hot_shortDescription, 
			previolongd.`tra_translation` AS previo_hot_longDescription, 
			projectshort.`tra_translation` AS project_hot_shortDescription, 
			projectlongd.`tra_translation` AS project_hot_longDescription, 
			transport.`tra_translation` AS hot_transportAccessibility, 
			surroundings.`tra_translation` AS hot_surroundings, 
			roomsDescription.`tra_translation` AS hot_roomsDescription, 
			gastronomy.`tra_translation` AS hot_gastronomy, 
			additionalInfo.`tra_translation` AS hot_additionalInfo, 
			transport_project.`tra_translation` AS project_hot_transportAccessibility, 
			surroundings_project.`tra_translation` AS project_hot_surroundings, 
			roomsDescription_project.`tra_translation` AS project_hot_roomsDescription, 
			gastronomy_project.`tra_translation` AS project_hot_gastronomy, 
			additionalInfo_project.`tra_translation` AS project_hot_additionalInfo, 
			transport_previo.`tra_translation` AS previo_hot_transportAccessibility, 
			surroundings_previo.`tra_translation` AS previo_hot_surroundings, 
			roomsDescription_previo.`tra_translation` AS previo_hot_roomsDescription, 
			gastronomy_previo.`tra_translation` AS previo_hot_gastronomy, 
			additionalInfo_previo.`tra_translation` AS previo_hot_additionalInfo, 
			paf.`pfm_id` as hasFirstMinute, 
			paf.`pfm_distance`, 
			paf.`pfm_discountRate`, 
			pal.`plm_id` as hasLastMinute, 
			pal.`plm_distance`, 
			pal.`plm_discountRate`, 
			pat.`pal_id` as hasLongTerm, 
			pat.`pal_count`, 
			pat.`pal_discountRate`, 
			r.`rat_guestReviews`, 
			ROUND(
                      ((SUM(reviewCount.`rev_staffReview`) 
                      + SUM(reviewCount.`rev_servicesReview`) 
                      + SUM(reviewCount.`rev_cleanReview`) 
                      + SUM(reviewCount.`rev_comfortReview`) 
                      + SUM(reviewCount.`rev_valueReview`)) / 5)
                      / count(reviewCount.`rev_id`), 1)
                      as hot_score, 
			COUNT(DISTINCT(reviewCount.`rev_id`)) as hot_reviewCount, 
			photo.`pho_id` AS photoId, 
			photo.`pho_name` AS photoName, 
			photo.`pho_hdd` AS photoHdd
		 FROM `Hotel` h
			INNER JOIN Hotel_Project hp ON hp.pre_id = h.pre_id AND hp.hot_id = h.hot_id AND hp.pro_id = :proId
			LEFT JOIN Town t ON h.pre_id = t.pre_id AND h.tow_id = t.tow_id
			LEFT JOIN County county ON h.cot_id = county.cot_id AND h.pre_id = county.pre_id
			LEFT JOIN Locality locality ON h.lct_id = locality.lct_id AND h.pre_id = locality.pre_id
			LEFT JOIN Region reg ON h.pre_id = reg.pre_id AND h.reg_id = reg.reg_id
			LEFT JOIN Zip z ON h.pre_id = z.pre_id AND h.zip_id = z.zip_id
			LEFT JOIN Translation tr
                    ON tr.`tra_rowid` = h.`reg_id` 
                      AND tr.pre_id = h.pre_id 
                      AND tr.`tco_id` = '1' 
                      AND tr.`lan_id` = :lanId 
                      AND tr.`pro_id` = 1
			LEFT JOIN Translation trtown
                    ON trtown.`tra_rowid` = h.`tow_id`
                      AND trtown.pre_id = h.pre_id
                      AND trtown.`tco_id` = '23'
                      AND trtown.`lan_id` = :lanId
                      AND trtown.`pro_id` = 1
			LEFT JOIN `Translation` short
                    ON short.`tra_rowid` = h.`hot_id` 
                      AND short.`pre_id` = h.`pre_id` 
                      AND short.`tco_id` = '6' 
                      AND short.`lan_id` = :lanId 
                      AND short.`pro_id` = 1
			LEFT JOIN `Translation` longd
                    ON longd.`tra_rowid` = h.`hot_id` 
                      AND longd.`pre_id` = h.`pre_id` 
                      AND longd.`tco_id` = '7' 
                      AND longd.`lan_id` = :lanId 
                      AND longd.`pro_id` = 1
			LEFT JOIN `Translation` cond
                    ON cond.`tra_rowid` = h.`hot_id`
                      AND cond.`pre_id` = h.`pre_id`
                      AND cond.`tco_id` = '21'
                      AND cond.`lan_id` = :lanId
                      AND cond.`pro_id` = 1
			LEFT JOIN `TranslationApproval` previoshort
                        ON previoshort.`tra_rowid` = h.`hot_id`
                          AND previoshort.`pre_id` = h.`pre_id`
                          AND previoshort.`tco_id` = '6'
                          AND previoshort.`lan_id` = :lanId
                          AND previoshort.`pro_id` = 1
			LEFT JOIN `TranslationApproval` previolongd
                        ON previolongd.`tra_rowid` = h.`hot_id`
                          AND previolongd.`pre_id` = h.`pre_id`
                          AND previolongd.`tco_id` = '7'
                          AND previolongd.`lan_id` = :lanId
                          AND previolongd.`pro_id` = 1
			LEFT JOIN `Translation` projectshort
                        ON projectshort.`tra_rowid` = h.`hot_id`
                          AND projectshort.`pre_id` = h.`pre_id`
                          AND projectshort.`tco_id` = '6'
                          AND projectshort.`lan_id` = :lanId
                          AND projectshort.`pro_id` = :proId
			LEFT JOIN `Translation` projectlongd
                        ON projectlongd.`tra_rowid` = h.`hot_id`
                          AND projectlongd.`pre_id` = h.`pre_id`
                          AND projectlongd.`tco_id` = '7'
                          AND projectlongd.`lan_id` = :lanId
                          AND projectlongd.`pro_id` = :proId
			LEFT JOIN `Translation` transport
                    ON transport.`tra_rowid` = h.`hot_id` 
                      AND transport.`pre_id` = h.`pre_id` 
                      AND transport.`tco_id` = '11' 
                      AND transport.`lan_id` = :lanId 
                      AND transport.`pro_id` = 1
			LEFT JOIN `Translation` surroundings
                    ON surroundings.`tra_rowid` = h.`hot_id` 
                      AND surroundings.`pre_id` = h.`pre_id` 
                      AND surroundings.`tco_id` = '13' 
                      AND surroundings.`lan_id` = :lanId 
                      AND surroundings.`pro_id` = 1
			LEFT JOIN `Translation` roomsDescription
                    ON roomsDescription.`tra_rowid` = h.`hot_id` 
                      AND roomsDescription.`pre_id` = h.`pre_id` 
                      AND roomsDescription.`tco_id` = '15' 
                      AND roomsDescription.`lan_id` = :lanId 
                      AND roomsDescription.`pro_id` = 1
			LEFT JOIN `Translation` gastronomy
                    ON gastronomy.`tra_rowid` = h.`hot_id` 
                      AND gastronomy.`pre_id` = h.`pre_id` 
                      AND gastronomy.`tco_id` = '14' 
                      AND gastronomy.`lan_id` = :lanId 
                      AND gastronomy.`pro_id` = 1
			LEFT JOIN `Translation` additionalInfo
                    ON additionalInfo.`tra_rowid` = h.`hot_id` 
                      AND additionalInfo.`pre_id` = h.`pre_id` 
                      AND additionalInfo.`tco_id` = '12' 
                      AND additionalInfo.`lan_id` = :lanId 
                      AND additionalInfo.`pro_id` = 1
			LEFT JOIN `Translation` transport_project
                    ON transport_project.`tra_rowid` = h.`hot_id`
                      AND transport_project.`pre_id` = h.`pre_id`
                      AND transport_project.`tco_id` = '11'
                      AND transport_project.`lan_id` = :lanId
                      AND transport_project.`pro_id` = :proId
			LEFT JOIN `Translation` surroundings_project
                    ON surroundings_project.`tra_rowid` = h.`hot_id`
                      AND surroundings_project.`pre_id` = h.`pre_id`
                      AND surroundings_project.`tco_id` = '13'
                      AND surroundings_project.`lan_id` = :lanId
                      AND surroundings_project.`pro_id` = :proId
			LEFT JOIN `Translation` roomsDescription_project
                    ON roomsDescription_project.`tra_rowid` = h.`hot_id`
                      AND roomsDescription_project.`pre_id` = h.`pre_id`
                      AND roomsDescription_project.`tco_id` = '15'
                      AND roomsDescription_project.`lan_id` = :lanId
                      AND roomsDescription_project.`pro_id` = :proId
			LEFT JOIN `Translation` gastronomy_project
                    ON gastronomy_project.`tra_rowid` = h.`hot_id`
                      AND gastronomy_project.`pre_id` = h.`pre_id`
                      AND gastronomy_project.`tco_id` = '14'
                      AND gastronomy_project.`lan_id` = :lanId
                      AND gastronomy_project.`pro_id` = :proId
			LEFT JOIN `Translation` additionalInfo_project
                    ON additionalInfo_project.`tra_rowid` = h.`hot_id`
                      AND additionalInfo_project.`pre_id` = h.`pre_id`
                      AND additionalInfo_project.`tco_id` = '12'
                      AND additionalInfo_project.`lan_id` = :lanId
                      AND additionalInfo_project.`pro_id` = :proId
			LEFT JOIN `TranslationApproval` transport_previo
                    ON transport_previo.`tra_rowid` = h.`hot_id`
                      AND transport_previo.`pre_id` = h.`pre_id`
                      AND transport_previo.`tco_id` = '11'
                      AND transport_previo.`lan_id` = :lanId
                      AND transport_previo.`pro_id` = 1
			LEFT JOIN `TranslationApproval` surroundings_previo
                    ON surroundings_previo.`tra_rowid` = h.`hot_id`
                      AND surroundings_previo.`pre_id` = h.`pre_id`
                      AND surroundings_previo.`tco_id` = '13'
                      AND surroundings_previo.`lan_id` = :lanId
                      AND surroundings_previo.`pro_id` = 1
			LEFT JOIN `TranslationApproval` roomsDescription_previo
                    ON roomsDescription_previo.`tra_rowid` = h.`hot_id`
                      AND roomsDescription_previo.`pre_id` = h.`pre_id`
                      AND roomsDescription_previo.`tco_id` = '15'
                      AND roomsDescription_previo.`lan_id` = :lanId
                      AND roomsDescription_previo.`pro_id` = 1
			LEFT JOIN `TranslationApproval` gastronomy_previo
                    ON gastronomy_previo.`tra_rowid` = h.`hot_id`
                      AND gastronomy_previo.`pre_id` = h.`pre_id`
                      AND gastronomy_previo.`tco_id` = '14'
                      AND gastronomy_previo.`lan_id` = :lanId
                      AND gastronomy_previo.`pro_id` = 1
			LEFT JOIN `TranslationApproval` additionalInfo_previo
                    ON additionalInfo_previo.`tra_rowid` = h.`hot_id`
                      AND additionalInfo_previo.`pre_id` = h.`pre_id`
                      AND additionalInfo_previo.`tco_id` = '12'
                      AND additionalInfo_previo.`lan_id` = :lanId
                      AND additionalInfo_previo.`pro_id` = 1
			LEFT JOIN `PriceActionFirstMinute` paf
                            ON paf.`hot_id` = h.`hot_id`
                               AND paf.`pre_id` = h.`pre_id`
                                  AND paf.`pfm_distance` > 0
                                     AND paf.`pfm_discountRate` > 0
			LEFT JOIN `PriceActionLastMinute` pal
                            ON pal.`hot_id` = h.`hot_id`
                               AND pal.`pre_id` = h.`pre_id`
                                  AND pal.`plm_distance` > 0
                                     AND pal.`plm_discountRate` > 0
			LEFT JOIN `PriceActionLongTerm` pat
                            ON pat.`hot_id` = h.`hot_id`
                               AND pat.`pre_id` = h.`pre_id`
                                  AND pat.`pal_count` > 0
                                     AND pat.`pal_discountRate` > 0
			LEFT JOIN Rating r ON h.hot_id = r.hot_id AND h.pre_id = r.pre_id
			LEFT JOIN `Reviews` reviewCount
                    ON reviewCount.`hot_id` = h.`hot_id` 
                      AND reviewCount.`pre_id` = h.`pre_id`
                      AND reviewCount.`rev_textOnly` <> '1'
                      AND reviewCount.`rev_disabled` <> '1'
			LEFT JOIN `Photos` photo
                    ON photo.`pho_pairId` = h.`hot_id` 
                      AND photo.`pre_id` = h.`pre_id` 
                      AND photo.`php_id` = '1'
                      AND photo.`obk_id` = '0'
			LEFT JOIN `Photos` x
                        ON x.`pho_pairId` = h.`hot_id` 
                      AND x.`pre_id` = h.`pre_id` 
                      AND x.`php_id` = '1'
                      AND x.`obk_id` = '0' 
                      AND x.`pho_syncUpdate` = '2'
			WHERE h.`hot_seoName` = :seoName
				 GROUP BY h.pre_id, h.`hot_id`' in /www/hory.cz/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /www/hory.cz/lib/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /www/hory.cz/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT h.`pre_i...', Array)
#3 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query('SELECT h.`pre_i...', Array)
#4 /www/hory.cz/app/models/BaseModel.php(85): Zend_Db_Adapter_Abstract->fetchAll('SELECT h.`pre_i...', Array)
#5 /www/hory.cz/app/models/GetHotel.php(2448): BaseModel->fetchAllCached('SELECT h.`pre_i...', Array, 'Model_GetHotel_...', Array)
#6 /www/hory.cz/app/controllers/horycz/HotelController.php(50): Model_GetHotel->getData()
#7 /www/hory.cz/lib/Zend/Controller/Action.php(133): Horycz_HotelController->init()
#8 /www/hory.cz/lib/Zend/Controller/Dispatcher/Standard.php(281): Zend_Controller_Action->__construct(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http), Array)
#9 /www/hory.cz/lib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#10 /www/hory.cz/lib/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
#11 /www/hory.cz/lib/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#12 /www/hory.cz/www/index.php(45): Zend_Application->run()
#13 {main} link: http://hory.cz/ubytovani/oderske-vrchy/tosovice/zamecky-hotel/ ip: 216.73.216.108