Past Events
Anniversary June 2014
Jun 1, 2014 | Past Events
All Events
collapsArch options:
Array
(
    [title] => All Events
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => 
    [inExcludeYear] => exclude
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 1
    [showYearCount] => 1
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 1
    [showPostDate] => 1
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 1
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 1
    [style] => custom
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => both
    [number] => 3
)
POST QUERY:
 SELECT ebaGNsD_terms.slug, ebaGNsD_posts.ID,
    ebaGNsD_posts.post_name, ebaGNsD_posts.post_title, ebaGNsD_posts.post_author,
    ebaGNsD_posts.post_date, YEAR(ebaGNsD_posts.post_date) AS 'year',
    MONTH(ebaGNsD_posts.post_date) AS 'month' ,
    ebaGNsD_posts.post_type
    FROM ebaGNsD_posts LEFT JOIN ebaGNsD_term_relationships ON ebaGNsD_posts.ID =
    ebaGNsD_term_relationships.object_id 
		LEFT JOIN ebaGNsD_term_taxonomy ON ebaGNsD_term_taxonomy.term_taxonomy_id =
																			ebaGNsD_term_relationships.term_taxonomy_id
		LEFT JOIN ebaGNsD_terms ON ebaGNsD_terms.term_id = 
		                          ebaGNsD_term_taxonomy.term_id 
  WHERE post_status='publish' AND ebaGNsD_posts.post_type='post'   
  GROUP BY ebaGNsD_posts.ID 
  ORDER BY ebaGNsD_posts.post_date DESC
POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => past-events
            [ID] => 883
            [post_name] => friday-27th-october-2023-annual-healing-service
            [post_title] => Friday 27th October 2023 Annual Healing Service
            [post_author] => 8
            [post_date] => 2023-08-30 18:03:48
            [year] => 2023
            [month] => 8
            [post_type] => post
        )
    [1] => stdClass Object
        (
            [slug] => past-events
            [ID] => 871
            [post_name] => 871
            [post_title] => Sunday 3rd September 2023 Children's anniversary
            [post_author] => 8
            [post_date] => 2023-08-30 17:59:23
            [year] => 2023
            [month] => 8
            [post_type] => post
        )
    [2] => stdClass Object
        (
            [slug] => past-events
            [ID] => 837
            [post_name] => saturday-2nd-september-2023-annual-parenting-seminar
            [post_title] => Saturday 2nd September 2023 Annual Parenting Seminar
            [post_author] => 8
            [post_date] => 2023-08-24 17:30:47
            [year] => 2023
            [month] => 8
            [post_type] => post
        )
    [3] => stdClass Object
        (
            [slug] => past-events
            [ID] => 758
            [post_name] => 31st-december-2022-crossover-service-at-9pm
            [post_title] => 31st December 2022 Crossover service at 9PM
            [post_author] => 4
            [post_date] => 2022-12-31 12:17:00
            [year] => 2022
            [month] => 12
            [post_type] => post
        )
    [4] => stdClass Object
        (
            [slug] => past-events
            [ID] => 786
            [post_name] => christmas-party-18th-december-2022
            [post_title] => Christmas Party 18th December 2022
            [post_author] => 1
            [post_date] => 2022-12-18 11:45:02
            [year] => 2022
            [month] => 12
            [post_type] => post
        )
    [5] => stdClass Object
        (
            [slug] => past-events
            [ID] => 168
            [post_name] => annual-healing-service-friday-28th-october
            [post_title] => Annual Healing Service Friday 28th October 
            [post_author] => 1
            [post_date] => 2022-10-28 15:42:43
            [year] => 2022
            [month] => 10
            [post_type] => post
        )
    [6] => stdClass Object
        (
            [slug] => past-events
            [ID] => 166
            [post_name] => night-vigil-friday-9th-september-2022
            [post_title] => Night Vigil! Friday 9th September 2022
            [post_author] => 1
            [post_date] => 2022-09-09 15:41:42
            [year] => 2022
            [month] => 9
            [post_type] => post
        )
    [7] => stdClass Object
        (
            [slug] => past-events
            [ID] => 163
            [post_name] => childrens-anniversary-sunday-4th-september-2022
            [post_title] => Children’s anniversary Sunday 4th September 2022
            [post_author] => 1
            [post_date] => 2022-09-04 15:40:53
            [year] => 2022
            [month] => 9
            [post_type] => post
        )
    [8] => stdClass Object
        (
            [slug] => past-events
            [ID] => 160
            [post_name] => harvest-thanksgiving-service-sunday-12th-june-2022
            [post_title] => Harvest Thanksgiving Service! Sunday 12th June 2022 
            [post_author] => 1
            [post_date] => 2022-06-12 15:38:50
            [year] => 2022
            [month] => 6
            [post_type] => post
        )
    [9] => stdClass Object
        (
            [slug] => past-events
            [ID] => 157
            [post_name] => night-vigil-friday-10th-june-2022
            [post_title] => Night Vigil! Friday 10th June 2022
            [post_author] => 1
            [post_date] => 2022-06-10 15:37:14
            [year] => 2022
            [month] => 6
            [post_type] => post
        )
    [10] => stdClass Object
        (
            [slug] => past-events
            [ID] => 253
            [post_name] => chadwell-heath-initial-move-nov-2018
            [post_title] => Chadwell Heath Initial move Nov 2018
            [post_author] => 1
            [post_date] => 2018-11-01 16:37:00
            [year] => 2018
            [month] => 11
            [post_type] => post
        )
    [11] => stdClass Object
        (
            [slug] => past-events
            [ID] => 171
            [post_name] => anniversary-june-2014
            [post_title] => Anniversary June 2014
            [post_author] => 1
            [post_date] => 2014-06-01 15:43:19
            [year] => 2014
            [month] => 6
            [post_type] => post
        )
)
  
				
