MySQL Error Occured
1054: Unknown column 'mid.value_id' in 'on clause'

QUERY = SELECT DISTINCT bot.assign_id, value_name FROM CubeCart_options_mid AS mid, CubeCart_options_bot AS bot INNER JOIN CubeCart_options_bot ON mid.value_id = bot.value_id AND bot.product = '189' ORDER BY assign_id ASC