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

Series 5200 Chinese Bristle Oil Brushes

by Princeton


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520449
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.34
deal_of_the_week NO
description 1, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 60577
list_price 4.35
map NO
mfr_num 5200R-1
net_weight 0.02
non_member_discount 46
non_member_price 2.36
prop65 NO
ship_rule_desc STD
shipping STD
sku 60577
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.57
ta_dealer_c_price 1.48
ta_price 2.83
text
array
1 60577
2 5200R-1
3 1, round
timestamp 2015-03-26T14:51:39.124Z
vip_member_price 1.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520142
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 [empty string]
cost 1.31
deal_of_the_week NO
description 1, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 75177
list_price 4.25
map NO
mfr_num 5200F-1
net_weight 0.04
non_member_discount 46
non_member_price 2.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 75177
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.53
ta_dealer_c_price 1.45
ta_price 2.75
text
array
1 75177
2 5200F-1
3 1, flat
timestamp 2015-03-26T14:52:05.36Z
vip_member_price 1.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520005
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 [empty string]
cost 1.31
deal_of_the_week NO
description 1, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 75939
list_price 4.25
map NO
mfr_num 5200B-1
net_weight 0.02
non_member_discount 46
non_member_price 2.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 75939
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.53
ta_dealer_c_price 1.45
ta_price 2.75
text
array
1 75939
2 5200B-1
3 1, bright
timestamp 2015-03-26T14:52:06.439Z
vip_member_price 1.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520364
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.18
deal_of_the_week NO
description 10, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 10439
list_price 10.35
map NO
mfr_num 5200R-10
net_weight 0.06
non_member_discount 46
non_member_price 5.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 10439
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.73
ta_dealer_c_price 3.52
ta_price 6.73
text
array
1 10439
2 5200R-10
3 10, round
timestamp 2015-03-26T14:50:27.088Z
vip_member_price 4.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520241
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.18
deal_of_the_week NO
description 10, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 18043
list_price 10.35
map NO
mfr_num 5200F-10
net_weight 0.06
non_member_discount 46
non_member_price 5.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 18043
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.73
ta_dealer_c_price 3.52
ta_price 6.73
text
array
1 18043
2 5200F-10
3 10, flat
timestamp 2015-03-26T14:50:39.109Z
vip_member_price 4.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520050
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.18
deal_of_the_week NO
description 10, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 27610
list_price 10.35
map NO
mfr_num 5200B-10
net_weight 0.06
non_member_discount 46
non_member_price 5.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 27610
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.73
ta_dealer_c_price 3.52
ta_price 6.73
text
array
1 27610
2 5200B-10
3 10, bright
timestamp 2015-03-26T14:50:51.309Z
vip_member_price 4.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520524
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.67
deal_of_the_week NO
description 12, filbert
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 15686
list_price 11.95
map NO
mfr_num 5200FB-12
net_weight 0.1
non_member_discount 46
non_member_price 6.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 15686
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.3
ta_dealer_c_price 4.06
ta_price 7.77
text
array
1 15686
2 5200FB-12
3 12, filbert
timestamp 2015-03-26T14:50:35.505Z
vip_member_price 5.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520531
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.67
deal_of_the_week NO
description 12, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 42444
list_price 11.95
map NO
mfr_num 5200R-12
net_weight 0.08
non_member_discount 46
non_member_price 6.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 42444
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.3
ta_dealer_c_price 4.06
ta_price 7.77
text
array
1 42444
2 5200R-12
3 12, round
timestamp 2015-03-26T14:51:11.992Z
vip_member_price 5.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520234
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.67
deal_of_the_week NO
description 12, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 79866
list_price 11.95
map NO
mfr_num 5200F-12
net_weight 0.08
non_member_discount 46
non_member_price 6.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 79866
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.3
ta_dealer_c_price 4.06
ta_price 7.78
text
array
1 79866
2 5200F-12
3 12, flat
timestamp 2015-03-26T14:52:12.808Z
vip_member_price 5.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520098
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.67
deal_of_the_week NO
description 12, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 84488
list_price 11.95
map NO
mfr_num 5200B-12
net_weight 0.06
non_member_discount 46
non_member_price 6.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 84488
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.3
ta_dealer_c_price 4.06
ta_price 7.78
text
array
1 84488
2 5200B-12
3 12, bright
timestamp 2015-03-26T14:52:16.656Z
vip_member_price 5.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520227
barcode_type UPC
col1 16
col1_sortorder 979
col2 flat
col2_sortorder 209
col3 [empty string]
cost 4.15
deal_of_the_week NO
description 16, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 18907
list_price 13.5
map NO
mfr_num 5200F-16
net_weight 0.12
non_member_discount 46
non_member_price 7.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 18907
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.86
ta_dealer_c_price 4.59
ta_price 8.78
text
array
1 18907
2 5200F-16
3 16, flat
timestamp 2015-03-26T14:50:39.982Z
vip_member_price 6.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520012
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 1.53
deal_of_the_week NO
description 2, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 60442
list_price 4.95
map NO
mfr_num 5200B-2
net_weight 0.02
non_member_discount 46
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 60442
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.78
ta_dealer_c_price 1.68
ta_price 3.22
text
array
1 60442
2 5200B-2
3 2, bright
timestamp 2015-03-26T14:51:38.836Z
vip_member_price 2.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520456
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.53
deal_of_the_week NO
description 2, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 61752
list_price 4.95
map NO
mfr_num 5200R-2
net_weight 0.02
non_member_discount 46
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 61752
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.78
ta_dealer_c_price 1.68
ta_price 3.22
text
array
1 61752
2 5200R-2
3 2, round
timestamp 2015-03-26T14:51:41.012Z
vip_member_price 2.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520159
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 1.53
deal_of_the_week NO
description 2, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 82558
list_price 4.95
map NO
mfr_num 5200F-2
net_weight 0.05
non_member_discount 46
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 82558
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.78
ta_dealer_c_price 1.68
ta_price 3.22
text
array
1 82558
2 5200F-2
3 2, flat
timestamp 2015-03-26T14:52:15.247Z
vip_member_price 2.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520296
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 1.53
deal_of_the_week NO
description 2, filbert
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 86689
list_price 4.95
map NO
mfr_num 5200FB-2
net_weight 0.02
non_member_discount 46
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 86689
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.78
ta_dealer_c_price 1.68
ta_price 3.22
text
array
1 86689
2 5200FB-2
3 2, filbert
timestamp 2015-03-26T14:52:18.562Z
vip_member_price 2.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520401
barcode_type UPC
col1 3
col1_sortorder 1434
col2 fan
col2_sortorder 198
col3 [empty string]
cost 1.53
deal_of_the_week NO
description 3, fan
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 38781
list_price 4.95
map NO
mfr_num 5200FN-3
net_weight 0.02
non_member_discount 46
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 38781
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.78
ta_dealer_c_price 1.68
ta_price 3.22
text
array
1 38781
2 5200FN-3
3 3, fan
timestamp 2015-03-26T14:51:08.849Z
vip_member_price 2.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520043
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 1.73
deal_of_the_week NO
description 4, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 16870
list_price 5.65
map NO
mfr_num 5200B-4
net_weight 0.03
non_member_discount 46
non_member_price 3.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 16870
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.03
ta_dealer_c_price 1.92
ta_price 3.68
text
array
1 16870
2 5200B-4
3 4, bright
timestamp 2015-03-26T14:50:37.575Z
vip_member_price 2.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520319
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 1.73
deal_of_the_week NO
description 4, filbert
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 54868
list_price 5.65
map NO
mfr_num 5200FB-4
net_weight 0.03
non_member_discount 46
non_member_price 3.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 54868
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.03
ta_dealer_c_price 1.92
ta_price 3.68
text
array
1 54868
2 5200FB-4
3 4, filbert
timestamp 2015-03-26T14:51:30.454Z
vip_member_price 2.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520470
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.7
deal_of_the_week NO
description 4, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 64774
list_price 5.5
map NO
mfr_num 5200R-4
net_weight 0.04
non_member_discount 46
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 64774
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.98
ta_dealer_c_price 1.87
ta_price 3.58
text
array
1 64774
2 5200R-4
3 4, round
timestamp 2015-03-26T14:51:47.488Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520173
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 1.73
deal_of_the_week NO
description 4, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 72409
list_price 5.65
map NO
mfr_num 5200F-4
net_weight 0.06
non_member_discount 46
non_member_price 3.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 72409
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.03
ta_dealer_c_price 1.92
ta_price 3.68
text
array
1 72409
2 5200F-4
3 4, flat
timestamp 2015-03-26T14:52:02.532Z
vip_member_price 2.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520333
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.14
deal_of_the_week NO
description 6, filbert
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 17747
list_price 6.95
map NO
mfr_num 5200FB-6
net_weight 0.04
non_member_discount 46
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 17747
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.5
ta_dealer_c_price 2.36
ta_price 4.51
text
array
1 17747
2 5200FB-6
3 6, filbert
timestamp 2015-03-26T14:50:38.67Z
vip_member_price 3.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520432
barcode_type UPC
col1 6
col1_sortorder 2077
col2 fan
col2_sortorder 198
col3 [empty string]
cost 1.7
deal_of_the_week NO
description 6, fan
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 39414
list_price 5.5
map NO
mfr_num 5200FN-6
net_weight 0.02
non_member_discount 46
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 39414
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.98
ta_dealer_c_price 1.87
ta_price 3.58
text
array
1 39414
2 5200FN-6
3 6, fan
timestamp 2015-03-26T14:51:09.366Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520197
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.14
deal_of_the_week NO
description 6, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 40099
list_price 6.95
map NO
mfr_num 5200F-6
net_weight 0.07
non_member_discount 46
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 40099
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.5
ta_dealer_c_price 2.36
ta_price 4.51
text
array
1 40099
2 5200F-6
3 6, flat
timestamp 2015-03-26T14:51:09.886Z
vip_member_price 3.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520494
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.14
deal_of_the_week NO
description 6, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 52510
list_price 6.95
map NO
mfr_num 5200R-6
net_weight 0.04
non_member_discount 46
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 52510
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.5
ta_dealer_c_price 2.36
ta_price 4.51
text
array
1 52510
2 5200R-6
3 6, round
timestamp 2015-03-26T14:51:27.431Z
vip_member_price 3.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520067
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.14
deal_of_the_week NO
description 6, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 87693
list_price 6.95
map NO
mfr_num 5200B-6
net_weight 0.04
non_member_discount 46
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 87693
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.5
ta_dealer_c_price 2.36
ta_price 4.51
text
array
1 87693
2 5200B-6
3 6, bright
timestamp 2015-03-26T14:52:19.476Z
vip_member_price 3.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520081
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.76
deal_of_the_week NO
description 8, bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 12197
list_price 8.95
map NO
mfr_num 5200B-8
net_weight 0.05
non_member_discount 46
non_member_price 4.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 12197
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.22
ta_dealer_c_price 3.04
ta_price 5.82
text
array
1 12197
2 5200B-8
3 8, bright
timestamp 2015-03-26T14:50:29.585Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520555
barcode_type UPC
col1 8
col1_sortorder 2250
col2 angular bright
col2_sortorder 78
col3 [empty string]
cost 2.84
deal_of_the_week NO
description 8, angular bright
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 12307
list_price 9.25
map NO
mfr_num 5200AB-8
net_weight 0.06
non_member_discount 46
non_member_price 5.02
prop65 NO
ship_rule_desc STD
shipping STD
sku 12307
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.33
ta_dealer_c_price 3.15
ta_price 6
text
array
1 12307
2 5200AB-8
3 8, angular bright
timestamp 2015-03-26T14:50:29.719Z
vip_member_price 4.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520210
barcode_type UPC
col1 8
col1_sortorder 2250
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.76
deal_of_the_week NO
description 8, flat
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 27679
list_price 8.95
map NO
mfr_num 5200F-8
net_weight 0.08
non_member_discount 46
non_member_price 4.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 27679
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.22
ta_dealer_c_price 3.04
ta_price 5.82
text
array
1 27679
2 5200F-8
3 8, flat
timestamp 2015-03-26T14:50:51.349Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520517
barcode_type UPC
col1 8
col1_sortorder 2250
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.7
deal_of_the_week NO
description 8, round
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 57986
list_price 8.75
map NO
mfr_num 5200R-8
net_weight 0.04
non_member_discount 46
non_member_price 4.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 57986
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 2.98
ta_price 5.69
text
array
1 57986
2 5200R-8
3 8, round
timestamp 2015-03-26T14:51:34.379Z
vip_member_price 3.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


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

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

