string(821) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 52.77363), 2) + pow(42.5*(classifieds.lon - -1.55728), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.77363' - 75/69.0) AND ('52.77363' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.55728' - 75/42.5) AND ('-1.55728' + 50/42.5)) AND classifieds.make = "audi" AND classifieds.model = "a6" 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 <= '50'
"
string(1123) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 52.77363), 2) + pow(42.5*(classifieds.lon - -1.55728), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.77363' - 75/69.0) AND ('52.77363' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.55728' - 75/42.5) AND ('-1.55728' + 50/42.5)) AND classifieds.make = "audi" AND classifieds.model = "a6" 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 <= '50' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(823) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 52.77363), 2) + pow(42.5*(classifieds.lon - -1.55728), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.77363' - 135/69.0) AND ('52.77363' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.55728' - 135/42.5) AND ('-1.55728' + 90/42.5)) AND classifieds.make = "audi" AND classifieds.model = "a6" 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(1125) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 52.77363), 2) + pow(42.5*(classifieds.lon - -1.55728), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.77363' - 135/69.0) AND ('52.77363' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.55728' - 135/42.5) AND ('-1.55728' + 90/42.5)) AND classifieds.make = "audi" AND classifieds.model = "a6" 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"
string(823) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 52.77363), 2) + pow(42.5*(classifieds.lon - -1.55728), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.77363' - 135/69.0) AND ('52.77363' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.55728' - 135/42.5) AND ('-1.55728' + 90/42.5)) AND classifieds.make = "audi" AND classifieds.model = "a6" 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(1125) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 52.77363), 2) + pow(42.5*(classifieds.lon - -1.55728), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.77363' - 135/69.0) AND ('52.77363' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.55728' - 135/42.5) AND ('-1.55728' + 90/42.5)) AND classifieds.make = "audi" AND classifieds.model = "a6" 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 Audi A6 Cars For Sale In Swadlincote, Derbyshire With Valid MOT | Cheapmoto.co.uk
Reliable and comfortable Audi A6, drives smoothly with plenty of space inside. Strong engine, alloy wheels, clean interior. Age-related marks on body but overall a solid car. Perfect daily driver