select c.id parentid,c.name parentName,sc.id subid,sc.name subname from category c LEFT JOIN category sc on sc.parentId=c.id and c.contentTypeId = '89' where sc.site_flag='3' and sc.id='267' and sc.contentTypeId = '89' order by parentName desc limit 1 Celebrities, Bollywood stars, Reality Show Contestants. Get the latest pictures| MTV India