Obtain Product List with detail from order id in Prestashop with MYSQL

Question

Im new in Prestashop ,i want to get the details of products from the id order from the data base so can anyone help me with the mysql query .

Answer 1

Use PrestaShop classes instead of mysql query:

    $order = new Order($id_order);
    $details = $order->getProductsDetail();
    d($details);