How to make a query to MYSQL?

SELECT product_id FROM product WHERE status = 1

The resulting array must be sorted in the option is the same as the product_id in the table review.
To count the number of records in a table review has every product_id and sort in descending order.

id - product_id - text

Please help
June 14th 19 at 21:07

Find more questions by tags MySQL