Image Gallery
user warning: Unknown column 'node_data_field_image_file.field_image_file_fid' in 'field list'
query: SELECT term_data.tid, term_data.name AS letter, count( DISTINCT(node.nid)) AS num_nodes, node.sticky AS node_sticky, node.title AS node_title, node.changed AS node_changed, node_data_field_image_file.field_image_file_fid AS node_data_field_image_file_field_image_file_fid, node_data_field_image_file.field_image_file_title AS node_data_field_image_file_field_image_file_title, node_data_field_image_file.field_image_file_alt AS node_data_field_image_file_field_image_file_alt FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN content_type_trivia node_data_field_image_file ON node.vid = node_data_field_image_file.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (node.status = '1') AND (node.type IN ('image')) AND (term_data.name IS NOT NULL) ) GROUP BY term_data.name, node_sticky ORDER BY node_sticky ASC LIMIT 0, 30 in /var/www/httpdocs/includes/database.mysql.inc on line 172.
