SQL statement that failed below: <br />
---------------------------------------------------------<br />
SELECT listingsdbelements_field_value, count(listingsdbelements_field_value) AS num_type FROM default_en_listingsdbelements, default_en_listingsdb WHERE listingsdbelements_field_name = 'FEATURE_CODES' AND listingsdb_active = 'yes' AND listingsdbelements_field_value <> '' AND default_en_listingsdbelements.listingsdb_id = default_en_listingsdb.listingsdb_id GROUP BY default_en_listingsdbelements.listingsdbelements_field_value ORDER BY listingsdbelements_field_value ASC <br />
<br />
---------------------------------------------------------<br />
<br />
ERROR REPORT www.homescondoflorida.com: September 9, 2010, 2:19:55 am<br />
<br />
---------------------------------------------------------<br />
SQL ERROR: SELECT listingsdbelements_field_value, count(listingsdbelements_field_value) AS num_type FROM default_en_listingsdbelements, default_en_listingsdb WHERE listingsdbelements_field_name = 'FEATURE_CODES' AND listingsdb_active = 'yes' AND listingsdbelements_field_value <> '' AND default_en_listingsdbelements.listingsdb_id = default_en_listingsdb.listingsdb_id GROUP BY default_en_listingsdbelements.listingsdbelements_field_value ORDER BY listingsdbelements_field_value ASC <br />
Server Type: Apache<br />
Request Method: GET<br />
Query String: action=searchresults&city_id[]=Y22827&sortby=listingsdb_featured,random&sorttype=DESC,ASC&LEGAL[]=&PROPERTY_TYPE_CODE=M&searchtext=&sale_price-min=700000&sale_price-max=800000&bedrooms=&baths_total=<br />
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)<br />
Request URI: /index.php?action=searchresults&city_id[]=Y22827&sortby=listingsdb_featured,random&sorttype=DESC,ASC&LEGAL[]=&PROPERTY_TYPE_CODE=M&searchtext=&sale_price-min=700000&sale_price-max=800000&bedrooms=&baths_total=<br />
POST Variables: array (<br />
)<br />
GET Variables: array (<br />
  'action' => 'searchresults',<br />
  'city_id' => <br />
  array (<br />
    0 => 'Y22827',<br />
  ),<br />
  'sortby' => 'listingsdb_featured,random',<br />
  'sorttype' => 'DESC,ASC',<br />
  'LEGAL' => <br />
  array (<br />
    0 => '',<br />
  ),<br />
  'PROPERTY_TYPE_CODE' => 'M',<br />
  'searchtext' => '',<br />
  'sale_price-min' => '700000',<br />
  'sale_price-max' => '800000',<br />
  'bedrooms' => '',<br />
  'baths_total' => '',<br />
  'printer_friendly' => false,<br />
  'cur_page' => 0,<br />
  'pclass' => '',<br />
)<br />