SQLSTATE |
HY000 |
DATASOURCE |
celerantSQL |
VENDORERRORCODE |
102 |
SQL |
SELECT distinct style_id
, max(url) as url
, max(realName) as realName
, max(style) as style
, max(overallqoh) as overallqoh
, max(sale) as sale
, max(new) as new
, max(SmallPicture) as SmallPicture
, max(MediumPicture) as MediumPicture
, max(LargePicture) as LargePicture
, min(sortposition) as sortposition
, max(dept) as dept
, max(typ) as typ
, max(subtyp1) as subtyp1
, max(subtyp2) as subtyp2
, max(subtyp3) as subtyp3
, max(brand) as brand
, max(branddisplay) as branddisplay
, max(team) as team
, max(league) as league
, max(priceRange) as priceRange
, min(salePriceRangeBottom) as salePriceRangeBottom
, max(salePriceRangeTop) as salePriceRangeTop
, max(ListPrice) as ListPrice
, max(ranking) as ranking
, max(alternateteam) as alternateteam
, max(romanticcopylong) as romanticcopylong
, max(romanticcopyshort) as romanticcopyshort
, max(depttree) as depttree
, max(weight) as weight
, max(attr1list) as attr1list
, max(sizelist) as sizelist
, max(name) as name
, max(inventorytype) as inventorytype
, max(GOOGLEPRODUCTTAXONOMY) as GOOGLEPRODUCTTAXONOMY
, max(gender) as gender
, max(agerange) as agerange
, max(picture_id) as picture_id
, max(isFeaturedItem) as isFeaturedItem
, max(prodReviewsAverage) as prodReviewsAverage
, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
, max(INTERNALPRICE) as INTERNALPRICE
, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
, max(TERMSALEPRICE) as TERMSALEPRICE
, max(TERMSALE) as TERMSALE
,max(OF12) AS OF12
,max(OF2) AS OF2
,max(OF1) AS OF1
FROM [dbo].[web_all_products] WHERE pictureid is not null
and upper(Brand)=
CHEF`N GROUP BY STYLE_ID
ORDER BY sortposition
|
|