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