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

Series 5400 Natural Bristle Oil & Acrylic Brushes

by Princeton


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544353
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.23
deal_of_the_week NO
description 1, round
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62969
list_price 7.25
map NO
mfr_num 5400R-1
net_weight 0.01
non_member_discount 44
non_member_price 4.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 62969
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.61
ta_dealer_c_price 2.47
ta_price 4.72
text
array
1 62969
2 5400R-1
3 1, round
timestamp 2015-04-01T21:26:46.658Z
vip_member_price 3.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544339
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.2
deal_of_the_week NO
description 1, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62979
list_price 7.15
map NO
mfr_num 5400F-1
net_weight 0.01
non_member_discount 44
non_member_price 3.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 62979
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.57
ta_dealer_c_price 2.43
ta_price 4.65
text
array
1 62979
2 5400F-1
3 1, flat
timestamp 2015-04-01T21:26:46.683Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544315
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.2
deal_of_the_week NO
description 1, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62994
list_price 7.15
map NO
mfr_num 5400B-1
net_weight 0.01
non_member_discount 44
non_member_price 3.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 62994
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.57
ta_dealer_c_price 2.43
ta_price 4.65
text
array
1 62994
2 5400B-1
3 1, bright
timestamp 2015-04-01T21:26:46.707Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544155
barcode_type UPC
col1 10
col1_sortorder 692
col2 angle bright
col2_sortorder 70
col3 [empty string]
cost 4.72
deal_of_the_week NO
description 10, angle bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59282
list_price 15.35
map NO
mfr_num 5400AB-10
net_weight 0.05
non_member_discount 44
non_member_price 8.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 59282
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.53
ta_dealer_c_price 5.22
ta_price 9.98
text
array
1 59282
2 5400AB-10
3 10, angle bright
timestamp 2015-04-01T21:26:38.823Z
vip_member_price 7.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544223
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 4.77
deal_of_the_week NO
description 10, filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59292
list_price 15.5
map NO
mfr_num 5400FB-10
net_weight 0.06
non_member_discount 44
non_member_price 8.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 59292
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.58
ta_dealer_c_price 5.27
ta_price 10.08
text
array
1 59292
2 5400FB-10
3 10, filbert
timestamp 2015-04-01T21:26:38.837Z
vip_member_price 7.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544377
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 4.29
deal_of_the_week NO
description 10, round
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62960
list_price 13.95
map NO
mfr_num 5400R-10
net_weight 0.05
non_member_discount 44
non_member_price 7.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 62960
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.02
ta_dealer_c_price 4.74
ta_price 9.07
text
array
1 62960
2 5400R-10
3 10, round
timestamp 2015-04-01T21:26:46.643Z
vip_member_price 6.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544162
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 [empty string]
cost 4.77
deal_of_the_week NO
description 10, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62974
list_price 15.5
map NO
mfr_num 5400F-10
net_weight 0.06
non_member_discount 44
non_member_price 8.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 62974
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.58
ta_dealer_c_price 5.27
ta_price 10.08
text
array
1 62974
2 5400F-10
3 10, flat
timestamp 2015-04-01T21:26:46.672Z
vip_member_price 7.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544148
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 [empty string]
cost 4.77
deal_of_the_week NO
description 10, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62987
list_price 15.5
map NO
mfr_num 5400B-10
net_weight 0.06
non_member_discount 44
non_member_price 8.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 62987
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.58
ta_dealer_c_price 5.27
ta_price 10.08
text
array
1 62987
2 5400B-10
3 10, bright
timestamp 2015-04-01T21:26:46.697Z
vip_member_price 7.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544209
barcode_type UPC
col1 12
col1_sortorder 816
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3.54
deal_of_the_week NO
description 12, fan
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59279
list_price 11.5
map NO
mfr_num 5400FN-12
net_weight 0.05
non_member_discount 44
non_member_price 6.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 59279
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.14
ta_dealer_c_price 3.91
ta_price 7.47
text
array
1 59279
2 5400FN-12
3 12, fan
timestamp 2015-04-01T21:26:38.819Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544247
barcode_type UPC
col1 12
col1_sortorder 816
col2 eggbert
col2_sortorder 193
col3 [empty string]
cost 5.95
deal_of_the_week NO
description 12, eggbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59283
list_price 19.35
map NO
mfr_num 5400EG-12
net_weight 0.1
non_member_discount 44
non_member_price 10.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 59283
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.97
ta_dealer_c_price 6.58
ta_price 12.58
text
array
1 59283
2 5400EG-12
3 12, eggbert
timestamp 2015-04-01T21:26:38.825Z
vip_member_price 8.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544414
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 5.61
deal_of_the_week NO
description 12, filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59289
list_price 18.25
map NO
mfr_num 5400FB-12
net_weight 0.09
non_member_discount 44
non_member_price 10.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 59289
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.57
ta_dealer_c_price 6.21
ta_price 11.87
text
array
1 59289
2 5400FB-12
3 12, filbert
timestamp 2015-04-01T21:26:38.835Z
vip_member_price 8.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544445
barcode_type UPC
col1 12
col1_sortorder 816
col2 short filbert
col2_sortorder 462
col3 [empty string]
cost 5.61
deal_of_the_week NO
description 12, short filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59298
list_price 18.25
map NO
mfr_num 5400SFB-12
net_weight 0.09
non_member_discount 44
non_member_price 10.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 59298
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.57
ta_dealer_c_price 6.21
ta_price 11.87
text
array
1 59298
2 5400SFB-12
3 12, short filbert
timestamp 2015-04-01T21:26:38.849Z
vip_member_price 8.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544186
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 4.77
deal_of_the_week NO
description 12, round
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62959
list_price 15.5
map NO
mfr_num 5400R-12
net_weight 0.07
non_member_discount 44
non_member_price 8.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 62959
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.58
ta_dealer_c_price 5.27
ta_price 10.08
text
array
1 62959
2 5400R-12
3 12, round
timestamp 2015-04-01T21:26:46.641Z
vip_member_price 7.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544216
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 5.61
deal_of_the_week NO
description 12, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62973
list_price 18.25
map NO
mfr_num 5400F-12
net_weight 0.09
non_member_discount 44
non_member_price 10.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 62973
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.57
ta_dealer_c_price 6.21
ta_price 11.87
text
array
1 62973
2 5400F-12
3 12, flat
timestamp 2015-04-01T21:26:46.668Z
vip_member_price 8.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544230
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 [empty string]
cost 5.61
deal_of_the_week NO
description 12, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62983
list_price 18.25
map NO
mfr_num 5400B-12
net_weight 0.08
non_member_discount 44
non_member_price 10.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 62983
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.57
ta_dealer_c_price 6.21
ta_price 11.88
text
array
1 62983
2 5400B-12
3 12, bright
timestamp 2015-04-01T21:26:46.691Z
vip_member_price 8.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544278
barcode_type UPC
col1 16
col1_sortorder 979
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 6.92
deal_of_the_week NO
description 16, filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59287
list_price 22.5
map NO
mfr_num 5400FB-16
net_weight 0.13
non_member_discount 44
non_member_price 12.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 59287
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.1
ta_dealer_c_price 7.65
ta_price 14.63
text
array
1 59287
2 5400FB-16
3 16, filbert
timestamp 2015-04-01T21:26:38.833Z
vip_member_price 10.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 757063544193
barcode_type UPC
col1 16
col1_sortorder 979
col2 round
col2_sortorder 434
col3 [empty string]
cost 6.87
deal_of_the_week NO
description 16, round
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62958
list_price 22.35
map NO
mfr_num 5400R-16
net_weight 0.09
non_member_discount 41
non_member_price 12.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 62958
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.05
ta_dealer_c_price 7.6
ta_price 14.53
text
array
1 62958
2 5400R-16
3 16, round
timestamp 2015-04-01T21:26:46.639Z
vip_member_price 10.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544285
barcode_type UPC
col1 16
col1_sortorder 979
col2 flat
col2_sortorder 209
col3 [empty string]
cost 6.92
deal_of_the_week NO
description 16, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62972
list_price 22.5
map NO
mfr_num 5400F-16
net_weight 0.12
non_member_discount 44
non_member_price 12.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 62972
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.1
ta_dealer_c_price 7.65
ta_price 14.63
text
array
1 62972
2 5400F-16
3 16, flat
timestamp 2015-04-01T21:26:46.664Z
vip_member_price 10.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544261
barcode_type UPC
col1 16
col1_sortorder 979
col2 bright
col2_sortorder 112
col3 [empty string]
cost 6.92
deal_of_the_week NO
description 16, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62981
list_price 22.5
map NO
mfr_num 5400B-16
net_weight 0.13
non_member_discount 44
non_member_price 12.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 62981
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.1
ta_dealer_c_price 7.65
ta_price 14.64
text
array
1 62981
2 5400B-16
3 16, bright
timestamp 2015-04-01T21:26:46.687Z
vip_member_price 10.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544384
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 2, filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59297
list_price 7.75
map NO
mfr_num 5400FB-2
net_weight 0.02
non_member_discount 44
non_member_price 4.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 59297
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.79
ta_dealer_c_price 2.64
ta_price 5.03
text
array
1 59297
2 5400FB-2
3 2, filbert
timestamp 2015-04-01T21:26:38.847Z
vip_member_price 3.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544049
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 2, round
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62968
list_price 7.75
map NO
mfr_num 5400R-2
net_weight 0.02
non_member_discount 44
non_member_price 4.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 62968
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.79
ta_dealer_c_price 2.64
ta_price 5.04
text
array
1 62968
2 5400R-2
3 2, round
timestamp 2015-04-01T21:26:46.653Z
vip_member_price 3.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544346
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 2, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62978
list_price 7.75
map NO
mfr_num 5400F-2
net_weight 0.01
non_member_discount 44
non_member_price 4.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 62978
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.79
ta_dealer_c_price 2.64
ta_price 5.03
text
array
1 62978
2 5400F-2
3 2, flat
timestamp 2015-04-01T21:26:46.681Z
vip_member_price 3.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544018
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.38
deal_of_the_week NO
description 2, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62993
list_price 7.75
map NO
mfr_num 5400B-2
net_weight 0.02
non_member_discount 44
non_member_price 4.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 62993
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.79
ta_dealer_c_price 2.64
ta_price 5.04
text
array
1 62993
2 5400B-2
3 2, bright
timestamp 2015-04-01T21:26:46.705Z
vip_member_price 3.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544421
barcode_type UPC
col1 20
col1_sortorder 1248
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 11.76
deal_of_the_week NO
description 20, filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59285
list_price 38.25
map NO
mfr_num 5400FB-20
net_weight 0.2
non_member_discount 44
non_member_price 21.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 59285
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.77
ta_dealer_c_price 13.01
ta_price 24.87
text
array
1 59285
2 5400FB-20
3 20, filbert
timestamp 2015-04-01T21:26:38.829Z
vip_member_price 17.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544292
barcode_type UPC
col1 20
col1_sortorder 1248
col2 flat
col2_sortorder 209
col3 [empty string]
cost 11.76
deal_of_the_week NO
description 20, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62971
list_price 38.25
map NO
mfr_num 5400F-20
net_weight 0.19
non_member_discount 44
non_member_price 21.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 62971
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.77
ta_dealer_c_price 13.01
ta_price 24.87
text
array
1 62971
2 5400F-20
3 20, flat
timestamp 2015-04-01T21:26:46.662Z
vip_member_price 17.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544254
barcode_type UPC
col1 20
col1_sortorder 1248
col2 bright
col2_sortorder 112
col3 [empty string]
cost 11.46
deal_of_the_week NO
description 20, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62980
list_price 37.25
map NO
mfr_num 5400B-20
net_weight 0.19
non_member_discount 44
non_member_price 20.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 62980
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.41
ta_dealer_c_price 12.67
ta_price 24.23
text
array
1 62980
2 5400B-20
3 20, bright
timestamp 2015-04-01T21:26:46.685Z
vip_member_price 17.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544308
barcode_type UPC
col1 24
col1_sortorder 1328
col2 flat
col2_sortorder 209
col3 [empty string]
cost 15.36
deal_of_the_week NO
description 24, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62970
list_price 49.95
map NO
mfr_num 5400F-24
net_weight 0.3
non_member_discount 44
non_member_price 27.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 62970
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.98
ta_dealer_c_price 16.98
ta_price 32.48
text
array
1 62970
2 5400F-24
3 24, flat
timestamp 2015-04-01T21:26:46.66Z
vip_member_price 22.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544391
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 59296
list_price 8.65
map NO
mfr_num 5400FB-4
net_weight 0.02
non_member_discount 44
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 59296
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.11
ta_dealer_c_price 2.94
ta_price 5.62
text
array
1 59296
2 5400FB-4
3 4, filbert
timestamp 2015-04-01T21:26:38.845Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544032
barcode_type UPC
col1 4
col1_sortorder 1724
col2 short filbert
col2_sortorder 462
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, short filbert
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62956
list_price 8.65
map NO
mfr_num 5400SFB-4
net_weight 0.02
non_member_discount 44
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 62956
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.11
ta_dealer_c_price 2.94
ta_price 5.62
text
array
1 62956
2 5400SFB-4
3 4, short filbert
timestamp 2015-04-01T21:26:46.635Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544056
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, round
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62966
list_price 8.65
map NO
mfr_num 5400R-4
net_weight 0.02
non_member_discount 44
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 62966
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.11
ta_dealer_c_price 2.94
ta_price 5.62
text
array
1 62966
2 5400R-4
3 4, round
timestamp 2015-04-01T21:26:46.651Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544094
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, flat
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62977
list_price 8.65
map NO
mfr_num 5400F-4
net_weight 0.02
non_member_discount 44
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 62977
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.11
ta_dealer_c_price 2.94
ta_price 5.62
text
array
1 62977
2 5400F-4
3 4, flat
timestamp 2015-04-01T21:26:46.679Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544322
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.66
deal_of_the_week NO
description 4, bright
group_id 12565
group_uname princeton-series-5400-natural-bristle-oil-acrylic-brushes
id 62992
list_price 8.65
map NO
mfr_num 5400B-4
net_weight 0.02
non_member_discount 44
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 62992
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.11
ta_dealer_c_price 2.94
ta_price 5.62
text
array
1 62992
2 5400B-4
3 4, bright
timestamp 2015-04-01T21:26:46.703Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 7
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8396' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e030b2e121842b89f5d52da1a1c1453475a7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=easels&catB=studio-easels&CatC=sort~1~&gr=best-navajo-easel.html
urltoken CFID=30982891&CFTOKEN=10068422&jsessionid=e030b2e121842b89f5d52da1a1c1453475a7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 05:08:18'}
sessionid e0303bc4a3e36c9a1cb61626281741314814
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=fp~6-10~&gr=princeton-series-5400-natural-bristle-oil-acrylic-brushes.html
urltoken CFID=30982892&CFTOKEN=73927330&jsessionid=e0303bc4a3e36c9a1cb61626281741314814
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 54
barcode 757063544179
barcode_type UPC
col1 6
col1_sortorder 2077
col2 fan