#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts

Simply Simmons Short Handle Brushes

by Robert Simmons


Problem with item sku 78142. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018446
barcode_type UPC
col1 angle comb
col1_sortorder 72
col2 1/4 in.
col2_sortorder 578
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle comb, 1/4 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78142
list_price 4.7
map NO
mfr_num 255058025
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78142
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78142
2 255058025
3 angle comb, 1/4 in.
timestamp 2015-03-26T14:52:10.193Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78144. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018453
barcode_type UPC
col1 angle comb
col1_sortorder 72
col2 3/8 in.
col2_sortorder 358
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle comb, 3/8 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78144
list_price 4.7
map NO
mfr_num 255058037
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78144
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78144
2 255058037
3 angle comb, 3/8 in.
timestamp 2015-03-26T14:52:10.218Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78145. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019443
barcode_type UPC
col1 angle comb
col1_sortorder 72
col2 1/2 in.
col2_sortorder 359
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle comb, 1/2 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78145
list_price 4.7
map NO
mfr_num 255058050
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78145
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78145
2 255058050
3 angle comb, 1/2 in.
timestamp 2015-03-26T14:52:10.224Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78131. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019412
barcode_type UPC
col1 angle shader
col1_sortorder 73
col2 1/8 in.
col2_sortorder 506
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle shader, 1/8 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78131
list_price 4.7
map NO
mfr_num 255057012
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78131
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78131
2 255057012
3 angle shader, 1/8 in.
timestamp 2015-03-26T14:52:10.107Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78132. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018415
barcode_type UPC
col1 angle shader
col1_sortorder 73
col2 1/4 in.
col2_sortorder 578
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle shader, 1/4 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78132
list_price 4.7
map NO
mfr_num 255057025
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78132
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78132
2 255057025
3 angle shader, 1/4 in.
timestamp 2015-03-26T14:52:10.113Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78134. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018422
barcode_type UPC
col1 angle shader
col1_sortorder 73
col2 3/8 in.
col2_sortorder 358
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle shader, 3/8 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78134
list_price 4.7
map NO
mfr_num 255057037
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78134
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78134
2 255057037
3 angle shader, 3/8 in.
timestamp 2015-03-26T14:52:10.139Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78136. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019429
barcode_type UPC
col1 angle shader
col1_sortorder 73
col2 5/8 in.
col2_sortorder 1994
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle shader, 5/8 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78136
list_price 4.7
map NO
mfr_num 255057062
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78136
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78136
2 255057062
3 angle shader, 5/8 in.
timestamp 2015-03-26T14:52:10.164Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78138. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018439
barcode_type UPC
col1 angle shader
col1_sortorder 73
col2 1/2 in.
col2_sortorder 359
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle shader, 1/2 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78138
list_price 4.7
map NO
mfr_num 255057050
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78138
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78138
2 255057050
3 angle shader, 1/2 in.
timestamp 2015-03-26T14:52:10.175Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78140. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019436
barcode_type UPC
col1 angle shader
col1_sortorder 73
col2 3/4 in.
col2_sortorder 360
col3 [empty string]
cost 1.61
deal_of_the_week NO
description angle shader, 3/4 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78140
list_price 4.7
map NO
mfr_num 255057075
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78140
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78140
2 255057075
3 angle shader, 3/4 in.
timestamp 2015-03-26T14:52:10.186Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78206. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018705
barcode_type UPC
col1 bristle bright
col1_sortorder 117
col2 1 in.
col2_sortorder 363
col3 [empty string]
cost 1.54
deal_of_the_week NO
description bristle bright, 1 in.
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78206
list_price 4.5
map NO
mfr_num 255044100
net_weight 0.04
non_member_discount 33
non_member_price 3.02
prop65 NO
ship_rule_desc STD
shipping STD
sku 78206
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.67
ta_dealer_c_price 1.67
ta_price 2.7
text
array
1 78206
2 255044100
3 bristle bright, 1 in.
timestamp 2015-03-26T14:52:10.421Z
vip_member_price 2.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78106. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019481
barcode_type UPC
col1 chisel blender
col1_sortorder 140
col2 4
col2_sortorder 1724
col3 [empty string]
cost 1.61
deal_of_the_week NO
description chisel blender, 4
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78106
list_price 4.7
map NO
mfr_num 255062004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78106
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78106
2 255062004
3 chisel blender, 4
timestamp 2015-03-26T14:52:09.9Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78107. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019498
barcode_type UPC
col1 chisel blender
col1_sortorder 140
col2 6
col2_sortorder 2077
col3 [empty string]
cost 1.61
deal_of_the_week NO
description chisel blender, 6
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78107
list_price 4.7
map NO
mfr_num 255062006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78107
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78107
2 255062006
3 chisel blender, 6
timestamp 2015-03-26T14:52:09.902Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78108. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019504
barcode_type UPC
col1 chisel blender
col1_sortorder 140
col2 8
col2_sortorder 2250
col3 [empty string]
cost 1.61
deal_of_the_week NO
description chisel blender, 8
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78108
list_price 4.7
map NO
mfr_num 255062008
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78108
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78108
2 255062008
3 chisel blender, 8
timestamp 2015-03-26T14:52:09.907Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78109. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019511
barcode_type UPC
col1 chisel blender
col1_sortorder 140
col2 10
col2_sortorder 692
col3 [empty string]
cost 1.61
deal_of_the_week NO
description chisel blender, 10
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78109
list_price 4.7
map NO
mfr_num 255062010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78109
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78109
2 255062010
3 chisel blender, 10
timestamp 2015-03-26T14:52:09.921Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78101. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019337
barcode_type UPC
col1 fan blender
col1_sortorder 199
col2 1
col2_sortorder 275
col3 [empty string]
cost 1.61
deal_of_the_week NO
description fan blender, 1
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78101
list_price 4.7
map NO
mfr_num 255047001
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78101
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78101
2 255047001
3 fan blender, 1
timestamp 2015-03-26T14:52:09.885Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78102. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018330
barcode_type UPC
col1 fan blender
col1_sortorder 199
col2 2
col2_sortorder 1114
col3 [empty string]
cost 1.61
deal_of_the_week NO
description fan blender, 2
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78102
list_price 4.7
map NO
mfr_num 255047002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78102
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78102
2 255047002
3 fan blender, 2
timestamp 2015-03-26T14:52:09.891Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78105. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019344
barcode_type UPC
col1 fan blender
col1_sortorder 199
col2 4
col2_sortorder 1724
col3 [empty string]
cost 1.61
deal_of_the_week NO
description fan blender, 4
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78105
list_price 4.7
map NO
mfr_num 255047004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78105
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78105
2 255047004
3 fan blender, 4
timestamp 2015-03-26T14:52:09.898Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78168. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019528
barcode_type UPC
col1 filbert
col1_sortorder 202
col2 2
col2_sortorder 1114
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert, 2
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78168
list_price 4.7
map NO
mfr_num 255067002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78168
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78168
2 255067002
3 filbert, 2
timestamp 2015-03-26T14:52:10.29Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78171. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018521
barcode_type UPC
col1 filbert
col1_sortorder 202
col2 4
col2_sortorder 1724
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert, 4
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78171
list_price 4.7
map NO
mfr_num 255067004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78171
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78171
2 255067004
3 filbert, 4
timestamp 2015-03-26T14:52:10.304Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78172. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018538
barcode_type UPC
col1 filbert
col1_sortorder 202
col2 6
col2_sortorder 2077
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert, 6
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78172
list_price 4.7
map NO
mfr_num 255067006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78172
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78172
2 255067006
3 filbert, 6
timestamp 2015-03-26T14:52:10.306Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78173. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018545
barcode_type UPC
col1 filbert
col1_sortorder 202
col2 8
col2_sortorder 2250
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert, 8
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78173
list_price 4.7
map NO
mfr_num 255067008
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78173
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78173
2 255067008
3 filbert, 8
timestamp 2015-03-26T14:52:10.308Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78174. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018552
barcode_type UPC
col1 filbert
col1_sortorder 202
col2 10
col2_sortorder 692
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert, 10
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78174
list_price 4.7
map NO
mfr_num 255067010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78174
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78174
2 255067010
3 filbert, 10
timestamp 2015-03-26T14:52:10.312Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78175. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019535
barcode_type UPC
col1 filbert
col1_sortorder 202
col2 12
col2_sortorder 816
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert, 12
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78175
list_price 4.7
map NO
mfr_num 255067012
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78175
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78175
2 255067012
3 filbert, 12
timestamp 2015-03-26T14:52:10.315Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78176. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372019542
barcode_type UPC
col1 filbert comb
col1_sortorder 203
col2 4
col2_sortorder 1724
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert comb, 4
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78176
list_price 4.7
map NO
mfr_num 255068004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78176
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78176
2 255068004
3 filbert comb, 4
timestamp 2015-03-26T14:52:10.32Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78177. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018569
barcode_type UPC
col1 filbert comb
col1_sortorder 203
col2 6
col2_sortorder 2077
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert comb, 6
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78177
list_price 4.7
map NO
mfr_num 255068006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78177
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78177
2 255068006
3 filbert comb, 6
timestamp 2015-03-26T14:52:10.326Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78179. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018576
barcode_type UPC
col1 filbert comb
col1_sortorder 203
col2 8
col2_sortorder 2250
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert comb, 8
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78179
list_price 4.7
map NO
mfr_num 255068008
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78179
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78179
2 255068008
3 filbert comb, 8
timestamp 2015-03-26T14:52:10.331Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78180. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880
AvailQtyList: 5.000000000000,8.000000000000,3.000000000000,6.000000000000,14.000000000000,8.000000000000,6.000000000000,1.000000000000,14.000000000000,6.000000000000,10.000000000000,4.000000000000,6.000000000000,4.000000000000,4.000000000000,13.000000000000,8.000000000000,19.000000000000,8.000000000000,0E-12,0E-12,4.000000000000,9.000000000000,12.000000000000,2.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372018583
barcode_type UPC
col1 filbert comb
col1_sortorder 203
col2 10
col2_sortorder 692
col3 [empty string]
cost 1.61
deal_of_the_week NO
description filbert comb, 10
group_id 10011
group_uname robert-simmons-simply-simmons-short-handle-brushes
id 78180
list_price 4.7
map NO
mfr_num 255068010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 78180
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 78180
2 255068010
3 filbert comb, 10
timestamp 2015-03-26T14:52:10.333Z
vip_member_price 2.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 10144
2 8.000000000000 10244
3 3.000000000000 10446
4 6.000000000000 11171
5 14.000000000000 11521
6 8.000000000000 13281
7 6.000000000000 17078
8 1.000000000000 18959
9 14.000000000000 19413
10 6.000000000000 19731
11 10.000000000000 21120
12 4.000000000000 21639
13 6.000000000000 21886
14 4.000000000000 22420
15 4.000000000000 25066
16 13.000000000000 26039
17 8.000000000000 27419
18 19.000000000000 27725
19 8.000000000000 27792
20 0E-12 27883
21 0E-12 28376
22 4.000000000000 29748
23 9.000000000000 30156
24 12.000000000000 30423
25 2.000000000000 30719
26 3.000000000000 30880
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '6293' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.175.61

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 03:39:36'}
sessionid e030163a61ffd9d5ceeb51067577a41622d6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=robert-simmons-simply-simmons-short-handle-brushes.html
urltoken CFID=29296217&CFTOKEN=57032450&jsessionid=e030163a61ffd9d5ceeb51067577a41622d6
validationerror [empty string]


Problem with item sku 78186. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10011 10011&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10011&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 10144,10244,10446,11171,11521,13281,17078,18959,19413,19731,21120,21639,21886,22420,25066,26039,27419,27725,27792,27883,28376,29748,30156,30423,30719,30880