SQL statement that failed below: <br />
---------------------------------------------------------<br />
SELECT COUNT(distinct(default_en_listingsdb.listingsdb_id)) as total_listings FROM default_en_listingsdb  ,default_en_listingsdbelements Province ,default_classlistingsdb WHERE (listingsdb_active = 'yes')  AND (default_en_listingsdb.listingsdb_id = Province.listingsdb_id) AND (Province.listingsdbelements_field_name = 'Province' AND ( Province.listingsdbelements_field_value LIKE '%L'Aquila%')) AND (default_classlistingsdb.class_id = 1) AND default_classlistingsdb.listingsdb_id = default_en_listingsdb.listingsdb_id<br />
<br />
---------------------------------------------------------<br />
<br />
ERROR REPORT www.italymag.co.uk: October 16, 2008, 4:56:33 am<br />
<br />
---------------------------------------------------------<br />
SQL ERROR: SELECT COUNT(distinct(default_en_listingsdb.listingsdb_id)) as total_listings FROM default_en_listingsdb  ,default_en_listingsdbelements Province ,default_classlistingsdb WHERE (listingsdb_active = 'yes')  AND (default_en_listingsdb.listingsdb_id = Province.listingsdb_id) AND (Province.listingsdbelements_field_name = 'Province' AND ( Province.listingsdbelements_field_value LIKE '%L'Aquila%')) AND (default_classlistingsdb.class_id = 1) AND default_classlistingsdb.listingsdb_id = default_en_listingsdb.listingsdb_id<br />
Server Type: Apache/2.0.52 (Red Hat)<br />
Request Method: GET<br />
Query String: Province[]=L'Aquila&pclass[]=1&action=searchresults<br />
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)<br />
Request URI: /accommodation-in-italy/agriturismo-in-laquila.html<br />
POST Variables: array (<br />
)<br />
GET Variables: array (<br />
  'Province' => <br />
  array (<br />
    0 => 'L\'Aquila',<br />
  ),<br />
  'pclass' => <br />
  array (<br />
    0 => '1',<br />
  ),<br />
  'action' => 'searchresults',<br />
  'printer_friendly' => false,<br />
  'sortby' => 'random',<br />
  'sorttype' => 'ASC',<br />
)<br />