mysql - 如何在 prestashop 的 mysql 数据库中获取每个产品项目的完整详细信息

Question

我正在尝试获取数据库中每个项目(产品 ID、产品名称、引用代码、功能、description_short、描述)的完整详细信息，但我不知道对此的确切查询， 我的数据库是 mysql 该项目所需的所有详细信息都驻留在不同的表中...每个功能名称都有不同的 ID，每个功能值都有不同的 ID，我不知道获取项目所有详细信息的查询..

请将查询发给我....

提前致谢

Answer 1

请尝试这个查询

SELECT
        a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active
        , shp.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, sa.`active`
        FROM `ps_product` a
        LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)

        LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product`)
        LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
         AND sav.id_shop = 1 )  JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = 1)
                LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = 1)
                LEFT JOIN `ps_shop` shop ON (shop.id_shop = 1) 
                LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = 1) 

        GROUP BY sa.id_product