SELECT p.id,
p.parentid,
p.exId,
p.productGroupId,
p.productTypeId,
p.storeId,
p.allowedBuy,
p.isOutlet,
p.model,
p.sort,
p.barcode,
p.productCode,
p.quantity as pQuantity,
p.status,
p.image,
p.imageThumbs,
p.numberBuy,
p.isbn,
p.author,
p.rating,
p.commentsFlag,
p.dateAvailability,
p.dateStart,
p.dateEnd,
p.pairedProducts,
p.similarProducts,
p.similarProducts1,
p.attributeIds,
p.listIds,
p.priceInfo,
p.productGroupPath,
p.dateEdit,
p.dateCreate,
p.soonSale,
p.minQuantity,
p.maxQuantity,
p.falseCoupons,
p.multifactor,
p.weight,
p.deliveryDate,
p.deliveryDateMax,
p.fixedDeliveryDate,
p.showDetails,
p.sliderOnProductList,
p.banerOnProductList,
p.useLoyaltyDiscount,
p.forbidShowPrice,
p.priority,
p.changefreq,
p.videoUrl,
p.forbidAddInCart,
p.showConvertedCurrency,
p.showCatalogPrice,
p.supplierCodes,
p.oem,
p.hasChild,
p.packagingQuantity,
p.voucherType,
pl.id as productLangId,
pl.productId,
pl.mid,
pl.lang,
pl.name,
pl.publicName,
pl.url,
pl.shortDescription,
pl.description,
pl.shortName,
pl.tagovi,
pl.permalink,
pl.metaTitle,
pl.metaDescription,
pl.remark,
pl.structure,
pl.declaration,
pl.searchText,
pl.priceDescription,
pl.packaginUnitLang,
pc.purchasePrice as purchasePrice,
pc.marginPercent as marginPercent,
pc.margin as margin,
pc.salePrice as salePrice,
pc.priceBasic as priceBasic,
pc.salePriceWithTax as salePriceWithTax,
MIN(pc.price) AS minimumPrice,
MAX(pc.price) AS maxPrice,
pc.price as price,
pc.oldPrice as oldPrice,
pc.tempPrice as tempPrice,
pc.lastMinPrice as lastMinPrice,
pc.dateUpdateLastMinPrice as dateUpdateLastMinPrice,
pc.montagePrice,
pc.infoPrice,
pc.infoPriceAction,
pc.tax as tax,
pc.taxValue as taxValue,
pc.discount as discount,
pc.discountValue as discountValue,
SUM(pc.quantity) as quantity,
pc.quantity as productQuantity,
pc.valutaId,
pc.catalogId,
pc.combinationCode,
pc.combinationBarcode,
pg.path as path,
pc.valutaCode as valutaCode,
pc.onQuery,
pc.onQueryWithPrice,
pc.canBuy,
pc.id as productCombId,
pc.loyaltyPrice
FROM nb_product p
INNER JOIN nb_product_lang pl ON pl.productId = p.id AND pl.lang = 'cz'
INNER JOIN nb_product_group pg ON pg.id = p.productGroupId
INNER JOIN nb_product_group_lang pgl ON pgl.productGroupId = pg.id AND pgl.lang = 'cz'
INNER JOIN nb_products_combinations pc ON pc.productId = p.id
WHERE pc.price > 0 AND pc.status = 1 AND pc.mainComb = -1 AND pc.catalogId = 1 AND (pc.quantity > 0 ) AND p.status = 1 AND p.del = -1 AND pg.status = 1 AND pg.del = -1 AND pc.del = -1 AND (p.id NOT IN (88097) ) AND (p.productGroupId > 0 AND FIND_IN_SET('33', p.productGroupPath) ) AND pl.lang = 'cz' AND pgl.lang = 'cz' AND (p.numberImages > 0 )
GROUP BY p.id
ORDER BY p.recommended DESC, (pg.sort*-1) DESC, p.id DESC, (p.sort*-1) DESC
LIMIT 0,4
SELECT p.id,
p.parentid,
p.exId,
p.productGroupId,
p.productTypeId,
p.storeId,
p.allowedBuy,
p.isOutlet,
p.model,
p.sort,
p.barcode,
p.productCode,
p.quantity as pQuantity,
p.status,
p.image,
p.imageThumbs,
p.numberBuy,
p.isbn,
p.author,
p.rating,
p.commentsFlag,
p.dateAvailability,
p.dateStart,
p.dateEnd,
p.pairedProducts,
p.similarProducts,
p.similarProducts1,
p.attributeIds,
p.listIds,
p.priceInfo,
p.productGroupPath,
p.dateEdit,
p.dateCreate,
p.soonSale,
p.minQuantity,
p.maxQuantity,
p.falseCoupons,
p.multifactor,
p.weight,
p.deliveryDate,
p.deliveryDateMax,
p.fixedDeliveryDate,
p.showDetails,
p.sliderOnProductList,
p.banerOnProductList,
p.useLoyaltyDiscount,
p.forbidShowPrice,
p.priority,
p.changefreq,
p.videoUrl,
p.forbidAddInCart,
p.showConvertedCurrency,
p.showCatalogPrice,
p.supplierCodes,
p.oem,
p.hasChild,
p.packagingQuantity,
p.voucherType,
pl.id as productLangId,
pl.productId,
pl.mid,
pl.lang,
pl.name,
pl.publicName,
pl.url,
pl.shortDescription,
pl.description,
pl.shortName,
pl.tagovi,
pl.permalink,
pl.metaTitle,
pl.metaDescription,
pl.remark,
pl.structure,
pl.declaration,
pl.searchText,
pl.priceDescription,
pl.packaginUnitLang,
pc.purchasePrice as purchasePrice,
pc.marginPercent as marginPercent,
pc.margin as margin,
pc.salePrice as salePrice,
pc.priceBasic as priceBasic,
pc.salePriceWithTax as salePriceWithTax,
MIN(pc.price) AS minimumPrice,
MAX(pc.price) AS maxPrice,
pc.price as price,
pc.oldPrice as oldPrice,
pc.tempPrice as tempPrice,
pc.lastMinPrice as lastMinPrice,
pc.dateUpdateLastMinPrice as dateUpdateLastMinPrice,
pc.montagePrice,
pc.infoPrice,
pc.infoPriceAction,
pc.tax as tax,
pc.taxValue as taxValue,
pc.discount as discount,
pc.discountValue as discountValue,
SUM(pc.quantity) as quantity,
pc.quantity as productQuantity,
pc.valutaId,
pc.catalogId,
pc.combinationCode,
pc.combinationBarcode,
pg.path as path,
pc.valutaCode as valutaCode,
pc.onQuery,
pc.onQueryWithPrice,
pc.canBuy,
pc.id as productCombId,
pc.loyaltyPrice
FROM nb_product p
INNER JOIN nb_product_lang pl ON pl.productId = p.id AND pl.lang = 'cz'
INNER JOIN nb_product_group pg ON pg.id = p.productGroupId
INNER JOIN nb_product_group_lang pgl ON pgl.productGroupId = pg.id AND pgl.lang = 'cz'
INNER JOIN nb_products_combinations pc ON pc.productId = p.id
WHERE pc.price > 0 AND pc.status = 1 AND pc.mainComb = -1 AND pc.catalogId = 1 AND (pc.quantity > 0 ) AND p.status = 1 AND p.del = -1 AND pg.status = 1 AND pg.del = -1 AND pc.del = -1 AND p.productGroupId = 33 AND (p.id != 88097 ) AND (p.model != '' AND p.model = '' ) AND pl.lang = 'cz' AND pgl.lang = 'cz' AND (p.numberImages > 0 ) AND ( FIND_IN_SET( '342', p.attributeIds ) ) AND ( FIND_IN_SET( '360', p.attributeIds ) )
GROUP BY p.id
ORDER BY p.recommended DESC, (pg.sort*-1) DESC, p.id DESC, (p.sort*-1) DESC
LIMIT 0,50
SELECT p.id,
p.parentid,
p.exId,
p.productGroupId,
p.productTypeId,
p.storeId,
p.allowedBuy,
p.isOutlet,
p.model,
p.sort,
p.barcode,
p.productCode,
p.quantity as pQuantity,
p.status,
p.image,
p.imageThumbs,
p.numberBuy,
p.isbn,
p.author,
p.rating,
p.commentsFlag,
p.dateAvailability,
p.dateStart,
p.dateEnd,
p.pairedProducts,
p.similarProducts,
p.similarProducts1,
p.attributeIds,
p.listIds,
p.priceInfo,
p.productGroupPath,
p.dateEdit,
p.dateCreate,
p.soonSale,
p.minQuantity,
p.maxQuantity,
p.falseCoupons,
p.multifactor,
p.weight,
p.deliveryDate,
p.deliveryDateMax,
p.fixedDeliveryDate,
p.showDetails,
p.sliderOnProductList,
p.banerOnProductList,
p.useLoyaltyDiscount,
p.forbidShowPrice,
p.priority,
p.changefreq,
p.videoUrl,
p.forbidAddInCart,
p.showConvertedCurrency,
p.showCatalogPrice,
p.supplierCodes,
p.oem,
p.hasChild,
p.packagingQuantity,
p.voucherType,
pl.id as productLangId,
pl.productId,
pl.mid,
pl.lang,
pl.name,
pl.publicName,
pl.url,
pl.shortDescription,
pl.description,
pl.shortName,
pl.tagovi,
pl.permalink,
pl.metaTitle,
pl.metaDescription,
pl.remark,
pl.structure,
pl.declaration,
pl.searchText,
pl.priceDescription,
pl.packaginUnitLang,
pc.purchasePrice as purchasePrice,
pc.marginPercent as marginPercent,
pc.margin as margin,
pc.salePrice as salePrice,
pc.priceBasic as priceBasic,
pc.salePriceWithTax as salePriceWithTax,
MIN(pc.price) AS minimumPrice,
MAX(pc.price) AS maxPrice,
pc.price as price,
pc.oldPrice as oldPrice,
pc.tempPrice as tempPrice,
pc.lastMinPrice as lastMinPrice,
pc.dateUpdateLastMinPrice as dateUpdateLastMinPrice,
pc.montagePrice,
pc.infoPrice,
pc.infoPriceAction,
pc.tax as tax,
pc.taxValue as taxValue,
pc.discount as discount,
pc.discountValue as discountValue,
SUM(pc.quantity) as quantity,
pc.quantity as productQuantity,
pc.valutaId,
pc.catalogId,
pc.combinationCode,
pc.combinationBarcode,
pg.path as path,
pc.valutaCode as valutaCode,
pc.onQuery,
pc.onQueryWithPrice,
pc.canBuy,
pc.id as productCombId,
pc.loyaltyPrice
FROM nb_product p
INNER JOIN nb_product_lang pl ON pl.productId = p.id AND pl.lang = 'cz'
INNER JOIN nb_product_group pg ON pg.id = p.productGroupId
INNER JOIN nb_product_group_lang pgl ON pgl.productGroupId = pg.id AND pgl.lang = 'cz'
INNER JOIN nb_products_combinations pc ON pc.productId = p.id
WHERE pc.price > 0 AND pc.status = 1 AND pc.mainComb = -1 AND pc.catalogId = 1 AND (pc.quantity > 0 ) AND p.status = 1 AND p.del = -1 AND pg.status = 1 AND pg.del = -1 AND pc.del = -1 AND p.productGroupId = 33 AND (p.id != 88097 ) AND (p.model != '' AND p.model = '' ) AND pl.lang = 'cz' AND pgl.lang = 'cz' AND (p.numberImages > 0 ) AND ( FIND_IN_SET( '342', p.attributeIds ) ) AND ( FIND_IN_SET( '360', p.attributeIds ) )
GROUP BY p.id
ORDER BY p.recommended DESC, (pg.sort*-1) DESC, p.id DESC, (p.sort*-1) DESC
LIMIT 0,50
adidas TR-ES 3S T | A3 Sport – Prodej sportovní obuvi a oblečení
Dámské tréninkové tričko adidas Essentials dává sbohem rozptylování během tréninků různé intenzity.
Toto inovativní sportovní tričko s technologií FreeLift je stvořeno pro ty, kteří nechtějí být omezováni ve svém pohybu. Díky revoluční konstrukci FreeLift můžete pohybem naplno využít svůj plný rozsah pohybu, aniž byste museli řešit nepříjemné posouvání trička, dokonce i při zvedání rukou nad hlavu. Jeho odolnost proti posunutí v kombinaci s technologií Aeroready zajišťuje, že zůstanete v suchu a pohodlí i během náročných tréninků. Aeroready je vybaveno schopností odvádět vlhkost, což znamená, že se můžete plně soustředit na svůj výkon bez obav z nepříjemného pocitu vlhkého oblečení. Navíc je toto tričko vyrobeno z recyklovaných materiálů, což přispívá k redukci plastového odpadu a podporuje udržitelnost. Adidas se zavázal k ochraně životního prostředí, a toto tričko je skvělým příkladem spojení výkonu a ekologické odpovědnosti. Můžete si být jisti, že přispíváte k lepšímu životnímu prostředí, zatímco dosahujete svých sportovních cílů. Začleňte do svého sportovního arzenálu tričko, které nejen podporuje váš výkon, ale také svědčí o vaší angažovanosti ve prospěch planety. Logo značky adidas na něm není jen symbolem kvality, ale také vaším partnerem při každém kroku směrem k dosažení vašich fitness cílů.
Specifikace:
Dámské tréninkové tričko Krátký rukáv Klasický střih Technologie Aeroready Kulatý výstřih Produkt Primegreen Design FreeLift < li> Logo adidas
Vlastnosti
Hodnota
Kategorie
Trička
Skupina
Oblečení
Barva
Zelená
Pohlaví
Ženy
Sport
Trénink
Značky
adidas
Věk
Dospělí
Dětské triko
Velikost
YLG
YLG
YMD
YMD
YSM
YSM
YXL
YXL
YXS
YXS
Přidat do košíku
Dámské tréninkové tričko
Velikost
SM
SM
XS
XS
LG
LG
MD
MD
XL
XL
Přidat do košíku
Dětské basketbalové tričko
Cena
319,00
Kč
Úspora
60%
799,00 Kč
Pánské outdoor tričko
Velikost
S
S
M
M
L
L
XL
XL
2XL
2XL
3XL
3XL
Přidat do košíku