ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'" string(1353) "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 - 55.84509), 2) + pow(42.5*(classifieds.lon - -4.42841), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('55.84509' - 75/69.0) AND ('55.84509' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.42841' - 75/42.5) AND ('-4.42841' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND classifieds.doors = 3 AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '50' 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(1355) "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 - 55.84509), 2) + pow(42.5*(classifieds.lon - -4.42841), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('55.84509' - 135/69.0) AND ('55.84509' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.42841' - 135/42.5) AND ('-4.42841' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND classifieds.doors = 3 AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '90' 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(1355) "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 - 55.84509), 2) + pow(42.5*(classifieds.lon - -4.42841), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('55.84509' - 135/69.0) AND ('55.84509' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.42841' - 135/42.5) AND ('-4.42841' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.doors = 3 AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '90' 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(1296) "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 - 55.84509), 2) + pow(42.5*(classifieds.lon - -4.42841), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('55.84509' - 135/69.0) AND ('55.84509' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.42841' - 135/42.5) AND ('-4.42841' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1 GROUP BY classifieds.id HAVING distance <= '90' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"

Cheap Manual Cars For Sale In Paisley, Renfrewshire With Less Than 100,000 Miles | Cheapmoto.co.uk

Cheap Manual Cars For Sale In Paisley, Renfrewshire With Less Than 100,000 Miles

1 Cheap Manual Cars For Sale In Paisley, Renfrewshire With Less Than 100,000 Miles

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 Paisley, Renfrewshire

Popular Locations