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

Black Gold Series Long Handled Synthetic Brushes

by Dynasty


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060160
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 1526B
col3_sortorder 384
cost 2.22
deal_of_the_week NO
description 1, bright, 1526B
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 40452
list_price 6.75
map NO
mfr_num 12156
net_weight 0.01
non_member_discount 34
non_member_price 4.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 40452
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.57
ta_dealer_c_price 2.43
ta_price 4.05
text
array
1 40452
2 12156
3 1, bright, 1526B
timestamp 2015-03-27T14:47:12.62Z
vip_member_price 3.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060085
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 1526F
col3_sortorder 385
cost 2.22
deal_of_the_week NO
description 1, flat, 1526F
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 55607
list_price 6.75
map NO
mfr_num 12148
net_weight 0.02
non_member_discount 34
non_member_price 4.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 55607
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.57
ta_dealer_c_price 2.43
ta_price 4.05
text
array
1 55607
2 12148
3 1, flat, 1526F
timestamp 2015-03-27T14:47:30.402Z
vip_member_price 3.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060245
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 2.22
deal_of_the_week NO
description 1, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 74749
list_price 6.75
map NO
mfr_num 12164
net_weight 0.01
non_member_discount 34
non_member_price 4.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 74749
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.57
ta_dealer_c_price 2.43
ta_price 4.05
text
array
1 74749
2 12164
3 1, filbert, 1526FIL
timestamp 2015-03-27T14:48:04.972Z
vip_member_price 3.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060009
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 1526R
col3_sortorder 387
cost 2.22
deal_of_the_week NO
description 1, round, 1526R
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 86905
list_price 6.75
map NO
mfr_num 12140
net_weight 0.02
non_member_discount 34
non_member_price 4.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 86905
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.57
ta_dealer_c_price 2.43
ta_price 4.05
text
array
1 86905
2 12140
3 1, round, 1526R
timestamp 2015-03-27T14:48:18.832Z
vip_member_price 3.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060146
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 1526F
col3_sortorder 385
cost 6.6
deal_of_the_week NO
description 10, flat, 1526F
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 24061
list_price 20.05
map NO
mfr_num 12154
net_weight 0.06
non_member_discount 34
non_member_price 13.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 24061
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.62
ta_dealer_c_price 7.22
ta_price 12.03
text
array
1 24061
2 12154
3 10, flat, 1526F
timestamp 2015-03-27T14:46:45.358Z
vip_member_price 11.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060306
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 6.6
deal_of_the_week NO
description 10, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 27320
list_price 20.05
map NO
mfr_num 12170
net_weight 0.05
non_member_discount 34
non_member_price 13.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 27320
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.62
ta_dealer_c_price 7.22
ta_price 12.03
text
array
1 27320
2 12170
3 10, filbert, 1526FIL
timestamp 2015-03-27T14:46:50.487Z
vip_member_price 11.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060221
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 1526B
col3_sortorder 384
cost 6.62
deal_of_the_week NO
description 10, bright, 1526B
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 46056
list_price 20.1
map NO
mfr_num 12162
net_weight 0.06
non_member_discount 34
non_member_price 13.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 46056
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.64
ta_dealer_c_price 7.24
ta_price 12.06
text
array
1 46056
2 12162
3 10, bright, 1526B
timestamp 2015-03-27T14:47:19.472Z
vip_member_price 11.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060061
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 1526R
col3_sortorder 387
cost 6.6
deal_of_the_week NO
description 10, round, 1526R
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 63043
list_price 20.05
map NO
mfr_num 12146
net_weight 0.06
non_member_discount 34
non_member_price 13.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 63043
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.62
ta_dealer_c_price 7.22
ta_price 12.03
text
array
1 63043
2 12146
3 10, round, 1526R
timestamp 2015-03-27T14:47:43.09Z
vip_member_price 11.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060313
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 8.6
deal_of_the_week NO
description 12, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 35712
list_price 26.11
map NO
mfr_num 12171
net_weight 0.09
non_member_discount 34
non_member_price 17.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 35712
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.92
ta_dealer_c_price 9.4
ta_price 15.67
text
array
1 35712
2 12171
3 12, filbert, 1526FIL
timestamp 2015-03-27T14:47:06.623Z
vip_member_price 14.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060177
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 1526B
col3_sortorder 384
cost 2.49
deal_of_the_week NO
description 2, bright, 1526B
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 40411
list_price 7.55
map NO
mfr_num 12157
net_weight 0.02
non_member_discount 34
non_member_price 4.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 40411
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.72
ta_price 4.53
text
array
1 40411
2 12157
3 2, bright, 1526B
timestamp 2015-03-27T14:47:12.599Z
vip_member_price 4.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060016
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 1526R
col3_sortorder 387
cost 2.49
deal_of_the_week NO
description 2, round, 1526R
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 64010
list_price 7.55
map NO
mfr_num 12141
net_weight 0.02
non_member_discount 34
non_member_price 4.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 64010
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.72
ta_price 4.53
text
array
1 64010
2 12141
3 2, round, 1526R
timestamp 2015-03-27T14:47:44.288Z
vip_member_price 4.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060092
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 1526F
col3_sortorder 385
cost 2.49
deal_of_the_week NO
description 2, flat, 1526F
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 75103
list_price 7.55
map NO
mfr_num 12149
net_weight 0.02
non_member_discount 34
non_member_price 4.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 75103
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.72
ta_price 4.53
text
array
1 75103
2 12149
3 2, flat, 1526F
timestamp 2015-03-27T14:48:05.15Z
vip_member_price 4.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060252
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 2.49
deal_of_the_week NO
description 2, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 81725
list_price 7.55
map NO
mfr_num 12165
net_weight 0.03
non_member_discount 34
non_member_price 4.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 81725
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.72
ta_price 4.53
text
array
1 81725
2 12165
3 2, filbert, 1526FIL
timestamp 2015-03-27T14:48:12.571Z
vip_member_price 4.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060030
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 1526R
col3_sortorder 387
cost 3.26
deal_of_the_week NO
description 4, round, 1526R
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 10304
list_price 9.9
map NO
mfr_num 12143
net_weight 0.03
non_member_discount 34
non_member_price 6.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 10304
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.76
ta_dealer_c_price 3.56
ta_price 5.94
text
array
1 10304
2 12143
3 4, round, 1526R
timestamp 2015-03-27T14:46:24.294Z
vip_member_price 5.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060191
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 1526B
col3_sortorder 384
cost 3.26
deal_of_the_week NO
description 4, bright, 1526B
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 21793
list_price 9.9
map NO
mfr_num 12159
net_weight 0.02
non_member_discount 34
non_member_price 6.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 21793
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.76
ta_dealer_c_price 3.56
ta_price 5.94
text
array
1 21793
2 12159
3 4, bright, 1526B
timestamp 2015-03-27T14:46:42.593Z
vip_member_price 5.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060276
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 3.26
deal_of_the_week NO
description 4, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 31802
list_price 9.9
map NO
mfr_num 12167
net_weight 0.04
non_member_discount 34
non_member_price 6.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 31802
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.76
ta_dealer_c_price 3.56
ta_price 5.94
text
array
1 31802
2 12167
3 4, filbert, 1526FIL
timestamp 2015-03-27T14:46:57.48Z
vip_member_price 5.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060115
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 1526F
col3_sortorder 385
cost 3.26
deal_of_the_week NO
description 4, flat, 1526F
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 74328
list_price 9.9
map NO
mfr_num 12151
net_weight 0.02
non_member_discount 34
non_member_price 6.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 74328
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.76
ta_dealer_c_price 3.56
ta_price 5.94
text
array
1 74328
2 12151
3 4, flat, 1526F
timestamp 2015-03-27T14:48:04.648Z
vip_member_price 5.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060207
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 1526B
col3_sortorder 384
cost 4.23
deal_of_the_week NO
description 6, bright, 1526B
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 38405
list_price 12.85
map NO
mfr_num 12160
net_weight 0.04
non_member_discount 34
non_member_price 8.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 38405
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.88
ta_dealer_c_price 4.63
ta_price 7.71
text
array
1 38405
2 12160
3 6, bright, 1526B
timestamp 2015-03-27T14:47:10.629Z
vip_member_price 7.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060047
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 1526R
col3_sortorder 387
cost 4.23
deal_of_the_week NO
description 6, round, 1526R
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 82188
list_price 12.85
map NO
mfr_num 12144
net_weight 0.04
non_member_discount 34
non_member_price 8.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 82188
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.88
ta_dealer_c_price 4.63
ta_price 7.71
text
array
1 82188
2 12144
3 6, round, 1526R
timestamp 2015-03-27T14:48:12.9Z
vip_member_price 7.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060122
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 1526F
col3_sortorder 385
cost 4.23
deal_of_the_week NO
description 6, flat, 1526F
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 84634
list_price 12.85
map NO
mfr_num 12152
net_weight 0.04
non_member_discount 34
non_member_price 8.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 84634
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.88
ta_dealer_c_price 4.63
ta_price 7.71
text
array
1 84634
2 12152
3 6, flat, 1526F
timestamp 2015-03-27T14:48:14.829Z
vip_member_price 7.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060283
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 4.23
deal_of_the_week NO
description 6, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 87857
list_price 12.85
map NO
mfr_num 12168
net_weight 0.05
non_member_discount 34
non_member_price 8.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 87857
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.88
ta_dealer_c_price 4.63
ta_price 7.71
text
array
1 87857
2 12168
3 6, filbert, 1526FIL
timestamp 2015-03-27T14:48:20.496Z
vip_member_price 7.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060054
barcode_type UPC
col1 8
col1_sortorder 2250
col2 round
col2_sortorder 434
col3 1526R
col3_sortorder 387
cost 5.67
deal_of_the_week NO
description 8, round, 1526R
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 10857
list_price 17.22
map NO
mfr_num 12145
net_weight 0.04
non_member_discount 34
non_member_price 11.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 10857
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.54
ta_dealer_c_price 6.2
ta_price 10.33
text
array
1 10857
2 12145
3 8, round, 1526R
timestamp 2015-03-27T14:46:24.868Z
vip_member_price 9.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060290
barcode_type UPC
col1 8
col1_sortorder 2250
col2 filbert
col2_sortorder 202
col3 1526FIL
col3_sortorder 386
cost 5.65
deal_of_the_week NO
description 8, filbert, 1526FIL
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 45843
list_price 17.15
map NO
mfr_num 12169
net_weight 0.05
non_member_discount 34
non_member_price 11.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 45843
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.52
ta_dealer_c_price 6.17
ta_price 10.29
text
array
1 45843
2 12169
3 8, filbert, 1526FIL
timestamp 2015-03-27T14:47:19.185Z
vip_member_price 9.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060214
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bright
col2_sortorder 112
col3 1526B
col3_sortorder 384
cost 5.65
deal_of_the_week NO
description 8, bright, 1526B
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 60476
list_price 17.15
map NO
mfr_num 12161
net_weight 0.04
non_member_discount 34
non_member_price 11.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 60476
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.52
ta_dealer_c_price 6.17
ta_price 10.29
text
array
1 60476
2 12161
3 8, bright, 1526B
timestamp 2015-03-27T14:47:38.386Z
vip_member_price 9.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


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

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

