string(824) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 50/69.0) AND ('53.73476' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 50/42.5) AND ('-2.13986' + 50/42.5)) AND classifieds.make = "land rover" 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 classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(1126) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 50/69.0) AND ('53.73476' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 50/42.5) AND ('-2.13986' + 50/42.5)) AND classifieds.make = "land rover" 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 classifieds.mpg >= 30 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(824) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 90/69.0) AND ('53.73476' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 90/42.5) AND ('-2.13986' + 90/42.5)) AND classifieds.make = "land rover" 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 classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1126) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 90/69.0) AND ('53.73476' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 90/42.5) AND ('-2.13986' + 90/42.5)) AND classifieds.make = "land rover" 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 classifieds.mpg >= 30 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(824) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 90/69.0) AND ('53.73476' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 90/42.5) AND ('-2.13986' + 90/42.5)) AND classifieds.make = "land rover" 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 classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1126) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 90/69.0) AND ('53.73476' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 90/42.5) AND ('-2.13986' + 90/42.5)) AND classifieds.make = "land rover" 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 classifieds.mpg >= 21 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(798) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 90/69.0) AND ('53.73476' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 90/42.5) AND ('-2.13986' + 90/42.5)) AND classifieds.make = "land rover" 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(1100) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.73476), 2) + pow(42.5*(classifieds.lon - -2.13986), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.73476' - 90/69.0) AND ('53.73476' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.13986' - 90/42.5) AND ('-2.13986' + 90/42.5)) AND classifieds.make = "land rover" 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 30+ MPG Land Rover Cars For Sale In Pudsey, West Yorkshire With Valid MOT | Cheapmoto.co.uk
LAND ROVER FREELANDER 2.0 Td4 SE Station Wagon 5dr. 2005 five speed manual. Very good runner. Long MOT till May 2026. Very good engine gearbox clutch suspension. Two keys all documents are service history runs and drives smooth and solid on the road. Price to sell Cheap Car cheap runner cheap maintenance. Ideal spacious arrival solid car. All documents here ready for same day drive away. No issues, no problems no more likes on the dashboard. We invite any inspection no obligation test ride viewing highly recommended price to sell cheapest of this type on the Internet HPI clear all documents are ready for same may drive away. Delivery can be arranged. Open seven days a week. Follow postcode M40 8HT Lord north Street. Gate 1 Lord. Safety Belt Pretensioners About Us: Budget car Specilist since 2001, highly experienced with customer requirements and needs in this area of the Market. Making sure our clients needs are met by challenging Budgets. Here at Trafford Budget we aim to please each client, and we thrive from repeat custom which has only come from the “back” trust and experience. Warranty: Our stock is hand picked, road checked prior to advertising and we provide a minimum of 30 days to a maximum of 12 months warranty (terms apply) unless stated at the point of sale. Terms and Conditions: Available upon request. We offer a no obligation test drive. An inspection from anyone of your choice, and pressure free purchase. Opening Hours: Mo: 09:00 AM to 05:30 PM Tu: 09:00 AM to 05:30 PM We: 09:00 AM to 05:30 PM Th: 09:00 AM to 05:30 PM Fr: 09:00 AM to 05:30 PM Sa: 10:00 AM to 05:00 PM Su: 10:00 AM to 04:00 PM Why buy from us? * Cheapest Cars in the UK * Road test / inspections / good warranty packages * Pressure free purchasing * Nationwide delivery * Accommodate to customer requirements