SELECT kr.entryid, kr.ki_result_id, kr.reactant_set_id, kr.ki, kr.delta_g, kr.ic50, kr.kd, kr.ec50, kr.koff, kr.kon, kr.ph, kr.temp, ers.enzyme, ers.inhibitor, ers.enzyme_polymerid, ers.enzyme_complexid, ers.inhibitor_monomerid, ers.enzyme_monomerid FROM ki_result kr, enzyme_reactant_set ers WHERE kr.reactant_set_id = ers.reactant_set_id AND ers.REACTANT_SET_ID IN (406749,50344981,50904181) ORDER BY CAST( SUBSTRING( kr.ic50, 2, LENGTH( kr.ic50) -1 ) AS DECIMAL(10,4)),CAST( SUBSTRING(kr.ki, 2, LENGTH( kr.ki ) - 1 ) AS DECIMAL(10,4))