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

Sterling Series Brushes

by Silver Brush


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
VIP_member_discount 60
barcode 765179600832
barcode_type UPC
col1 3/0
col1_sortorder 83
col2 round
col2_sortorder 434
col3 [empty string]
cost 0.65
deal_of_the_week NO
description 3/0, round
flags
array
1 3
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 87044
list_price 2.1
map NO
mfr_num 6000S-3/0
net_weight 0.02
non_member_discount 50
non_member_price 1.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 87044
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.71
ta_dealer_c_price 0.71
ta_price 1.26
text
array
1 87044
2 6000S-3/0
3 3/0, round
timestamp 2015-03-31T17:54:40.454Z
vip_member_price 0.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179607824
barcode_type UPC
col1 2/0
col1_sortorder 84
col2 script liner
col2_sortorder 455
col3 [empty string]
cost 0.67
deal_of_the_week NO
description 2/0, script liner
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 79968
list_price 2.2
map NO
mfr_num 6007S-2/0
net_weight 0.02
non_member_discount 50
non_member_price 1.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 79968
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.75
ta_dealer_c_price 0.75
ta_price 1.32
text
array
1 79968
2 6007S-2/0
3 2/0, script liner
timestamp 2015-03-31T17:54:32.974Z
vip_member_price 0.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179602508
barcode_type UPC
col1 0
col1_sortorder 85
col2 bright
col2_sortorder 112
col3 [empty string]
cost 0.67
deal_of_the_week NO
description 0, bright
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 38994
list_price 2.2
map NO
mfr_num 6002S-0
net_weight 0.02
non_member_discount 50
non_member_price 1.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 38994
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.75
ta_dealer_c_price 0.75
ta_price 1.32
text
array
1 38994
2 6002S-0
3 0, bright
timestamp 2015-03-31T17:53:23.23Z
vip_member_price 0.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600504
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 [empty string]
cost 0.66
deal_of_the_week NO
description 0, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 40949
list_price 2.15
map NO
mfr_num 6000S-0
net_weight 0.02
non_member_discount 50
non_member_price 1.08
prop65 NO
ship_rule_desc STD
shipping STD
sku 40949
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.73
ta_dealer_c_price 0.73
ta_price 1.29
text
array
1 40949
2 6000S-0
3 0, round
timestamp 2015-03-31T17:53:24.36Z
vip_member_price 0.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179607510
barcode_type UPC
col1 1
col1_sortorder 275
col2 script liner
col2_sortorder 455
col3 [empty string]
cost 0.71
deal_of_the_week NO
description 1, script liner
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 60360
list_price 2.3
map NO
mfr_num 6007S-1
net_weight 0.02
non_member_discount 50
non_member_price 1.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 60360
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.78
ta_dealer_c_price 0.78
ta_price 1.38
text
array
1 60360
2 6007S-1
3 1, script liner
timestamp 2015-03-31T17:53:55.812Z
vip_member_price 0.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600511
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 0.68
deal_of_the_week NO
description 1, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 83871
list_price 2.25
map NO
mfr_num 6000S-1
net_weight 0.02
non_member_discount 50
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 83871
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.77
ta_dealer_c_price 0.77
ta_price 1.35
text
array
1 83871
2 6000S-1
3 1, round
timestamp 2015-03-31T17:54:37.575Z
vip_member_price 0.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179606537
barcode_type UPC
col1 3/8 in.
col1_sortorder 358
col2 angular
col2_sortorder 77
col3 [empty string]
cost 1.17
deal_of_the_week NO
description 3/8 in., angular
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 83007
list_price 3.85
map NO
mfr_num 6006S-3/8
net_weight 0.02
non_member_discount 50
non_member_price 1.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 83007
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.31
ta_dealer_c_price 1.31
ta_price 2.31
text
array
1 83007
2 6006S-3/8
3 3/8 in., angular
timestamp 2015-03-31T17:54:36.819Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179611548
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 stroke
col2_sortorder 502
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 1/2 in., stroke
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 19251
list_price 4.25
map NO
mfr_num 6011S-1/2
net_weight 0.03
non_member_discount 50
non_member_price 2.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 19251
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.45
ta_dealer_c_price 1.45
ta_price 2.55
text
array
1 19251
2 6011S-1/2
3 1/2 in., stroke
timestamp 2015-03-31T17:52:51.829Z
vip_member_price 1.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179608548
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 square wash
col2_sortorder 487
col3 [empty string]
cost 1.34
deal_of_the_week NO
description 1/2 in., square wash
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 66256
list_price 4.4
map NO
mfr_num 6008S-1/2
net_weight 0.03
non_member_discount 50
non_member_price 2.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 66256
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.5
ta_dealer_c_price 1.5
ta_price 2.64
text
array
1 66256
2 6008S-1/2
3 1/2 in., square wash
timestamp 2015-03-31T17:54:10.421Z
vip_member_price 1.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179606544
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 angular
col2_sortorder 77
col3 [empty string]
cost 1.77
deal_of_the_week NO
description 1/2 in., angular
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 87564
list_price 5.8
map NO
mfr_num 6006S-1/2
net_weight 0.03
non_member_discount 50
non_member_price 2.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 87564
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.97
ta_dealer_c_price 1.97
ta_price 3.48
text
array
1 87564
2 6006S-1/2
3 1/2 in., angular
timestamp 2015-03-31T17:54:40.787Z
vip_member_price 2.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179611562
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 stroke
col2_sortorder 502
col3 [empty string]
cost 2.9
deal_of_the_week NO
description 3/4 in., stroke
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 87950
list_price 9.5
map NO
mfr_num 6011S-3/4
net_weight 0.04
non_member_discount 50
non_member_price 4.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 87950
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3.23
ta_price 5.7
text
array
1 87950
2 6011S-3/4
3 3/4 in., stroke
timestamp 2015-03-31T17:54:41.407Z
vip_member_price 3.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179611586
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 stroke
col2_sortorder 502
col3 [empty string]
cost 3.65
deal_of_the_week NO
description 1 in., stroke
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 44038
list_price 11.95
map NO
mfr_num 6011S-1
net_weight 0.05
non_member_discount 50
non_member_price 5.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 44038
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.06
ta_dealer_c_price 4.06
ta_price 7.17
text
array
1 44038
2 6011S-1
3 1 in., stroke
timestamp 2015-03-31T17:53:29.326Z
vip_member_price 4.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179608586
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 square wash
col2_sortorder 487
col3 [empty string]
cost 3.36
deal_of_the_week NO
description 1 in., square wash
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 56194
list_price 11
map NO
mfr_num 6008S-1
net_weight 0.04
non_member_discount 50
non_member_price 5.5
prop65 NO
ship_rule_desc STD
shipping STD
sku 56194
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 6.6
text
array
1 56194
2 6008S-1
3 1 in., square wash
timestamp 2015-03-31T17:53:49.452Z
vip_member_price 4.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179606520
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 angular
col2_sortorder 77
col3 [empty string]
cost 0.91
deal_of_the_week NO
description 1/4 in., angular
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 69271
list_price 3
map NO
mfr_num 6006S-1/4
net_weight 0.02
non_member_discount 50
non_member_price 1.5
prop65 NO
ship_rule_desc STD
shipping STD
sku 69271
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.02
ta_dealer_c_price 1.02
ta_price 1.8
text
array
1 69271
2 6006S-1/4
3 1/4 in., angular
timestamp 2015-03-31T17:54:16.368Z
vip_member_price 1.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600627
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.82
deal_of_the_week NO
description 12, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 23494
list_price 5.95
map NO
mfr_num 6000S-12
net_weight 0.03
non_member_discount 50
non_member_price 2.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 23494
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.02
ta_dealer_c_price 2.02
ta_price 3.57
text
array
1 23494
2 6000S-12
3 12, round
timestamp 2015-03-31T17:52:59.355Z
vip_member_price 2.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179602522
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 0.74
deal_of_the_week NO
description 2, bright
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 51923
list_price 2.45
map NO
mfr_num 6002S-2
net_weight 0.02
non_member_discount 50
non_member_price 1.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 51923
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.83
ta_dealer_c_price 0.83
ta_price 1.47
text
array
1 51923
2 6002S-2
3 2, bright
timestamp 2015-03-31T17:53:38.754Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600528
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 0.73
deal_of_the_week NO
description 2, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 61651
list_price 2.4
map NO
mfr_num 6000S-2
net_weight 0.02
non_member_discount 50
non_member_price 1.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 61651
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.82
ta_dealer_c_price 0.82
ta_price 1.44
text
array
1 61651
2 6000S-2
3 2, round
timestamp 2015-03-31T17:54:01.568Z
vip_member_price 0.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179603529
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 0.74
deal_of_the_week NO
description 2, filbert
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 67574
list_price 2.45
map NO
mfr_num 6003S-2
net_weight 0.02
non_member_discount 50
non_member_price 1.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 67574
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.83
ta_dealer_c_price 0.83
ta_price 1.47
text
array
1 67574
2 6003S-2
3 2, filbert
timestamp 2015-03-31T17:54:12.691Z
vip_member_price 0.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179614662
barcode_type UPC
col1 2 in.
col1_sortorder 1169
col2 wash
col2_sortorder 539
col3 [empty string]
cost 6.39
deal_of_the_week NO
description 2 in., wash
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 83448
list_price 20.95
map NO
mfr_num 6014S-2
net_weight 0.05
non_member_discount 50
non_member_price 10.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 83448
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.12
ta_dealer_c_price 7.12
ta_price 12.57
text
array
1 83448
2 6014S-2
3 2 in., wash
timestamp 2015-03-31T17:54:37.167Z
vip_member_price 8.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179614747
barcode_type UPC
col1 3 in.
col1_sortorder 1470
col2 wash
col2_sortorder 539
col3 [empty string]
cost 10.05
deal_of_the_week NO
description 3 in., wash
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 83798
list_price 32.95
map NO
mfr_num 6014S-3
net_weight 0.05
non_member_discount 50
non_member_price 16.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 83798
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.2
ta_dealer_c_price 11.2
ta_price 19.77
text
array
1 83798
2 6014S-3
3 3 in., wash
timestamp 2015-03-31T17:54:37.469Z
vip_member_price 13.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179603543
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 0.8
deal_of_the_week NO
description 4, filbert
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 19893
list_price 2.65
map NO
mfr_num 6003S-4
net_weight 0.02
non_member_discount 50
non_member_price 1.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 19893
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.9
ta_dealer_c_price 0.9
ta_price 1.59
text
array
1 19893
2 6003S-4
3 4, filbert
timestamp 2015-03-31T17:52:52.873Z
vip_member_price 1.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600542
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 0.77
deal_of_the_week NO
description 4, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 30548
list_price 2.5
map NO
mfr_num 6000S-4
net_weight 0.02
non_member_discount 50
non_member_price 1.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 30548
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.85
ta_dealer_c_price 0.85
ta_price 1.5
text
array
1 30548
2 6000S-4
3 4, round
timestamp 2015-03-31T17:53:08.738Z
vip_member_price 1

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179602546
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 0.78
deal_of_the_week NO
description 4, bright
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 53967
list_price 2.55
map NO
mfr_num 6002S-4
net_weight 0.02
non_member_discount 50
non_member_price 1.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 53967
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.87
ta_dealer_c_price 0.87
ta_price 1.53
text
array
1 53967
2 6002S-4
3 4, bright
timestamp 2015-03-31T17:53:47.267Z
vip_member_price 1.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179604540
barcode_type UPC
col1 4
col1_sortorder 1724
col2 fan
col2_sortorder 198
col3 [empty string]
cost 1.7
deal_of_the_week NO
description 4, fan
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 79631
list_price 5.55
map NO
mfr_num 6004S-4
net_weight 0.02
non_member_discount 50
non_member_price 2.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 79631
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.89
ta_dealer_c_price 1.89
ta_price 3.33
text
array
1 79631
2 6004S-4
3 4, fan
timestamp 2015-03-31T17:54:32.675Z
vip_member_price 2.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179602560
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 [empty string]
cost 0.91
deal_of_the_week NO
description 6, bright
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 13099
list_price 3
map NO
mfr_num 6002S-6
net_weight 0.02
non_member_discount 50
non_member_price 1.5
prop65 NO
ship_rule_desc STD
shipping STD
sku 13099
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.02
ta_dealer_c_price 1.02
ta_price 1.8
text
array
1 13099
2 6002S-6
3 6, bright
timestamp 2015-03-31T17:52:39.637Z
vip_member_price 1.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179603567
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 0.96
deal_of_the_week NO
description 6, filbert
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 24109
list_price 3.15
map NO
mfr_num 6003S-6
net_weight 0.03
non_member_discount 50
non_member_price 1.58
prop65 NO
ship_rule_desc STD
shipping STD
sku 24109
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.07
ta_dealer_c_price 1.07
ta_price 1.89
text
array
1 24109
2 6003S-6
3 6, filbert
timestamp 2015-03-31T17:52:59.75Z
vip_member_price 1.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600566
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 0.96
deal_of_the_week NO
description 6, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 50724
list_price 3.15
map NO
mfr_num 6000S-6
net_weight 0.03
non_member_discount 50
non_member_price 1.58
prop65 NO
ship_rule_desc STD
shipping STD
sku 50724
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.07
ta_dealer_c_price 1.07
ta_price 1.89
text
array
1 50724
2 6000S-6
3 6, round
timestamp 2015-03-31T17:53:37.468Z
vip_member_price 1.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179603581
barcode_type UPC
col1 8
col1_sortorder 2250
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 1.1
deal_of_the_week NO
description 8, filbert
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 55916
list_price 3.6
map NO
mfr_num 6003S-8
net_weight 0.03
non_member_discount 50
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 55916
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.22
ta_dealer_c_price 1.22
ta_price 2.16
text
array
1 55916
2 6003S-8
3 8, filbert
timestamp 2015-03-31T17:53:49.15Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179600580
barcode_type UPC
col1 8
col1_sortorder 2250
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.15
deal_of_the_week NO
description 8, round
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 80475
list_price 3.75
map NO
mfr_num 6000S-8
net_weight 0.03
non_member_discount 50
non_member_price 1.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 80475
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.25
text
array
1 80475
2 6000S-8
3 8, round
timestamp 2015-03-31T17:54:33.503Z
vip_member_price 1.5

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


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

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

