我们所做的
我们的故事
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
最新消息