SELECT DISTINCT `e`.`entity_id` AS `product_id`, IF(stock.stock_status = 0, 0, IF(attr_name.value like 'minion?___store=hcm%', 1000, IF(attr_name.value like '%minion?___store=hcm%', 999, ((IF((attr_name.value LIKE 'minion?___store=hcm %' OR attr_name.value LIKE ' minion?___store=hcm%' OR attr_name.value LIKE '% minion?___store=hcm' OR attr_name.value LIKE '% minion?___store=hcm %' OR attr_name.value = 'minion?___store=hcm'), 1, 0)))))) AS `relevance` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_varchar` AS `attr_name` ON e.entity_id = attr_name.entity_id AND attr_name.attribute_id = 71
INNER JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id WHERE (attr_name.store_id in (0,2)) AND (((attr_name.value LIKE 'minion''___store=hcm %' OR attr_name.value LIKE ' minion''___store=hcm%' OR attr_name.value LIKE '% minion''___store=hcm' OR attr_name.value LIKE '% minion''___store=hcm %' OR attr_name.value = 'minion''___store=hcm')))
Chúng tôi không tìm thấy sản phẩm theo từ khóa của bạn.