Jump to content

Bug in PS 8: SQL Query


Recommended Posts

SQL Query (group/customer):

SELECT c.`id_customer` AS `id_customer`, `id_gender`, `firstname`, `lastname`, c.`email` AS `email`, `birthday`, `date_add`, c.`active` AS `active`
, c.*, a.id_group
FROM `ps_customer_group` a 
LEFT JOIN `ps_customer` c ON (a.`id_customer` = c.`id_customer`) 
 WHERE 1 AND a.`id_group` = 3 AND c.`deleted` != 1 AND c.id_shop IN (1)  
 ORDER BY id_group ASC

SQL Query save:


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More