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
Comment #1
mustanggb commented