媒体

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' ANDnode__field_cat_type_of_page.langcode = node_field_field_data.langcode）左JOIN {node__field_field_field_publication_date}“ node_field_publication_date” on node_field_field_field_field_data.nid = nid = nid = node_field_field_public_date_field_date.field_field_enditic andity andity andity andity和d ='0'和node__field_publication_date.langcode = node_field_field_data.langcode）其中（（node__field_cat_cat_cat_type_of_page.field_field_field_type_page_page_page_page_target_target_target_target_target_target ='30'30'））and（在（'page_edito'）））和（（“ node_field_data”。“ type” in（'page_edito'））和（（“ content_moderation_state”。“ workflow” ='editorial'）和（“ content_moderation_state”。发布'）））订单by“ node__field_publication_date_field_field_publication_date_value” desc限制5偏移0