string(640) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 50/69.0) AND ('55.39439' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 50/42.5) AND ('-4.17943' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 30000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 50/69.0) AND ('55.39439' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 50/42.5) AND ('-4.17943' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 30000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 30000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 30000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 30000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 30000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 45000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 45000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 45000) 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 - 55.39439), 2) + pow(42.5*(classifieds.lon - -4.17943), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.39439' - 90/69.0) AND ('55.39439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.17943' - 90/42.5) AND ('-4.17943' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 45000) 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 Ayrshire And Arran With Less Than 30,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