string(980) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 75/69.0) AND ('53.75007' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 75/42.5) AND ('-2.48153' + 50/42.5)) AND (MATCH(title) AGAINST("\\(\\\\\"quick sale\\\\\" \\)" IN BOOLEAN MODE) OR MATCH(classifieds.description) AGAINST("\\(\\\\\"quick sale\\\\\" \\)" IN BOOLEAN MODE) or title REGEXP "\\b(\\(quick sale|\\))\\b" or classifieds.description REGEXP "\\b(\\(quick sale|\\))\\b") AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) AND (classifieds.year IS NOT NULL AND (2025 - classifieds.year) >= 15) AND (classifieds.year IS NOT NULL AND (2025 - classifieds.year) <= 20) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(840) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (MATCH(title) AGAINST("\\(\\\\\"quick sale\\\\\" \\)" IN BOOLEAN MODE) OR MATCH(classifieds.description) AGAINST("\\(\\\\\"quick sale\\\\\" \\)" IN BOOLEAN MODE) or title REGEXP "\\b(\\(quick sale|\\))\\b" or classifieds.description REGEXP "\\b(\\(quick sale|\\))\\b") AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(567) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(869) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) 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(567) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(869) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) 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(567) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(869) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.75007), 2) + pow(42.5*(classifieds.lon - -2.48153), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.75007' - 135/69.0) AND ('53.75007' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.48153' - 135/42.5) AND ('-2.48153' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) 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 Quick Sale Needed Cars For Sale In Blackburn, Lancashire With Less Than 40,000 Miles | 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
Here we have a wonderful example of a low mileage FIAT PUNTO with just 34,000 miles that will come with a FEBRUARY 2026 MOT and is fully HPI CLEAR. If you would like any more details please do not hesitate to contact us on [Phone number removed] or 07595257297. Safety Belt Pretensioners
2006 Honda Jazz 1.4 i-DSI SE Hatchback 5dr Petrol Manual (137 g/km, 82 bhp) Hatchback Petrol Manual CLEARENCE, MOT JULY 2026 £ 1,495.00 Make Honda Model Jazz Year 2006 Transmission Manual Fuel Petrol Engine Size 1,339 ccm Mileage 47,795 Miles Emission class 137 CLEARENCE, MOT JULY 2026, 2 KEYS.15in Alloy Wheels with Locking Wheelnuts, Anti-Lock Braking System (ABS) and
2005 Fiat Panda 1.2 Dynamic 5dr HATCHBACK Petrol Manual Blue 52319 Miles £ 995.00 Make Fiat Model Panda Year 2005 Transmission Manual Fuel Petrol Engine Size 1,242 ccm Mileage 52,319 Miles Emission class 133 ***************All cars come with 3 months nationwide warranty included in priceAll Electrical and all mechanical components covered in warranty All car comes with 3