SQL statement that failed below: <br />
---------------------------------------------------------<br />
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 = 'Каменец-Подольский')<br />
<br />
---------------------------------------------------------<br />
<br />
ERROR REPORT uarent.net: September 3, 2010, 2:08:42 pm<br />
<br />
---------------------------------------------------------<br />
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 = 'Каменец-Подольский')<br />
Server Type: Apache/2.2.13 (FreeBSD) DAV/2 PHP/5.2.11 mod_ssl/2.2.13 OpenSSL/0.9.8e<br />
Request Method: GET<br />
Query String: city=%CA%E0%EC%E5%ED%E5%F6-%CF%EE%E4%EE%EB%FC%F1%EA%E8%E9&action=searchresults<br />
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)<br />
Request URI: /en/index.php?city=%CA%E0%EC%E5%ED%E5%F6-%CF%EE%E4%EE%EB%FC%F1%EA%E8%E9&action=searchresults<br />
POST Variables: array (<br />
)<br />
GET Variables: array (<br />
  'city' => 'Каменец-Подольский',<br />
  'action' => 'searchresults',<br />
  'printer_friendly' => false,<br />
  'sortby' => 'price',<br />
  'sorttype' => 'DESC',<br />
)<br />