user warning: Unknown column 'n.nid' in 'on clause'
query: select distinct n.nid,n.title,COALESCE(r.field_thumbnail_value,concat(concat('http://img.youtube.com/vi/',field_url_value),'/2.jpg')) as field_thumbnail_value
from node n,term_node t,term_node t2
left join content_type_content_newsroom r on r.nid=n.nid and r.field_type_value='video'
left join content_field_url v on v.nid=n.nid
where t.nid=n.nid
and ((n.type ='video') or (n.type='content_newsroom' and r.field_type_value='video'))
and t.tid=t2.tid
and t.nid!=t2.nid
and t2.nid='146531'
limit 39 in /home/linksfm/public_html/includes/database.mysql.inc on line 172.
Submitted by Anonymous on Mon, 04/09/2007 - 4:37pm.
