string(860) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 75/69.0) AND ('53.70528' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 75/42.5) AND ('-1.93737' + 50/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(1162) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 75/69.0) AND ('53.70528' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 75/42.5) AND ('-1.93737' + 50/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') 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(862) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 135/69.0) AND ('53.70528' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 135/42.5) AND ('-1.93737' + 90/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1164) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 135/69.0) AND ('53.70528' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 135/42.5) AND ('-1.93737' + 90/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') 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(862) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 135/69.0) AND ('53.70528' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 135/42.5) AND ('-1.93737' + 90/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1164) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 135/69.0) AND ('53.70528' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 135/42.5) AND ('-1.93737' + 90/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') 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(862) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 135/69.0) AND ('53.70528' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 135/42.5) AND ('-1.93737' + 90/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1164) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70528), 2) + pow(42.5*(classifieds.lon - -1.93737), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70528' - 135/69.0) AND ('53.70528' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.93737' - 135/42.5) AND ('-1.93737' + 90/42.5)) AND classifieds.make = "ford" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') 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 Ford Cars For Sale In Sowerby Bridge, West Yorkshire With Less Than 50,000 Miles And Valid MOT | Cheapmoto.co.uk
Here is a good condition ford fiesta 06 plate, it’s a perfect little car to drive and good for learning in too. It has its MOT until sept 29, it has a couple of marks on the back , has recently had 2 owner myself and the person before has only 1 key full log book and everything
For sale my wife's 2014 ford ka just had new gearbox and coil pack brand new injectors and had a full service only thing what is wrong with it has a misfire and scratches on pasagner side as shown in photos £800 ono pick up only Hartlepool
2009 09 1.6 Style, 66,000 Genuine Miles With Service History, HPI Clear With Full Report, Mileage Is VOSA Verified, Mot Until June 2026, Electric Windows, Electric Mirrors, Power Assisted Steering, ABs Brakes, Air Conditioning, Metallic Black, Taken In Part Exchange Drives Lovely No Time wasters Please