Created
November 8, 2019 05:57
-
-
Save quardz/bfd035caf858374deb73303e06cecf1a to your computer and use it in GitHub Desktop.
temp sql to test
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT node.nid AS nid, | |
| node_data_field_recent_nodes_view.field_recent_nodes_view_vname AS node_data_field_recent_nodes_view_field_recent_nodes_view_vname, | |
| node_data_field_recent_nodes_view.field_recent_nodes_view_vargs AS node_data_field_recent_nodes_view_field_recent_nodes_view_vargs, | |
| node.type AS node_type, | |
| node.vid AS node_vid, | |
| node_data_field_archive_term_view_display.field_archive_term_view_display_vname AS node_data_field_archive_term_view_display_field_archive_term_view_display_vname, | |
| node_data_field_archive_term_view_display.field_archive_term_view_display_vargs AS node_data_field_archive_term_view_display_field_archive_term_view_display_vargs, | |
| node.title AS node_title, | |
| node_revisions.body AS node_revisions_body, | |
| node_revisions.format AS node_revisions_format, | |
| node.created AS node_created, | |
| node.changed AS node_changed | |
| FROM node node | |
| LEFT JOIN content_type_archive_second_level_term_page node_data_field_recent_nodes_view ON node.vid = node_data_field_recent_nodes_view.vid | |
| LEFT JOIN content_field_archive_term_view_display node_data_field_archive_term_view_display ON node.vid = node_data_field_archive_term_view_display.vid | |
| LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid | |
| WHERE node.type in ('archive_second_level_term_page', 'archive_top_level_term_page') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment