SELECT DISTINCT (SELECT c.id_parent FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category` c ON cp.id_category=c.id_category WHERE cp.id_product=p.`id_product` AND c.id_parent IN(12,13,77) ) AS id_category_basic, (SELECT name FROM `prstshp_category_lang` WHERE id_category=id_category_basic AND id_lang=1 ) AS category_name, (SELECT DISTINCT cl.name FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category` c ON cp.id_category=c.id_category LEFT JOIN `prstshp_category_lang` cl ON cp.id_category=cl.id_category WHERE cp.id_product=p.`id_product` AND c.id_parent=id_category_basic AND cl.id_lang=1 ) AS subcategory_name, (SELECT id_image FROM `prstshp_image` WHERE id_product=p.`id_product` ORDER BY position ASC LIMIT 1) AS first_image, sp.reduction AS p_reduction, sp.reduction_type AS p_reduction_type, p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-04-26 00:00:00", INTERVAL 999 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `prstshp_category_product` cp LEFT JOIN `prstshp_product` p ON p.`id_product` = cp.`id_product` INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prstshp_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `prstshp_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `prstshp_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `prstshp_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `prstshp_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `prstshp_specific_price` sp ON p.`id_product` = sp.`id_product` WHERE product_shop.`id_shop` = 1 AND cp.id_category = 18 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`date_upd` DESC LIMIT 0,12Montagut t-shirts | T-shirts - Montagut
A leader in the mid- to high-range polo shirt market, Montagut’s T-shirts and polos offer a relaxed, casual look without compromising on style. Seasonal palettes incorporate neutrals and block colours as well as fresh graphics, all of which can be dressed up or down. Collars and armholes in contrasting but complementary colours set the T-shirts ...
A leader in the mid- to high-range polo shirt market, Montagut’s T-shirts and polos offer a relaxed, casual look without compromising on style. Seasonal palettes incorporate neutrals and block colours as well as fresh graphics, all of which can be dressed up or down. Collars and armholes in contrasting but complementary colours set the T-shirts and polos apart from the norm as do classical designs and logos that reflect seasonal trends. As well as high-count pure cotton and silk, the company’s signature Fil Lumiere fabric, which is specially designed and tested for warm and humid climates, is commonly used. Sweat is transported away from the body to the fabric’s surface where it evaporates without the fabric itself getting wet, making these polos exceptionally comfortable to wear.
More
Showing 1 - 8 of 8 items
Showing 1 - 8 of 8 items