Error:
The mysql database returned an error while processing your request.
The SQL statement was: SELECT PX_Listings.id_1, PX_Listings.id_1, PX_Listings.mls_acct, PX_Listings.mls_acct, PX_Listings.city, areas.area_desc, categories.categorydesc, PX_Listings.subdivision, PX_Listings.subdivision, PX_Listings.proj_name, PX_Listings.proj_name, PX_Listings.ftr_waterfront, PX_Listings.ftr_waterview, PX_Listings.category, PX_Listings.year_built, PX_Listings.year_built, PX_Listings.acreage, PX_Listings.acreage, PX_Listings.tot_heat_sqft, PX_Listings.tot_heat_sqft, PX_Listings.bedrooms, PX_Listings.bedrooms, PX_Listings.baths_full, PX_Listings.baths_full, PX_Listings.baths_half, PX_Listings.udf_photo0, PX_Listings.id_1, PX_Listings.id_1, PX_Listings.lo_name, PX_Listings.list_price, PX_Listings.list_price FROM PX_Listings LEFT OUTER JOIN areas ON PX_Listings.area = areas.area_code LEFT OUTER JOIN categories ON PX_Listings.category = categories.categorycode WHERE () OR () ORDER BY PX_Listings.city ASC;
The database returned this: 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 ') OR () ORDER BY PX_Listings.city ASC' at line 1
Other info:
$user_data{PZ_Listings.proj_name}=2[watercolor]
$user_data{_cgifunction}=Search
$user_data{PZ_Listings.category}=1[1]2[1]
$user_data{PZ_Listings.subdivision}=1[watercolor]
$user_data{_layout}=listings-palmerprop