SQL statement that failed below:
---------------------------------------------------------
SELECT COUNT(distinct(uarenten_en_listingsdb.listingsdb_id)) as total_listings FROM uarenten_en_listingsdb ,uarenten_en_listingsdbelements city WHERE (listingsdb_active = 'yes') AND (uarenten_en_listingsdb.listingsdb_id = city.listingsdb_id) AND (city.listingsdbelements_field_name = 'city' AND city.listingsdbelements_field_value = 'Мукачево')
---------------------------------------------------------
ERROR REPORT uarent.net: September 3, 2010, 2:08:53 pm
---------------------------------------------------------
SQL ERROR: SELECT COUNT(distinct(uarenten_en_listingsdb.listingsdb_id)) as total_listings FROM uarenten_en_listingsdb ,uarenten_en_listingsdbelements city WHERE (listingsdb_active = 'yes') AND (uarenten_en_listingsdb.listingsdb_id = city.listingsdb_id) AND (city.listingsdbelements_field_name = 'city' AND city.listingsdbelements_field_value = 'Мукачево')
Server Type: Apache/2.2.13 (FreeBSD) DAV/2 PHP/5.2.11 mod_ssl/2.2.13 OpenSSL/0.9.8e
Request Method: GET
Query String: city=%CC%F3%EA%E0%F7%E5%E2%EE&action=searchresults
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Request URI: /en/index.php?city=%CC%F3%EA%E0%F7%E5%E2%EE&action=searchresults
POST Variables: array (
)
GET Variables: array (
'city' => 'Мукачево',
'action' => 'searchresults',
'printer_friendly' => false,
'sortby' => 'price',
'sorttype' => 'DESC',
)