SELECT b.* FROM (SELECT page, status, value, valuetext09 , MAX(no) no FROM idbengine.idbuser_post_db WHERE page = '12' AND status = '3' AND value = '1' GROUP BY page, status, value, valuetext09 ) a INNER JOIN idbengine.idbuser_post_db b ON a.page = b.page AND a.status = b.status AND a.value = b.value AND a.valuetext09 = b.valuetext09 AND a.no = b.no ;