ItemIDList: 06845,72591
AvailQtyList: 0E-12,1.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 018376060139
barcode_type UPC
col1 8
col1_sortorder 2250
col2 flat
col2_sortorder 209
col3 1526F
col3_sortorder 385
cost 5.65
deal_of_the_week NO
description 8, flat, 1526F
group_id 7235
group_uname dynasty-black-gold-series-long-handled-synthetic-brushes
id 69462
list_price 17.15
map NO
mfr_num 12153
net_weight 0.04
non_member_discount 34
non_member_price 11.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 69462
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.52
ta_dealer_c_price 6.17
ta_price 10.29
text
array
1 69462
2 12153
3 8, flat, 1526F
timestamp 2015-03-27T14:47:54.372Z
vip_member_price 9.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 06845
2 1.000000000000 72591
CACHED false
EXECUTIONTIME 8
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] = '10997' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:23:36'}
sessionid e0307c1650936b6c6c065e79352f2d382a34
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=dynasty-black-gold-series-long-handled-synthetic-brushes.html
urltoken CFID=29705164&CFTOKEN=84024519&jsessionid=e0307c1650936b6c6c065e79352f2d382a34
validationerror [empty string]


The craftsmanship truly shines in this brush made of the finest quality synthetic hair formed by master brushmakers. Special attention has been paid to the shaping of these brushes. Black Gold represents premium quality artist brushes which are designed to satisfy increased demands for a higher level of performance. This series of brushes is designed for use with oil or acrylic paints.

