newproducts
Submitted by administrator on 2006, February 26 - 5:41am. ::
test
Price: RM 500.00
user error: Unknown column 'n.nid' in 'on clause'
query: SELECT DISTINCT(n.nid), e.event_start FROM event e INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON n.nid = e.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0')) AND n.status = 1 AND ((e.event_start > 1277913600 AND e.event_start < 1280591999) OR (e.event_end > 1277913600 AND e.event_end < 1280591999) OR (e.event_start < 1277913600 AND e.event_end > 1280591999)) ORDER BY event_start in /home/joeynor/public_html/includes/database.mysql.inc on line 66.user error: Column 'nid' in from clause is ambiguous
query: SELECT DISTINCT(n.nid), n.title, n.type, n.status, n.moderate, e.event_start FROM node n INNER JOIN node_access na ON na.nid = n.nid INNER JOIN event e USING (nid) WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0')) AND n.status = 1 AND n.moderate = 0 AND e.event_start >= 1280501545 ORDER BY event_start LIMIT 0, 6 in /home/joeynor/public_html/includes/database.mysql.inc on line 66.