Τουριστική Πύλη Νομού Αχαΐας Logo

GreekEnglish (United Kingdom)
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups, u.email as author_email, cc.title AS category, s.title AS section, s.ord' at line 1 SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-01 08:49:25' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-01 08:49:25' ) ORDER BY cc.ordering, a.ordering LIMIT 0, 1
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups, u.email as author_email, cc.title AS category, s.title AS section, s.ord' at line 1 SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email as author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE 1 AND a.access <= 0 AND a.state = 1 AND (( cc.published = 1 AND s.published = 1 ) OR ( a.catid = 0 AND a.sectionid = 0 ) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-01 08:49:25' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-01 08:49:25' ) ORDER BY cc.ordering, a.ordering

Prehistoric Outline

Prehistoric Outline

Following an archaeological research, the presence of the food-collector, palaeolithic man has been established in the area of Achaia, in two neighboring locations at the feet of mountain Movri, near Elaiochorio of the present Municipality of Dymi, where blades and other Paleolithic tools have been found.

Prefecture of Achaia

Prefecture of Achaia

 

Achaia Prefecture is located in the northwestern Peloponnese. It covers an area of 3271 square kilometres, has a population of 327.316 inhabitants (2001) and it is the main gateway connecting Greece with rest EU countries through the Port of Patras.

Riding

Riding

Located just 10 minutes from Patras into forested area of 12 acres ,the Patras Riding Club (Riding School),offers well-equipped facilities for beginners and advanced riders but also to the people who are enjoying good food and they are able to enjoy several of traditional meals into the Club Restaurant, surrounded by dozens of horses.

Summer proposals


Polls

Which is the most beutiful mountain of Achaia?