Tourism in Bulgaria - ski resorts Malyovitsa, bulgarian ski hotels, skiing, snowboard, vacations, trips

Tourism in Bulgaria - ski resorts - Malyovitsa, bulgarian ski hotels, vacations, skiing, snowboard

Web Bulgaria

Bulgaria - Tourism - Bulgarian ski resorts and hotels - Malyovitsa

Malyovitsa is a small resort 27 km. away from Samokov and is connected to it by a well-maintained road. There is a regular bus line to Samokov and the nearby village of Govedartsi. Wonderful mountain scenery can be seen from the Malyovitsa summit which is 2729 m. above sea level.

The total length of the Malyovitsa ski runs is 4 kilometers. The longest one is Uleya - 1200 meters long. The Rajdavica ski run is 900 meters long, plus the road that connects it to the beginners ski run. The ski runs on Mecha Polqna are mainly for beginners. The only hotel there is "Malyovitsa" hotel. It offers a total of 180 beds to the visiting tourists and skiers.If you are interested in real estates and want to buy cheap bulgarian property Samokov has what to offer you. If you are a keen skiier and don't want to worry for reservations you can buy very cheap nice houses in Samokov.

chCounter: MySQL error!
SQL query:

SELECT d.besucher_gesamt, d.besucher_heute, d.heute_timestamp, d.besucher_gestern, d.`max_online:anzahl`, d.`max_online:timestamp`, d.`max_besucher_pro_tag:anzahl`, d.`max_besucher_pro_tag:timestamp`, d.`max_seitenaufrufe_pro_tag:anzahl`, d.`max_seitenaufrufe_pro_tag:timestamp`, d.seitenaufrufe_gesamt, d.seitenaufrufe_heute, d.seitenaufrufe_gestern, d.`durchschnittlich_pro_tag:timestamp`, d.`durchschnittlich_pro_tag:besucher`, d.`durchschnittlich_pro_tag:seitenaufrufe`, d.`seitenaufrufe_pro_besucher:besucher`, d.`seitenaufrufe_pro_besucher:seitenaufrufe`, d.js_aktiv, d.js_alle, d.timestamp_letztes_db_aufraeumen, IF(p.anzahl, p.anzahl, 0) AS diese_seite_seitenaufrufe, IF( c.nr, 1, 0 ) as counted, IF(c.nr, c.nr, 0) as besucher_nr, IF(c.seitenaufrufe, c.seitenaufrufe, 0) as besucher_seitenaufrufe, IF(c.is_robot, c.is_robot, -1 ) as is_robot, IF( online.id, online.id, 0) as online, IF(i.tmp_blocked = 0, 1, 0) as ignored_user, IF( i.id, i.id, -1 ) as ignored_user_id FROM `bulguide_count`.`chc_data` AS d LEFT JOIN `bulguide_count`.`chc_pages` AS p ON p.wert = '/malyovitsa.html' AND p.homepage_id = 1 LEFT JOIN `bulguide_count`.`chc_counted_users` AS c ON ( (c.ip = '38.103.63.17') OR (c.ip LIKE '38.103.63%' AND c.user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)') ) AND c.timestamp >= 1217034516 LEFT JOIN `bulguide_count`.`chc_online_users` as online ON c.nr = online.nr AND online.timestamp >= 1217120616 LEFT JOIN `bulguide_count`.`chc_ignored_users` AS i ON ( (i.ip = '38.103.63.17') OR (i.ip LIKE '38.103.63%' AND i.user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)') ) AND i.timestamp >= 1217034516;

Error number: 1054
Unknown column 'online.timestamp' in 'on clause'
Script stopped.