# MySQL - Getting top 10 records

**URL:** https://forum.kirupa.com/t/mysql-getting-top-10-records/237698
**Category:** programming
**Created:** [September 2, 2007, 8:08pm UTC](https://forum.kirupa.com/t/mysql-getting-top-10-records/237698 "2007-09-02T20:08:05Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Neolumi](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/neolumi/32/1306_2.png) [@Neolumi](https://forum.kirupa.com/u/Neolumi)
#### Post date: [September 2, 2007, 8:08pm UTC](https://forum.kirupa.com/t/mysql-getting-top-10-records/237698/1 "2007-09-02T20:08:05Z")

</div>

Hi, Ok I’m having a moment and I cant seem to get my head around this.

What I need to do is get the 10 most reviewed products from a db, whilst joing onto the product table to get its name, so effectively 2 tables:

# reviews

rev\_id  
rev\_text  
rev\_parent (contains id of the reviewed product)

# products

product\_id  
product\_title

how could I achieve this?