ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'" string(1294) "SELECT SQL_NO_CACHE classifieds.*, MIN(classifieds.price) AS price_min, MAX(classifieds.price) AS price_max, CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name, CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email, CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id, UNIX_TIMESTAMP(posted) AS sort_date, sqrt(pow(69*(classifieds.lat - 52.24496), 2) + pow(42.5*(classifieds.lon - -0.85840), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('52.24496' - 150/69.0) AND ('52.24496' + 100/69.0)) AND (classifieds.lon BETWEEN ('-0.85840' - 150/42.5) AND ('-0.85840' + 100/42.5)) AND classifieds.make = "suzuki" AND classifieds.seller_type = 2 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '100' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"

ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'" string(1294) "SELECT SQL_NO_CACHE classifieds.*, MIN(classifieds.price) AS price_min, MAX(classifieds.price) AS price_max, CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name, CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email, CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id, UNIX_TIMESTAMP(posted) AS sort_date, sqrt(pow(69*(classifieds.lat - 52.24496), 2) + pow(42.5*(classifieds.lon - -0.85840), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('52.24496' - 270/69.0) AND ('52.24496' + 180/69.0)) AND (classifieds.lon BETWEEN ('-0.85840' - 270/42.5) AND ('-0.85840' + 180/42.5)) AND classifieds.make = "suzuki" AND classifieds.seller_type = 2 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '180' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"

ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'" string(1262) "SELECT SQL_NO_CACHE classifieds.*, MIN(classifieds.price) AS price_min, MAX(classifieds.price) AS price_max, CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name, CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email, CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id, UNIX_TIMESTAMP(posted) AS sort_date, sqrt(pow(69*(classifieds.lat - 52.24496), 2) + pow(42.5*(classifieds.lon - -0.85840), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('52.24496' - 270/69.0) AND ('52.24496' + 180/69.0)) AND (classifieds.lon BETWEEN ('-0.85840' - 270/42.5) AND ('-0.85840' + 180/42.5)) AND classifieds.make = "suzuki" AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '180' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"

ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'" string(1262) "SELECT SQL_NO_CACHE classifieds.*, MIN(classifieds.price) AS price_min, MAX(classifieds.price) AS price_max, CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name, CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email, CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id, UNIX_TIMESTAMP(posted) AS sort_date, sqrt(pow(69*(classifieds.lat - 52.24496), 2) + pow(42.5*(classifieds.lon - -0.85840), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('52.24496' - 270/69.0) AND ('52.24496' + 180/69.0)) AND (classifieds.lon BETWEEN ('-0.85840' - 270/42.5) AND ('-0.85840' + 180/42.5)) AND classifieds.make = "suzuki" AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '180' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"

Cheap Suzuki Cars For Sale In East Midlands From Trade Dealerships | Cheapmoto.co.uk

Cheap Suzuki Cars For Sale In East Midlands From Trade Dealerships

2 Cheap Suzuki Cars For Sale In East Midlands From Trade Dealerships

Oops! We couldn't find any results exactly matching your search.

Try expanding your search criteria to get more results, you may like to try:

Cars for sale in East Midlands

Popular Locations