Alamo Fiesta

Filter By

Sort By :

Items Per Page :

query

RESULTSET

query
	ATTR1	ATTR1_ALIAS	ATTR1_ENTRY_ID	ATTR1_ORDER	ATTR2	ATTR2_ENTRY_ID	ATTR2_ORDER	FAM	FAM_HEX	HEX	LIST_PRICE	ORIGATTR1	ORIGATTR2	ORIGSIZ	PICTURE_ID	PRICE	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SIZY	SKU_ID	STYLE_ID
1	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	MED	358	0.00	2830	3868	MED	[empty string]	MED	1855	827
2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	SML	358	0.00	4923	3869	SML	[empty string]	SML	1856	827
3	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	LRG	358	0.00	338	3870	LRG	[empty string]	LRG	1857	827
4	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	XL	358	0.00	-432	3871	XL	[empty string]	XL	1858	827
5	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	2XL	358	0.00	-685	3872	2XL	[empty string]	2XL	1859	827
6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	3XL	358	0.00	51	3873	3XL	[empty string]	3XL	1860	827
7	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	2	358	0.00	-145	3874	2	[empty string]	2	1861	827
8	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	4	358	0.00	-144	3875	4	[empty string]	4	1862	827
9	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	6	358	0.00	-288	3876	6	[empty string]	6	1863	827
10	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	8	358	0.00	-406	3877	8	[empty string]	8	1864	827
11	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	10	358	0.00	-20	3878	10 Inch	[empty string]	10 Inch	1865	827
12	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	12	358	0.00	-21	3879	12	[empty string]	12	1866	827
13	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	14	358	0.00	-142	3880	14	[empty string]	14	1867	827
14	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	16	358	0.00	-2	3881	16	[empty string]	16	1868	827
15	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	4XL	358	0.00	153	3882	4XL	[empty string]	4XL	7546	827
16	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	5XL	358	0.00	1021	3883	5XL	[empty string]	5XL	7547	827
17	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	6XL	358	0.00	619	3884	6XL	[empty string]	6XL	8303	827

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id

SQLPARAMETERS

array
1	827
2	3

Quick View

Blouse Clavel Corto Redondo

Clothing Selection $24.00 to $42.00 Choose options

query

RESULTSET

query
	ATTR1	ATTR1_ALIAS	ATTR1_ENTRY_ID	ATTR1_ORDER	ATTR2	ATTR2_ENTRY_ID	ATTR2_ORDER	FAM	FAM_HEX	HEX	LIST_PRICE	ORIGATTR1	ORIGATTR2	ORIGSIZ	PICTURE_ID	PRICE	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SIZY	SKU_ID	STYLE_ID
1	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	SML	1813	0.00	-372	3923	SML	[empty string]	SML	8590	6047
2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	MED	1813	0.00	-450	3924	MED	[empty string]	MED	8591	6047
3	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	LRG	1813	0.00	-401	3925	LRG	[empty string]	LRG	8592	6047
4	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	XL	1813	0.00	-502	3926	XL	[empty string]	XL	8593	6047
5	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	2XL	1813	0.00	-530	3927	2XL	[empty string]	2XL	8594	6047
6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	3XL	1813	0.00	-241	3928	3XL	[empty string]	3XL	8595	6047
7	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	4XL	1813	0.00	-53	3929	4XL	[empty string]	4XL	8596	6047
8	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	5XL	1813	0.00	-28	3930	5XL	[empty string]	5XL	8597	6047
9	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	6XL	1813	0.00	-97	3931	6XL	[empty string]	6XL	8598	6047
10	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	14Y	1813	0.00	-224	3932	14Y	[empty string]	14Y	8624	6047
11	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	16Y	1813	0.00	-2	3933	16Y	[empty string]	16Y	8625	6047

CACHED

false

EXECUTIONTIME

SQL

SQLPARAMETERS

array
1	6047
2	3

Quick View

Dress Puebla Adult Tradicional 90/5poly

Clothing Selection $38.00 to $52.00 Choose options

query

RESULTSET

query
	ATTR1	ATTR1_ALIAS	ATTR1_ENTRY_ID	ATTR1_ORDER	ATTR2	ATTR2_ENTRY_ID	ATTR2_ORDER	FAM	FAM_HEX	HEX	LIST_PRICE	ORIGATTR1	ORIGATTR2	ORIGSIZ	PICTURE_ID	PRICE	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SIZY	SKU_ID	STYLE_ID
1	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	XS	1964	0.00	2	3581	XS	[empty string]	XS	4283	2401
2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	SML	1964	0.00	-12	3582	SML	[empty string]	SML	4284	2401
3	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	MED	1964	0.00	513	3583	MED	[empty string]	MED	4285	2401
4	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	LRG	1964	0.00	-157	3584	LRG	[empty string]	LRG	4286	2401
5	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	XL	1964	0.00	3	3585	XL	[empty string]	XL	4287	2401
6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	2XL	1964	0.00	60	3586	2XL	[empty string]	2XL	4288	2401
7	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	3XL	1964	0.00	0	3587	3XL	[empty string]	3XL	4289	2401
8	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	4XL	1964	0.00	0	3588	4XL	[empty string]	4XL	4290	2401

CACHED

false

EXECUTIONTIME

SQL

SQLPARAMETERS

array
1	2401
2	3

Quick View Pickup Only

Dress Adultsan Antonino Short Sleeve

Clothing Selection $169.00 to $179.00 Choose options

query

RESULTSET

query
	ATTR1	ATTR1_ALIAS	ATTR1_ENTRY_ID	ATTR1_ORDER	ATTR2	ATTR2_ENTRY_ID	ATTR2_ORDER	FAM	FAM_HEX	HEX	LIST_PRICE	ORIGATTR1	ORIGATTR2	ORIGSIZ	PICTURE_ID	PRICE	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SIZY	SKU_ID	STYLE_ID
1	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	SML	929	0.00	0	386	SML	[empty string]	SML	632	358
2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	MED	929	0.00	0	387	MED	[empty string]	MED	633	358
3	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.00	[empty string]	[empty string]	XL	929	0.00	0	388	XL	[empty string]	XL	634	358

CACHED

false

EXECUTIONTIME

SQL

SQLPARAMETERS

array
1	358
2	3

Quick View

Blouse Punto De Cruz

Clothing Selection $24.00 to $28.00 Choose options