Reply to comment
- User warning: Got error 28 from storage engine
query: SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 876 ORDER BY v.weight, t.weight, t.name in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).
- User warning: Got error 28 from storage engine
query: SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 4555 ORDER BY v.weight, t.weight, t.name in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).
- User warning: Got error 28 from storage engine
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
node.title AS node_title,
node.sticky AS node_sticky,
node_data_field_class_year.field_class_year_value AS node_data_field_class_year_field_class_year_value,
node_data_field_class_year.field_class_semester_value AS node_data_field_class_year_field_class_semester_value,
node.created AS node_created
FROM node node
LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
LEFT JOIN content_type_class_material node_data_field_class ON node.vid = node_data_field_class.vid
LEFT JOIN content_type_class node_data_field_class_year ON node.vid = node_data_field_class_year.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 = 'og_public'))) AND ( (node.status <> 0 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (og_ancestry.group_nid = 865) AND (node_data_field_class.field_class_nid = 4434)
)GROUP BY nid
ORDER BY node_sticky DESC, node_data_field_class_year_field_class_year_value DESC, node_data_field_class_year_field_class_semester_value ASC, node_created DESC
) count_alias in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).
- User warning: Got error 28 from storage engine
query: SELECT DISTINCT(node.nid) AS nid,
node.title AS node_title,
node.sticky AS node_sticky,
node_data_field_class_year.field_class_year_value AS node_data_field_class_year_field_class_year_value,
node_data_field_class_year.field_class_semester_value AS node_data_field_class_year_field_class_semester_value,
node.created AS node_created
FROM node node
LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
LEFT JOIN content_type_class_material node_data_field_class ON node.vid = node_data_field_class.vid
LEFT JOIN content_type_class node_data_field_class_year ON node.vid = node_data_field_class_year.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 = 'og_public'))) AND ( (node.status <> 0 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (og_ancestry.group_nid = 865) AND (node_data_field_class.field_class_nid = 4434)
)GROUP BY nid
ORDER BY node_sticky DESC, node_data_field_class_year_field_class_year_value DESC, node_data_field_class_year_field_class_semester_value ASC, node_created DESC
LIMIT 0, 10 in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).