string(46) "Unknown column 'users.seller_type' in 'SELECT'"
NULL
ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'"
string(1291) "SELECT SQL_NO_CACHE classifieds.*,
MIN(classifieds.price) AS price_min,
MAX(classifieds.price) AS price_max,
CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name,
CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email,
CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id,
UNIX_TIMESTAMP(posted) AS sort_date,
sqrt(pow(69*(classifieds.lat - 51.54616), 2) + pow(42.5*(classifieds.lon - -0.37078), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.54616' - 75/69.0) AND ('51.54616' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.37078' - 75/42.5) AND ('-0.37078' + 50/42.5)) AND classifieds.make = "peugeot" AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '50' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'"
string(1291) "SELECT SQL_NO_CACHE classifieds.*,
MIN(classifieds.price) AS price_min,
MAX(classifieds.price) AS price_max,
CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name,
CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email,
CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id,
UNIX_TIMESTAMP(posted) AS sort_date,
sqrt(pow(69*(classifieds.lat - 51.54616), 2) + pow(42.5*(classifieds.lon - -0.37078), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.54616' - 75/69.0) AND ('51.54616' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.37078' - 75/42.5) AND ('-0.37078' + 50/42.5)) AND classifieds.make = "peugeot" AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '50' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'"
string(1291) "SELECT SQL_NO_CACHE classifieds.*,
MIN(classifieds.price) AS price_min,
MAX(classifieds.price) AS price_max,
CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name,
CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email,
CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id,
UNIX_TIMESTAMP(posted) AS sort_date,
sqrt(pow(69*(classifieds.lat - 51.54616), 2) + pow(42.5*(classifieds.lon - -0.37078), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.54616' - 75/69.0) AND ('51.54616' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.37078' - 75/42.5) AND ('-0.37078' + 50/42.5)) AND classifieds.make = "peugeot" AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '50' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'"
string(1296) "SELECT SQL_NO_CACHE classifieds.*,
MIN(classifieds.price) AS price_min,
MAX(classifieds.price) AS price_max,
CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name,
CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email,
CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id,
UNIX_TIMESTAMP(posted) AS sort_date,
sqrt(pow(69*(classifieds.lat - 51.54616), 2) + pow(42.5*(classifieds.lon - -0.37078), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.54616' - 150/69.0) AND ('51.54616' + 100/69.0)) AND (classifieds.lon BETWEEN ('-0.37078' - 150/42.5) AND ('-0.37078' + 100/42.5)) AND classifieds.make = "peugeot" AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '100' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'"
string(1296) "SELECT SQL_NO_CACHE classifieds.*,
MIN(classifieds.price) AS price_min,
MAX(classifieds.price) AS price_max,
CASE WHEN users.name IS NOT NULL THEN users.name ELSE classifieds.seller END as user_name,
CASE WHEN users.email IS NOT NULL THEN users.email ELSE NULL END as user_email,
CASE WHEN users.id IS NOT NULL THEN users.id ELSE null END as seller_id,
UNIX_TIMESTAMP(posted) AS sort_date,
sqrt(pow(69*(classifieds.lat - 51.54616), 2) + pow(42.5*(classifieds.lon - -0.37078), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.54616' - 150/69.0) AND ('51.54616' + 100/69.0)) AND (classifieds.lon BETWEEN ('-0.37078' - 150/42.5) AND ('-0.37078' + 100/42.5)) AND classifieds.make = "peugeot" AND classifieds.transmission = 1 AND (expiry IS NULL OR expiry >= NOW()) AND ingested = 1
GROUP BY classifieds.id
HAVING distance <= '100' ORDER BY (sort_date - distance*5000) DESC, posted DESC, (title_match+desc_match) DESC LIMIT 0,20"