string(46) "Unknown column 'users.seller_type' in 'SELECT'" NULL ERROR:
string(39) "Unknown column 'users.name' in 'SELECT'" string(1279) "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.61960), 2) + pow(42.5*(classifieds.lon - 0.07564), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('51.61960' - 75/69.0) AND ('51.61960' + 50/69.0)) AND (classifieds.lon BETWEEN ('0.07564' - 75/42.5) AND ('0.07564' + 50/42.5)) AND classifieds.body = 9 AND classifieds.seller_type = 2 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(1279) "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.61960), 2) + pow(42.5*(classifieds.lon - 0.07564), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('51.61960' - 75/69.0) AND ('51.61960' + 50/69.0)) AND (classifieds.lon BETWEEN ('0.07564' - 75/42.5) AND ('0.07564' + 50/42.5)) AND classifieds.body = 9 AND classifieds.seller_type = 2 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(1279) "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.61960), 2) + pow(42.5*(classifieds.lon - 0.07564), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('51.61960' - 75/69.0) AND ('51.61960' + 50/69.0)) AND (classifieds.lon BETWEEN ('0.07564' - 75/42.5) AND ('0.07564' + 50/42.5)) AND classifieds.body = 9 AND classifieds.seller_type = 2 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(1252) "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.61960), 2) + pow(42.5*(classifieds.lon - 0.07564), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('51.61960' - 150/69.0) AND ('51.61960' + 100/69.0)) AND (classifieds.lon BETWEEN ('0.07564' - 150/42.5) AND ('0.07564' + 100/42.5)) AND classifieds.body = 9 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(1252) "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.61960), 2) + pow(42.5*(classifieds.lon - 0.07564), 2)) AS distance , 0 AS title_match, 0 AS desc_match FROM classifieds WHERE 1 AND (classifieds.lat BETWEEN ('51.61960' - 150/69.0) AND ('51.61960' + 100/69.0)) AND (classifieds.lon BETWEEN ('0.07564' - 150/42.5) AND ('0.07564' + 100/42.5)) AND classifieds.body = 9 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"