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

Winton Hog Brushes

by Winsor & Newton


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870442
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.1
deal_of_the_week NO
description 1, filbert
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 12884
list_price 7.39
map NO
mfr_num 5976701
net_weight 0.04
non_member_discount 51
non_member_price 3.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 12884
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.51
ta_dealer_c_price 2.22
ta_price 4.8
text
array
1 12884
2 5976701
3 1, filbert
timestamp 2015-03-27T14:46:28.046Z
vip_member_price 2.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870169
barcode_type UPC
col1 1
col1_sortorder 275
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 2.1
deal_of_the_week NO
description 1, short flat/bright
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 55020
list_price 7.39
map NO
mfr_num 5973701
net_weight 0.08
non_member_discount 51
non_member_price 3.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 55020
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.51
ta_dealer_c_price 2.22
ta_price 4.8
text
array
1 55020
2 5973701
3 1, short flat/bright
timestamp 2015-03-27T14:47:29.697Z
vip_member_price 2.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870527
barcode_type UPC
col1 1
col1_sortorder 275
col2 fan
col2_sortorder 198
col3 [empty string]
cost 4.07
deal_of_the_week NO
description 1, fan
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 58851
list_price 14.39
map NO
mfr_num 5977701
net_weight 0.04
non_member_discount 51
non_member_price 7.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 58851
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.89
ta_dealer_c_price 4.32
ta_price 9.35
text
array
1 58851
2 5977701
3 1, fan
timestamp 2015-03-27T14:47:34.353Z
vip_member_price 5.61

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870282
barcode_type UPC
col1 1
col1_sortorder 275
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 2.1
deal_of_the_week NO
description 1, long flat
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 82390
list_price 7.39
map NO
mfr_num 5974701
net_weight 0.08
non_member_discount 51
non_member_price 3.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 82390
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.51
ta_dealer_c_price 2.22
ta_price 4.8
text
array
1 82390
2 5974701
3 1, long flat
timestamp 2015-03-27T14:48:13.14Z
vip_member_price 2.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870367
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.1
deal_of_the_week NO
description 1, round
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 85162
list_price 7.39
map NO
mfr_num 5975701
net_weight 0.08
non_member_discount 51
non_member_price 3.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 85162
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.51
ta_dealer_c_price 2.22
ta_price 4.8
text
array
1 85162
2 5975701
3 1, round
timestamp 2015-03-27T14:48:15.556Z
vip_member_price 2.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870428
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 5.78
deal_of_the_week NO
description 10, round
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 17990
list_price 20.39
map NO
mfr_num 5975710
net_weight 0.1
non_member_discount 51
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 17990
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.93
ta_dealer_c_price 6.12
ta_price 13.25
text
array
1 17990
2 5975710
3 10, round
timestamp 2015-03-27T14:46:37.964Z
vip_member_price 7.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870220
barcode_type UPC
col1 10
col1_sortorder 692
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 5.78
deal_of_the_week NO
description 10, short flat/bright
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 23755
list_price 20.39
map NO
mfr_num 5973710
net_weight 0.1
non_member_discount 51
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 23755
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.93
ta_dealer_c_price 6.12
ta_price 13.25
text
array
1 23755
2 5973710
3 10, short flat/bright
timestamp 2015-03-27T14:46:44.997Z
vip_member_price 7.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870503
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 5.78
deal_of_the_week NO
description 10, filbert
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 49697
list_price 20.39
map NO
mfr_num 5976710
net_weight 0.06
non_member_discount 51
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 49697
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.93
ta_dealer_c_price 6.12
ta_price 13.25
text
array
1 49697
2 5976710
3 10, filbert
timestamp 2015-03-27T14:47:24.185Z
vip_member_price 7.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870343
barcode_type UPC
col1 10
col1_sortorder 692
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 5.78
deal_of_the_week NO
description 10, long flat
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 80206
list_price 20.39
map NO
mfr_num 5974710
net_weight 0.1
non_member_discount 51
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 80206
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.93
ta_dealer_c_price 6.12
ta_price 13.25
text
array
1 80206
2 5974710
3 10, long flat
timestamp 2015-03-27T14:48:10.192Z
vip_member_price 7.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870435
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 8.44
deal_of_the_week NO
description 12, round
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 18572
list_price 29.79
map NO
mfr_num 5975712
net_weight 0.1
non_member_discount 51
non_member_price 14.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 18572
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.13
ta_dealer_c_price 8.94
ta_price 19.36
text
array
1 18572
2 5975712
3 12, round
timestamp 2015-03-27T14:46:38.777Z
vip_member_price 11.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870237
barcode_type UPC
col1 12
col1_sortorder 816
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 8.44
deal_of_the_week NO
description 12, short flat/bright
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 78467
list_price 29.79
map NO
mfr_num 5973712
net_weight 0.12
non_member_discount 51
non_member_price 14.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 78467
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.13
ta_dealer_c_price 8.94
ta_price 19.36
text
array
1 78467
2 5973712
3 12, short flat/bright
timestamp 2015-03-27T14:48:08.4Z
vip_member_price 11.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870350
barcode_type UPC
col1 12
col1_sortorder 816
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 8.44
deal_of_the_week NO
description 12, long flat
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 87005
list_price 29.79
map NO
mfr_num 5974712
net_weight 0.1
non_member_discount 51
non_member_price 14.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 87005
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.13
ta_dealer_c_price 8.94
ta_price 19.36
text
array
1 87005
2 5974712
3 12, long flat
timestamp 2015-03-27T14:48:18.876Z
vip_member_price 11.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870510
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 8.44
deal_of_the_week NO
description 12, filbert
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 87291
list_price 29.79
map NO
mfr_num 5976712
net_weight 0.06
non_member_discount 51
non_member_price 14.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 87291
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.13
ta_dealer_c_price 8.94
ta_price 19.36
text
array
1 87291
2 5976712
3 12, filbert
timestamp 2015-03-27T14:48:19.274Z
vip_member_price 11.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870244
barcode_type UPC
col1 14
col1_sortorder 912
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 9.92
deal_of_the_week NO
description 14, short flat/bright
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 20439
list_price 34.99
map NO
mfr_num 5973714
net_weight 0.12
non_member_discount 51
non_member_price 17.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 20439
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.9
ta_dealer_c_price 10.5
ta_price 22.74
text
array
1 20439
2 5973714
3 14, short flat/bright
timestamp 2015-03-27T14:46:40.591Z
vip_member_price 13.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870251
barcode_type UPC
col1 16
col1_sortorder 979
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 12.76
deal_of_the_week NO
description 16, short flat/bright
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 21097
list_price 44.99
map NO
mfr_num 5973716
net_weight 0.12
non_member_discount 51
non_member_price 22.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 21097
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.3
ta_dealer_c_price 13.5
ta_price 29.24
text
array
1 21097
2 5973716
3 16, short flat/bright
timestamp 2015-03-27T14:46:41.547Z
vip_member_price 17.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870176
barcode_type UPC
col1 2
col1_sortorder 1114
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 2.29
deal_of_the_week NO
description 2, short flat/bright
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 11880
list_price 8.09
map NO
mfr_num 5973702
net_weight 0.08
non_member_discount 51
non_member_price 3.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 11880
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.75
ta_dealer_c_price 2.43
ta_price 5.26
text
array
1 11880
2 5973702
3 2, short flat/bright
timestamp 2015-03-27T14:46:26.682Z
vip_member_price 3.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870374
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.29
deal_of_the_week NO
description 2, round
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 15586
list_price 8.09
map NO
mfr_num 5975702
net_weight 0.08
non_member_discount 51
non_member_price 3.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 15586
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.75
ta_dealer_c_price 2.43
ta_price 5.26
text
array
1 15586
2 5975702
3 2, round
timestamp 2015-03-27T14:46:34.503Z
vip_member_price 3.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870459
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 2, filbert
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 38578
list_price 8.39
map NO
mfr_num 5976702
net_weight 0.05
non_member_discount 51
non_member_price 4.11
prop65 NO
ship_rule_desc STD
shipping STD
sku 38578
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.85
ta_dealer_c_price 2.52
ta_price 5.45
text
array
1 38578
2 5976702
3 2, filbert
timestamp 2015-03-27T14:47:10.729Z
vip_member_price 3.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870299
barcode_type UPC
col1 2
col1_sortorder 1114
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 2.29
deal_of_the_week NO
description 2, long flat
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 62145
list_price 8.09
map NO
mfr_num 5974702
net_weight 0.08
non_member_discount 51
non_member_price 3.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 62145
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.75
ta_dealer_c_price 2.43
ta_price 5.26
text
array
1 62145
2 5974702
3 2, long flat
timestamp 2015-03-27T14:47:41.618Z
vip_member_price 3.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870183
barcode_type UPC
col1 3
col1_sortorder 1434
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 3, short flat/bright
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 29345
list_price 8.39
map NO
mfr_num 5973703
net_weight 0.1
non_member_discount 51
non_member_price 4.11
prop65 NO
ship_rule_desc STD
shipping STD
sku 29345
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.85
ta_dealer_c_price 2.52
ta_price 5.45
text
array
1 29345
2 5973703
3 3, short flat/bright
timestamp 2015-03-27T14:46:53.256Z
vip_member_price 3.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870534
barcode_type UPC
col1 3
col1_sortorder 1434
col2 fan
col2_sortorder 198
col3 [empty string]
cost 4.9
deal_of_the_week NO
description 3, fan
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 43358
list_price 17.29
map NO
mfr_num 5977703
net_weight 0.08
non_member_discount 51
non_member_price 8.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 43358
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.19
ta_price 11.24
text
array
1 43358
2 5977703
3 3, fan
timestamp 2015-03-27T14:47:15.99Z
vip_member_price 6.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870305
barcode_type UPC
col1 3
col1_sortorder 1434
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 3, long flat
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 60115
list_price 8.39
map NO
mfr_num 5974703
net_weight 0.08
non_member_discount 51
non_member_price 4.11
prop65 NO
ship_rule_desc STD
shipping STD
sku 60115
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.85
ta_dealer_c_price 2.52
ta_price 5.45
text
array
1 60115
2 5974703
3 3, long flat
timestamp 2015-03-27T14:47:37.653Z
vip_member_price 3.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870381
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
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 70719
list_price 8.39
map NO
mfr_num 5975703
net_weight 0.08
non_member_discount 51
non_member_price 4.11
prop65 NO
ship_rule_desc STD
shipping STD
sku 70719
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.85
ta_dealer_c_price 2.52
ta_price 5.45
text
array
1 70719
2 5975703
3 3, round
timestamp 2015-03-27T14:47:57.381Z
vip_member_price 3.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870473
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, filbert
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 17711
list_price 9.39
map NO
mfr_num 5976704
net_weight 0.05
non_member_discount 51
non_member_price 4.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 17711
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.19
ta_dealer_c_price 2.82
ta_price 6.1
text
array
1 17711
2 5976704
3 4, filbert
timestamp 2015-03-27T14:46:37.74Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870398
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, round
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 47222
list_price 9.39
map NO
mfr_num 5975704
net_weight 0.08
non_member_discount 51
non_member_price 4.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 47222
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.19
ta_dealer_c_price 2.82
ta_price 6.1
text
array
1 47222
2 5975704
3 4, round
timestamp 2015-03-27T14:47:21.487Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870312
barcode_type UPC
col1 4
col1_sortorder 1724
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, long flat
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 56180
list_price 9.39
map NO
mfr_num 5974704
net_weight 0.08
non_member_discount 51
non_member_price 4.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 56180
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.19
ta_dealer_c_price 2.82
ta_price 6.1
text
array
1 56180
2 5974704
3 4, long flat
timestamp 2015-03-27T14:47:31.225Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870190
barcode_type UPC
col1 4
col1_sortorder 1724
col2 short flat/bright
col2_sortorder 463
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, short flat/bright
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 68587
list_price 9.39
map NO
mfr_num 5973704
net_weight 0.08
non_member_discount 51
non_member_price 4.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 68587
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.19
ta_dealer_c_price 2.82
ta_price 6.1
text
array
1 68587
2 5973704
3 4, short flat/bright
timestamp 2015-03-27T14:47:51.595Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870541
barcode_type UPC
col1 5
col1_sortorder 1906
col2 fan
col2_sortorder 198
col3 [empty string]
cost 5.64
deal_of_the_week NO
description 5, fan
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 34813
list_price 19.89
map NO
mfr_num 5977705
net_weight 0.08
non_member_discount 51
non_member_price 9.75
prop65 NO
ship_rule_desc STD
shipping STD
sku 34813
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.76
ta_dealer_c_price 5.97
ta_price 12.93
text
array
1 34813
2 5977705
3 5, fan
timestamp 2015-03-27T14:47:05.333Z
vip_member_price 7.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870329
barcode_type UPC
col1 6
col1_sortorder 2077
col2 long flat
col2_sortorder 285
col3 [empty string]
cost 3.4
deal_of_the_week NO
description 6, long flat
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 20449
list_price 11.99
map NO
mfr_num 5974706
net_weight 0.08
non_member_discount 51
non_member_price 5.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 20449
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.08
ta_dealer_c_price 3.6
ta_price 7.79
text
array
1 20449
2 5974706
3 6, long flat
timestamp 2015-03-27T14:46:40.598Z
vip_member_price 4.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870480
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
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 26155
list_price 11.99
map NO
mfr_num 5976706
net_weight 0.06
non_member_discount 51
non_member_price 5.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 26155
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.08
ta_dealer_c_price 3.6
ta_price 7.79
text
array
1 26155
2 5976706
3 6, filbert
timestamp 2015-03-27T14:46:48.314Z
vip_member_price 4.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030d3a5d948bd79104630531d6164142e68
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=fb~canson~&gr=canson-field-sketch-book.html
urltoken CFID=30010034&CFTOKEN=13669796&jsessionid=e030d3a5d948bd79104630531d6164142e68
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 16:20:21'}
sessionid e030e7ef6a19471501303e2c2775597f5f39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~fp~4-7~c1~brushes~&gr=winsor-newton-winton-hog-brushes.html
urltoken CFID=30010033&CFTOKEN=42897939&jsessionid=e030e7ef6a19471501303e2c2775597f5f39
validationerror [empty string]


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

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

ItemIDList: 16466,60515,60516,60517,60518,73837
AvailQtyList: 38.000000000000,11.000000000000,30.000000000000,29.000000000000,15.000000000000,37.000000000000

struct
VIP_member_discount 61
barcode 094376870404
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
flags
array
1 1
group_id 1061
group_uname winsor-newton-winton-hog-brushes
id 40117
list_price 11.99
map NO
mfr_num 5975706
net_weight 0.08
non_member_discount 51
non_member_price 5.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 40117
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.08
ta_dealer_c_price 3.6
ta_price 7.79
text
array
1 40117
2 5975706
3 6, round
timestamp 2015-03-27T14:47:12.405Z
vip_member_price 4.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 16466
2 11.000000000000 60515
3 30.000000000000 60516
4 29.000000000000 60517
5 15.000000000000 60518
6 37.000000000000 73837
CACHED false
EXECUTIONTIME 2
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] = '7355' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: