18
Apr
0 Comment
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
About Post Author
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
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] => 8718
[post_name] => ocean-temperatures-are-off-the-charts
[post_title] => Ocean temperatures are off the charts
[post_author] => 1
[post_date] => 2023-05-07 16:22:32
[year] => 2023
[month] => 5
[post_type] => post
)
[1] => stdClass Object
(
[slug] => news-articles
[ID] => 8637
[post_name] => first-climate-lawsuit-to-be-heard-by-european-court-for-human-rights
[post_title] => First climate lawsuit to be heard by European Court for Human Rights
[post_author] => 1
[post_date] => 2023-03-29 14:51:39
[year] => 2023
[month] => 3
[post_type] => post
)
[2] => stdClass Object
(
[slug] => news-articles
[ID] => 8578
[post_name] => on-thin-ice
[post_title] => On thin ice!
[post_author] => 1
[post_date] => 2023-02-15 19:56:02
[year] => 2023
[month] => 2
[post_type] => post
)
[3] => stdClass Object
(
[slug] => news-articles
[ID] => 8550
[post_name] => cop-27-so-green-hydrogen-is-the-next-great-fix-eh
[post_title] => COP 27: So, green hydrogen is the next great fix eh?
[post_author] => 1
[post_date] => 2022-11-08 16:02:26
[year] => 2022
[month] => 11
[post_type] => post
)
[4] => stdClass Object
(
[slug] => news-articles
[ID] => 8538
[post_name] => digital-innovation-offers-a-simple-way-to-monitor-the-worlds-trees
[post_title] => Digital innovation offers a simple way to monitor the world's trees
[post_author] => 1
[post_date] => 2022-10-30 15:47:05
[year] => 2022
[month] => 10
[post_type] => post
)
[5] => stdClass Object
(
[slug] => news-articles
[ID] => 8444
[post_name] => egypts-president-on-cop-27
[post_title] => Egypt's president on COP 27
[post_author] => 1
[post_date] => 2022-10-22 16:50:38
[year] => 2022
[month] => 10
[post_type] => post
)
[6] => stdClass Object
(
[slug] => news-articles
[ID] => 8530
[post_name] => how-many-types-of-trees-are-actually-there-on-earth
[post_title] => How many types of trees are actually there on earth?
[post_author] => 1
[post_date] => 2022-07-14 14:32:52
[year] => 2022
[month] => 7
[post_type] => post
)
[7] => stdClass Object
(
[slug] => news-articles
[ID] => 8439
[post_name] => earth-day-2022
[post_title] => Earth Day 2022
[post_author] => 1
[post_date] => 2022-06-05 16:01:15
[year] => 2022
[month] => 6
[post_type] => post
)
[8] => stdClass Object
(
[slug] => news-articles
[ID] => 8431
[post_name] => world-biodiversity-day-2022
[post_title] => World Biodiversity Day 2022
[post_author] => 1
[post_date] => 2022-05-22 15:23:10
[year] => 2022
[month] => 5
[post_type] => post
)
[9] => stdClass Object
(
[slug] => news-articles
[ID] => 8362
[post_name] => new-plant-species-discovered-in-knuckles-range
[post_title] => New plant species discovered in Knuckles Range
[post_author] => 1
[post_date] => 2022-05-15 16:26:41
[year] => 2022
[month] => 5
[post_type] => post
)
[10] => stdClass Object
(
[slug] => news-articles
[ID] => 8350
[post_name] => urgent-global-need-to-recycle-e-waste
[post_title] => Urgent global need to recycle e-waste
[post_author] => 1
[post_date] => 2022-05-09 04:07:20
[year] => 2022
[month] => 5
[post_type] => post
)
[11] => stdClass Object
(
[slug] => news-articles
[ID] => 8276
[post_name] => the-subcontinent-is-being-fried-to-death-and-it-is-a-warning-for-sri-lanka
[post_title] => The subcontinent is being fried to death - and it is a warning for Sri Lanka
[post_author] => 1
[post_date] => 2022-04-30 17:08:22
[year] => 2022
[month] => 4
[post_type] => post
)
[12] => stdClass Object
(
[slug] => news-articles
[ID] => 8261
[post_name] => wg3-report-out
[post_title] => WG3 Report Out
[post_author] => 1
[post_date] => 2022-04-12 15:01:39
[year] => 2022
[month] => 4
[post_type] => post
)
[13] => stdClass Object
(
[slug] => news-articles
[ID] => 8253
[post_name] => world-water-day-2022-groundwater-making-the-invisible-visible
[post_title] => World Water Day 2022: Groundwater - Making the invisible visible
[post_author] => 1
[post_date] => 2022-03-22 14:33:33
[year] => 2022
[month] => 3
[post_type] => post
)
[14] => stdClass Object
(
[slug] => news-articles
[ID] => 8216
[post_name] => wg2-report-out
[post_title] => WG2 report out
[post_author] => 2
[post_date] => 2022-03-01 16:27:22
[year] => 2022
[month] => 3
[post_type] => post
)
[15] => stdClass Object
(
[slug] => news-articles
[ID] => 8156
[post_name] => huge-methane-plumes-from-leaks-mapped-from-outer-space
[post_title] => Huge methane plumes from leaks mapped from outer space
[post_author] => 1
[post_date] => 2022-02-06 11:31:41
[year] => 2022
[month] => 2
[post_type] => post
)
[16] => stdClass Object
(
[slug] => news-articles
[ID] => 8112
[post_name] => raid-assessing-cc-risks-to-coastal-cities
[post_title] => Raid assessing CC risks to coastal cities
[post_author] => 1
[post_date] => 2022-01-27 14:57:24
[year] => 2022
[month] => 1
[post_type] => post
)
[17] => stdClass Object
(
[slug] => news-articles
[ID] => 8079
[post_name] => cop26-leaked-documents-the-chief-polluters-producers-and-consumers-wants-the-ipcc-wg1-report-toned-down-ha
[post_title] => COP26 Leaked Documents: The chief polluters, producers and consumers wants the IPCC WG1 report toned down! HA!
[post_author] => 1
[post_date] => 2021-10-21 16:02:05
[year] => 2021
[month] => 10
[post_type] => post
)
[18] => 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
)
[19] => 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
)
[20] => 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
)
[21] => 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
)
[22] => 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
)
[23] => 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
)
[24] => 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
)
[25] => 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
)
[26] => 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
)
[27] => 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
)
[28] => 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
)
[29] => 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
)
)