News › Fishing

News for the Fly-Fisher people interested in salmon fishing on the acclaimed river Blackwater.

Oct 14 2017
Good Hotel Guide 2018 Editors’ Choice Award Fishing Hotel for Ballyvolane House

We are also thrilled with the Good Hotel Guide 2018 Editors’ Choice Award for Fishing Hotel. Massive thanks to all the editors of the GHG. The salmon fishing season on the river Blackwater runs from 01 February to 30 September. …

Read more ›

Time	Δ	Debug Message - Perch Runway 3.1.1
0.0277	0	[39] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
0.0327	0.0051	Matched route: news/category/[slug:cat]
0.0328	0	Using master page: /templates/pages/news/archive.php
0.0328	0	Page arguments: Array ( [0] => /news/category/fishing [cat] => fishing [1] => fishing )
0.0331	0.0004	[33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.0379	0.0048	[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
0.0384	0.0004	[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/fishing/') ORDER BY catTreePosition ASC
0.0392	0.0009	Using template: /templates/categories/category.html
0.0396	0.0004	[1] SELECT * FROM perch3_categories WHERE catPath='blog/fishing/' LIMIT 1
0.0402	0.0006	[1] SELECT * FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1
0.0411	0.0009	Using template: /templates/pages/attributes/default.html
0.0412	0.0002	Using sub-template: /templates/pages/attributes/seo.html
0.0413	0	Using sub-template: /templates/pages/attributes/facebook.html
0.0413	0	Using sub-template: /templates/pages/attributes/twitter.html
0.0425	0.0012	[22] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.0432	0.0007	[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1
0.0434	0.0003	[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-009-002', '000-009', '000') ORDER BY pageTreePosition DESC
0.0438	0.0004	Using template: /templates/navigation/item.html
0.0438	0	[7] Using template: /templates/navigation/subitem.html
0.0444	0.0005	[9] Using template: /templates/navigation/subitem.html
0.0457	0.0013	[1] SELECT * FROM perch3_categories WHERE catPath='blog/fishing/' LIMIT 1
0.046	0.0003	[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
0.0463	0.0002	[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/fishing/') ORDER BY catTreePosition ASC
0.0466	0.0003	[1] Template file not found: /home/ballyvol/public_html/dev/perch/templates/categories/category_blog_intro.html
0.0477	0.0011	[1] SELECT DISTINCT idx.itemID FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'blog/fishing/%' OR idx.indexKey='_category' AND idx.indexValue='blog/fishing/'))
0.049	0.0013	[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' AND idx.itemID IN ('23') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2025-04-24 10:19:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 8
0.0513	0.0023	[1] SELECT FOUND_ROWS() AS `count`
0.0526	0.0013	[1] Using template: /templates/blog/post_in_list.html
0.0528	0.0002	Rescoping to perch:blog
0.0528	0	Using sub-template: /templates/blog/_blog_image_listing.html
0.0535	0.0007	[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
0.0541	0.0006	[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
0.0551	0.0011	[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.0554	0.0003	[10] SELECT main.* , COALESCE(cc.countValue,0) AS `count.blog.post` FROM perch3_categories main LEFT OUTER JOIN perch3_category_counts cc ON cc.catID=main.catID WHERE 1=1 AND setID=1 AND (cc.countType='blog.post' OR cc.countType IS NULL) AND cc.countValue > 0 ORDER BY catTreePosition ASC
0.0566	0.0012	[10] Using template: /templates/blog/category_link_box.html
0.058	0.0014	[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.0582	0.0003	[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1
0.0585	0.0002	[18] SELECT t.tagTitle, t.tagSlug, COUNT(p2t.postID) AS qty FROM perch3_blog_tags t, perch3_blog_posts_to_tags p2t, perch3_blog_posts p WHERE p2t.tagID=t.tagID AND p2t.postID=p.postID AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.0598	0.0013	[18] Using template: /templates/blog/tag_link.html
0.0606	0.0008	[10] SELECT year(postDateTime) as year, COUNT(*) AS year_qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2025-04-24 10:19:00' GROUP BY year ORDER BY year DESC
0.0623	0.0017	Using template: /templates/blog/months_month_link.html
0.0624	0	[4] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2018' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0642	0.0019	[11] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2017' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0667	0.0025	[11] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2016' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0692	0.0025	[7] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2015' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0713	0.0021	[8] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2014' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0734	0.0021	[6] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2013' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0754	0.002	[7] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2012' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0774	0.0021	[5] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2011' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0793	0.0019	[8] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2010' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0815	0.0022	[2] SELECT DISTINCT year(postDateTime) AS year, month(postDateTime) AS month, CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date, COUNT(*) AS month_qty FROM perch3_blog_posts p WHERE year(postDateTime) = '2009' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.0832	0.0017	[10] Using template: /templates/blog/months_year_link.html
0.0837	0.0005	[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.084	0.0003	[10] SELECT main.* , COALESCE(cc.countValue,0) AS `count.blog.post` FROM perch3_categories main LEFT OUTER JOIN perch3_category_counts cc ON cc.catID=main.catID WHERE 1=1 AND setID=1 AND (cc.countType='blog.post' OR cc.countType IS NULL) AND cc.countValue > 0 ORDER BY catTreePosition ASC
0.0852	0.0012	[10] Using template: /templates/blog/category_link.html
0.0858	0.0007	[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.0861	0.0003	[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1
0.0864	0.0002	[18] SELECT t.tagTitle, t.tagSlug, COUNT(p2t.postID) AS qty FROM perch3_blog_tags t, perch3_blog_posts_to_tags p2t, perch3_blog_posts p WHERE p2t.tagID=t.tagID AND p2t.postID=p.postID AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:19:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.0873	0.0009	[18] Using template: /templates/blog/tag_link.html
0.0881	0.0009	[10] Using template: /templates/blog/year_link.html
0.0889	0.0008	[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary' LIMIT 1
0.0893	0.0004	[6] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=1 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
0.09	0.0007	[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=1 AND p.pagePath='/news/archive' LIMIT 1
0.0904	0.0004	[6] Using template: /templates/navigation/secondary_item.html
0.0912	0.0007	Request time: 0.0911
0.0912	0	Process time: 0.0903
0.0912	0	Memory: 3.6635
0.0912	0	Array ( [type] => 8 [message] => Undefined variable: obfuscatedEmail [file] => /home/ballyvol/public_html/dev/inc/functions.inc.php [line] => 14 )

News › Fishing

Good Hotel Guide 2018 Editors’ Choice Award Fishing Hotel for Ballyvolane House

Subscribe to our Email Newsletter