REEF BRAZIL

Reef Women's Ginger Sandals

$28.00

Item # 1660

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 05 6 2119 5 25 94851 32390
2 06 17 2120 6 34 483007 32390
3 07 11 2121 7 42 94850 32390
4 08 13 2122 8 50 483009 32390
5 09 4 2123 9 60 94904 32390
6 10 7 2124 10 88 483011 32390
CACHED false
EXECUTIONTIME 878
SQL SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 1660
2 32390
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 BLK/BLK BK2 [empty string] 126219 [empty string] [empty string] BLK/BLK BK2 51 2124 94955 [empty string] 32390
2 BLK.BLSH_KBS [empty string] 126242 [empty string] [empty string] BLK.BLSH_KBS 7 2124 483011 [empty string] 32390
CACHED false
EXECUTIONTIME 4
SQL SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 32390
Reef Women's Ginger Sandals BLKBLK BK2 Reef Women's Ginger Sandals BLK.BLSH_KBS
5 6 7 8 9 10
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94848 98 1660
2 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94849 98 1660
3 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 11 2121 94850 98 1660
4 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 6 2119 94851 98 1660
5 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94852 98 1660
6 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94853 98 1660
7 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94854 98 1660
8 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94855 98 1660
9 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94856 98 1660
10 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94857 98 1660
11 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94858 98 1660
12 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94859 98 1660
13 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94860 98 1660
14 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94861 98 1660
15 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94862 98 1660
16 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94863 98 1660
17 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94864 98 1660
18 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94865 98 1660
19 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94866 98 1660
20 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94867 98 1660
21 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94868 98 1660
22 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94869 98 1660
23 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94870 98 1660
24 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94871 98 1660
25 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94872 98 1660
26 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94873 98 1660
27 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94874 98 1660
28 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94875 98 1660
29 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94876 98 1660
30 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94877 98 1660
31 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94878 98 1660
32 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94879 98 1660
33 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94880 98 1660
34 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94881 98 1660
35 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94882 98 1660
36 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94883 98 1660
37 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94884 98 1660
38 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94885 98 1660
39 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94886 98 1660
40 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 15 2120 94887 98 1660
41 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94888 98 1660
42 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94889 98 1660
43 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94890 98 1660
44 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94891 98 1660
45 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 11 2122 94892 98 1660
46 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94893 98 1660
47 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94894 98 1660
48 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94895 98 1660
49 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94896 98 1660
50 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94897 98 1660
51 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94898 98 1660
52 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94899 98 1660
53 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94900 98 1660
54 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94901 98 1660
55 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94902 98 1660
56 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94903 98 1660
57 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 4 2123 94904 98 1660
58 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94905 98 1660
59 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94906 98 1660
60 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94907 98 1660
61 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94908 98 1660
62 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94909 98 1660
63 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94910 98 1660
64 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94911 98 1660
65 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 1 2125 94912 98 1660
66 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94913 98 1660
67 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94914 98 1660
68 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94915 98 1660
69 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94916 98 1660
70 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94917 98 1660
71 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94918 98 1660
72 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94919 98 1660
73 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94920 98 1660
74 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94921 98 1660
75 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94922 98 1660
76 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94923 98 1660
77 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94924 98 1660
78 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94925 98 1660
79 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94926 98 1660
80 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94927 98 1660
81 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94928 98 1660
82 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94929 98 1660
83 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94930 98 1660
84 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94931 98 1660
85 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94932 98 1660
86 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94933 98 1660
87 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94934 98 1660
88 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94935 98 1660
89 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94936 98 1660
90 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94937 98 1660
91 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94938 98 1660
92 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94939 98 1660
93 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94940 98 1660
94 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94941 98 1660
95 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94942 98 1660
96 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94943 98 1660
97 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94944 98 1660
98 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94945 98 1660
99 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94946 98 1660
100 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94947 98 1660
101 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94948 98 1660
102 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94949 98 1660
103 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94950 98 1660
104 126222 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94951 98 1660
105 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94952 98 1660
106 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94953 98 1660
107 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94954 98 1660
108 126219 [empty string] 50-WOMENS FOOTWEAR [empty string] 4 2124 94955 98 1660
109 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 94956 98 1660
110 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94957 98 1660
111 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94958 98 1660
112 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94959 98 1660
113 126228 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 94960 98 1660
114 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94961 98 1660
115 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94962 98 1660
116 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94963 98 1660
117 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94964 98 1660
118 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94965 98 1660
119 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94966 98 1660
120 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94967 98 1660
121 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94968 98 1660
122 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94969 98 1660
123 126235 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 94970 98 1660
124 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 94971 98 1660
125 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 94972 98 1660
126 126237 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 94973 98 1660
127 126240 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 94974 98 1660
128 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128866 98 1660
129 126239 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128867 98 1660
130 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128868 98 1660
131 126238 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128869 98 1660
132 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128870 98 1660
133 126236 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128871 98 1660
134 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128872 98 1660
135 126234 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128873 98 1660
136 126233 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128874 98 1660
137 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128875 98 1660
138 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 128876 98 1660
139 126232 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128877 98 1660
140 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128878 98 1660
141 126231 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128879 98 1660
142 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128880 98 1660
143 126230 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128881 98 1660
144 126229 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128882 98 1660
145 126227 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128883 98 1660
146 126226 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128884 98 1660
147 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128885 98 1660
148 126225 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128886 98 1660
149 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128887 98 1660
150 126224 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128888 98 1660
151 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 128889 98 1660
152 126223 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128890 98 1660
153 126221 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128891 98 1660
154 126220 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 128892 98 1660
155 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 144165 98 1660
156 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2120 144166 98 1660
157 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 144167 98 1660
158 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2122 144168 98 1660
159 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 144169 98 1660
160 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2124 144170 98 1660
161 126241 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 144171 98 1660
162 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2119 483006 98 1660
163 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 2 2120 483007 98 1660
164 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2121 483008 98 1660
165 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 2 2122 483009 98 1660
166 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2123 483010 98 1660
167 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 3 2124 483011 98 1660
168 126242 [empty string] 50-WOMENS FOOTWEAR [empty string] 0 2125 483012 98 1660
CACHED false
EXECUTIONTIME 1819
SQL SELECT sum(c.qoh+c.qc) as qoh ,max(b.sku_id) as sku_id , max(b.scale_entry_id) as scale_entry_id , max(b.attr2_entry_id) as attr2_entry_id , max(e.attr1_entry_id) as attr1_entry_id , max(g.dept) as dept , max(a.style) as style , max(c.store_id) as store_id , max(h.purchase_amount) as purchase_amount FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id) LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id) LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE (b.style_id IN ( SELECT style_id FROM tb_styles WHERE web_style = '1660' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 32390
59
Add to Cart Find in Store Add to Wish List

product description Find comfort that will exceed expectations at a fair price with the Reef Women's Ginger Sandals. From brunch to the boat, or biking to the beach, Reef Ginger sandals will do the trick. Designed for all-day wear, these sandals feature soft woven polyester straps, Reef-Flex triple density EVA construction with anatomical arch support, and a durable, high density EVA outsole.
product specs
  • Soft, slim woven polyester strap
  • Reef flex triple-density EVA construction
  • Durable rubber outsole
  • Anatomical arch support
  • Water friendly
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

No reviews have been written for this product.
Be the first one!  –


FREE SHIPPING* ON ORDERS OVER $100.00
My Bag (0)
Menu

query
RESULTSET
query
  ADDITIONAL_DESCRIPTION AGERANGE ALTIMAGERECORDCOUNT ATTR1ID ATTR1LIST ATTR2ID BRAND BRANDDISPLAY DEPT DEPTTREE DESCRIPTION FAMLIST GENDER GOOGLEPRODUCTTAXONOMY HEXLIST ID INSTORE_ONLY INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE KEYWORDS LARGEPICTURE LISTPRICE LOWESTPRICE MEDIUMPICTURE METADESC METATAGS NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 ORIGBRAND OVERALLQOH OVERALL_RATING PAGETITLE PICTUREID PICTURE_ID PRICERANGE PRODREVIEWSAVERAGE PRODREVIEWSRECORDCOUNT QUANTITYONHANDSUM QUANTITYSOLDSUM RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SCALEID SHIP_SURCHARGE SIZELIST SIZING_IMAGE_FILE SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TINYPICTURE TYP URL USEPACKAGE VIDEO WEBSTYLE WEB_OF1 WEB_OF10 WEB_OF11 WEB_OF12 WEB_OF13 WEB_OF14 WEB_OF15 WEB_OF16 WEB_OF17 WEB_OF18 WEB_OF19 WEB_OF2 WEB_OF20 WEB_OF3 WEB_OF4 WEB_OF5 WEB_OF6 WEB_OF7 WEB_OF8 WEB_OF9
1 <li>Soft, slim woven polyester strap</li> <li>Reef flex triple-density EVA construction</li> <li>Durable rubber outsole</li> <li>Anatomical arch support</li> <li>Water friendly</li> [empty string] [empty string] 58045 BLK/BLK BK2,BLK.BLSH_KBS, [empty string] REEF BRAZIL REEF BRAZIL CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Footwear &gt Sandals &gt Flip-Flops [empty string] [empty string] [empty string] 596 [empty string] 27236906 [empty string] 28 28 28 [empty string] 14087-DEFAULT-l.jpg 28 [empty string] 14087-DEFAULT-m.jpg Find comfort that will exceed expectations at a fair price with the Reef Women's Ginger Sandals. [empty string] W/Ginger N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 50G [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] [empty string] REEF BRAZIL 57 0 [empty string] 14087 14087 25-to-50 0.00 0 [empty string] [empty string] [empty string] Reef Women's Ginger Sandals Find comfort that will exceed expectations at a fair price with the Reef Women's Ginger Sandals. From brunch to the boat, or biking to the beach, Reef Ginger sandals will do the trick. Designed for all-day wear, these sandals feature soft woven polyester straps, Reef-Flex triple density EVA construction with anatomical arch support, and a durable, high density EVA outsole. [empty string] N 28 28 974 0 10,5,6,7,8,9, [empty string] 14087-DEFAULT-s.jpg 1000 1660 32390 FOOTWEAR SANDALS FLIP-FLOPS 0 [empty string] [empty string] 14087-DEFAULT-xs.jpg WOMENS shop/reef-womens-ginger-sandals-32390 0 [empty string] 1660 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 28
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='32390' order by ID desc