SELECT t2.product_details FROM order_items AS t1 JOIN products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_id ORDER BY count(*) DESC LIMIT 1
Which product has been ordered most number of times?
SELECT t2.product_details FROM order_items AS t1 JOIN products AS t2 ON t1.product_id = t2.product_id GROUP BY t1.product_id ORDER BY count ( * ) DESC LIMIT 1
select t2 . product_details from order_items as t1 join products as t2 on t1 . product_id = t2 . product_id group by t1 . product_id order by count ( * ) desc limit value
Which product has been ordered most number of times ?