Unknown column 'f.tid' in 'on clause' SELECT SQL_CALC_FOUND_ROWS t.* FROM tweet_forwards AS f LEFT JOIN tweets AS t ON f.tid = t.id WHERE f.forward_id = 2231 ORDER BY t.id DESC LIMIT 0, 8