string(696) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 75/69.0) AND ('51.88762' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 75/42.5) AND ('-0.52311' + 50/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(998) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 75/69.0) AND ('51.88762' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 75/42.5) AND ('-0.52311' + 50/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '50' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(698) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 135/69.0) AND ('51.88762' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 135/42.5) AND ('-0.52311' + 90/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1000) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 135/69.0) AND ('51.88762' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 135/42.5) AND ('-0.52311' + 90/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '90' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(698) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 135/69.0) AND ('51.88762' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 135/42.5) AND ('-0.52311' + 90/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1000) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 135/69.0) AND ('51.88762' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 135/42.5) AND ('-0.52311' + 90/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '90' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(600) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 135/69.0) AND ('51.88762' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 135/42.5) AND ('-0.52311' + 90/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(902) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.88762), 2) + pow(42.5*(classifieds.lon - -0.52311), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.88762' - 135/69.0) AND ('51.88762' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.52311' - 135/42.5) AND ('-0.52311' + 90/42.5)) AND classifieds.make = "subaru" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND expiry >= NOW() AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '90' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
Cheap 1.0 - 1.9L Subaru Cars For Sale In Dunstable, Bedfordshire With Less Than 125,000 Miles | Cheapmoto.co.uk
1999 Subaru justy 1.3 GX ALL WHEEL DRIVE 4X4 needs carburetor engine is fine done 65,000 miles in very good condition Four Wheel Drive; Safety Belt Pretensioners
STARTS AND DRIVES GOOD BUT WE ARE SELLING IT FOR SPARES OR REPAIRS + STEERING RACK HAS PLAY IN IT + SMOKES ON HARSH ACCELERATION POSSIBLE AIR LEAK SOME WHERE + RETAIL VALUE FOR £3500 SO PROJECT CAR FOR SPARES OR REPAIRSVIEWING BY APPOINTMENTS ONLY ++ FREE DELIVERY WITHIN 30 MILES ++ PART EXCHANGES WELCOME Safety Belt Pretensioners