I really can't figure out why the 3 link which is for Roskilde do show ALL
the nodes instead of ONLY for Roskilde. Hope someone can help. I have copied
a lot of info that maybe can help you.
København = 6
SELECT node.nid AS nid, node.created AS node_created FROM node node INNER
JOIN term_node term_node ON node.vid = term_node.vid
WHERE (node.status <> 0) AND (node.type in ('copenhagen')) AND
(term_node.tid = 6) ORDER BY node_created DESC
nid vid tid
1090 1091 6 -------------- Content type Copenhagen
1095 1096 6 -------------- Content type Copenhagen
1098 1099 6 -------------- Content type Copenhagen
1099 1100 6 -------------- Content type Copenhagen
1100 1101 6 -------------- Content type Copenhagen
1145 1146 6 -------------- Content type Copenhagen
1182 1183 6 -------------- Content type Kommune ----------- alternative URL
node/6 - THIS SHOULD NOT BE SHOWED ON RSS
-------------------------
Odense = 7
SELECT node.nid AS nid, node.created AS node_created FROM node node INNER
JOIN term_node term_node ON node.vid = term_node.vid
WHERE (node.status <> 0) AND (node.type in ('copenhagen')) AND
(term_node.tid = 7) ORDER BY node_created DESC
nid vid tid
1157 1158 7 -------------- Content type Copenhagen
1158 1159 7 -------------- Content type Copenhagen
1159 1160 7 -------------- Content type Copenhagen
1183 1184 7 -------------- Content type Kommune ----------- alternative URL
node/7 - THIS SHOULD NOT BE SHOWED ON RSS
-------------------------
Roskilde = 8
SELECT node.nid AS nid, node.created AS node_created FROM node node INNER
JOIN term_node term_node ON node.vid = term_node.vid
WHERE (node.status <> 0) AND (node.type in ('copenhagen')) AND
(term_node.tid = 8) ORDER BY node_created DESC
nid vid tid
1160 1161 8 -------------- Content type Copenhagen
1161 1162 8 -------------- Content type Copenhagen
1162 1163 8 -------------- Content type Copenhagen
1184 1185 8 -------------- Content type Kommune ----------- alternative URL
node/8 - THIS SHOULD NOT BE SHOWED ON RSS
Need help with RSS Views
Need help with RSS Views