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] => yy/m/d
    [postDateAppend] => before
    [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] => 8068
            [post_name] => systemic-bias-and-helicopter-science-prevents-global-south-scientists-from-being-heard
            [post_title] => Systemic bias and "helicopter science" prevents global south scientists from being heard
            [post_author] => 1
            [post_date] => 2021-10-11 05:10:31
            [year] => 2021
            [month] => 10
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 8064
            [post_name] => the-novel-prize-for-physics-goes-to-climate-scientists
            [post_title] => The Nobel Prize for physics goes to climate scientists
            [post_author] => 1
            [post_date] => 2021-10-08 06:38:26
            [year] => 2021
            [month] => 10
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 8023
            [post_name] => strong-regulation-needed-to-rid-our-homes-of-killer-forever-chems
            [post_title] => Strong regulation needed to rid our homes of killer “forever chems”
            [post_author] => 1
            [post_date] => 2021-09-29 06:18:36
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7977
            [post_name] => 16th-unesco-session-on-intangible-cultural-heritage-to-be-held-in-colombo
            [post_title] => 16th UNESCO session on intangible cultural heritage to be held in Colombo
            [post_author] => 1
            [post_date] => 2021-09-17 06:15:08
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [4] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7934
            [post_name] => number-of-hot-day-50c-double-over-the-last-decade
            [post_title] => Number of hot day (>50C) double over the last decade
            [post_author] => 1
            [post_date] => 2021-09-14 16:01:00
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [5] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7925
            [post_name] => iucn-world-conservation-congress-closes-with-marseille-manifesto
            [post_title] => IUCN World Conservation Congress Closes with Marseille Manifesto
            [post_author] => 1
            [post_date] => 2021-09-11 15:41:25
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [6] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7922
            [post_name] => 15-nations-including-sri-lanka-in-2022-vnr
            [post_title] => 15 nations including Sri Lanka in 2022 VNR
            [post_author] => 1
            [post_date] => 2021-09-11 15:21:41
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [7] => stdClass Object
        (
            [slug] => news-articles
            [ID] => 7917
            [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:18:35
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [8] => 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
        )

    [9] => 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
        )

    [10] => 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
        )

    [11] => 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 (12)
  • ▼October (2)
    • 2121/10/11 Systemic bias and "helicopter science" prevents global south scientists from being heard
    • 2121/10/08 The Nobel Prize for physics goes to climate scientists
  • ►September (8)
  • ►August (2)