Corrected sql statement for getProps in renewals