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 (107037) ) AND (p.productGroupId > 0 AND FIND_IN_SET('50', 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 = 50 AND (p.id != 107037 ) 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 = 50 AND (p.id != 107037 ) 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 Sportovní souprava Essentials 3-Stripes | A3 Sport – Prodej sportovní obuvi a oblečení
Sportovní souprava pro každodenní nošení by ve tvém šatníku neměla chybět. Tato souprava adidas je vyrobená z měkkého úpletu a má přiléhavý střih. Má všechny nezbytné detaily, jako je vroubkovaný lem a manžety, elastický pas a zapínání na zip. Tento model obsahuje minimálně 70 % recyklovaných a obnovitelných materiálů.