Лучшие загадки и головоломки (по числу голосов)

user warning: Incorrect key file for table '/tmp/#sql_9ec_7.MYI'; try to repair it query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid_1, votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value, node.title AS node_title, node.nid AS nid, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, votingapi_cache_node_percent_vote_count.value AS votingapi_cache_node_percent_vote_count_value, node_data_field_images.field_images_fid AS node_data_field_images_field_images_fid, node_data_field_images.field_images_list AS node_data_field_images_field_images_list, node_data_field_images.field_images_data AS node_data_field_images_field_images_data, node_data_field_images.delta AS node_data_field_images_delta, node.type AS node_type, node.vid AS node_vid FROM gadaika_node node INNER JOIN gadaika_votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average') INNER JOIN gadaika_votingapi_cache votingapi_cache_node_percent_vote_count ON node.nid = votingapi_cache_node_percent_vote_count.content_id AND (votingapi_cache_node_percent_vote_count.content_type = 'node' AND votingapi_cache_node_percent_vote_count.value_type = 'percent' AND votingapi_cache_node_percent_vote_count.tag = 'vote' AND votingapi_cache_node_percent_vote_count.function = 'count') LEFT JOIN gadaika_content_type_story node_data_field_approved ON node.vid = node_data_field_approved.vid LEFT JOIN gadaika_node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN gadaika_content_field_images node_data_field_images ON node.vid = node_data_field_images.vid WHERE (node.status = 1) AND ((node_data_field_approved.field_approved_value) = ('Y')) ORDER BY votingapi_cache_node_percent_vote_count_value DESC, votingapi_cache_node_percent_vote_average_value DESC ) count_alias in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
user warning: Incorrect key file for table '/tmp/#sql_9ec_5.MYI'; try to repair it query: SELECT DISTINCT(node.nid) AS nid_1, votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value, node.title AS node_title, node.nid AS nid, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, votingapi_cache_node_percent_vote_count.value AS votingapi_cache_node_percent_vote_count_value, node_data_field_images.field_images_fid AS node_data_field_images_field_images_fid, node_data_field_images.field_images_list AS node_data_field_images_field_images_list, node_data_field_images.field_images_data AS node_data_field_images_field_images_data, node_data_field_images.delta AS node_data_field_images_delta, node.type AS node_type, node.vid AS node_vid FROM gadaika_node node INNER JOIN gadaika_votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average') INNER JOIN gadaika_votingapi_cache votingapi_cache_node_percent_vote_count ON node.nid = votingapi_cache_node_percent_vote_count.content_id AND (votingapi_cache_node_percent_vote_count.content_type = 'node' AND votingapi_cache_node_percent_vote_count.value_type = 'percent' AND votingapi_cache_node_percent_vote_count.tag = 'vote' AND votingapi_cache_node_percent_vote_count.function = 'count') LEFT JOIN gadaika_content_type_story node_data_field_approved ON node.vid = node_data_field_approved.vid LEFT JOIN gadaika_node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN gadaika_content_field_images node_data_field_images ON node.vid = node_data_field_images.vid WHERE (node.status = 1) AND ((node_data_field_approved.field_approved_value) = ('Y')) ORDER BY votingapi_cache_node_percent_vote_count_value DESC, votingapi_cache_node_percent_vote_average_value DESC LIMIT 1240, 20 in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1191.