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 (32439,32468,33029,33043,33084,33237,34402,47806,50761305,50761306,51160124,50009063,50009066,50011339,50011352,50133741,50011376,50487603,50578492,51356757,51364499,51475494,51485303,51485324,50367182,50367185,50396011,50396014,50514770,50514788,50623942,50623944,50627423,50698889,50698892,50698910,50709090,50709115,50709140,50011717,50011750,50730289,50746917,50060302,50225930,50225938,50796315,50798443,50859013,50859026,50859047,50859070,50869184,50869214,50909942,50914131,50919301,51013489,51050462,51050479,51050494,51056589,50243482,50401180) ORDER BY CAST( SUBSTRING( kr.ki, 2, LENGTH( kr.ki) -1 ) AS DECIMAL(10,4)), CAST(SUBSTRING(kr.ic50, 2, LENGTH( kr.ic50 ) - 1 ) AS DECIMAL(10,4))