Citizen Promaster Land

For over 30 years, the CITIZEN Promaster collection has captured the admiration of adventurers around the world. Embodying the spirit of adventure in the air, on land or at sea, Promaster watches live up to the values of functionality, durability and safety. Professional Promaster watches for high-speed adventurers with all the tools for the toughest environments on land.

SELECT `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`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` 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=1183 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in '1617253141') INNER JOIN `inventory_stock_6` AS `stock_status_index` ON product.sku = stock_status_index.sku LEFT JOIN `catalog_product_entity_int` AS `sw_featured_t` ON e.row_id=sw_featured_t.row_id AND sw_featured_t.attribute_id='173' AND sw_featured_t.store_id='0' WHERE ((stock_status_index.is_salable = 1) AND (e.entity_id IN (16722, 9250, 16762, 20717))) AND (e.created_in '1617253141') ORDER BY `sw_featured_t`.`value` DESC, `cat_index`.`position` ASC, `e`.`entity_id` DESC