Show results on results page even before the form has been completed MSQL error.

Hi.

I would like to have the result plage show all the possible results. I have checked off the right box in Adanced, but I get an 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 ') ) count_alias' at line 5 query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node LEFT JOIN content_type

This is what I get from the Finder Export:

array(
'finder_id' => '8',
'base' => 'views',
'title' => 'Our Home Styles',
'description' => 'The home page \"I\'m looking for a\" form',
'path' => 'finder/8',
'block' => '1',
'settings' => array(
'form_on_page' => 0,
'form' => array(
'prefix' => '',
'prefix_format' => '2',
'suffix' => '',
'suffix_format' => '2',
'button_text' => 'Find',
'go_text' => 'Go',
),
'advanced' => array(
'no_results' => array(
'no_results' => 'There are no results to display',
),
'filter' => 1,
'validate_empty' => 1,
'submission' => 1,
'ahah' => 0,
'ahah_effect' => 'none',
'ahah_remote' => 0,
'element_combination' => '0',
'pager' => '10',
'goto' => '',
'hide_args' => 0,
'arg_sep' => ',',
'empty_symbol' => '',
'show_links' => 1,
'show_admin_links' => 1,
'cache_finder_find' => '0',
'search' => '0',
'search_tab' => 'node',
),
'views' => array(
'view' => 'home_style_lists',
'displays' => array(
'query' => 'block_1',
'output' => 'block_1',
),
'results' => '0',
'views_args' => array(
'args' => 'Condominium',
'delimiter' => '/',
),
'empty_text' => 1,
),
),
'elements' => array(
'0' => array(
'finder_element_id' => '9',
'finder_id' => '8',
'element' => 'buttons',
'title' => 'I\'m looking for a:',
'weight' => '0',
'settings' => array(
'form' => array(
'description' => '',
'prefix' => '',
'prefix_format' => '2',
'suffix' => '',
'suffix_format' => '2',
'default_value' => '',
'required' => 1,
'multiple' => 1,
'empty' => '',
'empty_text' => '',
),
'choices' => array(
'field' => array(
'node_data_field_home_style.field_home_style_value' => 'node_data_field_home_style.field_home_style_value',
),
'rewrite' => array(
'php' => '',
),
'displays' => array(
'query' => 'default',
),
'views' => array(
'args' => '',
'delimiter' => '/',
),
),
'advanced' => array(
'delimit' => '',
'field_combination' => '0',
'value_combination' => '0',
'nesting_order' => '0',
'match' => 'e',
),
),
'element_handler' => array(
'#title' => 'Check boxes/radio buttons',
'#module' => 'finder_optionwidgets',
),
'#_finder_object' => '1',
),
),
'elements_index' => array(
'9' => 0,
),
'base_handler' => array(
'#title' => 'Views finder',
'#module' => 'finder_views',
),
'admin_links' => array(
'finder/8' => 'View \"Path\"',
'admin/build/finder/8/edit' => 'Edit',
),
'links' => array(),
'#_finder_object' => '1',
)

Thanks for any help!