user warning: Unknown column 'khanna' in 'where clause'
query:
SELECT node.nid AS nid, term_data.name AS term_data_name,
term_data.vid AS term_data_vid, term_data.tid AS term_data_tid,
node.language AS node_language, node.type AS node_type, node.vid AS node_vid,
c.field_image_new_fid,
c.field_image_new_list,
c.field_image_new_data,
c.field_office_location_value,
c.field_office_hours_value,
node_data_field_first_name.field_first_name_value AS fname,
node.title AS node_title, node_data_field_title.field_title_value AS title,
files.filepath,
content_field_telephone.field_telephone_value AS phone,
content_field_email.field_email_value AS email
FROM node node
LEFT JOIN content_type_faculty c ON c.vid = node.vid and node.nid=c.nid
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
LEFT JOIN files ON files.fid = c.field_image_new_fid
LEFT JOIN content_field_first_name node_data_field_first_name ON node.vid = node_data_field_first_name.vid
LEFT JOIN content_field_title node_data_field_title ON node.vid = node_data_field_title.vid
LEFT JOIN content_field_telephone content_field_telephone ON node.vid = content_field_telephone.vid
LEFT JOIN content_field_email content_field_email ON node.vid = content_field_email.vid
WHERE node.type='faculty' and term_data.vid = 6 and term_data.tid=khanna ORDER BY node_title ASC, fname ASC
in /afs/ir.stanford.edu/dept/economics/cgi-bin/www/sites/all/modules/mecon/theme/faculty.tpl.php on line 108.
