nasouti

select *from jmeshposts join (SELECT jmeshposts.post_parent as tb1_id, jmeshposts.guid as image FROM `jmeshposts` where `jmeshposts`.`post_status`='inherit' and `jmeshposts`.`post_type`='attachment' ORDER BY `jmeshposts`.`post_parent` DESC) as table1 on jmeshposts.id= table1.tb1_id