SELECT v.*, s.state, s.statename FROM vendors v INNER JOIN states s ON s.id = v.vendor_state WHERE vendor_id = 1953