News › Media

Jul 16 2018

Chew the Fat Podcast on Bertha by the GastroGays

Listen back to the wonderful #ChewTheFat podcast episode 3 by Patrick and Russell AKA The GastroGays about Bertha’s Revenge Gin’s journey so far. Very enjoyable chats, thank you very much gents!

Read more ›
Jul 15 2018

Ballyvolane House - Ireland’s Best Guest House, Home of Bertha’s Revenge by The GastroGays

We are delighted to share this wonderful blog by the Gastro Gays ‘Ballyvolane House - Ireland’s Best Guest House, Home of Bertha’s Revenge’. It is beautifully written and the house comes alive with their stunning pics too. Thank you so much gents. It was a pleasure having you here.

Read more ›

Time	Δ	Debug Message - Perch Runway 3.1.1
0.029	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.0037	Matched route: news/category/[slug:cat]
0.0328	0.0001	Using master page: /templates/pages/news/archive.php
0.0328	0	Page arguments: Array ( [0] => /news/category/media [cat] => media [1] => media )
0.0332	0.0004	[33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
0.0378	0.0046	[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
0.0383	0.0005	[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/media/') ORDER BY catTreePosition ASC
0.0391	0.0009	Using template: /templates/categories/category.html
0.0395	0.0004	[1] SELECT * FROM perch3_categories WHERE catPath='blog/media/' LIMIT 1
0.04	0.0006	[1] SELECT * FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1
0.0409	0.0008	Using template: /templates/pages/attributes/default.html
0.041	0.0002	Using sub-template: /templates/pages/attributes/seo.html
0.0411	0	Using sub-template: /templates/pages/attributes/facebook.html
0.0411	0	Using sub-template: /templates/pages/attributes/twitter.html
0.0423	0.0012	[22] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.0429	0.0005	[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1
0.0431	0.0002	[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-009-002', '000-009', '000') ORDER BY pageTreePosition DESC
0.0434	0.0003	Using template: /templates/navigation/item.html
0.0434	0	[7] Using template: /templates/navigation/subitem.html
0.044	0.0006	[9] Using template: /templates/navigation/subitem.html
0.0453	0.0014	[1] SELECT * FROM perch3_categories WHERE catPath='blog/media/' LIMIT 1
0.0456	0.0003	[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
0.0458	0.0002	[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/media/') ORDER BY catTreePosition ASC
0.046	0.0002	[1] Template file not found: /home/ballyvol/public_html/dev/perch/templates/categories/category_blog_intro.html
0.0472	0.0012	[2] 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/media/%' OR idx.indexKey='_category' AND idx.indexValue='blog/media/'))
0.0483	0.0011	[2] 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 ('149', '151') 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:12:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 8
0.051	0.0027	[1] SELECT FOUND_ROWS() AS `count`
0.0525	0.0015	[2] Using template: /templates/blog/post_in_list.html
0.0527	0.0003	Rescoping to perch:blog
0.0527	0	Using sub-template: /templates/blog/_blog_image_listing.html
0.0536	0.0008	[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
0.0543	0.0007	[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
0.113	0.0587	[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.1134	0.0004	[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.1145	0.0011	[10] Using template: /templates/blog/category_link_box.html
0.116	0.0015	[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.1162	0.0002	[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1
0.1165	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:12:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.1175	0.001	[18] Using template: /templates/blog/tag_link.html
0.1183	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:12:00' GROUP BY year ORDER BY year DESC
0.1193	0.001	Using template: /templates/blog/months_month_link.html
0.1193	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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1207	0.0014	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1227	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) = '2016' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1246	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) = '2015' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1262	0.0015	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1279	0.0017	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1295	0.0016	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.131	0.0015	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1324	0.0014	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.134	0.0016	[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC
0.1351	0.0011	[10] Using template: /templates/blog/months_year_link.html
0.1357	0.0006	[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1
0.1359	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.1369	0.0009	[10] Using template: /templates/blog/category_link.html
0.1376	0.0007	[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1
0.1379	0.0003	[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1
0.1381	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:12:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC
0.1387	0.0007	[18] Using template: /templates/blog/tag_link.html
0.1396	0.0008	[10] Using template: /templates/blog/year_link.html
0.1404	0.0008	[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary' LIMIT 1
0.1407	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.1412	0.0005	[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.1415	0.0003	[6] Using template: /templates/navigation/secondary_item.html
0.1421	0.0006	Request time: 0.1421
0.1421	0	Process time: 0.1411
0.1421	0	Memory: 8.2226
0.1422	0	Array ( [type] => 8 [message] => Undefined variable: obfuscatedEmail [file] => /home/ballyvol/public_html/dev/inc/functions.inc.php [line] => 14 )

Time

Debug Message - Perch Runway 3.1.1

0.029

[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.0037

Matched route: news/category/[slug:cat]

0.0328

0.0001

Using master page: /templates/pages/news/archive.php

0.0328

Page arguments:

Array
(
    [0] => /news/category/media
    [cat] => media
    [1] => media
)

0.0332

0.0004

[33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0

0.0378

0.0046

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

0.0383

0.0005

[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/media/') ORDER BY catTreePosition ASC

0.0391

0.0009

Using template: /templates/categories/category.html

0.0395

0.0004

[1] SELECT * FROM perch3_categories WHERE catPath='blog/media/' LIMIT 1

0.04

0.0006

[1] SELECT * FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1

0.0409

0.0008

Using template: /templates/pages/attributes/default.html

0.041

0.0002

Using sub-template: /templates/pages/attributes/seo.html

0.0411

Using sub-template: /templates/pages/attributes/facebook.html

0.0411

Using sub-template: /templates/pages/attributes/twitter.html

0.0423

0.0012

[22] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC

0.0429

0.0005

[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/news/archive' LIMIT 1

0.0431

0.0002

[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-009-002', '000-009', '000') ORDER BY pageTreePosition DESC

0.0434

0.0003

Using template: /templates/navigation/item.html

0.0434

[7] Using template: /templates/navigation/subitem.html

0.044

0.0006

[9] Using template: /templates/navigation/subitem.html

0.0453

0.0014

[1] SELECT * FROM perch3_categories WHERE catPath='blog/media/' LIMIT 1

0.0456

0.0003

[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1

0.0458

0.0002

[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='blog/media/') ORDER BY catTreePosition ASC

0.046

0.0002

[1] Template file not found: /home/ballyvol/public_html/dev/perch/templates/categories/category_blog_intro.html

0.0472

0.0012

[2] 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/media/%' OR idx.indexKey='_category' AND idx.indexValue='blog/media/'))

0.0483

0.0011

[2] 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 ('149', '151') 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:12:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 8

0.051

0.0027

[1] SELECT FOUND_ROWS() AS `count`

0.0525

0.0015

[2] Using template: /templates/blog/post_in_list.html

0.0527

0.0003

Rescoping to perch:blog

0.0527

Using sub-template: /templates/blog/_blog_image_listing.html

0.0536

0.0008

[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC

0.0543

0.0007

[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC

0.113

0.0587

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1

0.1134

0.0004

[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.1145

0.0011

[10] Using template: /templates/blog/category_link_box.html

0.116

0.0015

[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1

0.1162

0.0002

[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1

0.1165

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:12:00' AND p.sectionID=1 AND p.blogID=1 GROUP BY t.tagID ORDER BY t.tagTitle ASC

0.1175

0.001

[18] Using template: /templates/blog/tag_link.html

0.1183

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:12:00' GROUP BY year ORDER BY year DESC

0.1193

0.001

Using template: /templates/blog/months_month_link.html

0.1193

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1207

0.0014

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1227

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) = '2016' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1246

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) = '2015' AND p.postStatus='Published' AND p.postDateTime<='2025-04-24 10:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1262

0.0015

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1279

0.0017

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1295

0.0016

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.131

0.0015

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1324

0.0014

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.134

0.0016

[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:12:00' GROUP BY year, month, grouped_date ORDER BY month DESC

0.1351

0.0011

[10] Using template: /templates/blog/months_year_link.html

0.1357

0.0006

[1] SELECT setID FROM perch3_category_sets WHERE setSlug='blog' LIMIT 1

0.1359

0.0003

0.1369

0.0009

[10] Using template: /templates/blog/category_link.html

0.1376

0.0007

[1] SELECT * FROM perch3_blogs WHERE blogSlug='blog' LIMIT 1

0.1379

0.0003

[1] SELECT * FROM perch3_blog_sections WHERE sectionSlug='posts' LIMIT 1

0.1381

0.0002

0.1387

0.0007

[18] Using template: /templates/blog/tag_link.html

0.1396

0.0008

[10] Using template: /templates/blog/year_link.html

0.1404

0.0008

[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary' LIMIT 1

0.1407

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.1412

0.0005

[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.1415

0.0003

[6] Using template: /templates/navigation/secondary_item.html

0.1421

0.0006

Request time: 0.1421

0.1421

Process time: 0.1411

0.1421

Memory: 8.2226

0.1422

Array
(
    [type] => 8
    [message] => Undefined variable: obfuscatedEmail
    [file] => /home/ballyvol/public_html/dev/inc/functions.inc.php
    [line] => 14
)

News › Media

Chew the Fat Podcast on Bertha by the GastroGays

Ballyvolane House - Ireland’s Best Guest House, Home of Bertha’s Revenge by The GastroGays

Subscribe to our Email Newsletter