----- Original Message -----
Sent: Saturday, March 13, 2010
3:41 PM
Subject: [support] Need help with
RSS Views
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
--
[ Drupal support list | http://lists.drupal.org/ ]
No virus found in this incoming message.
Checked by AVG
- www.avg.com
Version: 8.5.436 / Virus Database: 271.1.1/2742 - Release Date:
03/12/10 19:33:00