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 1 <table_name> : Products col : product_id | product_details row 1 : 1 | Americano row 2 : 2 | Dove Chocolate row 3 : 3 | Latte <table_name> : Order_Items col : order_id | product_id | order_quantity row 1 : 14 | 2 | 5 row 2 : 5 | 2 | 9 row 3 : 14 | 3 | 2 row 4 : 2 | 2 | 9 row 5 : 13 | 1 | 9 row 6 : 10 | 1 | 5 row 7 : 10 | 3 | 6 row 8 : 7 | 2 | 9 row 9 : 14 | 3 | 8 row 10 : 10 | 2 | 5 row 11 : 10 | 2 | 9 row 12 : 11 | 2 | 1 row 13 : 10 | 3 | 6 row 14 : 8 | 1 | 7 row 15 : 8 | 2 | 5
col : product_details row 1 : Dove Chocolate