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

University Series Long Handled Brushes

by Winsor & Newton


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864540
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 2.21
deal_of_the_week NO
description 1, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 11118
list_price 7.79
map NO
mfr_num 5418001
net_weight 0.02
non_member_discount 51
non_member_price 3.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 11118
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.65
ta_dealer_c_price 2.34
ta_price 5.06
text
array
1 11118
2 5418001
3 1, bright, 237
timestamp 2015-03-26T14:50:27.836Z
vip_member_price 3.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376865349
barcode_type UPC
col1 1
col1_sortorder 275
col2 fan
col2_sortorder 198
col3 238
col3_sortorder 97
cost 3
deal_of_the_week NO
description 1, fan, 238
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 30230
list_price 10.59
map NO
mfr_num 5462001
net_weight 0.56
non_member_discount 51
non_member_price 5.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 30230
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.18
ta_price 6.88
text
array
1 30230
2 5462001
3 1, fan, 238
timestamp 2015-03-26T14:50:55.088Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864441
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 2.27
deal_of_the_week NO
description 1, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 56412
list_price 7.99
map NO
mfr_num 5417001
net_weight 0.08
non_member_discount 51
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 56412
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.72
ta_dealer_c_price 2.4
ta_price 5.19
text
array
1 56412
2 5417001
3 1, flat, 236
timestamp 2015-03-26T14:51:32.746Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864625
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 7.69
deal_of_the_week NO
description 10, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 11248
list_price 27.09
map NO
mfr_num 5418010
net_weight 0.04
non_member_discount 51
non_member_price 13.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 11248
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.21
ta_dealer_c_price 8.13
ta_price 17.61
text
array
1 11248
2 5418010
3 10, bright, 237
timestamp 2015-03-26T14:50:28.061Z
vip_member_price 10.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864724
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 235
col3_sortorder 85
cost 7.69
deal_of_the_week NO
description 10, round, 235
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 63481
list_price 27.09
map NO
mfr_num 5419010
net_weight 0.06
non_member_discount 51
non_member_price 13.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 63481
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.21
ta_dealer_c_price 8.13
ta_price 17.61
text
array
1 63481
2 5419010
3 10, round, 235
timestamp 2015-03-26T14:51:44.893Z
vip_member_price 10.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864526
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 7.69
deal_of_the_week NO
description 10, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 79743
list_price 27.09
map NO
mfr_num 5417010
net_weight 0.12
non_member_discount 51
non_member_price 13.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 79743
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.21
ta_dealer_c_price 8.13
ta_price 17.61
text
array
1 79743
2 5417010
3 10, flat, 236
timestamp 2015-03-26T14:52:12.669Z
vip_member_price 10.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864731
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 235
col3_sortorder 85
cost 9.83
deal_of_the_week NO
description 12, round, 235
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 66065
list_price 34.69
map NO
mfr_num 5419012
net_weight 0.05
non_member_discount 51
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 66065
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.79
ta_dealer_c_price 10.41
ta_price 22.55
text
array
1 66065
2 5419012
3 12, round, 235
timestamp 2015-03-26T14:51:50.186Z
vip_member_price 13.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864533
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 9.83
deal_of_the_week NO
description 12, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 88115
list_price 34.69
map NO
mfr_num 5417012
net_weight 0.12
non_member_discount 51
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 88115
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.79
ta_dealer_c_price 10.41
ta_price 22.55
text
array
1 88115
2 5417012
3 12, flat, 236
timestamp 2015-03-26T14:52:19.802Z
vip_member_price 13.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864656
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 235
col3_sortorder 85
cost 2.4
deal_of_the_week NO
description 2, round, 235
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 73318
list_price 8.49
map NO
mfr_num 5419002
net_weight 0.04
non_member_discount 51
non_member_price 4.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 73318
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.89
ta_dealer_c_price 2.55
ta_price 5.52
text
array
1 73318
2 5419002
3 2, round, 235
timestamp 2015-03-26T14:52:03.866Z
vip_member_price 3.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864557
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 2.4
deal_of_the_week NO
description 2, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 80734
list_price 8.49
map NO
mfr_num 5418002
net_weight 0.02
non_member_discount 51
non_member_price 4.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 80734
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.89
ta_dealer_c_price 2.55
ta_price 5.52
text
array
1 80734
2 5418002
3 2, bright, 237
timestamp 2015-03-26T14:52:13.804Z
vip_member_price 3.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864458
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 2.4
deal_of_the_week NO
description 2, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 84810
list_price 8.49
map NO
mfr_num 5417002
net_weight 0.08
non_member_discount 51
non_member_price 4.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 84810
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.89
ta_dealer_c_price 2.55
ta_price 5.52
text
array
1 84810
2 5417002
3 2, flat, 236
timestamp 2015-03-26T14:52:16.883Z
vip_member_price 3.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376865356
barcode_type UPC
col1 3
col1_sortorder 1434
col2 fan
col2_sortorder 198
col3 238
col3_sortorder 97
cost 3.77
deal_of_the_week NO
description 3, fan, 238
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 46131
list_price 13.29
map NO
mfr_num 5462003
net_weight 0.56
non_member_discount 51
non_member_price 6.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 46131
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.52
ta_dealer_c_price 3.99
ta_price 8.64
text
array
1 46131
2 5462003
3 3, fan, 238
timestamp 2015-03-26T14:51:16.802Z
vip_member_price 5.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864465
barcode_type UPC
col1 3
col1_sortorder 1434
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 2.7
deal_of_the_week NO
description 3, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 49037
list_price 9.49
map NO
mfr_num 5417003
net_weight 0.08
non_member_discount 51
non_member_price 4.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 49037
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 2.85
ta_price 6.17
text
array
1 49037
2 5417003
3 3, flat, 236
timestamp 2015-03-26T14:51:21.552Z
vip_member_price 3.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864564
barcode_type UPC
col1 3
col1_sortorder 1434
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 2.7
deal_of_the_week NO
description 3, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 58493
list_price 9.49
map NO
mfr_num 5418003
net_weight 0.02
non_member_discount 51
non_member_price 4.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 58493
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 2.85
ta_price 6.17
text
array
1 58493
2 5418003
3 3, bright, 237
timestamp 2015-03-26T14:51:34.887Z
vip_member_price 3.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864670
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 235
col3_sortorder 85
cost 3.06
deal_of_the_week NO
description 4, round, 235
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 11145
list_price 10.79
map NO
mfr_num 5419004
net_weight 0.04
non_member_discount 51
non_member_price 5.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 11145
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.24
ta_price 7.01
text
array
1 11145
2 5419004
3 4, round, 235
timestamp 2015-03-26T14:50:27.884Z
vip_member_price 4.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864472
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 3.06
deal_of_the_week NO
description 4, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 58897
list_price 10.79
map NO
mfr_num 5417004
net_weight 0.08
non_member_discount 51
non_member_price 5.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 58897
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.24
ta_price 7.01
text
array
1 58897
2 5417004
3 4, flat, 236
timestamp 2015-03-26T14:51:35.252Z
vip_member_price 4.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864571
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 3.06
deal_of_the_week NO
description 4, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 61439
list_price 10.79
map NO
mfr_num 5418004
net_weight 0.02
non_member_discount 51
non_member_price 5.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 61439
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.24
ta_price 7.01
text
array
1 61439
2 5418004
3 4, bright, 237
timestamp 2015-03-26T14:51:40.748Z
vip_member_price 4.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864588
barcode_type UPC
col1 5
col1_sortorder 1906
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 3.77
deal_of_the_week NO
description 5, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 22811
list_price 13.29
map NO
mfr_num 5418005
net_weight 0.03
non_member_discount 51
non_member_price 6.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 22811
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.52
ta_dealer_c_price 3.99
ta_price 8.64
text
array
1 22811
2 5418005
3 5, bright, 237
timestamp 2015-03-26T14:50:45.569Z
vip_member_price 5.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864496
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 4.31
deal_of_the_week NO
description 6, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 29303
list_price 15.19
map NO
mfr_num 5417006
net_weight 0.08
non_member_discount 51
non_member_price 7.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 29303
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.16
ta_dealer_c_price 4.56
ta_price 9.87
text
array
1 29303
2 5417006
3 6, flat, 236
timestamp 2015-03-26T14:50:53.777Z
vip_member_price 5.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864595
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 4.31
deal_of_the_week NO
description 6, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 37236
list_price 15.19
map NO
mfr_num 5418006
net_weight 0.02
non_member_discount 51
non_member_price 7.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 37236
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.16
ta_dealer_c_price 4.56
ta_price 9.87
text
array
1 37236
2 5418006
3 6, bright, 237
timestamp 2015-03-26T14:51:07.288Z
vip_member_price 5.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376865363
barcode_type UPC
col1 6
col1_sortorder 2077
col2 fan
col2_sortorder 198
col3 238
col3_sortorder 97
cost 5.61
deal_of_the_week NO
description 6, fan, 238
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 45004
list_price 19.79
map NO
mfr_num 5462006
net_weight 0.56
non_member_discount 51
non_member_price 9.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 45004
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.73
ta_dealer_c_price 5.94
ta_price 12.86
text
array
1 45004
2 5462006
3 6, fan, 238
timestamp 2015-03-26T14:51:15.119Z
vip_member_price 7.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864694
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 235
col3_sortorder 85
cost 4.31
deal_of_the_week NO
description 6, round, 235
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 50090
list_price 15.19
map NO
mfr_num 5419006
net_weight 0.05
non_member_discount 51
non_member_price 7.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 50090
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.16
ta_dealer_c_price 4.56
ta_price 9.87
text
array
1 50090
2 5419006
3 6, round, 235
timestamp 2015-03-26T14:51:22.981Z
vip_member_price 5.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864618
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bright
col2_sortorder 112
col3 237
col3_sortorder 96
cost 5.21
deal_of_the_week NO
description 8, bright, 237
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 45801
list_price 18.39
map NO
mfr_num 5418008
net_weight 0.04
non_member_discount 51
non_member_price 9.01
prop65 NO
ship_rule_desc STD
shipping STD
sku 45801
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.25
ta_dealer_c_price 5.52
ta_price 11.95
text
array
1 45801
2 5418008
3 8, bright, 237
timestamp 2015-03-26T14:51:16.363Z
vip_member_price 7.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864519
barcode_type UPC
col1 8
col1_sortorder 2250
col2 flat
col2_sortorder 209
col3 236
col3_sortorder 90
cost 5.25
deal_of_the_week NO
description 8, flat, 236
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 55138
list_price 18.49
map NO
mfr_num 5417008
net_weight 0.1
non_member_discount 51
non_member_price 9.06
prop65 NO
ship_rule_desc STD
shipping STD
sku 55138
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.29
ta_dealer_c_price 5.55
ta_price 12.02
text
array
1 55138
2 5417008
3 8, flat, 236
timestamp 2015-03-26T14:51:30.934Z
vip_member_price 7.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


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

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

