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

Bristlette Oil and Acrylic Brushes

by Grumbacher


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355546
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 [empty string]
cost 1.82
deal_of_the_week NO
description 1, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 57234
list_price 6.6
map NO
mfr_num 4720B.1
net_weight 0.1
non_member_discount 51
non_member_price 3.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 57234
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.11
ta_dealer_c_price 1.98
ta_price 3.96
text
array
1 57234
2 4720B.1
3 1, bright
timestamp 2015-03-27T14:47:32.323Z
vip_member_price 2.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355614
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 [empty string]
cost 1.82
deal_of_the_week NO
description 1, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91395
list_price 6.6
map NO
mfr_num 4720F.1
net_weight 0.1
non_member_discount 51
non_member_price 3.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 91395
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.11
ta_dealer_c_price 1.98
ta_price 3.96
text
array
1 91395
2 4720F.1
3 1, flat
timestamp 2015-03-27T14:48:27.457Z
vip_member_price 2.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355713
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.82
deal_of_the_week NO
description 1, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91404
list_price 6.6
map NO
mfr_num 4720R.1
net_weight 0.1
non_member_discount 51
non_member_price 3.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 91404
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.11
ta_dealer_c_price 1.98
ta_price 3.96
text
array
1 91404
2 4720R.1
3 1, round
timestamp 2015-03-27T14:48:27.49Z
vip_member_price 2.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362933
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 1.99
deal_of_the_week NO
description 1, filbert
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91416
list_price 7.25
map NO
mfr_num 4722.1
net_weight 0.1
non_member_discount 51
non_member_price 3.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 91416
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 4.35
text
array
1 91416
2 4722.1
3 1, filbert
timestamp 2015-03-27T14:48:27.526Z
vip_member_price 2.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173360335
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 [empty string]
cost 5.56
deal_of_the_week NO
description 10, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91393
list_price 20.25
map NO
mfr_num 4720B.10
net_weight 0.1
non_member_discount 51
non_member_price 9.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91393
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.48
ta_dealer_c_price 6.08
ta_price 12.15
text
array
1 91393
2 4720B.10
3 10, bright
timestamp 2015-03-27T14:48:27.451Z
vip_member_price 7.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173360342
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 [empty string]
cost 5.56
deal_of_the_week NO
description 10, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91402
list_price 20.25
map NO
mfr_num 4720F.10
net_weight 0.1
non_member_discount 51
non_member_price 9.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91402
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.48
ta_dealer_c_price 6.08
ta_price 12.15
text
array
1 91402
2 4720F.10
3 10, flat
timestamp 2015-03-27T14:48:27.486Z
vip_member_price 7.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362926
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 7.12
deal_of_the_week NO
description 10, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91411
list_price 25.95
map NO
mfr_num 4720R.10
net_weight 0.1
non_member_discount 51
non_member_price 12.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91411
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.3
ta_dealer_c_price 7.79
ta_price 15.57
text
array
1 91411
2 4720R.10
3 10, round
timestamp 2015-03-27T14:48:27.516Z
vip_member_price 10.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362957
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 6.76
deal_of_the_week NO
description 10, filbert
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91421
list_price 24.6
map NO
mfr_num 4722.10
net_weight 0.1
non_member_discount 51
non_member_price 12.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 91421
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.87
ta_dealer_c_price 7.38
ta_price 14.76
text
array
1 91421
2 4722.10
3 10, filbert
timestamp 2015-03-27T14:48:27.536Z
vip_member_price 9.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355553
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 [empty string]
cost 7.8
deal_of_the_week NO
description 12, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91394
list_price 28.4
map NO
mfr_num 4720B.12
net_weight 0.1
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91394
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.09
ta_dealer_c_price 8.52
ta_price 17.04
text
array
1 91394
2 4720B.12
3 12, bright
timestamp 2015-03-27T14:48:27.454Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355621
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 7.8
deal_of_the_week NO
description 12, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91403
list_price 28.4
map NO
mfr_num 4720F.12
net_weight 0.1
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91403
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.09
ta_dealer_c_price 8.52
ta_price 17.04
text
array
1 91403
2 4720F.12
3 12, flat
timestamp 2015-03-27T14:48:27.488Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355720
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 7.8
deal_of_the_week NO
description 12, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91412
list_price 28.4
map NO
mfr_num 4720R.12
net_weight 0.1
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91412
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.09
ta_dealer_c_price 8.52
ta_price 17.04
text
array
1 91412
2 4720R.12
3 12, round
timestamp 2015-03-27T14:48:27.518Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362964
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 7.64
deal_of_the_week NO
description 12, filbert
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91422
list_price 27.8
map NO
mfr_num 4722.12
net_weight 0.1
non_member_discount 51
non_member_price 13.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 91422
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.9
ta_dealer_c_price 8.34
ta_price 16.68
text
array
1 91422
2 4722.12
3 12, filbert
timestamp 2015-03-27T14:48:27.539Z
vip_member_price 10.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355560
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.05
deal_of_the_week NO
description 2, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91388
list_price 7.45
map NO
mfr_num 4720B.2
net_weight 0.1
non_member_discount 51
non_member_price 3.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 91388
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.38
ta_dealer_c_price 2.24
ta_price 4.47
text
array
1 91388
2 4720B.2
3 2, bright
timestamp 2015-03-27T14:48:27.43Z
vip_member_price 2.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355638
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.05
deal_of_the_week NO
description 2, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91396
list_price 7.45
map NO
mfr_num 4720F.2
net_weight 0.1
non_member_discount 51
non_member_price 3.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 91396
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.38
ta_dealer_c_price 2.24
ta_price 4.47
text
array
1 91396
2 4720F.2
3 2, flat
timestamp 2015-03-27T14:48:27.461Z
vip_member_price 2.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355737
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.05
deal_of_the_week NO
description 2, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91405
list_price 7.45
map NO
mfr_num 4720R.2
net_weight 0.1
non_member_discount 51
non_member_price 3.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 91405
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.38
ta_dealer_c_price 2.24
ta_price 4.47
text
array
1 91405
2 4720R.2
3 2, round
timestamp 2015-03-27T14:48:27.495Z
vip_member_price 2.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355812
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 [empty string]
cost 2.61
deal_of_the_week NO
description 2, fan
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91413
list_price 9.5
map NO
mfr_num 4721.2
net_weight 0.1
non_member_discount 51
non_member_price 4.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 91413
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.04
ta_dealer_c_price 2.85
ta_price 5.7
text
array
1 91413
2 4721.2
3 2, fan
timestamp 2015-03-27T14:48:27.52Z
vip_member_price 3.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361578
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.12
deal_of_the_week NO
description 2, filbert
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91417
list_price 7.75
map NO
mfr_num 4722.2
net_weight 0.1
non_member_discount 51
non_member_price 3.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 91417
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 4.65
text
array
1 91417
2 4722.2
3 2, filbert
timestamp 2015-03-27T14:48:27.528Z
vip_member_price 3.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362889
barcode_type UPC
col1 3
col1_sortorder 1434
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 3, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91397
list_price 8.65
map NO
mfr_num 4720F.3
net_weight 0.1
non_member_discount 51
non_member_price 4.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 91397
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.77
ta_dealer_c_price 2.6
ta_price 5.19
text
array
1 91397
2 4720F.3
3 3, flat
timestamp 2015-03-27T14:48:27.466Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362902
barcode_type UPC
col1 3
col1_sortorder 1434
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 3, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91406
list_price 8.65
map NO
mfr_num 4720R.3
net_weight 0.1
non_member_discount 51
non_member_price 4.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 91406
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.77
ta_dealer_c_price 2.6
ta_price 5.19
text
array
1 91406
2 4720R.3
3 3, round
timestamp 2015-03-27T14:48:27.497Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173360021
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.4
deal_of_the_week NO
description 4, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91389
list_price 8.75
map NO
mfr_num 4720B.4
net_weight 0.1
non_member_discount 51
non_member_price 4.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 91389
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.8
ta_dealer_c_price 2.63
ta_price 5.25
text
array
1 91389
2 4720B.4
3 4, bright
timestamp 2015-03-27T14:48:27.432Z
vip_member_price 3.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355645
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.4
deal_of_the_week NO
description 4, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91398
list_price 8.75
map NO
mfr_num 4720F.4
net_weight 0.1
non_member_discount 51
non_member_price 4.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 91398
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.8
ta_dealer_c_price 2.63
ta_price 5.25
text
array
1 91398
2 4720F.4
3 4, flat
timestamp 2015-03-27T14:48:27.469Z
vip_member_price 3.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355744
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.4
deal_of_the_week NO
description 4, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91407
list_price 8.75
map NO
mfr_num 4720R.4
net_weight 0.1
non_member_discount 51
non_member_price 4.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 91407
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.8
ta_dealer_c_price 2.63
ta_price 5.25
text
array
1 91407
2 4720R.4
3 4, round
timestamp 2015-03-27T14:48:27.503Z
vip_member_price 3.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355829
barcode_type UPC
col1 4
col1_sortorder 1724
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3.25
deal_of_the_week NO
description 4, fan
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91414
list_price 11.8
map NO
mfr_num 4721.4
net_weight 0.1
non_member_discount 51
non_member_price 5.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 91414
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.78
ta_dealer_c_price 3.54
ta_price 7.08
text
array
1 91414
2 4721.4
3 4, fan
timestamp 2015-03-27T14:48:27.522Z
vip_member_price 4.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361585
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.78
deal_of_the_week NO
description 4, filbert
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91418
list_price 10.15
map NO
mfr_num 4722.4
net_weight 0.1
non_member_discount 51
non_member_price 4.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 91418
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.25
ta_dealer_c_price 3.05
ta_price 6.09
text
array
1 91418
2 4722.4
3 4, filbert
timestamp 2015-03-27T14:48:27.53Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362872
barcode_type UPC
col1 5
col1_sortorder 1906
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.1
deal_of_the_week NO
description 5, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91390
list_price 11.3
map NO
mfr_num 4720B.5
net_weight 0.1
non_member_discount 51
non_member_price 5.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 91390
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.62
ta_dealer_c_price 3.39
ta_price 6.78
text
array
1 91390
2 4720B.5
3 5, bright
timestamp 2015-03-27T14:48:27.434Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355652
barcode_type UPC
col1 5
col1_sortorder 1906
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.1
deal_of_the_week NO
description 5, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91399
list_price 11.3
map NO
mfr_num 4720F.5
net_weight 0.1
non_member_discount 51
non_member_price 5.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 91399
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.62
ta_dealer_c_price 3.39
ta_price 6.78
text
array
1 91399
2 4720F.5
3 5, flat
timestamp 2015-03-27T14:48:27.475Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362919
barcode_type UPC
col1 5
col1_sortorder 1906
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.14
deal_of_the_week NO
description 5, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91408
list_price 11.4
map NO
mfr_num 4720R.5
net_weight 0.1
non_member_discount 51
non_member_price 5.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 91408
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.65
ta_dealer_c_price 3.42
ta_price 6.84
text
array
1 91408
2 4720R.5
3 5, round
timestamp 2015-03-27T14:48:27.505Z
vip_member_price 4.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355577
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.32
deal_of_the_week NO
description 6, bright
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91391
list_price 12.1
map NO
mfr_num 4720B.6
net_weight 0.1
non_member_discount 51
non_member_price 5.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 91391
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.87
ta_dealer_c_price 3.63
ta_price 7.26
text
array
1 91391
2 4720B.6
3 6, bright
timestamp 2015-03-27T14:48:27.443Z
vip_member_price 4.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355669
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.32
deal_of_the_week NO
description 6, flat
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91400
list_price 12.1
map NO
mfr_num 4720F.6
net_weight 0.1
non_member_discount 51
non_member_price 5.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 91400
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.87
ta_dealer_c_price 3.63
ta_price 7.26
text
array
1 91400
2 4720F.6
3 6, flat
timestamp 2015-03-27T14:48:27.482Z
vip_member_price 4.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355751
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.32
deal_of_the_week NO
description 6, round
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91409
list_price 12.1
map NO
mfr_num 4720R.6
net_weight 0.1
non_member_discount 51
non_member_price 5.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 91409
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.87
ta_dealer_c_price 3.63
ta_price 7.26
text
array
1 91409
2 4720R.6
3 6, round
timestamp 2015-03-27T14:48:27.511Z
vip_member_price 4.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173355836
barcode_type UPC
col1 6
col1_sortorder 2077
col2 fan
col2_sortorder 198
col3 [empty string]
cost 4.48
deal_of_the_week NO
description 6, fan
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91415
list_price 16.3
map NO
mfr_num 4721.6
net_weight 0.1
non_member_discount 51
non_member_price 7.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 91415
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.22
ta_dealer_c_price 4.89
ta_price 9.78
text
array
1 91415
2 4721.6
3 6, fan
timestamp 2015-03-27T14:48:27.524Z
vip_member_price 6.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030e84d2881ec95a26b601a384571f10633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=fb~jack-richeson~fp~0-5~&gr=jack-richeson-hole-cutters.html
urltoken CFID=29851109&CFTOKEN=34566956&jsessionid=e030e84d2881ec95a26b601a384571f10633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:41:14'}
sessionid e030845193c72cb10141143e54c39b51352d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html
urltoken CFID=29851110&CFTOKEN=10075479&jsessionid=e030845193c72cb10141143e54c39b51352d
validationerror [empty string]


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

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

ItemIDList: 66981,73015
AvailQtyList: 12.000000000000,12.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361592
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.64
deal_of_the_week NO
description 6, filbert
group_id 12159
group_uname grumbacher-bristlette-oil-and-acrylic-brushes
id 91419
list_price 13.25
map NO
mfr_num 4722.6
net_weight 0.1
non_member_discount 51
non_member_price 6.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 91419
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.24
ta_dealer_c_price 3.98
ta_price 7.95
text
array
1 91419
2 4722.6
3 6, filbert
timestamp 2015-03-27T14:48:27.532Z
vip_member_price 5.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 66981
2 12.000000000000 73015
CACHED false
EXECUTIONTIME 5
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] = '1015' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~grumbacher~&gr=grumbacher-bristlette-oil-and-acrylic-brushes.html

StartSessionVariables: