Morning
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid),
node.title AS node_title,
node_data_field_teacher.fiel' at line 1
query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid),
node.title AS node_title,
node_data_field_teacher.field_teacher_value AS node_data_field_teacher_field_teacher_value,
node_data_field_teacher.nid AS node_data_field_teacher_nid,
node.type AS node_type,
node_data_field_description.field_description_value AS node_data_field_description_field_description_value,
node_data_field_description.field_description_format AS node_data_field_description_field_description_format,
node_data_field_description.nid AS node_data_field_description_nid,
node_data_field_cat_value_0.field_cat_value AS node_data_field_cat_value_0_field_cat_value
FROM node node
LEFT JOIN content_field_cat node_data_field_cat_value_0 ON node.vid = node_data_field_cat_value_0.vid AND node_data_field_cat_value_0.field_cat_value = 'AM'
LEFT JOIN content_field_cat node_data_field_cat_value_1 ON node.vid = node_data_field_cat_value_1.vid AND node_data_field_cat_value_1.field_cat_value = 'PM'
INNER JOIN content_type_course node_data_field_event ON node.vid = node_data_field_event.vid
LEFT JOIN content_type_course node_data_field_teacher ON node.vid = node_data_field_teacher.vid
LEFT JOIN content_field_description node_data_field_description ON node.vid = node_data_field_description.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 = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type in ('course')) AND (node_data_field_cat_value_0.field_cat_value = 'AM' OR node_data_field_cat_value_1.field_cat_value = 'PM') AND (node_data_field_event.field_event_value = 'si2009') AND (node_data_field_cat_value_0.field_cat_value = 'js')
)ORDER BY node_data_field_cat_value_0_field_cat_value ASC
in /home/havurah/production/sites/all/modules/views/includes/view.inc on line 729.
