SQL statement that failed below:
---------------------------------------------------------
SELECT distinct(default_en_listingsdb.listingsdb_id), default_en_listingsdb.userdb_id, default_en_listingsdb.listingsdb_title FROM default_en_listingsdb ,default_en_listingsdbelements status ,default_en_listingsdbelements sort0 ,default_classlistingsdb WHERE (listingsdb_active = 'yes') AND (default_en_listingsdb.listingsdb_id = status.listingsdb_id) AND (default_en_listingsdb.listingsdb_id = sort0.listingsdb_id) AND (status.listingsdbelements_field_name = 'status' AND status.listingsdbelements_field_value = 'Active') AND (default_classlistingsdb.class_id = 2) AND default_classlistingsdb.listingsdb_id = default_en_listingsdb.listingsdb_id AND (sort0.listingsdbelements_field_name = 'beds') ORDER BY sort0.listingsdbelements_field_value ASC

---------------------------------------------------------

ERROR REPORT austinrealty.on.ca: March 28, 2024, 5:02:02 am

---------------------------------------------------------
SQL ERROR: SELECT distinct(default_en_listingsdb.listingsdb_id), default_en_listingsdb.userdb_id, default_en_listingsdb.listingsdb_title FROM default_en_listingsdb ,default_en_listingsdbelements status ,default_en_listingsdbelements sort0 ,default_classlistingsdb WHERE (listingsdb_active = 'yes') AND (default_en_listingsdb.listingsdb_id = status.listingsdb_id) AND (default_en_listingsdb.listingsdb_id = sort0.listingsdb_id) AND (status.listingsdbelements_field_name = 'status' AND status.listingsdbelements_field_value = 'Active') AND (default_classlistingsdb.class_id = 2) AND default_classlistingsdb.listingsdb_id = default_en_listingsdb.listingsdb_id AND (sort0.listingsdbelements_field_name = 'beds') ORDER BY sort0.listingsdbelements_field_value ASC
Server Type: Apache
Request Method: GET
Query String: action=searchresults&sortby=beds&sorttype=ASC&status=Active&pclass[]=2
User Agent: claudebot
Request URI: /realty/index.php?action=searchresults&sortby=beds&sorttype=ASC&status=Active&pclass[]=2
POST Variables: array (
)
GET Variables: array (
'action' => 'searchresults',
'sortby' => 'beds',
'sorttype' => 'ASC',
'status' => 'Active',
'pclass' =>
array (
0 => '2',
),
'printer_friendly' => false,
'cur_page' => 0,
)