 <p>Ok this works in SqlServer not sure about MySQL, but perhaps it will help you get on the right track.</p> <pre><code>Select Top 1 Parent.Title, Descriptions.Description From Reviews Parent inner join Reviews Child on Parent.Id = Child.Parent inner join Descriptions on Child.Id = Descriptions.review_id Where Parent.Id = 1 Order By Child.[Views] desc </code></pre> <p>Fiddle: <a href="http://sqlfiddle.com/#!6/89a76/1" rel="nofollow">http://sqlfiddle.com/#!6/89a76/1</a></p> <p>Psuedo Code without Table Names as Requested</p> <blockquote> <pre><code>Select Take the Top 1 Parent.Title, Descriptions.Description From Table1 (The Parent) inner join Table1 Back onto itself (The Child) linking The parents Id to the Child's Parent inner join Table2 onto the Child Linking Child's Id to the Descriptions' review_id Where the parents Id is 1 (or the Passed in value) Order By The number of views the child had desc </code></pre> </blockquote>