Jump to content

Edit History

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT  a.id_customer,
        a.firstname,
        a.lastname,
        a.email
FROM    ps_customer a
        LEFT JOIN ps_orders o
            ON a.id_customer = o.id_customer
        LEFT JOIN ps_order_detail b
            ON o.id_order = b.id_order
        LEFT JOIN ps_category_product c
            ON b.product_id = c.id_product
WHERE c.id_category = 4
GROUP BY a.id_customer

obrazek.thumb.png.221acfa66096584b47779482a21f30a9.png

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT  a.id_customer,
        a.firstname,
        a.lastname,
        a.email
FROM    ps_customer a
        LEFT JOIN ps_orders o
            ON a.id_customer = o.id_customer
        LEFT JOIN ps_order_detail b
            ON o.id_order = b.id_order
        LEFT JOIN ps_category_product c
            ON b.product_id = c.id_product
WHERE c.id_category = 4
GROUP BY a.id_customer

 

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT  a.id_customer,
        a.firstname,
        a.lastname,
        a.email
FROM    ps_customer a
        LEFT JOIN ps_orders o
            ON a.id_customer = o.id_customer
        LEFT JOIN ps_order_detail b
            ON o.id_order = b.id_order
        LEFT JOIN ps_category_product c
            ON b.product_id = c.id_product
WHERE c.id_category = 4
GROUP BY a.id_customer

obrazek.thumb.png.498b732cd8399dd9b1a1fa1b3cd7b716.png

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT  a.id_customer,
        a.firstname,
        a.lastname,
        a.email
FROM    ps_customer a
        LEFT JOIN ps_orders o
            ON a.id_customer = o.id_customer
        LEFT JOIN ps_order_detail b
            ON o.id_order = b.id_order
        LEFT JOIN ps_category_product c
            ON b.product_id = c.id_product
WHERE c.id_category = 4
GROUP BY a.id_customer

obrazek.thumb.png.498b732cd8399dd9b1a1fa1b3cd7b716.png

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT  a.id_customer,
        a.firstname,
        a.lastname,
        a.email
FROM    ps_customer a
        LEFT JOIN ps_orders o
            ON a.id_customer = o.id_customer
        LEFT JOIN ps_order_detail b
            ON o.id_order = b.id_order
        LEFT JOIN ps_category_product c
            ON b.product_id = c.id_product
WHERE c.id_category = 4
GROUP BY a.id_customer

 

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT a.id_customer,
       a.firstname,
       a.lastname,
       a.email
FROM   ps_customer a
       LEFT JOIN ps_orders o
              ON a.id_customer = o.id_customer
       LEFT JOIN ps_order_detail b
              ON o.id_order = b.id_order
       LEFT JOIN ps_category_product c
              ON b.product_id = c.id_product
WHERE  c.id_category = 4
GROUP  BY a.id_customer

 

ps8modules

ps8modules

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4: 

SELECT a.id_customer,
       a.firstname,
       a.lastname,
       a.email
FROM   ps_customer a
       LEFT JOIN ps_orders o
              ON a.id_customer = o.id_customer
       LEFT JOIN ps_order_detail b
              ON aa.id_order = b.id_order
       LEFT JOIN ps_category_product c
              ON b.product_id = c.id_product
WHERE  c.id_category = 4
GROUP  BY a.id_customer

 

ps8modules

ps8modules

Hi.

E.g. for id category = 4: 

SELECT a.id_customer,
       a.firstname,
       a.lastname,
       a.email
FROM   ps_customer a
       LEFT JOIN ps_orders o
              ON a.id_customer = o.id_customer
       LEFT JOIN ps_order_detail b
              ON aa.id_order = b.id_order
       LEFT JOIN ps_category_product c
              ON b.product_id = c.id_product
WHERE  c.id_category = 4
GROUP  BY a.id_customer

 

ps8modules

ps8modules

Hi.

E.g. for id category = 4: 

SELECT a.id_customer,
       a.firstname,
       a.lastname,
       a.email
FROM   ps_customer a
       LEFT JOIN ps_orders o
              ON a.id_customer = o.id_customer
       LEFT JOIN ps_order_detail b
              ON aa.id_order = b.id_order
       LEFT JOIN ps_category_product c
              ON b.product_id = c.id_product
WHERE  c.id_category = 4
GROUP  BY a.id_customer

 

×
×
  • Create New...