Hi all
i'm having problem with (and i don't understand if it is a normal behaviour) referenced content feed item.
I want to show a list of items that has node-reference for checkup if reference is right. When items has one reference view show one node, but when it has more reference it show a repeated number of nodes as how many references it has. But...node in only one....

This is my view:

SELECT node.nid AS nid,
node.title AS node_title,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
node.type AS node_type,
node.uid AS node_uid,
node.vid AS node_vid,
node.created AS node_created,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m%d') AS node_created_day
 FROM node node 
 LEFT JOIN feeds_node_item feeds_node_item ON node.nid = feeds_node_item.nid
 INNER JOIN node node_feeds_node_item ON feeds_node_item.feed_nid = node_feeds_node_item.nid
 LEFT JOIN content_field_corporate_node node_data_field_corporate_node ON node.vid = node_data_field_corporate_node.vid
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (node.type in ('feed_item')) AND (node_data_field_corporate_node.field_corporate_node_nid IS NOT NULL)
   ORDER BY node_created_day DESC

This is a my incorrect setting or what?

Comments

mustanggb’s picture

Issue summary: View changes
Status: Active » Closed (outdated)