string(628) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 75/69.0) AND ('55.94566' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 75/42.5) AND ('-4.56671' + 50/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.transmission = 1 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(930) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 75/69.0) AND ('55.94566' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 75/42.5) AND ('-4.56671' + 50/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.transmission = 1 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(630) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 135/69.0) AND ('55.94566' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 135/42.5) AND ('-4.56671' + 90/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.transmission = 1 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(932) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 135/69.0) AND ('55.94566' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 135/42.5) AND ('-4.56671' + 90/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.transmission = 1 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(630) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 135/69.0) AND ('55.94566' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 135/42.5) AND ('-4.56671' + 90/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.transmission = 1 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(932) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 135/69.0) AND ('55.94566' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 135/42.5) AND ('-4.56671' + 90/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.transmission = 1 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(597) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 135/69.0) AND ('55.94566' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 135/42.5) AND ('-4.56671' + 90/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(899) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.94566), 2) + pow(42.5*(classifieds.lon - -4.56671), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.94566' - 135/69.0) AND ('55.94566' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.56671' - 135/42.5) AND ('-4.56671' + 90/42.5)) AND classifieds.make = "kia" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) 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 Manual Kia Cars For Sale In Dumbarton, Dunbartonshire With Less Than 150,000 Miles | Cheapmoto.co.uk
KIA rio ice 1.4 very good condition for age 70k miles, 1 years mot no advisories, starts and drives perfectly no rattles or bangs , 1 key, log book here, ready to go