string(581) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 50/69.0) AND ('55.94462' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 50/42.5) AND ('-2.95403' + 50/42.5)) AND classifieds.make = "suzuki" AND classifieds.doors = 5 AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(883) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 50/69.0) AND ('55.94462' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 50/42.5) AND ('-2.95403' + 50/42.5)) AND classifieds.make = "suzuki" AND classifieds.doors = 5 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(581) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 90/69.0) AND ('55.94462' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 90/42.5) AND ('-2.95403' + 90/42.5)) AND classifieds.make = "suzuki" AND classifieds.doors = 5 AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(883) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 90/69.0) AND ('55.94462' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 90/42.5) AND ('-2.95403' + 90/42.5)) AND classifieds.make = "suzuki" AND classifieds.doors = 5 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(581) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 90/69.0) AND ('55.94462' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 90/42.5) AND ('-2.95403' + 90/42.5)) AND classifieds.make = "suzuki" AND classifieds.doors = 5 AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(883) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 90/69.0) AND ('55.94462' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 90/42.5) AND ('-2.95403' + 90/42.5)) AND classifieds.make = "suzuki" AND classifieds.doors = 5 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(529) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 90/69.0) AND ('55.94462' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 90/42.5) AND ('-2.95403' + 90/42.5)) AND classifieds.make = "suzuki" AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(831) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94462), 2) + pow(42.5*(classifieds.lon - -2.95403), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94462' - 90/69.0) AND ('55.94462' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.95403' - 90/42.5) AND ('-2.95403' + 90/42.5)) AND classifieds.make = "suzuki" 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 Suzuki Cars For Sale In Tranent, East Lothian | 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 are available on Ebay and are easily fitted.