Tourism in Bulgaria - St. St. Constantin and Elena - sea resorts, bulgarian sea hotels, vacations, trips

Hotels

Sea Resorts

Ski Resorts

Web Bulgaria

Bulgaria - Tourism - Bulgarian sea resorts and hotels - St. St. Constantin and Elena

This is the oldest resort on the Bulgarian Black sea coast. It is situated 9 km. north of Varna. There are more than 50 hotels there. Zlatni Pyasutsi (Golden Sands) 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 St. St. Constantin and Elena are: Admiral, Azalia, Bor, Chaika, Dolphin, Dolphin Marina, Emona, Estreya, Flagman, Gloria, Grand hotel Varna, Kalina, Lebed, Letovishte, Roubin, Sana, Sirius Beach, St. Elena, Complex FLOTILIA , F. Joliot - Curie , Family house Detelina , Finesse , Grand Varna , Holiday Village Grand Varn , Perla , Rossitsa , Saint Elena , Alfa , Astra

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 = '/konstantin-elena.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 >= 1223323133 LEFT JOIN `bulguide_count`.`chc_online_users` as online ON c.nr = online.nr AND online.timestamp >= 1223409233 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 >= 1223323133;

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