Share |

Articles in "News"

user warning: Incorrect key file for table '/ramdisk/mysql/tmp/#sql_4c9b_1.MYI'; try to repair it query: SELECT node.nid AS nid, node_data_field_thumbnail_image.field_thumbnail_image_fid AS node_data_field_thumbnail_image_field_thumbnail_image_fid, node_data_field_thumbnail_image.field_thumbnail_image_list AS node_data_field_thumbnail_image_field_thumbnail_image_list, node_data_field_thumbnail_image.field_thumbnail_image_data AS node_data_field_thumbnail_image_field_thumbnail_image_data, node.language AS node_language, node.type AS node_type, node.vid AS node_vid, node_data_field_main_image.field_main_image_fid AS node_data_field_main_image_field_main_image_fid, node_data_field_main_image.field_main_image_list AS node_data_field_main_image_field_main_image_list, node_data_field_main_image.field_main_image_data AS node_data_field_main_image_field_main_image_data, node.created AS node_created, node.title AS node_title, node_node_data_field_op_author.title AS node_node_data_field_op_author_title, node_node_data_field_op_author.nid AS node_node_data_field_op_author_nid, node_node_data_field_op_author.language AS node_node_data_field_op_author_language, node_node_data_field_op_author_1.title AS node_node_data_field_op_author_1_title, node_node_data_field_op_author_1.nid AS node_node_data_field_op_author_1_nid, node_node_data_field_op_author_1.language AS node_node_data_field_op_author_1_language, node_data_field_teaser.field_teaser_value AS node_data_field_teaser_field_teaser_value, node_data_field_teaser.field_teaser_format AS node_data_field_teaser_field_teaser_format, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.sticky AS node_sticky FROM node node LEFT JOIN content_field_op_author node_data_field_op_author ON node.vid = node_data_field_op_author.vid AND node_data_field_op_author.delta = 0 LEFT JOIN node node_node_data_field_op_author ON node_data_field_op_author.field_op_author_nid = node_node_data_field_op_author.nid LEFT JOIN content_field_op_author node_data_field_op_author2 ON node.vid = node_data_field_op_author2.vid AND node_data_field_op_author2.delta = 1 LEFT JOIN node node_node_data_field_op_author_1 ON node_data_field_op_author2.field_op_author_nid = node_node_data_field_op_author_1.nid LEFT JOIN term_node term_node ON node.vid = term_node.vid INNER JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN vocabulary vocabulary ON term_data.vid = vocabulary.vid LEFT JOIN content_type_article node_data_field_thumbnail_image ON node.vid = node_data_field_thumbnail_image.vid LEFT JOIN content_field_main_image node_data_field_main_image ON node.vid = node_data_field_main_image.vid LEFT JOIN content_field_teaser node_data_field_teaser ON node.vid = node_data_field_teaser.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.type in ('article')) AND (node.status <> 0) AND (term_data.name = 'News') AND (vocabulary.vid = '43') ORDER BY node_sticky DESC, node_created DESC, node_title ASC LIMIT 2625, 25 in /home1/hostinl0/public_html/lagrangepublishing/openpublish/sites/all/modules/views/includes/view.inc on line 771.