Creating a more sustainable world
At Holcim US, we're building progress for people and the planet. Using our technological know-how, we seek any opportunity to produce greener products and to manufacture and operate in a more environmentally sound way.
Our commitment to sustainability motivates us to take critical steps to continually move toward a net-zero future, creating value for our company, our business and the world.
SELECT DISTINCT "node__field_publication_date"."field_publication_date_value" AS "node__field_publication_date_field_publication_date_value", "node_field_data"."nid" AS "nid"
FROM
{node_field_data} "node_field_data"
LEFT JOIN {content_moderation_state_field_revision} "content_moderation_state" ON node_field_data.vid = content_moderation_state.content_entity_revision_id AND (content_moderation_state.content_entity_type_id = 'node' AND content_moderation_state.content_entity_id = node_field_data.nid AND content_moderation_state.langcode = node_field_data.langcode)
INNER JOIN {node__field_cat_type_of_page} "node__field_cat_type_of_page" ON node_field_data.nid = node__field_cat_type_of_page.entity_id AND (node__field_cat_type_of_page.deleted = '0' AND node__field_cat_type_of_page.langcode = node_field_data.langcode)
INNER JOIN {node__field_cat_themes} "node__field_cat_themes" ON node_field_data.nid = node__field_cat_themes.entity_id AND (node__field_cat_themes.deleted = '0' AND node__field_cat_themes.langcode = node_field_data.langcode)
LEFT JOIN {node__field_publication_date} "node__field_publication_date" ON node_field_data.nid = node__field_publication_date.entity_id AND (node__field_publication_date.deleted = '0' AND node__field_publication_date.langcode = node_field_data.langcode)
WHERE (((node__field_cat_type_of_page.field_cat_type_of_page_target_id = '30')) AND ((node__field_cat_themes.field_cat_themes_target_id = '167'))) AND (("node_field_data"."status" = '1') AND ("node_field_data"."type" IN ('page_edito')) AND (("node_field_data"."type" IN ('page_edito')) AND (("content_moderation_state"."workflow" = 'editorial') AND ("content_moderation_state"."moderation_state" = 'published'))))
ORDER BY "node__field_publication_date_field_publication_date_value" DESC
LIMIT 5 OFFSET 0Sustainability News