ItemIDList: 43008
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 757063520357
barcode_type UPC
col1 8
col1_sortorder 2250
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.76
deal_of_the_week NO
description 8, filbert
group_id 231
group_uname princeton-series-5200-chinese-bristle-oil-brushes
id 61768
list_price 8.95
map NO
mfr_num 5200FB-8
net_weight 0.04
non_member_discount 46
non_member_price 4.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 61768
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.22
ta_dealer_c_price 3.04
ta_price 5.82
text
array
1 61768
2 5200FB-8
3 8, filbert
timestamp 2015-03-26T14:51:41.022Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 43008
CACHED false
EXECUTIONTIME 6
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] = '12112' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e030be4b5f97c2d6cff77d5a3d4f722a606c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=fb~speedball~fp~8-13~&gr=speedball-screen-printing-dvd.html
urltoken CFID=29237314&CFTOKEN=60369073&jsessionid=e030be4b5f97c2d6cff77d5a3d4f722a606c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:40:21'}
sessionid e03097ce46abfff4a8d329701f5857767111
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fp~4-6~&gr=princeton-series-5200-chinese-bristle-oil-brushes.html
urltoken CFID=29237313&CFTOKEN=69033438&jsessionid=e03097ce46abfff4a8d329701f5857767111
validationerror [empty string]


