Tourism in Bulgaria - Kamchia - sea resorts, bulgarian sea hotels, vacations, trips

Hotels

Sea Resorts

Ski Resorts

Web Bulgaria

Bulgaria - Tourism - Bulgarian sea resorts and hotels - Kamchia

The mouth of Kamchia river is one of the most beautiful sights on the Bulgarian seaside. It is situated 34 km. south of Varna. The area is known for its wide beaches. The reserve of Kamchia is under the protechtion of UNESCO. Kamchia is one of the many Bulgarian Black Sea resorts where you may fully enjoy a small part of the beautiful Bulgarian nature with its endless sand beaches and limpid sea water. Here you can feel the hospitality and warm attitude of your hosts. This is something that Bulgarians are famous for around the world. Come to Bulgaria and visit this great sea resort.

The most popular hotels in Kamchia are: Kamchia, Longoza, Nimfa, Camping Pirin, Eskana, Villas Rai

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 = '/kamchia.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 >= 1219923287 LEFT JOIN `bulguide_count`.`chc_online_users` as online ON c.nr = online.nr AND online.timestamp >= 1220009387 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 >= 1219923287;

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