Share on Facebook Twitter Pinterest

Ask a question about Black Gold Series Long Handled Synthetic Brushes Ask a question about this product

Black Gold Series Long Handled Synthetic Brushes

by Dynasty

Average User Rating: Based on (15 Reviews)

5 15

PAM from ABQ,NM says:

The price was about one quarter of the price quoted online at several sources. I am quite pleased as they seem to be holding a sharp, chisel edge under heavy use--worth the price in quality.

[Read All Reviews] [Write a Review]









  Item# Image size
Ascending
shape series number Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
40452
Black Gold Series Long Handled Synthetic Brushes 1 bright 1526B
Zoom Image
1 bright 1526B 12156 $6.75 $4.46 34% Off $3.78 44% Off Email When In Stock
Add to Favorites
55607
Black Gold Series Long Handled Synthetic Brushes 1 flat 1526F
Zoom Image
1 flat 1526F 12148 $6.75 $4.46 34% Off $3.78 44% Off Email When In Stock
Add to Favorites
74749
Black Gold Series Long Handled Synthetic Brushes 1 filbert 1526FIL
Zoom Image
1 filbert 1526FIL 12164 $6.75 $4.46 34% Off $3.78 44% Off Email When In Stock
Add to Favorites
86905
Black Gold Series Long Handled Synthetic Brushes 1 round 1526R
Zoom Image
1 round 1526R 12140 $6.75 $4.46 34% Off $3.78 44% Off Email When In Stock
Add to Favorites
24061
Black Gold Series Long Handled Synthetic Brushes 10 flat 1526F
Zoom Image
10 flat 1526F 12154 $20.05 $13.23 34% Off $11.23 44% Off Email When In Stock
Add to Favorites
27320
Black Gold Series Long Handled Synthetic Brushes 10 filbert 1526FIL
Zoom Image
10 filbert 1526FIL 12170 $20.05 $13.23 34% Off $11.23 44% Off Email When In Stock
Add to Favorites
46056
Black Gold Series Long Handled Synthetic Brushes 10 bright 1526B
Zoom Image
10 bright 1526B 12162 $20.10 $13.27 34% Off $11.26 44% Off Email When In Stock
Add to Favorites
63043
Black Gold Series Long Handled Synthetic Brushes 10 round 1526R
Zoom Image
10 round 1526R 12146 $20.05 $13.23 34% Off $11.23 44% Off Email When In Stock
Add to Favorites
35712
Black Gold Series Long Handled Synthetic Brushes 12 filbert 1526FIL
Zoom Image
12 filbert 1526FIL 12171 $26.11 $17.23 34% Off $14.62 44% Off Email When In Stock
Add to Favorites
40411
Black Gold Series Long Handled Synthetic Brushes 2 bright 1526B
Zoom Image
2 bright 1526B 12157 $7.55 $4.98 34% Off $4.23 44% Off Email When In Stock
Add to Favorites
64010
Black Gold Series Long Handled Synthetic Brushes 2 round 1526R
Zoom Image
2 round 1526R 12141 $7.55 $4.98 34% Off $4.23 44% Off Email When In Stock
Add to Favorites
75103
Black Gold Series Long Handled Synthetic Brushes 2 flat 1526F
Zoom Image
2 flat 1526F 12149 $7.55 $4.98 34% Off $4.23 44% Off Email When In Stock
Add to Favorites
81725
Black Gold Series Long Handled Synthetic Brushes 2 filbert 1526FIL
Zoom Image
2 filbert 1526FIL 12165 $7.55 $4.98 34% Off $4.23 44% Off Email When In Stock
Add to Favorites
10304
Black Gold Series Long Handled Synthetic Brushes 4 round 1526R
Zoom Image
4 round 1526R 12143 $9.90 $6.53 34% Off $5.54 44% Off Email When In Stock
Add to Favorites
21793
Black Gold Series Long Handled Synthetic Brushes 4 bright 1526B
Zoom Image
4 bright 1526B 12159 $9.90 $6.53 34% Off $5.54 44% Off Email When In Stock
Add to Favorites
31802
Black Gold Series Long Handled Synthetic Brushes 4 filbert 1526FIL
Zoom Image
4 filbert 1526FIL 12167 $9.90 $6.53 34% Off $5.54 44% Off Email When In Stock
Add to Favorites
74328
Black Gold Series Long Handled Synthetic Brushes 4 flat 1526F
Zoom Image
4 flat 1526F 12151 $9.90 $6.53 34% Off $5.54 44% Off Email When In Stock
Add to Favorites
38405
Black Gold Series Long Handled Synthetic Brushes 6 bright 1526B
Zoom Image
6 bright 1526B 12160 $12.85 $8.48 34% Off $7.20 44% Off Email When In Stock
Add to Favorites
82188
Black Gold Series Long Handled Synthetic Brushes 6 round 1526R
Zoom Image
6 round 1526R 12144 $12.85 $8.48 34% Off $7.20 44% Off Email When In Stock
Add to Favorites
84634
Black Gold Series Long Handled Synthetic Brushes 6 flat 1526F
Zoom Image
6 flat 1526F 12152 $12.85 $8.48 34% Off $7.20 44% Off Email When In Stock
Add to Favorites
87857
Black Gold Series Long Handled Synthetic Brushes 6 filbert 1526FIL
Zoom Image
6 filbert 1526FIL 12168 $12.85 $8.48 34% Off $7.20 44% Off Email When In Stock
Add to Favorites
10857
Black Gold Series Long Handled Synthetic Brushes 8 round 1526R
Zoom Image
8 round 1526R 12145 $17.22 $11.37 34% Off $9.64 44% Off Email When In Stock
Add to Favorites
45843
Black Gold Series Long Handled Synthetic Brushes 8 filbert 1526FIL
Zoom Image
8 filbert 1526FIL 12169 $17.15 $11.32 34% Off $9.60 44% Off Email When In Stock
Add to Favorites
60476
Black Gold Series Long Handled Synthetic Brushes 8 bright 1526B
Zoom Image
8 bright 1526B 12161 $17.15 $11.32 34% Off $9.60 44% Off Email When In Stock
Add to Favorites
69462
Black Gold Series Long Handled Synthetic Brushes 8 flat 1526F
Zoom Image
8 flat 1526F 12153 $17.15 $11.32 34% Off $9.60 44% Off Email When In Stock