ItemIDList: 51588
AvailQtyList: 26.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179602584
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bright
col2_sortorder 112
col3 [empty string]
cost 1.05
deal_of_the_week NO
description 8, bright
group_id 7795
group_uname silver-brush-sterling-series-brushes
id 86735
list_price 3.45
map NO
mfr_num 6002S-8
net_weight 0.03
non_member_discount 50
non_member_price 1.73
prop65 NO
ship_rule_desc STD
shipping STD
sku 86735
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.17
ta_dealer_c_price 1.17
ta_price 2.07
text
array
1 86735
2 6002S-8
3 8, bright
timestamp 2015-03-31T17:54:40.088Z
vip_member_price 1.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 51588
CACHED false
EXECUTIONTIME 3
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] = '2323' 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.145.246.183

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030465e04ea63eeba391d3d31344291d124
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~&gr=krylon-repositionable-adhesive.html
urltoken CFID=30613913&CFTOKEN=43916109&jsessionid=e030465e04ea63eeba391d3d31344291d124
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:36:46'}
sessionid e030f0e11534fb2db99717263d4a5945c3b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&gr=silver-brush-sterling-series-brushes.html
urltoken CFID=30613912&CFTOKEN=42893898&jsessionid=e030f0e11534fb2db99717263d4a5945c3b4
validationerror [empty string]


