Jump to content

[solved] Which table contains Colour Picker field?


Recommended Posts

I'm trying to write a query that displays all products with combinations > 0, but does not have a Colour Picker = TRUE



But I can't seem to find where this value is stored. It makes sense that it should be in ps_product but it's not. Does anyone have any idea?

Link to comment
Share on other sites

I just wrote the following query in case anyone wants to use it in the future:



SELECT ps_product_lang.name, ps_product.id_product AS id

FROM ps_product

LEFT JOIN ps_product_attribute ON

ps_product.id_product = ps_product_attribute.id_product

INNER JOIN ps_product_lang ON

ps_product_lang.id_product = ps_product.id_product

WHERE ps_product.active = 1 AND ps_product.id_color_default = 0

GROUP BY ps_product.id_product

HAVING COUNT(ps_product.id_product) > 1

Edited by noesac (see edit history)
  • Like 2
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...