Archives

collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => include
    [inExcludeCats] => news-articles
    [inExcludeYear] => include
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 1
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 0
    [showPostDate] => 1
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 1
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 1
    [style] => kubrick
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => category
    [number] => 3
)
POST QUERY:
 SELECT wp_terms.slug, wp_posts.ID,
    wp_posts.post_name, wp_posts.post_title, wp_posts.post_author,
    wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
    MONTH(wp_posts.post_date) AS 'month' ,
    wp_posts.post_type
    FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
    wp_term_relationships.object_id 
		LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
																			wp_term_relationships.term_taxonomy_id
		LEFT JOIN wp_terms ON wp_terms.term_id = 
		                          wp_term_taxonomy.term_id 
  WHERE post_status='publish' AND wp_posts.post_type='post'  AND wp_terms.slug IN ('news-articles') 
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7877
            [post_name] => largest-source-of-lead-pollution-no-more
            [post_title] => Largest source of lead pollution no more!
            [post_author] => 1
            [post_date] => 2021-09-10 14:08:57
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7867
            [post_name] => cop26-must-be-postponed-climate-action-network
            [post_title] => "COP26 must be postponed" - Climate Action Network
            [post_author] => 1
            [post_date] => 2021-09-07 21:24:07
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7862
            [post_name] => gmsl-conducts-a-seminar-on-the-ipccs-latest-wg1-report
            [post_title] => GMSL webinar on the  IPCC's latest WG1 report
            [post_author] => 1
            [post_date] => 2021-09-07 21:00:08
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7297
            [post_name] => kalpitiya-mangrove-planting-continues
            [post_title] => Kalpitiya mangrove planting continues
            [post_author] => 2
            [post_date] => 2021-08-27 07:16:07
            [year] => 2021
            [month] => 8
            [post_type] => post
        )

    [4] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7295
            [post_name] => ipcc-issues-code-red-warning-to-the-world
            [post_title] => IPCC issues code red warning to the world
            [post_author] => 2
            [post_date] => 2021-08-11 07:03:06
            [year] => 2021
            [month] => 8
            [post_type] => post
        )

)

• ►2021 (5)
  • ►September (3)
  • ►August (2)