ItemIDList: 78550
AvailQtyList: 0E-12

struct
VIP_member_discount 61
barcode 094376864717
barcode_type UPC
col1 8
col1_sortorder 2250
col2 round
col2_sortorder 434
col3 235
col3_sortorder 85
cost 5.25
deal_of_the_week NO
description 8, round, 235
flags
array
1 1
group_id 940
group_uname winsor-newton-university-series-long-handled-brushes
id 64355
list_price 18.49
map NO
mfr_num 5419008
net_weight 0.06
non_member_discount 51
non_member_price 9.06
prop65 NO
ship_rule_desc STD
shipping STD
sku 64355
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.29
ta_dealer_c_price 5.55
ta_price 12.02
text
array
1 64355
2 5419008
3 8, round, 235
timestamp 2015-03-26T14:51:46.832Z
vip_member_price 7.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 78550
CACHED false
EXECUTIONTIME 2
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] = '2856' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030962dfa171ae65104144d724c2f715d2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~gaebel~fp~9-15~&gr=gaebel-series-622-scaling-ruler.html
urltoken CFID=29245860&CFTOKEN=88989594&jsessionid=e030962dfa171ae65104144d724c2f715d2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:38:00'}
sessionid e030c5eb81a907f133f2322a51671458e272
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=winsor-newton-university-series-long-handled-brushes.html
urltoken CFID=29245859&CFTOKEN=44947461&jsessionid=e030c5eb81a907f133f2322a51671458e272
validationerror [empty string]