Extraordinary value Golden Taklon brushes are an excellent choice for students, crafters, and decorative painters working in acrylics and watercolors. The brush head is constructed of multi-diameter Taklon filaments to enhance color carrying capacity and maintain shape. The hair is set in gold tone ferrules on beautiful butterscotch colored handles, carefully balanced for comfort.

Share on Facebook Twitter Pinterest

Ask a question about Sterling Series Brushes Ask a question about this product

Sterling Series Brushes

by Silver Brush

Average User Rating: Based on (7 Reviews)

5 7

Alexis M from Monterey, CA says:

Purchased a variety of brushes as a present for my daughter and she was excited to receive them. Thanks for not disappointing!

[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
87044
Sterling Series Brushes 3/0 round
Zoom Image
3/0 round 6000S-3/0 $2.10 $1.05 50% Off $0.84 60% Off Email When In Stock
Add to Favorites
79968
Sterling Series Brushes 2/0 script liner
Zoom Image
2/0 script liner 6007S-2/0 $2.20 $1.10 50% Off $0.88 60% Off Email When In Stock
Add to Favorites
38994
Sterling Series Brushes 0 bright
Zoom Image
0 bright 6002S-0 $2.20 $1.10 50% Off $0.88 60% Off Email When In Stock
Add to Favorites
40949
Sterling Series Brushes 0 round
Zoom Image
0 round 6000S-0 $2.15 $1.08 50% Off $0.86 60% Off Email When In Stock
Add to Favorites
60360
Sterling Series Brushes 1 script liner
Zoom Image
1 script liner 6007S-1 $2.30 $1.15 50% Off $0.92 60% Off Email When In Stock
Add to Favorites
83871
Sterling Series Brushes 1 round
Zoom Image
1 round 6000S-1 $2.25 $1.13 50% Off $0.90 60% Off Email When In Stock
Add to Favorites
83007
Sterling Series Brushes 3/8 in. angular
Zoom Image
3/8 in. angular 6006S-3/8 $3.85 $1.93 50% Off $1.54 60% Off Email When In Stock
Add to Favorites
19251
Sterling Series Brushes 1/2 in. stroke
Zoom Image
1/2 in. stroke 6011S-1/2 $4.25 $2.13 50% Off $1.70 60% Off Email When In Stock
Add to Favorites
66256
Sterling Series Brushes 1/2 in. square wash
Zoom Image
1/2 in. square wash 6008S-1/2 $4.40 $2.20 50% Off $1.76 60% Off Email When In Stock
Add to Favorites
87564
Sterling Series Brushes 1/2 in. angular
Zoom Image
1/2 in. angular 6006S-1/2 $5.80 $2.90 50% Off $2.32 60% Off Email When In Stock
Add to Favorites
87950
Sterling Series Brushes 3/4 in. stroke
Zoom Image
3/4 in. stroke 6011S-3/4 $9.50 $4.75 50% Off $3.80 60% Off Email When In Stock
Add to Favorites
44038
Sterling Series Brushes 1 in. stroke
Zoom Image
1 in. stroke 6011S-1 $11.95 $5.98 50% Off $4.78 60% Off Email When In Stock
Add to Favorites
56194
Sterling Series Brushes 1 in. square wash
Zoom Image
1 in. square wash 6008S-1 $11.00 $5.50 50% Off $4.40 60% Off Email When In Stock
Add to Favorites
69271
Sterling Series Brushes 1/4 in. angular
Zoom Image
1/4 in. angular 6006S-1/4 $3.00 $1.50 50% Off $1.20 60% Off Email When In Stock
Add to Favorites
23494
Sterling Series Brushes 12 round
Zoom Image
12 round 6000S-12 $5.95 $2.98 50% Off $2.38 60% Off Email When In Stock
Add to Favorites
51923
Sterling Series Brushes 2 bright
Zoom Image
2 bright 6002S-2 $2.45 $1.23 50% Off $0.98 60% Off Email When In Stock
Add to Favorites
61651
Sterling Series Brushes 2 round
Zoom Image
2 round 6000S-2 $2.40 $1.20 50% Off $0.96 60% Off Email When In Stock
Add to Favorites
67574
Sterling Series Brushes 2 filbert
Zoom Image
2 filbert 6003S-2 $2.45 $1.23 50% Off $0.98 60% Off Email When In Stock
Add to Favorites
83448
Sterling Series Brushes 2 in. wash
Zoom Image
2 in. wash 6014S-2 $20.95 $10.48 50% Off $8.38 60% Off Email When In Stock
Add to Favorites
83798
Sterling Series Brushes 3 in. wash
Zoom Image
3 in. wash 6014S-3 $32.95 $16.48 50% Off $13.18 60% Off Email When In Stock
Add to Favorites
19893
Sterling Series Brushes 4 filbert
Zoom Image
4 filbert 6003S-4 $2.65 $1.33 50% Off $1.06 60% Off Email When In Stock
Add to Favorites
30548
Sterling Series Brushes 4 round
Zoom Image
4 round 6000S-4 $2.50 $1.25 50% Off $1.00 60% Off Email When In Stock
Add to Favorites
53967
Sterling Series Brushes 4 bright
Zoom Image
4 bright 6002S-4 $2.55 $1.28 50% Off $1.02 60% Off Email When In Stock
Add to Favorites
79631
Sterling Series Brushes 4 fan
Zoom Image
4 fan 6004S-4 $5.55 $2.78 50% Off $2.22 60% Off Email When In Stock
Add to Favorites
13099
Sterling Series Brushes 6 bright
Zoom Image
6 bright 6002S-6 $3.00 $1.50 50% Off $1.20 60% Off Email When In Stock
Add to Favorites
24109
Sterling Series Brushes 6 filbert
Zoom Image
6 filbert 6003S-6 $3.15 $1.58 50% Off $1.26 60% Off Email When In Stock
Add to Favorites
50724
Sterling Series Brushes 6 round
Zoom Image
6 round 6000S-6 $3.15 $1.58 50% Off $1.26 60% Off Email When In Stock
Add to Favorites
55916