SQL statement that failed below:
---------------------------------------------------------
SELECT a.listingsdb_id, a.listingsdb_title, b.listingsdbelements_field_value FROM default_en_listingsdb a,default_en_listingsdbelements b, default_classlistingsdb c where c.class_id = 2 and a.listingsdb_id <> 16708 and a.listingsdb_id = b.listingsdb_id and
b.listingsdbelements_field_name = 'region' and b.listingsdbelements_field_value = 'St.John's' and
a.listingsdb_id = c.listingsdb_id order by RAND() limit 0,3
---------------------------------------------------------
ERROR REPORT www.theedenlist.com: February 9, 2012, 9:01:46 pm
---------------------------------------------------------
SQL ERROR: SELECT a.listingsdb_id, a.listingsdb_title, b.listingsdbelements_field_value FROM default_en_listingsdb a,default_en_listingsdbelements b, default_classlistingsdb c where c.class_id = 2 and a.listingsdb_id <> 16708 and a.listingsdb_id = b.listingsdb_id and
b.listingsdbelements_field_name = 'region' and b.listingsdbelements_field_value = 'St.John's' and
a.listingsdb_id = c.listingsdb_id order by RAND() limit 0,3
Server Type: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.14
Request Method: GET
Query String: action=listingview&listingID=16708
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Request URI: /listing-Exotic+Water+Front+Land%22%22-16708.html
POST Variables: array (
)
GET Variables: array (
'action' => 'listingview',
'listingID' => '16708',
'printer_friendly' => false,
)