University brushes are affordable and all-purpose, stiff enough for use with oils and acrylics, yet soft enough for use with watercolors. Serving a wide array of craft applications, they provide an inexpensive option for the beginner, the student, and the professional painter.

The no. 235 round has the same brush head as the short handle no. 233 round, but the longer handle is generally more suitable for oil and acrylic painters.

These brushes feature seamless nickel plated ferrules and red polished handles with white tips.

Share on Facebook Twitter Pinterest

Ask a question about University Series Long Handled Brushes Ask a question about this product

University Series Long Handled Brushes

by Winsor & Newton

Average User Rating: Based on (2 Reviews)

5 2

Dennis from Iron River,MI says:

These brushes are great. They hold the paint just great and paint very well. I would suggest this product to anyone. Thank you for the fine service.

[Read All Reviews] [Write a Review]









  Item# Image size
Ascending
shape series number Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
11118
University Series Long Handled Brushes 1 bright 237
Zoom Image
1 bright 237 5418001 $7.79 $3.82 51% Off $3.04 61% Off Email When In Stock
Add to Favorites
30230
University Series Long Handled Brushes 1 fan 238
Zoom Image
1 fan 238 5462001 $10.59 $5.19 51% Off $4.13 61% Off Email When In Stock
Add to Favorites
56412
University Series Long Handled Brushes 1 flat 236
Zoom Image
1 flat 236 5417001 $7.99 $3.92 51% Off $3.12 61% Off Email When In Stock
Add to Favorites
11248
University Series Long Handled Brushes 10 bright 237
Zoom Image
10 bright 237 5418010 $27.09 $13.27 51% Off $10.57 61% Off Email When In Stock
Add to Favorites
63481
University Series Long Handled Brushes 10 round 235
Zoom Image
10 round 235 5419010 $27.09 $13.27 51% Off $10.57 61% Off Email When In Stock
Add to Favorites
79743
University Series Long Handled Brushes 10 flat 236
Zoom Image
10 flat 236 5417010 $27.09 $13.27 51% Off $10.57 61% Off Email When In Stock
Add to Favorites
66065
University Series Long Handled Brushes 12 round 235
Zoom Image
12 round 235 5419012 $34.69 $17.00 51% Off $13.53 61% Off Email When In Stock
Add to Favorites
88115
University Series Long Handled Brushes 12 flat 236
Zoom Image
12 flat 236 5417012 $34.69 $17.00 51% Off $13.53 61% Off Email When In Stock
Add to Favorites
73318
University Series Long Handled Brushes 2 round 235
Zoom Image
2 round 235 5419002 $8.49 $4.16 51% Off $3.31 61% Off Email When In Stock
Add to Favorites
80734
University Series Long Handled Brushes 2 bright 237
Zoom Image
2 bright 237 5418002 $8.49 $4.16 51% Off $3.31 61% Off Email When In Stock
Add to Favorites
84810
University Series Long Handled Brushes 2 flat 236
Zoom Image
2 flat 236 5417002 $8.49 $4.16 51% Off $3.31 61% Off Email When In Stock
Add to Favorites
46131
University Series Long Handled Brushes 3 fan 238
Zoom Image
3 fan 238 5462003 $13.29 $6.51 51% Off $5.18 61% Off Email When In Stock
Add to Favorites
49037
University Series Long Handled Brushes 3 flat 236
Zoom Image
3 flat 236 5417003 $9.49 $4.65 51% Off $3.70 61% Off Email When In Stock
Add to Favorites
58493
University Series Long Handled Brushes 3 bright 237
Zoom Image
3 bright 237 5418003 $9.49 $4.65 51% Off $3.70 61% Off Email When In Stock
Add to Favorites
11145
University Series Long Handled Brushes 4 round 235
Zoom Image
4 round 235 5419004 $10.79 $5.29 51% Off $4.21 61% Off Email When In Stock
Add to Favorites
58897
University Series Long Handled Brushes 4 flat 236
Zoom Image
4 flat 236 5417004 $10.79 $5.29 51% Off $4.21 61% Off Email When In Stock
Add to Favorites
61439
University Series Long Handled Brushes 4 bright 237
Zoom Image
4 bright 237 5418004 $10.79 $5.29 51% Off $4.21 61% Off Email When In Stock
Add to Favorites
22811
University Series Long Handled Brushes 5 bright 237
Zoom Image
5 bright 237 5418005 $13.29 $6.51 51% Off $5.18 61% Off Email When In Stock
Add to Favorites
29303
University Series Long Handled Brushes 6 flat 236
Zoom Image
6 flat 236 5417006 $15.19 $7.44 51% Off $5.92 61% Off Email When In Stock
Add to Favorites
37236
University Series Long Handled Brushes 6 bright 237
Zoom Image
6 bright 237 5418006 $15.19 $7.44 51% Off $5.92 61% Off Email When In Stock
Add to Favorites
45004
University Series Long Handled Brushes 6 fan 238
Zoom Image
6 fan 238 5462006 $19.79 $9.70 51% Off $7.72 61% Off Email When In Stock
Add to Favorites
50090
University Series Long Handled Brushes 6 round 235
Zoom Image
6 round 235 5419006 $15.19 $7.44 51% Off $5.92 61% Off Email When In Stock
Add to Favorites
45801
University Series Long Handled Brushes 8 bright 237
Zoom Image
8 bright 237 5418008 $18.39 $9.01 51% Off $7.17 61% Off Email When In Stock
Add to Favorites
55138
University Series Long Handled Brushes 8 flat 236
Zoom Image
8 flat 236 5417008 $18.49 $9.06 51% Off $7.21 61% Off Email When In Stock
Add to Favorites
64355
University Series Long Handled Brushes 8 round 235
Zoom Image
8 round 235 5419008 $18.49 $9.06 51% Off $7.21 61% Off Email When In Stock

Click the to add item to your Favorites.



Please wait...
You May Also Like...

Up to 61% Off

Artists' Oil Colours

by Winsor & Newton

Our best selling oil paint--artist recommended

At Least 39 % Off

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About University Series Long Handled Brushes

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Customer Product Reviews
Write a Review
Write a Review
Rated by: Dennis in Iron River,MI
These brushes are great. They hold the paint just great and paint very well. I would suggest this product to anyone. Thank you for the fine service.
Rated by: Darlene G. in Apple Valley, CA
Great brushes- very smooth and soft.

Write a Product Review for University Series Long Handled Brushes

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...