Click the to add item to your Favorites.



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

Classico Oil Colors

by Maimeri

Just pigment and oil, for truly pure color

At Least 39 % Off

From $3.14

Canvas Boards

by Fredrix

Primed and ready

Up to 65% Off

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

Learn More »

Ask a Question About Black Gold Series Long Handled Synthetic Brushes

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

Customer Product Reviews
Write a Review
Write a Review
Rated by: PAM in ABQ,NM
The price was about one quarter of the price quoted online at several sources. I am quite pleased as they seem to be holding a sharp, chisel edge under heavy use--worth the price in quality.
Rated by: Sheila B in Burlington, NC
l Iove the chisel edge..keeps it's shape when moist
Rated by: Sal in D.C.
Decent brush for the price.
Rated by: Muddled Moose in Ennis,Mt
I am not really an expert on brushes,but this brush really feels good and works great!
Rated by: Wade F. in Shakopee, MN
I really love these brushes. The bristles hold paint well, have nice strength, hold their shape well, and clean easily. Very nice.
Rated by: Mary B. in Gainesville, FL
Beautiful and functional. I love them!
Rated by: Wanda W. in Port Orchard, WA
I felt that these brushes are the best for vary detailed painting of flowers. I can't wait to use them in my crafts.
Rated by: Catherine B. in Frazee, MN
I'm new to painting, but definitely can tell the quality of this brush! I will definitely be back for more.
Rated by: Jean C. in Lake Wales, FL
I wasn't able to find a set of Filberts anywhere else. Certainly will buy my supplies here from now on.
Rated by: Jenny A. in North Bergen, NJ
Thank you MisterArt.com! because of you I have good brushes at a great price.
Rated by: stuart m. in Longmont, CO
Dynasty Black and Gold series are by far the best brushes out there.I am big on detail and very picky about my brushes,With Dynasty B&G I have been impressed far beyond my expectations.I use to not be able to afford quality brushes,thanks to misterart.com I have the best brushes out there and they are my 4 sets of Dynasty B&G.
Rated by: Deborah B. in Lincoln, NE
Once you use Dynasty Black Gold brushes, you cannot go back to another brand with true satisfaction. They are especially cherished for holding their true shape, ease of movement and fluidity. I keep mine separate from my other brushes, I am so protective of them. They clean up very nicely from any medium. Miniature artists MUST use Dynasty! The best brushes at the best prices always at MisterArt.com.
Rated by: LAJUNE M. in BREWTON, AL
These brushes are great. I only ordered two, but at the prices,I will be back to order more. MisterArt.com is the best place I have ordered from. Low prices and really fast shipping.
Rated by: James S. in La Porte, TX
Oil painting with these brushes is an altogether different painting experience than I have ever had with any other paintbrush. I have been able to get deeper detail and finer control over my paint than I ever would have thought possible. Easily worth three times the price--buy a handpicked set before these people wise up =) I got the following to augment a full set of china bristle brights and rounds: Series 206 flat shader #4,8,12; Series 206D dagger (WAY cool brush); Series 206R round #0,3/0; Series 206L liner #0,2; Series 206FIL filberts #2,4. Absolutely awesome brushes!
Rated by: Catherine K. in De Soto, IL
I really like these brushes. They hold up really well and the shape is perfect for my needs.

Write a Product Review for Black Gold Series Long Handled Synthetic Brushes

Add Your Review

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

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

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