Обсуждение и советы: создание интернет-магазинов - решения, процессы, прайсинг

Код: Выделить всё

SET @id_lang = 1;;;
SET @id_feature = (SELECT id_feature FROM ps_feature_lang WHERE name = 'Серия');;;
 
INSERT INTO ps_tag (id_lang, name) 
SELECT @id_lang AS id_lang, ps_feature_value_lang.value 
FROM ps_feature_product 
INNER JOIN ps_feature_value_lang ON ps_feature_value_lang.id_feature_value=ps_feature_product.id_feature_value
WHERE ps_feature_product.id_feature=@id_feature AND 
	  ps_feature_value_lang.id_lang=@id_lang AND 
	  ps_feature_value_lang.value NOT IN (SELECT ps_tag.name FROM ps_tag GROUP BY ps_tag.name) 
GROUP BY ps_feature_value_lang.value;;;

INSERT INTO ps_product_tag (id_product, id_tag) 
SELECT ps_feature_product.id_product, ps_tag.id_tag 
FROM ps_feature_product 
INNER JOIN ps_feature_value_lang ON ps_feature_value_lang.id_feature_value=ps_feature_product.id_feature_value 
INNER JOIN ps_tag ON ps_feature_value_lang.value=ps_tag.name 
WHERE ps_feature_product.id_feature=@id_feature AND 
	  ps_feature_value_lang.id_lang=@id_lang AND 
	  ps_tag.id_lang=@id_lang AND 
	  ps_tag.id_tag NOT IN (SELECT id_tag FROM ps_product_tag WHERE ps_product_tag.id_product=ps_feature_product.id_product) 
GROUP BY ps_feature_product.id_product, ps_feature_value_lang.value;;;