Alamo Fiesta

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DATE_ENTERED	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH	WS_PRICE
1	[empty string]	WEDDING COLLECTION	Wedding Collection	[empty string]	PARTY SUPPLIES & ARRANGEMENTS	Party Supplies & Arrangements>Interactive Fun	[empty string]	1	49	0	49	1978-DEFAULT-l.jpg	49	1978-DEFAULT-m.jpg	PINATA BRIDE GROOM	N	[empty string]	MADE IN USA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	Y	[empty string]	[empty string]	VALENTINES DAY	WEDDING	[empty string]	PAPER	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Pinata Bride Groom	Bride and Groom Pinata Lrg Size is approximately 4ft. tall and the Med. size is approximately 3ft. tall. The couple comes together as one pinata and the price is for both. You can change hair color, clothing, or gender to whatever you like with a special order. <a href=FOM-SERVICEFEE-FOR-PINATA-SPECIAL-ORDER-PROCESSING-1028> PLEASE CLICK HERE FOR SPECIAL ORDERS</a> All special orders take approximately 2 weeks to make and they have to be picked up at our Fiesta At North Star Location. There is an extra processing $5 fee for all special orders. Calls us to check the inventory to see if your preferences already exist in our vast warehouse so you dont have to pay for the processing fee.	[empty string]	N	49	64	LRG,MED	1978-DEFAULT-s.jpg	[empty string]	1000	1000	PBRI	1319	EMPTY	EMPTY	EMPTY	0	0	0	INTERACTIVE FUN	wedding-collection/pinata-bride-groom-1319	PBRI	0	48.02

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT webstyle , max(style_id) as 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 , max(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(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ws_price) as ws_price , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , 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(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , max(DATE_ENTERED) as DATE_ENTERED , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products_NEW WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = ? and ltrim(rtrim(subtyp1)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) AND ( 1=2 OR upper(sizeList) like ? OR upper(sizeList) like ? OR upper(sizeList) like ? OR upper(sizeList) = ? ) GROUP BY WEBSTYLE

SQLPARAMETERS

array
1	Party Supplies & Arrangements
2	Interactive Fun
3	%headware%selection%
4	%kitchenware%selection%
5	%kitchenware%collection%
6	%easter%selection%
7	%wedding%collection%
8	med,%
9	%,med,%
10	%,med
11	med