MNN.COM

SELECT node.nid AS nid, node_node_data_field_wst_cause_node_data_field_cause_logo.field_cause_logo_fid AS node_node_data_field_wst_cause_node_data_field_cause_logo_field_cause_logo_fid, node_node_data_field_wst_cause_node_data_field_cause_logo.field_cause_logo_list AS node_node_data_field_wst_cause_node_data_field_cause_logo_field_cause_logo_list, node_node_data_field_wst_cause_node_data_field_cause_logo.field_cause_logo_data AS node_node_data_field_wst_cause_node_data_field_cause_logo_field_cause_logo_data, node_node_data_field_wst_cause.nid AS node_node_data_field_wst_cause_nid, node_node_data_field_wst_cause.type AS node_node_data_field_wst_cause_type, node_node_data_field_wst_cause.vid AS node_node_data_field_wst_cause_vid, node.created AS node_created FROM node node LEFT JOIN content_type_world_share_transaction node_data_field_wst_cause ON node.vid = node_data_field_wst_cause.vid LEFT JOIN node node_node_data_field_wst_cause ON node_data_field_wst_cause.field_wst_cause_nid = node_node_data_field_wst_cause.nid LEFT JOIN content_type_cause node_node_data_field_wst_cause_node_data_field_cause_logo ON node_node_data_field_wst_cause.vid = node_node_data_field_wst_cause_node_data_field_cause_logo.vid WHERE node.type in ('world_share_transaction') ORDER BY node_created DESC