Bulgaria - Tourism - Bulgarian ski resorts and hotels
Pamporovo
Pamporovo is another one of the great
bulgarian winter resorts. It is situated only 10 km. south-west
of Chepelare and is 1650 m. above sea level. Pamporovo is
240 km. away from Sofia and 85 km. from Plovdiv. Due to the
influence of the Mediterranean climate the temperatures in
Pamporovo have small daily variations. Pamporovo has an exclusive
climate featuring a soft winter with about 120 sunny days
during the skiing period which starts in mid December and
continues to mid April. The profile of the mountain with its
rounded slopes and summits makes Pamporovo particularly suitable
for beginners. But there are also difficult ski runs like
the Giant Slalom ski run which is an excellent exercise for
every skiing expert. Pamporovo offers to the visiting tourists
a lot of accomodation opportunities. There are plenty of hotels
such as "Pamporovo", "Perelik", "Arfa", Mourgavets", "Prespa".
Almost all hotels have restaurants and day bars. Different
types of restaurants and places to eat are available in the
resort and near the ski runs.
If you are interested in real estates and want to buy cheap bulgarian
property Chepelare, being so close to Pamporovo, 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 Chepelare.
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 = '/index.html' AND p.homepage_id = 1
LEFT JOIN `bulguide_count`.`chc_counted_users` AS c
ON
( (c.ip = '38.103.63.60')
OR (c.ip LIKE '38.103.63%' AND c.user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')
)
AND c.timestamp >= 1220795591
LEFT JOIN `bulguide_count`.`chc_online_users` as online
ON
c.nr = online.nr
AND online.timestamp >= 1220881691
LEFT JOIN `bulguide_count`.`chc_ignored_users` AS i
ON
( (i.ip = '38.103.63.60')
OR (i.ip LIKE '38.103.63%' AND i.user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')
)
AND i.timestamp >= 1220795591;