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_year} "node__field_cat_year" ON node_field_data.nid = node__field_cat_year.entity_id AND (node__field_cat_year.deleted = '0' AND node__field_cat_year.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_year.field_cat_year_target_id IN('145', '134', '144')))) 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 3 OFFSET 0
Find the solutions for your next project
Supercrete
Supercrete, the only Portland Limestone Cement (PLC) brand in Bangladesh, complies with BDS EN 197-1: 2003, CEM II/ B-L, 42.5N standard. Own clinker production facility and usage ensure the consistent quality of the Cement.
Holcim Strong Structure
Holcim (Strong Structure), a Portland Composite Cement (PCC) complies with BDS EN 197-1:2003, CEM II/B-M (S-V-L), 42.5N standard. The usage of this type of cement started from last few decades in Bangladesh.
Holcim Water Protect
A unique tailor made product that addresses the key problems of water seepage, dampness and water ingress that are of significant concern for home builders. Developed through continuous consumer engagement and research, Holcim Water Protect has been
Holcim Red
Holcim (Red) is an Ordinary Portland Cement (OPC) complies with BDS EN 197-1:2003, CEM I, 52.5N standard. The clinker, the key quality factor of Holcim Red, mainly comes from reliable and authentic sources of Vietnam and Thailand.
