Sitka ir zīmols, kurš nepieciešamības dēļ tika radīts 2005. gadā. Gluži kā daudzi stāsti, arī šis sākās kā ceļojums, kas beidzās ar skaidru vīziju. Sitka eksistē, lai paaugstinātu standartus pēc kādiem tiek vērtēti visi nozares zīmoli
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='557'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 ORDER BY `cat_index`.`position` ASC
LIMIT 12
Incinerator cepure
Cepure
Core plānā apkakle
Mugursoma Flash20
Uzrocis Incinerator
Siltā apkakle
Mountain
Core Heavyweight Bottom
Jaka Kelvin lite hoody
Bikses Coldfront
Bikses Incinerator
Bikses Fanatic Elevated
