select b.id,b.alias,b.categories_id from old_audio_redirections a join #__avt_catalog_products b on(a.newid=b.id) where a.alias='infinity-beta-40'