User account
user warning: Got error 28 from storage engine
query: SELECT DISTINCT(node.nid) AS nid,
node_data_field_image_main.field_image_main_fid AS node_data_field_image_main_field_image_main_fid,
node_data_field_image_main.field_image_main_list AS node_data_field_image_main_field_image_main_list,
node_data_field_image_main.field_image_main_data AS node_data_field_image_main_field_image_main_data,
node.type AS node_type,
node.vid AS node_vid,
node.title AS node_title,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
node_counter.daycount AS node_counter_daycount,
node_counter.totalcount AS node_counter_totalcount,
DATE_FORMAT(FROM_UNIXTIME(node.created), '%Y%m%d%H%i') AS node_created_minute,
node.nid AS node_nid
FROM node node
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 content_field_image_main node_data_field_image_main ON node.vid = node_data_field_image_main.vid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid
WHERE (node.type in ('advpoll_binary', 'blog', 'book', 'poll', 'story', 'video_story', 'webform')) AND (node.moderate = 0) AND (node.status = 1) AND ((term_data.name) != ('test yourself'))
GROUP BY nid
ORDER BY node_counter_daycount DESC, node_counter_totalcount DESC, node_created_minute DESC, node_nid DESC
LIMIT 0, 4 in /var/www/vhosts/nailpro.com/httpdocs/modules/views/includes/view.inc on line 810.
