我们所做的
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_data.langcode）其中（（（node__field_cat_cat_cat_type_of_page.field_field_field_type_type_page_page_page_page_target_target_target_id in（'30'，'273'，'273''，'273''，'273'）and（'node_field_field_field_）node_field_data“。” type“在（'page_edito'）中）和（（“ node_field_data”。“ type” in（'page_edito'））和（（“ content_moderation_state”。。“ Mederation_State” ='发布'））））订单by“ node__field_publication_date_field_field_publication_date_value” desc限制5偏移0
最新消息
