Search using Views filters and error in SQL syntax - please help.

Hello there,

Let me preface my request by saying that I'm not a programmer so I really don't understand much of what the error is trying to indicate. If the error is on my part, please let me know how I can correct it via the Views settings. I've attached the entire exported view as well as the query as per posting guidelines.
Thanks for any assistance provided.
After an upgrade from 2.3 to 2.4, a search that was created in Views is now giving me the following error:

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS score, node.title AS node_title, node.type AS node_type, node.vid ' at line 2 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, SUM(search_index.score * .count) AS score, node.title AS node_title, node.type AS node_type, node.vid AS node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value FROM node node LEFT JOIN search_index search_index ON node.nid = search_index.sid LEFT JOIN search_total ON search_index.word = .word WHERE (node.status <> 0) AND (node.type in ('druglisting')) AND (search_index.word = 'kuvan') AND (search_index.type = 'search_index') GROUP BY search_index.sid, node_title, nid, node_type, node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value HAVING COUNT(*) >= 1 ORDER BY node_title ASC ) count_alias in /services7/webpages/d/p/dpic.org/public/_testsite/sites/all/modules/views/includes/view.inc on line 705.

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS score, node.title AS node_title, node.type AS node_type, node.vid ' at line 2 query: SELECT DISTINCT(node.nid) AS nid, SUM(search_index.score * .count) AS score, node.title AS node_title, node.type AS node_type, node.vid AS node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value FROM node node LEFT JOIN search_index search_index ON node.nid = search_index.sid LEFT JOIN search_total ON search_index.word = .word WHERE (node.status <> 0) AND (node.type in ('druglisting')) AND (search_index.word = 'kuvan') AND (search_index.type = 'search_index') GROUP BY search_index.sid, node_title, nid, node_type, node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value HAVING COUNT(*) >= 1 ORDER BY node_title ASC LIMIT 0, 36 in /services7/webpages/d/p/dpic.org/public/_testsite/sites/all/modules/views/includes/view.inc on line 731.

Here is the exported view:

