SQL statement that failed below:
---------------------------------------------------------
SELECT distinct(default_de_listingsdb.listingsdb_id), default_de_listingsdb.userdb_id, default_de_listingsdb.listingsdb_title FROM default_de_listingsdb ,default_de_listingsdbelements `sort0` ,default_classlistingsdb WHERE (listingsdb_active = 'yes') AND (default_de_listingsdb.listingsdb_id = `sort0`.listingsdb_id) AND (default_classlistingsdb.class_id = 3) AND default_classlistingsdb.listingsdb_id = default_de_listingsdb.listingsdb_id AND (sort0.listingsdbelements_field_name = 'price') ORDER BY CAST(sort0.listingsdbelements_field_value as signed) ASC

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

ERROR REPORT pieper-immobilien.com: August 3, 2021, 3:04:18 am

---------------------------------------------------------
SQL ERROR: SELECT distinct(default_de_listingsdb.listingsdb_id), default_de_listingsdb.userdb_id, default_de_listingsdb.listingsdb_title FROM default_de_listingsdb ,default_de_listingsdbelements `sort0` ,default_classlistingsdb WHERE (listingsdb_active = 'yes') AND (default_de_listingsdb.listingsdb_id = `sort0`.listingsdb_id) AND (default_classlistingsdb.class_id = 3) AND default_classlistingsdb.listingsdb_id = default_de_listingsdb.listingsdb_id AND (sort0.listingsdbelements_field_name = 'price') ORDER BY CAST(sort0.listingsdbelements_field_value as signed) ASC
Server Type: Apache
Request Method: GET
Query String: action=searchresults&sortby=price&sorttype=ASC&pclass%5B%5D=3
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Request URI: /index.php?action=searchresults&sortby=price&sorttype=ASC&pclass%5B%5D=3
POST Variables: array (
)
GET Variables: array (
'action' => 'searchresults',
'sortby' => 'price',
'sorttype' => 'ASC',
'pclass' =>
array (
0 => '3',
),
'printer_friendly' => false,
'cur_page' => 0,
)