SELECT a.test_id, a.test_name, b.test_type_name FROM t_test a INNER JOIN m_test_type b ON a.test_type_id = b.test_type_id WHERE a.test_name LIKE /*testName*/'S%' ORDER BY a.test_id DESC