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

Ruby Satin Series Synthetic Brushes Short Handle

by Silver Brush


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179250938
barcode_type UPC
col1 3/0
col1_sortorder 83
col2 round
col2_sortorder 434
col3 2500S
col3_sortorder 108
cost 2.61
deal_of_the_week NO
description 3/0, round, 2500S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 65770
list_price 8.55
map NO
mfr_num 2500S-3/0
net_weight 0.01
non_member_discount 50
non_member_price 4.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 65770
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.91
ta_dealer_c_price 2.91
ta_price 5.13
text
array
1 65770
2 2500S-3/0
3 3/0, round, 2500S
timestamp 2015-03-30T16:21:08.79Z
vip_member_price 3.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179272923
barcode_type UPC
col1 2/0
col1_sortorder 84
col2 liner
col2_sortorder 282
col3 2522S
col3_sortorder 118
cost 2.57
deal_of_the_week NO
description 2/0, liner, 2522S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 67985
list_price 8.45
map NO
mfr_num 2522S-2/0
net_weight 0.01
non_member_discount 50
non_member_price 4.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 67985
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.87
ta_price 5.07
text
array
1 67985
2 2522S-2/0
3 2/0, liner, 2522S
timestamp 2015-03-30T16:21:15.484Z
vip_member_price 3.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179250921
barcode_type UPC
col1 2/0
col1_sortorder 84
col2 round
col2_sortorder 434
col3 2500S
col3_sortorder 108
cost 2.67
deal_of_the_week NO
description 2/0, round, 2500S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 74227
list_price 8.75
map NO
mfr_num 2500S-2/0
net_weight 0.01
non_member_discount 50
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 74227
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.98
ta_dealer_c_price 2.98
ta_price 5.25
text
array
1 74227
2 2500S-2/0
3 2/0, round, 2500S
timestamp 2015-03-30T16:21:38.56Z
vip_member_price 3.5

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179250501
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 2500S
col3_sortorder 108
cost 2.73
deal_of_the_week NO
description 0, round, 2500S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 26295
list_price 8.95
map NO
mfr_num 2500S-0
net_weight 0.01
non_member_discount 50
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 26295
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.04
ta_dealer_c_price 3.04
ta_price 5.37
text
array
1 26295
2 2500S-0
3 0, round, 2500S
timestamp 2015-03-30T16:19:50.169Z
vip_member_price 3.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179272503
barcode_type UPC
col1 0
col1_sortorder 85
col2 liner
col2_sortorder 282
col3 2522S
col3_sortorder 118
cost 2.7
deal_of_the_week NO
description 0, liner, 2522S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 29418
list_price 8.85
map NO
mfr_num 2522S-0
net_weight 0.02
non_member_discount 50
non_member_price 4.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 29418
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.01
ta_dealer_c_price 3.01
ta_price 5.31
text
array
1 29418
2 2522S-0
3 0, liner, 2522S
timestamp 2015-03-30T16:19:55.642Z
vip_member_price 3.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179253502
barcode_type UPC
col1 0
col1_sortorder 85
col2 filbert
col2_sortorder 202
col3 2503S
col3_sortorder 113
cost 2.92
deal_of_the_week NO
description 0, filbert, 2503S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 42460
list_price 9.55
map NO
mfr_num 2503S-0
net_weight 0.01
non_member_discount 50
non_member_price 4.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 42460
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.25
ta_dealer_c_price 3.25
ta_price 5.73
text
array
1 42460
2 2503S-0
3 0, filbert, 2503S
timestamp 2015-03-30T16:20:26.603Z
vip_member_price 3.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179252505
barcode_type UPC
col1 0
col1_sortorder 85
col2 bright
col2_sortorder 112
col3 2502S
col3_sortorder 111
cost 2.7
deal_of_the_week NO
description 0, bright, 2502S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 68769
list_price 8.85
map NO
mfr_num 2502S-0
net_weight 0.01
non_member_discount 50
non_member_price 4.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 68769
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.01
ta_dealer_c_price 3.01
ta_price 5.31
text
array
1 68769
2 2502S-0
3 0, bright, 2502S
timestamp 2015-03-30T16:21:17.282Z
vip_member_price 3.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179272510
barcode_type UPC
col1 1
col1_sortorder 275
col2 liner
col2_sortorder 282
col3 2522S
col3_sortorder 118
cost 2.78
deal_of_the_week NO
description 1, liner, 2522S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 21785
list_price 9.1
map NO
mfr_num 2522S-1
net_weight 0.02
non_member_discount 50
non_member_price 4.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 21785
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.09
ta_dealer_c_price 3.09
ta_price 5.46
text
array
1 21785
2 2522S-1
3 1, liner, 2522S
timestamp 2015-03-30T16:19:42.217Z
vip_member_price 3.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179250518
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 2500S
col3_sortorder 108
cost 2.76
deal_of_the_week NO
description 1, round, 2500S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 69407
list_price 9.05
map NO
mfr_num 2500S-1
net_weight 0.02
non_member_discount 50
non_member_price 4.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 69407
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.08
ta_dealer_c_price 3.08
ta_price 5.43
text
array
1 69407
2 2500S-1
3 1, round, 2500S
timestamp 2015-03-30T16:21:20.546Z
vip_member_price 3.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179253519
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 2503S
col3_sortorder 113
cost 3.04
deal_of_the_week NO
description 1, filbert, 2503S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 87980
list_price 9.95
map NO
mfr_num 2503S-1
net_weight 0.01
non_member_discount 50
non_member_price 4.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 87980
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 5.97
text
array
1 87980
2 2503S-1
3 1, filbert, 2503S
timestamp 2015-03-30T16:21:59.676Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179256534
barcode_type UPC
col1 3/8 in.
col1_sortorder 358
col2 angular
col2_sortorder 77
col3 2506S
col3_sortorder 114
cost 4.09
deal_of_the_week NO
description 3/8 in., angular, 2506S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 37771
list_price 13.4
map NO
mfr_num 2506S-3/8
net_weight 0.01
non_member_discount 50
non_member_price 6.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 37771
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.56
ta_dealer_c_price 4.56
ta_price 8.04
text
array
1 37771
2 2506S-3/8
3 3/8 in., angular, 2506S
timestamp 2015-03-30T16:20:19.874Z
vip_member_price 5.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179278536
barcode_type UPC
col1 3/8 in.
col1_sortorder 358
col2 grass comb
col2_sortorder 244
col3 2528S
col3_sortorder 119
cost 5.87
deal_of_the_week NO
description 3/8 in., grass comb, 2528S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 63765
list_price 19.25
map NO
mfr_num 2528S-3/8
net_weight 0.03
non_member_discount 50
non_member_price 9.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 63765
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.55
ta_dealer_c_price 6.55
ta_price 11.55
text
array
1 63765
2 2528S-3/8
3 3/8 in., grass comb, 2528S
timestamp 2015-03-30T16:21:05.106Z
vip_member_price 7.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179262535
barcode_type UPC
col1 3/8 in.
col1_sortorder 358
col2 dagger striper
col2_sortorder 163
col3 2512S
col3_sortorder 116
cost 5.73
deal_of_the_week NO
description 3/8 in., dagger striper, 2512S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 65528
list_price 18.8
map NO
mfr_num 2512S-3/8
net_weight 0.02
non_member_discount 50
non_member_price 9.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 65528
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.39
ta_dealer_c_price 6.39
ta_price 11.28
text
array
1 65528
2 2512S-3/8
3 3/8 in., dagger striper, 2512S
timestamp 2015-03-30T16:21:08.434Z
vip_member_price 7.52

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179256541
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 angular
col2_sortorder 77
col3 2506S
col3_sortorder 114
cost 5.12
deal_of_the_week NO
description 1/2 in., angular, 2506S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 13385
list_price 16.8
map NO
mfr_num 2506S-1/2
net_weight 0.02
non_member_discount 50
non_member_price 8.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 13385
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.71
ta_dealer_c_price 5.71
ta_price 10.08
text
array
1 13385
2 2506S-1/2
3 1/2 in., angular, 2506S
timestamp 2015-03-30T16:19:20.381Z
vip_member_price 6.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179262542
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 dagger striper
col2_sortorder 163
col3 2512S
col3_sortorder 116
cost 6.64
deal_of_the_week NO
description 1/2 in., dagger striper, 2512S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 58704
list_price 21.75
map NO
mfr_num 2512S-1/2
net_weight 0.02
non_member_discount 50
non_member_price 10.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 58704
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.4
ta_dealer_c_price 7.4
ta_price 13.05
text
array
1 58704
2 2512S-1/2
3 1/2 in., dagger striper, 2512S
timestamp 2015-03-30T16:20:51.221Z
vip_member_price 8.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179278543
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 grass comb
col2_sortorder 244
col3 2528S
col3_sortorder 119
cost 6.82
deal_of_the_week NO
description 1/2 in., grass comb, 2528S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 63470
list_price 22.35
map NO
mfr_num 2528S-1/2
net_weight 0.04
non_member_discount 50
non_member_price 11.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 63470
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.6
ta_dealer_c_price 7.6
ta_price 13.41
text
array
1 63470
2 2528S-1/2
3 1/2 in., grass comb, 2528S
timestamp 2015-03-30T16:21:04.462Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179278567
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 grass comb
col2_sortorder 244
col3 2528S
col3_sortorder 119
cost 9.08
deal_of_the_week NO
description 3/4 in., grass comb, 2528S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 39936
list_price 29.75
map NO
mfr_num 2528S-3/4
net_weight 0.04
non_member_discount 50
non_member_price 14.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 39936
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.12
ta_dealer_c_price 10.12
ta_price 17.85
text
array
1 39936
2 2528S-3/4
3 3/4 in., grass comb, 2528S
timestamp 2015-03-30T16:20:23.546Z
vip_member_price 11.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179256565
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 angular
col2_sortorder 77
col3 2506S
col3_sortorder 114
cost 7.92
deal_of_the_week NO
description 3/4 in., angular, 2506S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 88204
list_price 25.95
map NO
mfr_num 2506S-3/4
net_weight 0.02
non_member_discount 50
non_member_price 12.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 88204
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.82
ta_dealer_c_price 8.82
ta_price 15.57
text
array
1 88204
2 2506S-3/4
3 3/4 in., angular, 2506S
timestamp 2015-03-30T16:22:00.525Z
vip_member_price 10.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179261583
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 stroke
col2_sortorder 502
col3 2511S
col3_sortorder 115
cost 9.65
deal_of_the_week NO
description 1 in., stroke, 2511S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 31584
list_price 31.65
map NO
mfr_num 2511S-1
net_weight 0.04
non_member_discount 50
non_member_price 15.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 31584
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.76
ta_dealer_c_price 10.76
ta_price 18.99
text
array
1 31584
2 2511S-1
3 1 in., stroke, 2511S
timestamp 2015-03-30T16:20:01.208Z
vip_member_price 12.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179278512
barcode_type UPC
col1 1/8 in.
col1_sortorder 506
col2 grass comb
col2_sortorder 244
col3 2528S
col3_sortorder 119
cost 4.5
deal_of_the_week NO
description 1/8 in., grass comb, 2528S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 72422
list_price 14.75
map NO
mfr_num 2528S-1/8
net_weight 0.03
non_member_discount 50
non_member_price 7.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 72422
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.02
ta_dealer_c_price 5.02
ta_price 8.85
text
array
1 72422
2 2528S-1/8
3 1/8 in., grass comb, 2528S
timestamp 2015-03-30T16:21:34.993Z
vip_member_price 5.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179278529
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 grass comb
col2_sortorder 244
col3 2528S
col3_sortorder 119
cost 5.05
deal_of_the_week NO
description 1/4 in., grass comb, 2528S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 44864
list_price 16.55
map NO
mfr_num 2528S-1/4
net_weight 0.03
non_member_discount 50
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 44864
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.63
ta_dealer_c_price 5.63
ta_price 9.93
text
array
1 44864
2 2528S-1/4
3 1/4 in., grass comb, 2528S
timestamp 2015-03-30T16:20:29.755Z
vip_member_price 6.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179256527
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 angular
col2_sortorder 77
col3 2506S
col3_sortorder 114
cost 3.59
deal_of_the_week NO
description 1/4 in., angular, 2506S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 80512
list_price 11.75
map NO
mfr_num 2506S-1/4
net_weight 0.01
non_member_discount 50
non_member_price 5.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 80512
sku_pix YES
supplier_id 1
ta_dealer_a_price 4
ta_dealer_c_price 4
ta_price 7.05
text
array
1 80512
2 2506S-1/4
3 1/4 in., angular, 2506S
timestamp 2015-03-30T16:21:46.329Z
vip_member_price 4.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179252604
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 2502S
col3_sortorder 111
cost 4.62
deal_of_the_week NO
description 10, bright, 2502S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 56756
list_price 15.15
map NO
mfr_num 2502S-10
net_weight 0.02
non_member_discount 50
non_member_price 7.58
prop65 NO
ship_rule_desc STD
shipping STD
sku 56756
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.15
ta_dealer_c_price 5.15
ta_price 9.09
text
array
1 56756
2 2502S-10
3 10, bright, 2502S
timestamp 2015-03-30T16:20:48.861Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179253601
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 2503S
col3_sortorder 113
cost 4.89
deal_of_the_week NO
description 10, filbert, 2503S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 56775
list_price 16.05
map NO
mfr_num 2503S-10
net_weight 0.02
non_member_discount 50
non_member_price 8.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 56775
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.46
ta_dealer_c_price 5.46
ta_price 9.63
text
array
1 56775
2 2503S-10
3 10, filbert, 2503S
timestamp 2015-03-30T16:20:48.888Z
vip_member_price 6.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179250600
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 2500S
col3_sortorder 108
cost 5.28
deal_of_the_week NO
description 10, round, 2500S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 89552
list_price 17.3
map NO
mfr_num 2500S-10
net_weight 0.02
non_member_discount 50
non_member_price 8.65
prop65 NO
ship_rule_desc STD
shipping STD
sku 89552
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 10.38
text
array
1 89552
2 2500S-10
3 10, round, 2500S
timestamp 2015-03-30T16:22:02.474Z
vip_member_price 6.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179252628
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 2502S
col3_sortorder 111
cost 5.29
deal_of_the_week NO
description 12, bright, 2502S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 45255
list_price 17.35
map NO
mfr_num 2502S-12
net_weight 0.02
non_member_discount 50
non_member_price 8.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 45255
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.9
ta_dealer_c_price 5.9
ta_price 10.41
text
array
1 45255
2 2502S-12
3 12, bright, 2502S
timestamp 2015-03-30T16:20:30.483Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179252529
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 2502S
col3_sortorder 111
cost 3.04
deal_of_the_week NO
description 2, bright, 2502S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 12769
list_price 9.95
map NO
mfr_num 2502S-2
net_weight 0.01
non_member_discount 50
non_member_price 4.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 12769
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 5.97
text
array
1 12769
2 2502S-2
3 2, bright, 2502S
timestamp 2015-03-30T16:19:19.181Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179272527
barcode_type UPC
col1 2
col1_sortorder 1114
col2 liner
col2_sortorder 282
col3 2522S
col3_sortorder 118
cost 2.82
deal_of_the_week NO
description 2, liner, 2522S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 77614
list_price 9.25
map NO
mfr_num 2522S-2
net_weight 0.02
non_member_discount 50
non_member_price 4.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 77614
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 3.15
ta_price 5.55
text
array
1 77614
2 2522S-2
3 2, liner, 2522S
timestamp 2015-03-30T16:21:42.627Z
vip_member_price 3.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179250525
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 2500S
col3_sortorder 108
cost 2.85
deal_of_the_week NO
description 2, round, 2500S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 84521
list_price 9.35
map NO
mfr_num 2500S-2
net_weight 0.02
non_member_discount 50
non_member_price 4.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 84521
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.18
ta_dealer_c_price 3.18
ta_price 5.61
text
array
1 84521
2 2500S-2
3 2, round, 2500S
timestamp 2015-03-30T16:21:53.285Z
vip_member_price 3.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179253526
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 2503S
col3_sortorder 113
cost 3.11
deal_of_the_week NO
description 2, filbert, 2503S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 89141
list_price 10.2
map NO
mfr_num 2503S-2
net_weight 0.01
non_member_discount 50
non_member_price 5.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 89141
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.47
ta_dealer_c_price 3.47
ta_price 6.12
text
array
1 89141
2 2503S-2
3 2, filbert, 2503S
timestamp 2015-03-30T16:22:02.236Z
vip_member_price 4.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179272541
barcode_type UPC
col1 4
col1_sortorder 1724
col2 liner
col2_sortorder 282
col3 2522S
col3_sortorder 118
cost 3
deal_of_the_week NO
description 4, liner, 2522S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 28933
list_price 9.85
map NO
mfr_num 2522S-4
net_weight 0.02
non_member_discount 50
non_member_price 4.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 28933
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.35
ta_dealer_c_price 3.35
ta_price 5.91
text
array
1 28933
2 2522S-4
3 4, liner, 2522S
timestamp 2015-03-30T16:19:54.377Z
vip_member_price 3.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' 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.21.95

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e0305036b33c9f78fb462f26761f3d3f5b2f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=spray-adhesives&CatC=sort~1~fp~2-9~&gr=3m-photomount-spray-adhesive.html
urltoken CFID=30256691&CFTOKEN=71230121&jsessionid=e0305036b33c9f78fb462f26761f3d3f5b2f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 13:25:12'}
sessionid e030a216609dd3da002b1e5ed5a77257d919
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=round&CatD=fb~silver-brush~fp~5-7~&gr=silver-brush-ruby-satin-series-synthetic-brushes-short-handle.html
urltoken CFID=30256692&CFTOKEN=96258419&jsessionid=e030a216609dd3da002b1e5ed5a77257d919
validationerror [empty string]


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

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

ItemIDList: 49436,77622
AvailQtyList: 28.000000000000,38.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 765179252543
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 2502S
col3_sortorder 111
cost 3.31
deal_of_the_week NO
description 4, bright, 2502S
group_id 328
group_uname silver-brush-ruby-satin-series-synthetic-brushes-short-handle
id 47256
list_price 10.85
map NO
mfr_num 2502S-4
net_weight 0.02
non_member_discount 50
non_member_price 5.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 47256
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.69
ta_dealer_c_price 3.69
ta_price 6.51
text
array
1 47256
2 2502S-4
3 4, bright, 2502S
timestamp 2015-03-30T16:20:32.901Z
vip_member_price 4.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 28.000000000000 49436
2 38.000000000000 77622
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] = '177' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: