SELECT warehouse_number, application_details.nomenclature_id, amount, speciality_name, lifetime, price * amount FROM application_details INNER JOIN nomenclature ON application_details.nomenclature_id = nomenclature.nomenclature_id INNER JOIN speciality ON application_details.speciality_id = speciality.speciality_id INNER JOIN lifetime ON application_details.nomenclature_id = lifetime.nomenclature_id AND application_details.speciality_id = lifetime.speciality_id WHERE application_details.application_id = 1