A Database Error Occurred

Error Number: 1242

Subquery returns more than 1 row

SELECT a.contents_no FROM (dgc_online_inquiry a) WHERE `a`.`app_seq` = '1' GROUP BY a.contents_no ORDER BY ( select value from dgc_online_inquiry b where b.app_seq = 1 and b.contents_no = a.contents_no and b.field_seq = "default_regdate" ) desc LIMIT 10