string(640) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 50/69.0) AND ('56.62191' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 50/42.5) AND ('-3.22975' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
"
string(919) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 50/69.0) AND ('56.62191' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 50/42.5) AND ('-3.22975' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(640) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
"
string(919) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(640) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
"
string(919) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(640) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
"
string(919) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(516) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND expiry >= NOW() AND ingested = 1
"
string(795) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.62191), 2) + pow(42.5*(classifieds.lon - -3.22975), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.62191' - 90/69.0) AND ('56.62191' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.22975' - 90/42.5) AND ('-3.22975' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
Cheap 30+ MPG 1.0 - 1.9L Cars For Sale In Alyth, Perth And Kinross With Less Than 50,000 Miles | Cheapmoto.co.uk
2001 Toyota Yaris 1.3vvti Automatic Spares repairs as needs MOT. Starts & drives good. All paper work there, couple small rattles from the front suspension. Just had 3 new tyres, belonged to a friend who has since just purchased a new car. This car no longer needed. £500 Edinburgh
Ford Fiesta Zetec 1.2L, 2012 Non-runner, spares or repair £500 or best offer -3-door hatchback -Black -62,000 miles -Mot till April -Comes with v5 logbook Not starting with key (makes clicking noise) but starts with jump Broke down 2weeks ago Mechanic assessed engine failure due to overheating (Coolant cap left off) Car ran fine prior to this, no other known issues 2 new tyres
KIA rio ice 1.4 very good condition for age 70k miles, 1 years mot no advisories, starts and drives perfectly no rattles or bangs , 1 key, log book here, ready to go