SELECT a_id, a_id_word, a_headline, a_publish_date, a_abstract, a_author, a_has_video, a_has_audio FROM su_cat_sg_mappings, re_categories , re_category_sections_assoc , pr_sections , pr_article_section_assoc , pr_articles_search, pr_article_media_assoc WHERE csg_sg_id = 1 AND csg_cat_id = cat_id AND a_status = 1
AND a_process_status = 4 AND a_expiry_date >= 1717833600
AND cat_id = scat_cat_id AND scat_s_id = s_id AND s_id = ase_s_id AND ase_a_id = a_id
AND cat_re_id = 42 AND ama_a_id = a_id AND ama_mt_id = 2 AND ama_p_id = ase_p_id AND s_id NOT IN (14903,14910,14911,14906,14904,14912,14909,14908,14907,14905) AND a_publish_date <= 1717833600 AND ase_s_id IN (13929,13778,16683,13779,13828,13945,15252,13781,13783,13784,13785,13959,13960,13961,13962,13963,13964,13958,13966,13965,13967,13969,13968,13970,13971,13972,13973,16686,16685,16690,16688,16691,16692,16687,13974,13975,13976,13977) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 100
|
|
NortH2, Netherlands
Published: 12 Apr 24
The project will abate eight to ten-million tonnes of carbon dioxide emissions.
|
|
|
Koruson 2, South Africa
Published: 12 Apr 24
Envusa Energy has completed the project financing for its first three wind and solar projects, collectively known as Koruson 2.
|
|
|
Wind/solar project, Albania
Published: 05 Apr 24
CWP Global and General Electric Vernova plan to build a large-scale hybrid wind and solar project.
|
|
|
Solar panel glass plant, US
Published: 05 Apr 24
The facility will be the first-of-its-kind in the US to use recycled materials from retired solar panels to produce specialised glass for crystalline-silicon photovoltaics in the country.
|
|
|
HyDeal España, Spain
Published: 05 Apr 24
HyDeal España envisages supplying green hydrogen over 20 years to major hydrogen consumption clusters in northern and eastern Spain at a price competitive with fossil fuels.
|
|
|
|