SQL statement that failed below: <br />
---------------------------------------------------------<br />
SELECT COUNT(distinct(property_en_listingsdb.listingsdb_id)) as total_listings FROM property_en_listingsdb  ,property_en_listingsdbelements Province WHERE (listingsdb_active = 'yes')  AND (property_en_listingsdb.listingsdb_id = Province.listingsdb_id) AND (Province.listingsdbelements_field_name = 'Province' AND ( Province.listingsdbelements_field_value LIKE '%L'Aquila%'))<br />
<br />
---------------------------------------------------------<br />
<br />
ERROR REPORT www.italymag.co.uk: September 8, 2008, 2:57:28 am<br />
<br />
---------------------------------------------------------<br />
SQL ERROR: SELECT COUNT(distinct(property_en_listingsdb.listingsdb_id)) as total_listings FROM property_en_listingsdb  ,property_en_listingsdbelements Province WHERE (listingsdb_active = 'yes')  AND (property_en_listingsdb.listingsdb_id = Province.listingsdb_id) AND (Province.listingsdbelements_field_name = 'Province' AND ( Province.listingsdbelements_field_value LIKE '%L'Aquila%'))<br />
Server Type: Apache/2.0.52 (Red Hat)<br />
Request Method: GET<br />
Query String: Province[]=L'Aquila&action=searchresults<br />
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)<br />
Request URI: /property-for-sale-in-italy/property-for-sale-in-laquila.html<br />
POST Variables: array (<br />
)<br />
GET Variables: array (<br />
  'Province' => <br />
  array (<br />
    0 => 'L\'Aquila',<br />
  ),<br />
  'action' => 'searchresults',<br />
  'printer_friendly' => false,<br />
  'sortby' => 'baths',<br />
  'sorttype' => 'DESC',<br />
)<br />