Jump to content

How get products id without 0 if product has attribute


ArsalanAnsari

Recommended Posts

Hi,

I want to get records from ps_stock_available without default "0" attribute if product has attribute. As you know in ps_stock_available table show's default attribute as 0

for example ...

id_product id_product_attribute
     1              0
     1              12
     1              13
     1              14
     2              0
     3              0
     4              0
     4              1
     4              2
     4              4

What i want is to get records by mysql query such as...

id_product id_product_attribute
    1                12
    1                13
    1                14
    2                0
    3                0
    4                1
    4                2
    4                4

Let me know if someone can help.

Link to comment
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...