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