QUERY: SELECT t.*, DATE_FORMAT(t.date_added, '%a, %b %D') AS date_str, DATE_FORMAT(t.date_added, '%l:%i%p') AS time_str FROM zips AS t WHERE zip = '90001' ORDER BY date_added DESC LIMIT 1

ERROR: Table 'farmtoschool_db.zips' doesn't exist

QUERY: (SELECT 'distro' AS type, z.zip AS zip, d.title AS title, d.id AS pid, SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM distributors AS d, zips AS z WHERE SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) < 0 AND z.zip = d.zip_code) UNION (SELECT 'farmer' AS type, z.zip AS zip, d.title AS title, d.id as pid, SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM farmers AS d, zips AS z WHERE SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) < 0 AND z.zip = d.zip_code) UNION (SELECT 'school' AS type, z.zip AS zip, d.title AS title, d.id as pid, SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM programs AS d, zips AS z WHERE SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) < 0 AND z.zip = d.contact_zip)

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM distributors AS d, zips AS' at line 1