string(771) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 50/69.0) AND ('56.15504' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 50/42.5) AND ('-3.94805' + 50/42.5)) AND classifieds.make = "suzuki" 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 >= 40 AND expiry >= NOW() AND ingested = 1
"
string(1050) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 50/69.0) AND ('56.15504' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 50/42.5) AND ('-3.94805' + 50/42.5)) AND classifieds.make = "suzuki" 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 >= 40 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(771) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 90/69.0) AND ('56.15504' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 90/42.5) AND ('-3.94805' + 90/42.5)) AND classifieds.make = "suzuki" 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 >= 40 AND expiry >= NOW() AND ingested = 1
"
string(1050) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 90/69.0) AND ('56.15504' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 90/42.5) AND ('-3.94805' + 90/42.5)) AND classifieds.make = "suzuki" 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 >= 40 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(771) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 90/69.0) AND ('56.15504' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 90/42.5) AND ('-3.94805' + 90/42.5)) AND classifieds.make = "suzuki" 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 >= 28 AND expiry >= NOW() AND ingested = 1
"
string(1050) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 90/69.0) AND ('56.15504' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 90/42.5) AND ('-3.94805' + 90/42.5)) AND classifieds.make = "suzuki" 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 >= 28 AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(745) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 90/69.0) AND ('56.15504' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 90/42.5) AND ('-3.94805' + 90/42.5)) AND classifieds.make = "suzuki" 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
"
string(1024) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.15504), 2) + pow(42.5*(classifieds.lon - -3.94805), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.15504' - 90/69.0) AND ('56.15504' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.94805' - 90/42.5) AND ('-3.94805' + 90/42.5)) AND classifieds.make = "suzuki" 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
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
Cheap 40+ MPG Suzuki Cars For Sale In Bridge Of Allan, Stirling And Falkirk With Valid MOT | Cheapmoto.co.uk
This car is in excellent condition inside and out. It comes with 12 months MOT, is LEZ compliant and has a new battery. Comes with one remote key and with keyless entry and starting. Cloth interior is clean and tidy. The car is fitted with a tow bar, four snow tyres for excellent traction and would be 4WD but the prop shaft has been removed by a previous owner. New propshafts