Attributes (color) NOT used: a list

[gabgar]

Hi to all

 

I need to get a list of not used attibutes, specifically color attributes.

 

What i need is a list of NOT USED color atributes from my DB.

 

i can get a list of attributes with the query from prestashop it self, but i dont know how to get only the attributes not used in my list. i need this cause a i have 564 different colors and it is really painfull trying to assing a color every single time.

SELECT SQL_CALC_FOUND_ROWS b.*, a.* FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` b ON (b.`id_attribute` = a.`id_attribute` AND b.`id_lang` = 1) WHERE 1 AND a.`id_attribute_group` = 3 ORDER BY a.`position` ASC 

 

Edited March 2, 2020 by gabgar (see edit history)