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

Monarch Brushes

by Winsor & Newton


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866032
barcode_type UPC
col1 2/0
col1_sortorder 84
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 2.83
deal_of_the_week NO
description 2/0, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 39827
list_price 9.99
map NO
mfr_num 5503020
net_weight 0.02
non_member_discount 50
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 39827
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.4
ta_dealer_c_price 3
ta_price 6.49
text
array
1 39827
2 5503020
3 2/0, round, long handle
timestamp 2015-03-31T17:53:23.726Z
vip_member_price 4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866049
barcode_type UPC
col1 0
col1_sortorder 85
col2 filbert
col2_sortorder 202
col3 long handle
col3_sortorder 3595
cost 4.11
deal_of_the_week NO
description 0, filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 31426
list_price 14.49
map NO
mfr_num 5504000
net_weight 0.02
non_member_discount 50
non_member_price 7.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 31426
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.93
ta_dealer_c_price 4.35
ta_price 9.42
text
array
1 31426
2 5504000
3 0, filbert, long handle
timestamp 2015-03-31T17:53:09.874Z
vip_member_price 5.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865875
barcode_type UPC
col1 0
col1_sortorder 85
col2 flat
col2_sortorder 209
col3 long handle
col3_sortorder 3595
cost 3.57
deal_of_the_week NO
description 0, flat, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 52300
list_price 12.59
map NO
mfr_num 5502000
net_weight 0.02
non_member_discount 50
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 52300
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.28
ta_dealer_c_price 3.78
ta_price 8.18
text
array
1 52300
2 5502000
3 0, flat, long handle
timestamp 2015-03-31T17:53:39.096Z
vip_member_price 5.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865950
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 2.98
deal_of_the_week NO
description 0, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 56702
list_price 10.49
map NO
mfr_num 5503000
net_weight 0.02
non_member_discount 50
non_member_price 5.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 56702
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.57
ta_dealer_c_price 3.15
ta_price 6.82
text
array
1 56702
2 5503000
3 0, round, long handle
timestamp 2015-03-31T17:53:50.211Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865790
barcode_type UPC
col1 0
col1_sortorder 85
col2 flat/bright
col2_sortorder 221
col3 long handle
col3_sortorder 3595
cost 3.66
deal_of_the_week NO
description 0, flat/bright, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 79273
list_price 12.89
map NO
mfr_num 5501000
net_weight 0.02
non_member_discount 50
non_member_price 6.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 79273
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.38
ta_dealer_c_price 3.87
ta_price 8.38
text
array
1 79273
2 5501000
3 0, flat/bright, long handle
timestamp 2015-03-31T17:54:32.214Z
vip_member_price 5.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376938012
barcode_type UPC
col1 1
col1_sortorder 275
col2 fan
col2_sortorder 198
col3 long handle
col3_sortorder 3595
cost 3.57
deal_of_the_week NO
description 1, fan, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 18015
list_price 12.59
map NO
mfr_num 5506001
net_weight 0.02
non_member_discount 50
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 18015
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.28
ta_dealer_c_price 3.78
ta_price 8.18
text
array
1 18015
2 5506001
3 1, fan, long handle
timestamp 2015-03-31T17:52:49.359Z
vip_member_price 5.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866209
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 glazing/ varnishing
col2_sortorder 242
col3 short handle
col3_sortorder 5424
cost 20.75
deal_of_the_week NO
description 1 in., glazing/ varnishing, short handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 28001
list_price 73.19
map NO
mfr_num 5507125
net_weight 0.05
non_member_discount 50
non_member_price 36.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 28001
sku_pix YES
supplier_id 1
ta_dealer_a_price 24.88
ta_dealer_c_price 21.96
ta_price 47.57
text
array
1 28001
2 5507125
3 1 in., glazing/ varnishing, short handle
timestamp 2015-03-31T17:53:05.174Z
vip_member_price 29.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865929
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 long handle
col3_sortorder 3595
cost 10.58
deal_of_the_week NO
description 10, flat, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 10703
list_price 37.29
map NO
mfr_num 5502010
net_weight 0.04
non_member_discount 50
non_member_price 18.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 10703
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.68
ta_dealer_c_price 11.19
ta_price 24.24
text
array
1 10703
2 5502010
3 10, flat, long handle
timestamp 2015-03-31T17:52:36.041Z
vip_member_price 14.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866001
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 8.78
deal_of_the_week NO
description 10, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 55422
list_price 30.99
map NO
mfr_num 5503010
net_weight 0.04
non_member_discount 50
non_member_price 15.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 55422
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.54
ta_dealer_c_price 9.3
ta_price 20.14
text
array
1 55422
2 5503010
3 10, round, long handle
timestamp 2015-03-31T17:53:48.536Z
vip_member_price 12.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865844
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat/bright
col2_sortorder 221
col3 long handle
col3_sortorder 3595
cost 9.72
deal_of_the_week NO
description 10, flat/bright, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 62345
list_price 34.29
map NO
mfr_num 5501010
net_weight 0.04
non_member_discount 50
non_member_price 17.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 62345
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.66
ta_dealer_c_price 10.29
ta_price 22.29
text
array
1 62345
2 5501010
3 10, flat/bright, long handle
timestamp 2015-03-31T17:54:03.268Z
vip_member_price 13.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866094
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 long handle
col3_sortorder 3595
cost 10
deal_of_the_week NO
description 10, filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 79825
list_price 35.29
map NO
mfr_num 5504010
net_weight 0.04
non_member_discount 50
non_member_price 17.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 79825
sku_pix YES
supplier_id 1
ta_dealer_a_price 12
ta_dealer_c_price 10.59
ta_price 22.94
text
array
1 79825
2 5504010
3 10, filbert, long handle
timestamp 2015-03-31T17:54:32.887Z
vip_member_price 14.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866018
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 10.35
deal_of_the_week NO
description 12, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 39975
list_price 36.49
map NO
mfr_num 5503012
net_weight 0.04
non_member_discount 50
non_member_price 18.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 39975
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.41
ta_dealer_c_price 10.95
ta_price 23.72
text
array
1 39975
2 5503012
3 12, round, long handle
timestamp 2015-03-31T17:53:23.845Z
vip_member_price 14.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865851
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat/bright
col2_sortorder 221
col3 long handle
col3_sortorder 3595
cost 11.08
deal_of_the_week NO
description 12, flat/bright, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 82336
list_price 39.09
map NO
mfr_num 5501012
net_weight 0.04
non_member_discount 50
non_member_price 19.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 82336
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.29
ta_dealer_c_price 11.73
ta_price 25.41
text
array
1 82336
2 5501012
3 12, flat/bright, long handle
timestamp 2015-03-31T17:54:36.044Z
vip_member_price 15.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865936
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 long handle
col3_sortorder 3595
cost 12.38
deal_of_the_week NO
description 12, flat, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 87352
list_price 43.69
map NO
mfr_num 5502012
net_weight 0.04
non_member_discount 50
non_member_price 21.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 87352
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.85
ta_dealer_c_price 13.11
ta_price 28.4
text
array
1 87352
2 5502012
3 12, flat, long handle
timestamp 2015-03-31T17:54:40.624Z
vip_member_price 17.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866100
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 long handle
col3_sortorder 3595
cost 11.39
deal_of_the_week NO
description 12, filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 88015
list_price 40.19
map NO
mfr_num 5504012
net_weight 0.04
non_member_discount 50
non_member_price 20.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 88015
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.66
ta_dealer_c_price 12.06
ta_price 26.12
text
array
1 88015
2 5504012
3 12, filbert, long handle
timestamp 2015-03-31T17:54:41.463Z
vip_member_price 16.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865868
barcode_type UPC
col1 14
col1_sortorder 912
col2 flat/bright
col2_sortorder 221
col3 long handle
col3_sortorder 3595
cost 12.47
deal_of_the_week NO
description 14, flat/bright, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 19265
list_price 43.99
map NO
mfr_num 5501014
net_weight 0.04
non_member_discount 50
non_member_price 21.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 19265
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.96
ta_dealer_c_price 13.2
ta_price 28.59
text
array
1 19265
2 5501014
3 14, flat/bright, long handle
timestamp 2015-03-31T17:52:51.862Z
vip_member_price 17.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866025
barcode_type UPC
col1 14
col1_sortorder 912
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 12.72
deal_of_the_week NO
description 14, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 26676
list_price 44.89
map NO
mfr_num 5503014
net_weight 0.04
non_member_discount 50
non_member_price 22.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 26676
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.26
ta_dealer_c_price 13.47
ta_price 29.18
text
array
1 26676
2 5503014
3 14, round, long handle
timestamp 2015-03-31T17:53:03.77Z
vip_member_price 17.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866117
barcode_type UPC
col1 14
col1_sortorder 912
col2 filbert
col2_sortorder 202
col3 long handle
col3_sortorder 3595
cost 14.01
deal_of_the_week NO
description 14, filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 57915
list_price 49.39
map NO
mfr_num 5504014
net_weight 0.04
non_member_discount 50
non_member_price 24.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 57915
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.79
ta_dealer_c_price 14.82
ta_price 32.1
text
array
1 57915
2 5504014
3 14, filbert, long handle
timestamp 2015-03-31T17:53:51.704Z
vip_member_price 19.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865943
barcode_type UPC
col1 14
col1_sortorder 912
col2 flat
col2_sortorder 209
col3 long handle
col3_sortorder 3595
cost 13.49
deal_of_the_week NO
description 14, flat, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 77740
list_price 47.59
map NO
mfr_num 5502014
net_weight 0.04
non_member_discount 50
non_member_price 23.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 77740
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.18
ta_dealer_c_price 14.28
ta_price 30.93
text
array
1 77740
2 5502014
3 14, flat, long handle
timestamp 2015-03-31T17:54:30.202Z
vip_member_price 19.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866179
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 long handle
col3_sortorder 3595
cost 5.64
deal_of_the_week NO
description 2, fan, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 12953
list_price 19.89
map NO
mfr_num 5506002
net_weight 0.02
non_member_discount 50
non_member_price 9.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 12953
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 12953
2 5506002
3 2, fan, long handle
timestamp 2015-03-31T17:52:39.485Z
vip_member_price 7.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865806
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat/bright
col2_sortorder 221
col3 long handle
col3_sortorder 3595
cost 4.11
deal_of_the_week NO
description 2, flat/bright, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 15132
list_price 14.49
map NO
mfr_num 5501002
net_weight 0.02
non_member_discount 50
non_member_price 7.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 15132
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.93
ta_dealer_c_price 4.35
ta_price 9.42
text
array
1 15132
2 5501002
3 2, flat/bright, long handle
timestamp 2015-03-31T17:52:45.817Z
vip_member_price 5.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865882
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 long handle
col3_sortorder 3595
cost 4.11
deal_of_the_week NO
description 2, flat, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 19901
list_price 14.49
map NO
mfr_num 5502002
net_weight 0.02
non_member_discount 50
non_member_price 7.24
prop65 NO
ship_rule_desc STD
shipping STD
sku 19901
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.93
ta_dealer_c_price 4.35
ta_price 9.42
text
array
1 19901
2 5502002
3 2, flat, long handle
timestamp 2015-03-31T17:52:52.885Z
vip_member_price 5.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866056
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 long handle
col3_sortorder 3595
cost 5.04
deal_of_the_week NO
description 2, filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 21367
list_price 17.79
map NO
mfr_num 5504002
net_weight 0.02
non_member_discount 50
non_member_price 8.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 21367
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.05
ta_dealer_c_price 5.34
ta_price 11.56
text
array
1 21367
2 5504002
3 2, filbert, long handle
timestamp 2015-03-31T17:52:55.866Z
vip_member_price 7.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866124
barcode_type UPC
col1 2
col1_sortorder 1114
col2 short filbert
col2_sortorder 462
col3 long handle
col3_sortorder 3595
cost 5.04
deal_of_the_week NO
description 2, short filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 35992
list_price 17.79
map NO
mfr_num 5505002
net_weight 0.04
non_member_discount 50
non_member_price 8.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 35992
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.05
ta_dealer_c_price 5.34
ta_price 11.56
text
array
1 35992
2 5505002
3 2, short filbert, long handle
timestamp 2015-03-31T17:53:18.765Z
vip_member_price 7.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865967
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 3.57
deal_of_the_week NO
description 2, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 70918
list_price 12.59
map NO
mfr_num 5503002
net_weight 0.02
non_member_discount 50
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 70918
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.28
ta_dealer_c_price 3.78
ta_price 8.18
text
array
1 70918
2 5503002
3 2, round, long handle
timestamp 2015-03-31T17:54:19.838Z
vip_member_price 5.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865974
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 4.31
deal_of_the_week NO
description 4, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 35303
list_price 15.19
map NO
mfr_num 5503004
net_weight 0.02
non_member_discount 50
non_member_price 7.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 35303
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.16
ta_dealer_c_price 4.56
ta_price 9.87
text
array
1 35303
2 5503004
3 4, round, long handle
timestamp 2015-03-31T17:53:17.482Z
vip_member_price 6.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865813
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat/bright
col2_sortorder 221
col3 long handle
col3_sortorder 3595
cost 5.19
deal_of_the_week NO
description 4, flat/bright, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 39995
list_price 18.29
map NO
mfr_num 5501004
net_weight 0.02
non_member_discount 50
non_member_price 9.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 39995
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.22
ta_dealer_c_price 5.49
ta_price 11.89
text
array
1 39995
2 5501004
3 4, flat/bright, long handle
timestamp 2015-03-31T17:53:23.855Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866063
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 long handle
col3_sortorder 3595
cost 6.17
deal_of_the_week NO
description 4, filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 45751
list_price 21.79
map NO
mfr_num 5504004
net_weight 0.02
non_member_discount 50
non_member_price 10.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 45751
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.41
ta_dealer_c_price 6.54
ta_price 14.16
text
array
1 45751
2 5504004
3 4, filbert, long handle
timestamp 2015-03-31T17:53:31.202Z
vip_member_price 8.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866186
barcode_type UPC
col1 4
col1_sortorder 1724
col2 fan
col2_sortorder 198
col3 long handle
col3_sortorder 3595
cost 7.73
deal_of_the_week NO
description 4, fan, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 50923
list_price 27.29
map NO
mfr_num 5506004
net_weight 0.02
non_member_discount 50
non_member_price 13.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 50923
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.28
ta_dealer_c_price 8.19
ta_price 17.74
text
array
1 50923
2 5506004
3 4, fan, long handle
timestamp 2015-03-31T17:53:37.574Z
vip_member_price 10.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376866131
barcode_type UPC
col1 4
col1_sortorder 1724
col2 short filbert
col2_sortorder 462
col3 long handle
col3_sortorder 3595
cost 6.17
deal_of_the_week NO
description 4, short filbert, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 59345
list_price 21.79
map NO
mfr_num 5505004
net_weight 0.04
non_member_discount 50
non_member_price 10.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 59345
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.41
ta_dealer_c_price 6.54
ta_price 14.16
text
array
1 59345
2 5505004
3 4, short filbert, long handle
timestamp 2015-03-31T17:53:53.282Z
vip_member_price 8.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865899
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 long handle
col3_sortorder 3595
cost 5.19
deal_of_the_week NO
description 4, flat, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 81944
list_price 18.29
map NO
mfr_num 5502004
net_weight 0.02
non_member_discount 50
non_member_price 9.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 81944
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.22
ta_dealer_c_price 5.49
ta_price 11.89
text
array
1 81944
2 5502004
3 4, flat, long handle
timestamp 2015-03-31T17:54:35.32Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 60
barcode 094376865981
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 long handle
col3_sortorder 3595
cost 5.01
deal_of_the_week NO
description 6, round, long handle
group_id 3702
group_uname winsor-newton-monarch-brushes
id 28654
list_price 17.69
map NO
mfr_num 5503006
net_weight 0.02
non_member_discount 50
non_member_price 8.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 28654
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.01
ta_dealer_c_price 5.31
ta_price 11.5
text
array
1 28654
2 5503006
3 6, round, long handle
timestamp 2015-03-31T17:53:05.825Z
vip_member_price 7.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 1
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] = '5087' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0307ccfd4cb52b7434413514956483d5365
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=airbrushing&catB=fp~119-324~&gr=iwata-sprint-jet-compressor.html
urltoken CFID=30621104&CFTOKEN=77838970&jsessionid=e0307ccfd4cb52b7434413514956483d5365
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 21:12:27'}
sessionid e0305f64292392251f307e57c918341a1934
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~4-6~&gr=winsor-newton-monarch-brushes.html
urltoken CFID=30621105&CFTOKEN=16801233&jsessionid=e0305f64292392251f307e57c918341a1934
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList: