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 = 8 and a.listingsdb_id <> 9667 and a.listingsdb_id = b.listingsdb_id and
b.listingsdbelements_field_name = 'region' and b.listingsdbelements_field_value = 'St. Mary's' and
a.listingsdb_id = c.listingsdb_id order by RAND() limit 0,3
---------------------------------------------------------
ERROR REPORT www.theedenlist.com: February 9, 2012, 8:23:01 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 = 8 and a.listingsdb_id <> 9667 and a.listingsdb_id = b.listingsdb_id and
b.listingsdbelements_field_name = 'region' and b.listingsdbelements_field_value = 'St. Mary'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=9667
User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Request URI: /listing-DEVELOPERS+BEACHFRONT+DREAM-9667.html
POST Variables: array (
)
GET Variables: array (
'action' => 'listingview',
'listingID' => '9667',
'printer_friendly' => false,
)