Bands by popularity

  • user warning: Got error 28 from storage engine query: SELECT DISTINCT node.nid AS nid, node_data_field_partner_link.field_partner_link_url AS node_data_field_partner_link_field_partner_link_url, node_data_field_partner_link.field_partner_link_title AS node_data_field_partner_link_field_partner_link_title, node_data_field_partner_link.field_partner_link_attributes AS node_data_field_partner_link_field_partner_link_attributes, node.type AS node_type, node.vid AS node_vid, node_data_field_partner_link.field_banner_image_fid AS node_data_field_partner_link_field_banner_image_fid, node_data_field_partner_link.field_banner_image_list AS node_data_field_partner_link_field_banner_image_list, node_data_field_partner_link.field_banner_image_data AS node_data_field_partner_link_field_banner_image_data, RAND() AS _random FROM node node LEFT JOIN content_type_partnership node_data_field_partner_link ON node.vid = node_data_field_partner_link.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 = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND (((SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND gid=0 AND realm='all') > 0) OR ((SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND realm IN ('workflow_access','workflow_access_owner')) = 0 OR (SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND ((gid=1 AND realm='workflow_access') OR (gid=0 AND realm='workflow_access_owner'))) > 0) AND ((SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND realm IN ('forum_access')) = 0 OR (SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND ((gid=1 AND realm='forum_access'))) > 0)) AND ( (node.type in ('partnership')) AND (node.status <> 0) )ORDER BY _random ASC LIMIT 0, 3 in /home/sander/sites/got-djent/sites/all/modules/views/includes/view.inc on line 771.
  • user warning: Got error 28 from storage engine query: SELECT DISTINCT node.nid AS nid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node_data_field_eyecatcher_link.field_eyecatcher_link_url AS node_data_field_eyecatcher_link_field_eyecatcher_link_url, node_data_field_eyecatcher_link.field_eyecatcher_link_title AS node_data_field_eyecatcher_link_field_eyecatcher_link_title, node_data_field_eyecatcher_link.field_eyecatcher_link_attributes AS node_data_field_eyecatcher_link_field_eyecatcher_link_attributes, node.type AS node_type, node.vid AS node_vid, node_data_field_eyecatcher_link.field_eyecatcher_image_fid AS node_data_field_eyecatcher_link_field_eyecatcher_image_fid, node_data_field_eyecatcher_link.field_eyecatcher_image_list AS node_data_field_eyecatcher_link_field_eyecatcher_image_list, node_data_field_eyecatcher_link.field_eyecatcher_image_data AS node_data_field_eyecatcher_link_field_eyecatcher_image_data, RAND() AS _random FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_eyecatcher node_data_field_eyecatcher_link ON node.vid = node_data_field_eyecatcher_link.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 = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND (((SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND gid=0 AND realm='all') > 0) OR ((SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND realm IN ('workflow_access','workflow_access_owner')) = 0 OR (SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND ((gid=1 AND realm='workflow_access') OR (gid=0 AND realm='workflow_access_owner'))) > 0) AND ((SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND realm IN ('forum_access')) = 0 OR (SELECT COUNT(1) FROM node_access nasq WHERE na.nid=nasq.nid AND ((gid=1 AND realm='forum_access'))) > 0)) AND ( (node.type in ('eyecatcher')) AND (node.status <> 0) )ORDER BY _random ASC LIMIT 0, 1 in /home/sander/sites/got-djent/sites/all/modules/views/includes/view.inc on line 771.