The Series 5200 Bright Brush is both popular and affordable. Made of pure white Chinese hog bristles, it’s perfect for both students and amateurs.

The brush features an elegant dark blue handle and seamless nickel plated ferrule.

Share on Facebook Twitter Pinterest

Ask a question about Series 5200 Chinese Bristle Oil Brushes Ask a question about this product

Series 5200 Chinese Bristle Oil Brushes

by Princeton

Average User Rating: Based on (1 Review)

5 1

Charity A. from Gunnison, CO says:

These brushes are amazing, they handle oils really well, ive been painting nonstop.

[Read All Reviews] [Write a Review]









  Item# Image size
Ascending
shape Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
60577
Series 5200 Chinese Bristle Oil Brushes 1 round
Zoom Image
1 round 5200R-1 $4.35 $2.36 46% Off $1.94 56% Off Email When In Stock
Add to Favorites
75177
Series 5200 Chinese Bristle Oil Brushes 1 flat
Zoom Image
1 flat 5200F-1 $4.25 $2.31 46% Off $1.89 56% Off Email When In Stock
Add to Favorites
75939
Series 5200 Chinese Bristle Oil Brushes 1 bright
Zoom Image
1 bright 5200B-1 $4.25 $2.31 46% Off $1.89 56% Off Email When In Stock
Add to Favorites
10439
Series 5200 Chinese Bristle Oil Brushes 10 round
Zoom Image
10 round 5200R-10 $10.35 $5.62 46% Off $4.60 56% Off Email When In Stock
Add to Favorites
18043
Series 5200 Chinese Bristle Oil Brushes 10 flat
Zoom Image
10 flat 5200F-10 $10.35 $5.62 46% Off $4.60 56% Off Email When In Stock
Add to Favorites
27610
Series 5200 Chinese Bristle Oil Brushes 10 bright
Zoom Image
10 bright 5200B-10 $10.35 $5.62 46% Off $4.60 56% Off Email When In Stock
Add to Favorites
15686
Series 5200 Chinese Bristle Oil Brushes 12 filbert
Zoom Image
12 filbert 5200FB-12 $11.95 $6.49 46% Off $5.32 56% Off Email When In Stock
Add to Favorites
42444
Series 5200 Chinese Bristle Oil Brushes 12 round
Zoom Image
12 round 5200R-12 $11.95 $6.49 46% Off $5.32 56% Off Email When In Stock
Add to Favorites
79866
Series 5200 Chinese Bristle Oil Brushes 12 flat
Zoom Image
12 flat 5200F-12 $11.95 $6.49 46% Off $5.32 56% Off Email When In Stock
Add to Favorites
84488
Series 5200 Chinese Bristle Oil Brushes 12 bright
Zoom Image
12 bright 5200B-12 $11.95 $6.49 46% Off $5.32 56% Off Email When In Stock
Add to Favorites
18907
Series 5200 Chinese Bristle Oil Brushes 16 flat
Zoom Image
16 flat 5200F-16 $13.50 $7.33 46% Off $6.01 56% Off Email When In Stock
Add to Favorites
60442
Series 5200 Chinese Bristle Oil Brushes 2 bright
Zoom Image
2 bright 5200B-2 $4.95 $2.69 46% Off $2.20 56% Off Email When In Stock
Add to Favorites
61752
Series 5200 Chinese Bristle Oil Brushes 2 round
Zoom Image
2 round 5200R-2 $4.95 $2.69 46% Off $2.20 56% Off Email When In Stock
Add to Favorites
82558
Series 5200 Chinese Bristle Oil Brushes 2 flat
Zoom Image
2 flat 5200F-2 $4.95 $2.69 46% Off $2.20 56% Off Email When In Stock
Add to Favorites
86689
Series 5200 Chinese Bristle Oil Brushes 2 filbert
Zoom Image
2 filbert 5200FB-2 $4.95 $2.69 46% Off $2.20 56% Off Email When In Stock
Add to Favorites
38781
Series 5200 Chinese Bristle Oil Brushes 3 fan
Zoom Image
3 fan 5200FN-3 $4.95 $2.69 46% Off $2.20 56% Off Email When In Stock
Add to Favorites
16870
Series 5200 Chinese Bristle Oil Brushes 4 bright
Zoom Image
4 bright 5200B-4 $5.65 $3.07 46% Off $2.51 56% Off Email When In Stock
Add to Favorites
54868
Series 5200 Chinese Bristle Oil Brushes 4 filbert
Zoom Image
4 filbert 5200FB-4 $5.65 $3.07 46% Off $2.51 56% Off Email When In Stock
Add to Favorites
64774
Series 5200 Chinese Bristle Oil Brushes 4 round
Zoom Image
4 round 5200R-4 $5.50 $2.99 46% Off $2.45 56% Off Email When In Stock
Add to Favorites
72409
Series 5200 Chinese Bristle Oil Brushes 4 flat
Zoom Image
4 flat 5200F-4 $5.65 $3.07 46% Off $2.51 56% Off Email When In Stock
Add to Favorites
17747
Series 5200 Chinese Bristle Oil Brushes 6 filbert
Zoom Image
6 filbert 5200FB-6 $6.95 $3.77 46% Off $3.09 56% Off Email When In Stock
Add to Favorites
39414
Series 5200 Chinese Bristle Oil Brushes 6 fan
Zoom Image
6 fan 5200FN-6 $5.50 $2.99 46% Off $2.45 56% Off Email When In Stock
Add to Favorites
40099
Series 5200 Chinese Bristle Oil Brushes 6 flat
Zoom Image
6 flat 5200F-6 $6.95 $3.77 46% Off $3.09 56% Off Email When In Stock
Add to Favorites
52510
Series 5200 Chinese Bristle Oil Brushes 6 round
Zoom Image
6 round 5200R-6 $6.95 $3.77 46% Off $3.09 56% Off Email When In Stock
Add to Favorites
87693
Series 5200 Chinese Bristle Oil Brushes 6 bright
Zoom Image
6 bright 5200B-6 $6.95 $3.77 46% Off $3.09 56% Off Email When In Stock
Add to Favorites
12197
Series 5200 Chinese Bristle Oil Brushes 8 bright
Zoom Image
8 bright 5200B-8 $8.95 $4.86 46% Off $3.98 56% Off Email When In Stock
Add to Favorites
12307
Series 5200 Chinese Bristle Oil Brushes 8 angular bright
Zoom Image
8 angular bright 5200AB-8 $9.25 $5.02 46% Off $4.12 56% Off Email When In Stock