What Val Wants

SQL failed; SQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT `t`.*, `p`.`id` AS `pod_id`, `p`.`created`, `p`.`modified` FROM `wp_zdcg86_pod` AS `p` INNER JOIN `wp_zdcg86_pod_tbl_wants` AS `t` ON `t`.`id` = `p`.`tbl_row_id` WHERE `p`.`datatype` = 7 ORDER BY `t`.`modified` DESC LIMIT 0,6; Response: Unknown column 't.modified' in 'order clause'