Unknown column 'tds' in 'field list'
Query:SELECT p.playernum, p.stats_id, CONCAT(p.firstname, ' ', p.lastname) AS name, team, (idp_solo / 1.00) * 2.00 + (idp_ast / 1.00) * 1.00 + (idp_sac / 1.00) * 3.00 + (idp_fum_f / 1.00) * 1.00 + (idp_fum_r / 1.00) * 1.00 + (idp_p_int / 1.00) * 1.00 + (idp_p_def / 1.00) * 1.00 + (tds / 1.00) * 6.00 AS fpts, idp_tac AS idp_tac, idp_solo AS idp_solo, idp_ast AS idp_ast, idp_sac, idp_fum_f AS idp_fum, idp_fum_r AS idp_rec, idp_p_int AS idp_int, idp_p_def AS idp_def FROM projections_2009_idp proj INNER JOIN player p ON (proj.playernum = p.playernum) WHERE p.position IN ('CB','S') AND proj.ffpts > '0' ORDER BY fpts DESC