SQL statement that failed below:
---------------------------------------------------------
SELECT COUNT(distinct(bsz_hu_listingsdb.listingsdb_id)) as total_listings FROM bsz_hu_listingsdb ,bsz_hu_listingsdbelements `kiemelt` WHERE (listingsdb_active = 'yes') AND (bsz_hu_listingsdb.listingsdb_id = `kiemelt`.listingsdb_id) AND (`kiemelt`.listingsdbelements_field_name = 'kiemelt' AND `kiemelt`.listingsdbelements_field_value = 'Siófok')

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

ERROR REPORT balatoni-szallas.hu: December 4, 2016, 5:14:52 pm

---------------------------------------------------------
SQL ERROR: SELECT COUNT(distinct(bsz_hu_listingsdb.listingsdb_id)) as total_listings FROM bsz_hu_listingsdb ,bsz_hu_listingsdbelements `kiemelt` WHERE (listingsdb_active = 'yes') AND (bsz_hu_listingsdb.listingsdb_id = `kiemelt`.listingsdb_id) AND (`kiemelt`.listingsdbelements_field_name = 'kiemelt' AND `kiemelt`.listingsdbelements_field_value = 'Siófok')
Server Type: Apache
Request Method: GET
Query String: beds-min=&beds-max=&price-min=&price-max=&szobak-min=&szobak-max=&kiemelt=Si%C3%B3fok&searchtext=&action=searchresults&pclass%5B%5D=
User Agent: CCBot/2.0 (http://commoncrawl.org/faq/)
Request URI: /index.php?beds-min=&beds-max=&price-min=&price-max=&szobak-min=&szobak-max=&kiemelt=Si%C3%B3fok&searchtext=&action=searchresults&pclass%5B%5D=
POST Variables: array (
)
GET Variables: array (
'beds-min' => '',
'beds-max' => '',
'price-min' => '',
'price-max' => '',
'szobak-min' => '',
'szobak-max' => '',
'kiemelt' => 'Siófok',
'searchtext' => '',
'action' => 'searchresults',
'pclass' =>
array (
0 => '',
),
'printer_friendly' => false,
'sortby' => 'listingsdb_id',
'sorttype' => 'ASC',
)