SELECT DISTINCT `e`.`entity_id` AS `product_id`, IF(stock.stock_status = 0, 0, IF(attr_name.value like 'garfield%', 1000, IF(attr_name.value like '%garfield%', 999, ((IF((attr_name.value LIKE 'garfield %' OR attr_name.value LIKE ' garfield%' OR attr_name.value LIKE '% garfield' OR attr_name.value LIKE '% garfield %' OR attr_name.value = 'garfield'), 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,1)) AND (((attr_name.value LIKE 'garfield %' OR attr_name.value LIKE ' garfield%' OR attr_name.value LIKE '% garfield' OR attr_name.value LIKE '% garfield %' OR attr_name.value = 'garfield')))
Chúng tôi không tìm thấy sản phẩm theo từ khóa của bạn.