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,default_classlistingsdb  WHERE listingsdbelements_field_name = 'Rent' AND listingsdb_active = 'yes' AND listingsdbelements_field_value <> '' AND default_en_listingsdbelements.listingsdb_id = default_en_listingsdb.listingsdb_id AND default_en_listingsdb.listingsdb_id = default_classlistingsdb.listingsdb_id  AND (default_classlistingsdb.class_id = 5)GROUP BY default_en_listingsdbelements.listingsdbelements_field_value ORDER BY CAST(listingsdbelements_field_value as int4) ASC <br />
<br />
---------------------------------------------------------<br />
<br />
ERROR REPORT six-rivers.com: July 27, 2024, 7:53:57 am<br />
<br />
---------------------------------------------------------<br />
SQL ERROR: SELECT listingsdbelements_field_value, count(listingsdbelements_field_value) AS num_type FROM default_en_listingsdbelements, default_en_listingsdb,default_classlistingsdb  WHERE listingsdbelements_field_name = 'Rent' AND listingsdb_active = 'yes' AND listingsdbelements_field_value <> '' AND default_en_listingsdbelements.listingsdb_id = default_en_listingsdb.listingsdb_id AND default_en_listingsdb.listingsdb_id = default_classlistingsdb.listingsdb_id  AND (default_classlistingsdb.class_id = 5)GROUP BY default_en_listingsdbelements.listingsdbelements_field_value ORDER BY CAST(listingsdbelements_field_value as int4) ASC <br />
Server Type: Apache<br />
Request Method: GET<br />
Query String: action=search_step_2&pclass%5B%5D=5<br />
User Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)<br />
Request URI: /index.php?action=search_step_2&pclass%5B%5D=5<br />
POST Variables: array (<br />
)<br />
GET Variables: array (<br />
  'action' => 'search_step_2',<br />
  'pclass' => <br />
  array (<br />
    0 => '5',<br />
  ),<br />
  'printer_friendly' => false,<br />
)<br />