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

Gainsborough Oil and Acrylic Brushes

by Grumbacher


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173364456
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.95
deal_of_the_week NO
description 0, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91368
list_price 7.1
map NO
mfr_num 1271R.Z
net_weight 0.08
non_member_discount 51
non_member_price 3.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 91368
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.27
ta_dealer_c_price 2.13
ta_price 4.26
text
array
1 91368
2 1271R.Z
3 0, round
timestamp 2015-03-26T14:52:23.424Z
vip_member_price 2.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362131
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.01
deal_of_the_week NO
description 1, bright
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 57217
list_price 7.35
map NO
mfr_num 1271B.1
net_weight 0.08
non_member_discount 51
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 57217
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.21
ta_price 4.41
text
array
1 57217
2 1271B.1
3 1, bright
timestamp 2015-03-26T14:51:33.715Z
vip_member_price 2.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362155
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.01
deal_of_the_week NO
description 1, flat
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91360
list_price 7.35
map NO
mfr_num 1271F.1
net_weight 0.08
non_member_discount 51
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 91360
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.21
ta_price 4.41
text
array
1 91360
2 1271F.1
3 1, flat
timestamp 2015-03-26T14:52:23.399Z
vip_member_price 2.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354686
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.01
deal_of_the_week NO
description 1, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91369
list_price 7.35
map NO
mfr_num 1271R.1
net_weight 0.08
non_member_discount 51
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 91369
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.21
ta_price 4.41
text
array
1 91369
2 1271R.1
3 1, round
timestamp 2015-03-26T14:52:23.427Z
vip_member_price 2.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362209
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.01
deal_of_the_week NO
description 1, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91380
list_price 7.35
map NO
mfr_num 1271T.1
net_weight 0.08
non_member_discount 51
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 91380
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.21
ta_price 4.41
text
array
1 91380
2 1271T.1
3 1, filbert
timestamp 2015-03-26T14:52:23.501Z
vip_member_price 2.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361325
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 [empty string]
cost 5.55
deal_of_the_week NO
description 10, bright
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91357
list_price 20.2
map NO
mfr_num 1271B.10
net_weight 0.08
non_member_discount 51
non_member_price 9.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 91357
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.46
ta_dealer_c_price 6.06
ta_price 12.12
text
array
1 91357
2 1271B.10
3 10, bright
timestamp 2015-03-26T14:52:23.384Z
vip_member_price 7.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354617
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 [empty string]
cost 5.55
deal_of_the_week NO
description 10, flat
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91365
list_price 20.2
map NO
mfr_num 1271F.10
net_weight 0.08
non_member_discount 51
non_member_price 9.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 91365
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.46
ta_dealer_c_price 6.06
ta_price 12.12
text
array
1 91365
2 1271F.10
3 10, flat
timestamp 2015-03-26T14:52:23.418Z
vip_member_price 7.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173360595
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 5.55
deal_of_the_week NO
description 10, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91375
list_price 20.2
map NO
mfr_num 1271R.10
net_weight 0.08
non_member_discount 51
non_member_price 9.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 91375
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.46
ta_dealer_c_price 6.06
ta_price 12.12
text
array
1 91375
2 1271R.10
3 10, round
timestamp 2015-03-26T14:52:23.464Z
vip_member_price 7.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362223
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 5.55
deal_of_the_week NO
description 10, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91385
list_price 20.2
map NO
mfr_num 1271T.10
net_weight 0.08
non_member_discount 51
non_member_price 9.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 91385
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.46
ta_dealer_c_price 6.06
ta_price 12.12
text
array
1 91385
2 1271T.10
3 10, filbert
timestamp 2015-03-26T14:52:23.534Z
vip_member_price 7.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354532
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 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91358
list_price 28.4
map NO
mfr_num 1271B.12
net_weight 0.08
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91358
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 91358
2 1271B.12
3 12, bright
timestamp 2015-03-26T14:52:23.386Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354624
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 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91366
list_price 28.4
map NO
mfr_num 1271F.12
net_weight 0.08
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91366
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 91366
2 1271F.12
3 12, flat
timestamp 2015-03-26T14:52:23.42Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354693
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 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91376
list_price 28.4
map NO
mfr_num 1271R.12
net_weight 0.08
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91376
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 91376
2 1271R.12
3 12, round
timestamp 2015-03-26T14:52:23.47Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362230
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 7.8
deal_of_the_week NO
description 12, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91386
list_price 28.4
map NO
mfr_num 1271T.12
net_weight 0.08
non_member_discount 51
non_member_price 13.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91386
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 91386
2 1271T.12
3 12, filbert
timestamp 2015-03-26T14:52:23.54Z
vip_member_price 11.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354549
barcode_type UPC
col1 14
col1_sortorder 912
col2 bright
col2_sortorder 112
col3 [empty string]
cost 8.53
deal_of_the_week NO
description 14, bright
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91359
list_price 31.05
map NO
mfr_num 1271B.14
net_weight 0.08
non_member_discount 51
non_member_price 15.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 91359
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.94
ta_dealer_c_price 9.32
ta_price 18.63
text
array
1 91359
2 1271B.14
3 14, bright
timestamp 2015-03-26T14:52:23.392Z
vip_member_price 12.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173365170
barcode_type UPC
col1 14
col1_sortorder 912
col2 flat
col2_sortorder 209
col3 [empty string]
cost 8.53
deal_of_the_week NO
description 14, flat
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91367
list_price 31.05
map NO
mfr_num 1271F.14
net_weight 0.08
non_member_discount 51
non_member_price 15.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 91367
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.94
ta_dealer_c_price 9.32
ta_price 18.63
text
array
1 91367
2 1271F.14
3 14, flat
timestamp 2015-03-26T14:52:23.422Z
vip_member_price 12.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173365187
barcode_type UPC
col1 14
col1_sortorder 912
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 8.53
deal_of_the_week NO
description 14, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91387
list_price 31.05
map NO
mfr_num 1271T.14
net_weight 0.08
non_member_discount 51
non_member_price 15.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 91387
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.94
ta_dealer_c_price 9.32
ta_price 18.63
text
array
1 91387
2 1271T.14
3 14, filbert
timestamp 2015-03-26T14:52:23.544Z
vip_member_price 12.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361318
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.2
deal_of_the_week NO
description 2, bright
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91353
list_price 8
map NO
mfr_num 1271B.2
net_weight 0.08
non_member_discount 51
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91353
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.56
ta_dealer_c_price 2.4
ta_price 4.8
text
array
1 91353
2 1271B.2
3 2, bright
timestamp 2015-03-26T14:52:23.37Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173360328
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.2
deal_of_the_week NO
description 2, flat
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91361
list_price 8
map NO
mfr_num 1271F.2
net_weight 0.08
non_member_discount 51
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91361
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.56
ta_dealer_c_price 2.4
ta_price 4.8
text
array
1 91361
2 1271F.2
3 2, flat
timestamp 2015-03-26T14:52:23.406Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354709
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.2
deal_of_the_week NO
description 2, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91370
list_price 8
map NO
mfr_num 1271R.2
net_weight 0.08
non_member_discount 51
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91370
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.56
ta_dealer_c_price 2.4
ta_price 4.8
text
array
1 91370
2 1271R.2
3 2, round
timestamp 2015-03-26T14:52:23.432Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361332
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 [empty string]
cost 2.45
deal_of_the_week NO
description 2, fan
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91377
list_price 8.95
map NO
mfr_num 1271N.2
net_weight 0.08
non_member_discount 51
non_member_price 4.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 91377
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.86
ta_dealer_c_price 2.69
ta_price 5.37
text
array
1 91377
2 1271N.2
3 2, fan
timestamp 2015-03-26T14:52:23.478Z
vip_member_price 3.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361356
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.2
deal_of_the_week NO
description 2, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91381
list_price 8
map NO
mfr_num 1271T.2
net_weight 0.08
non_member_discount 51
non_member_price 3.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 91381
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.56
ta_dealer_c_price 2.4
ta_price 4.8
text
array
1 91381
2 1271T.2
3 2, filbert
timestamp 2015-03-26T14:52:23.508Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362186
barcode_type UPC
col1 3
col1_sortorder 1434
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.49
deal_of_the_week NO
description 3, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91371
list_price 9.05
map NO
mfr_num 1271R.3
net_weight 0.08
non_member_discount 51
non_member_price 4.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 91371
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.9
ta_dealer_c_price 2.72
ta_price 5.43
text
array
1 91371
2 1271R.3
3 3, round
timestamp 2015-03-26T14:52:23.438Z
vip_member_price 3.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354570
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.61
deal_of_the_week NO
description 4, bright
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91354
list_price 9.5
map NO
mfr_num 1271B.4
net_weight 0.08
non_member_discount 51
non_member_price 4.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 91354
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 91354
2 1271B.4
3 4, bright
timestamp 2015-03-26T14:52:23.374Z
vip_member_price 3.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354648
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.61
deal_of_the_week NO
description 4, flat
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91362
list_price 9.5
map NO
mfr_num 1271F.4
net_weight 0.08
non_member_discount 51
non_member_price 4.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 91362
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 91362
2 1271F.4
3 4, flat
timestamp 2015-03-26T14:52:23.41Z
vip_member_price 3.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354716
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.61
deal_of_the_week NO
description 4, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91372
list_price 9.5
map NO
mfr_num 1271R.4
net_weight 0.08
non_member_discount 51
non_member_price 4.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 91372
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 91372
2 1271R.4
3 4, round
timestamp 2015-03-26T14:52:23.444Z
vip_member_price 3.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362193
barcode_type UPC
col1 4
col1_sortorder 1724
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3.5
deal_of_the_week NO
description 4, fan
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91378
list_price 12.75
map NO
mfr_num 1271N.4
net_weight 0.08
non_member_discount 51
non_member_price 6.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 91378
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.08
ta_dealer_c_price 3.83
ta_price 7.65
text
array
1 91378
2 1271N.4
3 4, fan
timestamp 2015-03-26T14:52:23.484Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361363
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.61
deal_of_the_week NO
description 4, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91382
list_price 9.5
map NO
mfr_num 1271T.4
net_weight 0.08
non_member_discount 51
non_member_price 4.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 91382
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 91382
2 1271T.4
3 4, filbert
timestamp 2015-03-26T14:52:23.515Z
vip_member_price 3.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354587
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.4
deal_of_the_week NO
description 6, bright
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91355
list_price 12.4
map NO
mfr_num 1271B.6
net_weight 0.08
non_member_discount 51
non_member_price 6.08
prop65 NO
ship_rule_desc STD
shipping STD
sku 91355
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.97
ta_dealer_c_price 3.72
ta_price 7.44
text
array
1 91355
2 1271B.6
3 6, bright
timestamp 2015-03-26T14:52:23.379Z
vip_member_price 4.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354655
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.4
deal_of_the_week NO
description 6, flat
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91363
list_price 12.4
map NO
mfr_num 1271F.6
net_weight 0.08
non_member_discount 51
non_member_price 6.08
prop65 NO
ship_rule_desc STD
shipping STD
sku 91363
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.97
ta_dealer_c_price 3.72
ta_price 7.44
text
array
1 91363
2 1271F.6
3 6, flat
timestamp 2015-03-26T14:52:23.412Z
vip_member_price 4.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173354723
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.4
deal_of_the_week NO
description 6, round
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91373
list_price 12.4
map NO
mfr_num 1271R.6
net_weight 0.08
non_member_discount 51
non_member_price 6.08
prop65 NO
ship_rule_desc STD
shipping STD
sku 91373
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.97
ta_dealer_c_price 3.72
ta_price 7.44
text
array
1 91373
2 1271R.6
3 6, round
timestamp 2015-03-26T14:52:23.452Z
vip_member_price 4.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361349
barcode_type UPC
col1 6
col1_sortorder 2077
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3.84
deal_of_the_week NO
description 6, fan
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91379
list_price 14
map NO
mfr_num 1271N.6
net_weight 0.08
non_member_discount 51
non_member_price 6.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 91379
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 4.2
ta_price 8.4
text
array
1 91379
2 1271N.6
3 6, fan
timestamp 2015-03-26T14:52:23.495Z
vip_member_price 5.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361370
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.4
deal_of_the_week NO
description 6, filbert
group_id 12157
group_uname grumbacher-gainsborough-oil-and-acrylic-brushes
id 91383
list_price 12.4
map NO
mfr_num 1271T.6
net_weight 0.08
non_member_discount 51
non_member_price 6.08
prop65 NO
ship_rule_desc STD
shipping STD
sku 91383
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.97
ta_dealer_c_price 3.72
ta_price 7.44
text
array
1 91383
2 1271T.6
3 6, filbert
timestamp 2015-03-26T14:52:23.52Z
vip_member_price 4.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 80858
CACHED false
EXECUTIONTIME 7
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] = '7461' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.238

URL: www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e030f8086ebab08f158958364b6a37125474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=sort~1~fb~duncan~&gr=duncan-br-576-premium-flat-glaze-brush.html
urltoken CFID=29310324&CFTOKEN=24645889&jsessionid=e030f8086ebab08f158958364b6a37125474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 05:15:54'}
sessionid e0308d18c6826e0af12822591149167a54c3
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fb~grumbacher~&gr=grumbacher-gainsborough-oil-and-acrylic-brushes.html
urltoken CFID=29310323&CFTOKEN=21867459&jsessionid=e0308d18c6826e0af12822591149167a54c3
validationerror [empty string]


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

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

ItemIDList: 80858