SQL ERROR

IP:54.80.219.236 Failed Query: select fm.*, date_format(fm.date_match,"%d %b, %Y - %h : %i %p") as date_match, qrtm1.team_name as qr_team_name_1,qrtm1.team_logo as qr_team_logo_1, qrtm2.team_name as qr_team_name_2,qrtm2.team_logo as qr_team_logo_2, ptm1.team_name as p_team_name_1,ptm1.team_logo as p_team_logo_1, ptm2.team_name as p_team_name_2,ptm2.team_logo as p_team_logo_2, sfqrtm1.team_name as sf_team_name_1,sfqrtm1.team_logo as sf_team_logo_1, sfqrtm2.team_name as sf_team_name_2,sfqrtm2.team_logo as sf_team_logo_2, pm1.pool_name as pool_name_1,pm2.pool_name as pool_name_2 from hockey_fixture_master fm left join hockey_team_master qrtm1 on (qrtm1.id = fm.qr_team_id_1) left join hockey_team_master qrtm2 on (qrtm2.id = fm.qr_team_id_2) left join hockey_team_master ptm1 on (ptm1.id = fm.pool_team_id_1) left join hockey_team_master ptm2 on (ptm2.id = fm.pool_team_id_2) left join hockey_team_master sfqrtm1 on (sfqrtm1.id = fm.sfm_pool_qualifier_1) left join hockey_team_master sfqrtm2 on (sfqrtm2.id = fm.sfm_pool_qualifier_2) left join hockey_pool_master pm1 on (pm1.id = fm.sfm_pool_id_1) left join hockey_pool_master pm2 on (pm2.id = fm.sfm_pool_id_2) where fm.year_id = 6 and fm.pool_category_type = 1 order by fm.date_match,fm.match_no SQL Error: Unknown column 'fm.qr_team_id_1' in 'on clause' ********************