$view = new view;
$view->name = 'druglisting_glossary';
$view->description = 'A list of all druglisting content, by letter.';
$view->tag = 'default';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'title' => array(
    'label' => 'Title',
    'link_to_node' => 1,
    'exclude' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'relationship' => 'none',
  ),
  'field_tradename_value' => array(
    'label' => 'Trade Name',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 0,
    'id' => 'field_tradename_value',
    'table' => 'node_data_field_tradename',
    'field' => 'field_tradename_value',
    'relationship' => 'none',
  ),
  'field_class_value' => array(
    'label' => 'Classification',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 0,
    'id' => 'field_class_value',
    'table' => 'node_data_field_class',
    'field' => 'field_class_value',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'field_atc_value' => array(
    'id' => 'field_atc_value',
    'table' => 'node_data_field_atc',
    'field' => 'field_atc_value',
  ),
  'field_class_value_1' => array(
    'id' => 'field_class_value_1',
    'table' => 'node_data_field_class',
    'field' => 'field_class_value',
  ),
  'field_comments_value' => array(
    'id' => 'field_comments_value',
    'table' => 'node_data_field_comments',
    'field' => 'field_comments_value',
  ),
  'field_marketed_value' => array(
    'id' => 'field_marketed_value',
    'table' => 'node_data_field_marketed',
    'field' => 'field_marketed_value',
  ),
  'field_furtherinfo_value' => array(
    'id' => 'field_furtherinfo_value',
    'table' => 'node_data_field_furtherinfo',
    'field' => 'field_furtherinfo_value',
  ),
  'field_keywords_value' => array(
    'id' => 'field_keywords_value',
    'table' => 'node_data_field_keywords',
    'field' => 'field_keywords_value',
  ),
  'field_manufacturer_value' => array(
    'id' => 'field_manufacturer_value',
    'table' => 'node_data_field_manufacturer',
    'field' => 'field_manufacturer_value',
  ),
  'field_noc_value' => array(
    'id' => 'field_noc_value',
    'table' => 'node_data_field_noc',
    'field' => 'field_noc_value',
  ),
  'field_presentation_value' => array(
    'id' => 'field_presentation_value',
    'table' => 'node_data_field_presentation',
    'field' => 'field_presentation_value',
  ),
  'field_source_value' => array(
    'id' => 'field_source_value',
    'table' => 'node_data_field_source',
    'field' => 'field_source_value',
  ),
  'field_synonym_value' => array(
    'id' => 'field_synonym_value',
    'table' => 'node_data_field_synonym',
    'field' => 'field_synonym_value',
  ),
  'field_tradename_value_1' => array(
    'id' => 'field_tradename_value_1',
    'table' => 'node_data_field_tradename',
    'field' => 'field_tradename_value',
  ),
));
$handler->override_option('arguments', array(
  'title' => array(
    'default_action' => 'default',
    'style_plugin' => 'default_summary',
    'style_options' => array(),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'default_argument_type' => 'fixed',
    'default_argument' => '',
    'validate_type' => 'none',
    'validate_fail' => 'not found',
    'glossary' => 1,
    'limit' => '1',
    'case' => 'upper',
    'path_case' => 'lower',
    'transform_dash' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'relationship' => 'none',
    'default_argument_user' => 0,
    'default_argument_fixed' => 'a',
    'default_argument_php' => '',
    'validate_argument_vocabulary' => array(
      '2' => 0,
      '19' => 0,
      '22' => 0,
      '23' => 0,
      '20' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_php' => '',
    'default_options_div_prefix' => '',
    'validate_argument_node_type' => array(
      'faq' => 0,
      'weblinks' => 0,
      'book' => 0,
      'ddbimage' => 0,
      'ddbtext' => 0,
      'dir_monograph' => 0,
      'druglisting' => 0,
      'page' => 0,
      'pmm_monograph' => 0,
      'redirect' => 0,
      'simplenews' => 0,
      'story' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'user_argument_type' => '',
    'restrict_user_roles' => 0,
    'user_roles' => array(),
  ),
));
$handler->override_option('filters', array(
  'status' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'status',
    'table' => 'node',
    'field' => 'status',
    'relationship' => 'none',
  ),
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'druglisting' => 'druglisting',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
  'role' => array(),
  'perm' => '',
));
$handler->override_option('title', 'Drug Listings');
$handler->override_option('use_ajax', '1');
$handler->override_option('items_per_page', 36);
$handler->override_option('use_pager', '1');
$handler->override_option('distinct', 0);
$handler->override_option('row_plugin', 'node');
$handler->override_option('row_options', array(
  'teaser' => 1,
  'links' => 1,
  'comments' => 0,
));
$handler = $view->new_display('page', 'Page', 'page');
$handler->override_option('fields', array(
  'title' => array(
    'label' => 'Generic Name',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 1,
    'exclude' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'field_tradename_value' => array(
    'label' => 'Trade Name',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 0,
    'id' => 'field_tradename_value',
    'table' => 'node_data_field_tradename',
    'field' => 'field_tradename_value',
    'relationship' => 'none',
  ),
  'field_class_value' => array(
    'label' => 'Classification',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 0,
    'id' => 'field_class_value',
    'table' => 'node_data_field_class',
    'field' => 'field_class_value',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'field_atc_value' => array(
    'label' => 'ATC Class',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 1,
    'id' => 'field_atc_value',
    'table' => 'node_data_field_atc',
    'field' => 'field_atc_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_comments_value' => array(
    'label' => 'Comments',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 1,
    'id' => 'field_comments_value',
    'table' => 'node_data_field_comments',
    'field' => 'field_comments_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_marketed_value' => array(
    'label' => 'Date Marketed',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 1,
    'id' => 'field_marketed_value',
    'table' => 'node_data_field_marketed',
    'field' => 'field_marketed_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_furtherinfo_value' => array(
    'label' => 'Further Information',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 1,
    'id' => 'field_furtherinfo_value',
    'table' => 'node_data_field_furtherinfo',
    'field' => 'field_furtherinfo_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_keywords_value' => array(
    'label' => 'Keywords',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 1,
    'id' => 'field_keywords_value',
    'table' => 'node_data_field_keywords',
    'field' => 'field_keywords_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_manufacturer_value' => array(
    'label' => 'Manufacturer/Distributor',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 1,
    'id' => 'field_manufacturer_value',
    'table' => 'node_data_field_manufacturer',
    'field' => 'field_manufacturer_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_noc_value' => array(
    'label' => 'Notice of Compliance',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 1,
    'id' => 'field_noc_value',
    'table' => 'node_data_field_noc',
    'field' => 'field_noc_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_presentation_value' => array(
    'label' => 'Presentation',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 1,
    'id' => 'field_presentation_value',
    'table' => 'node_data_field_presentation',
    'field' => 'field_presentation_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_source_value' => array(
    'label' => 'Source',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 1,
    'id' => 'field_source_value',
    'table' => 'node_data_field_source',
    'field' => 'field_source_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'field_synonym_value' => array(
    'label' => 'Synonym(s)',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 1,
    'id' => 'field_synonym_value',
    'table' => 'node_data_field_synonym',
    'field' => 'field_synonym_value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array());
$handler->override_option('filters', array(
  'status' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'status',
    'table' => 'node',
    'field' => 'status',
    'relationship' => 'none',
  ),
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'druglisting' => 'druglisting',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'relationship' => 'none',
  ),
  'field_status_value_many_to_one' => array(
    'operator' => 'or',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'field_status_value_many_to_one_op',
      'identifier' => 'field_status_value_many_to_one',
      'label' => 'Product status:',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'field_status_value_many_to_one',
    'table' => 'node_data_field_status',
    'field' => 'field_status_value_many_to_one',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
    'reduce_duplicates' => 1,
  ),
  'keys' => array(
    'operator' => 'optional',
    'value' => '',
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'keys_op',
      'identifier' => 'keys',
      'label' => 'Keywords:',
      'optional' => 1,
      'remember' => 0,
    ),
    'id' => 'keys',
    'table' => 'search_index',
    'field' => 'keys',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 1,
  'sticky' => 1,
  'order' => 'asc',
  'columns' => array(
    'title' => 'title',
    'field_tradename_value' => 'field_tradename_value',
    'field_class_value' => 'field_class_value',
    'field_atc_value' => 'field_atc_value',
    'field_comments_value' => 'field_comments_value',
    'field_marketed_value' => 'field_marketed_value',
    'field_furtherinfo_value' => 'field_furtherinfo_value',
    'field_keywords_value' => 'field_keywords_value',
    'field_manufacturer_value' => 'field_manufacturer_value',
    'field_noc_value' => 'field_noc_value',
    'field_presentation_value' => 'field_presentation_value',
    'field_source_value' => 'field_source_value',
    'field_synonym_value' => 'field_synonym_value',
  ),
  'info' => array(
    'title' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'field_tradename_value' => array(
      'separator' => '',
    ),
    'field_class_value' => array(
      'separator' => '',
    ),
    'field_atc_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_comments_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_marketed_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_furtherinfo_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_keywords_value' => array(
      'separator' => '',
    ),
    'field_manufacturer_value' => array(
      'separator' => '',
    ),
    'field_noc_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_presentation_value' => array(
      'separator' => '',
    ),
    'field_source_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_synonym_value' => array(
      'separator' => '',
    ),
  ),
  'default' => 'title',
));
$handler->override_option('row_plugin', 'fields');
$handler->override_option('row_options', array());
$handler->override_option('path', 'druglistings');
$handler->override_option('menu', array(
  'type' => 'normal',
  'title' => 'Drug Listings',
  'description' => 'DPIC list of new drug products',
  'weight' => '0',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));

and here is the query code:

SELECT node.nid AS nid,
   SUM(search_index.score * .count) AS score,
   node.title AS node_title,
   node.type AS node_type,
   node.vid AS node_vid,
   field_atc_value,
   field_comments_value,
   field_marketed_value,
   field_furtherinfo_value,
   field_noc_value,
   field_source_value
 FROM node node 
 LEFT JOIN search_index search_index ON node.nid = search_index.sid
 LEFT JOIN search_total  ON search_index.word = .word
 WHERE (node.status <> 0) AND (node.type in ('druglisting')) AND (search_index.word = 'kuvan') AND (search_index.type = 'search_index')
 GROUP BY search_index.sid, node_title, nid, node_type, node_vid, field_atc_value, field_comments_value, field_marketed_value, field_furtherinfo_value, field_noc_value, field_source_value
 HAVING COUNT(*) >= 1
 ORDER BY node_title ASC