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

Galeria Long Handled Brushes

by Winsor & Newton


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870688
barcode_type UPC
col1 1
col1_sortorder 275
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3
deal_of_the_week NO
description 1, fan
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 29396
list_price 10.59
map NO
mfr_num 5735001
net_weight 0.05
non_member_discount 51
non_member_price 5.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 29396
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.18
ta_price 6.88
text
array
1 29396
2 5735001
3 1, fan
timestamp 2015-03-27T14:46:53.315Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872804
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.83
deal_of_the_week NO
description 1, round
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 71206
list_price 9.99
map NO
mfr_num 5730001
net_weight 0.06
non_member_discount 51
non_member_price 4.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 71206
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.4
ta_dealer_c_price 3
ta_price 6.49
text
array
1 71206
2 5730001
3 1, round
timestamp 2015-03-27T14:47:58.976Z
vip_member_price 3.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872934
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 4.59
deal_of_the_week NO
description 12, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 22706
list_price 16.19
map NO
mfr_num 5731012
net_weight 0.12
non_member_discount 51
non_member_price 7.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 22706
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 4.86
ta_price 10.52
text
array
1 22706
2 5731012
3 12, flat/bright
timestamp 2015-03-27T14:46:43.681Z
vip_member_price 6.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870749
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 4.59
deal_of_the_week NO
description 12, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 57909
list_price 16.19
map NO
mfr_num 5736012
net_weight 0.12
non_member_discount 51
non_member_price 7.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 57909
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 4.86
ta_price 10.52
text
array
1 57909
2 5736012
3 12, flat
timestamp 2015-03-27T14:47:32.999Z
vip_member_price 6.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872859
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 4.59
deal_of_the_week NO
description 12, round
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 64417
list_price 16.19
map NO
mfr_num 5730012
net_weight 0.08
non_member_discount 51
non_member_price 7.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 64417
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 4.86
ta_price 10.52
text
array
1 64417
2 5730012
3 12, round
timestamp 2015-03-27T14:47:44.907Z
vip_member_price 6.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376873016
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 4.59
deal_of_the_week NO
description 12, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 86912
list_price 16.19
map NO
mfr_num 5732012
net_weight 0.16
non_member_discount 51
non_member_price 7.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 86912
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 4.86
ta_price 10.52
text
array
1 86912
2 5732012
3 12, filbert
timestamp 2015-03-27T14:48:18.834Z
vip_member_price 6.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870756
barcode_type UPC
col1 14
col1_sortorder 912
col2 flat
col2_sortorder 209
col3 [empty string]
cost 6.51
deal_of_the_week NO
description 14, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 21071
list_price 22.99
map NO
mfr_num 5736014
net_weight 0.12
non_member_discount 51
non_member_price 11.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 21071
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.82
ta_dealer_c_price 6.9
ta_price 14.94
text
array
1 21071
2 5736014
3 14, flat
timestamp 2015-03-27T14:46:41.525Z
vip_member_price 8.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376873023
barcode_type UPC
col1 14
col1_sortorder 912
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 6.51
deal_of_the_week NO
description 14, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 27959
list_price 22.99
map NO
mfr_num 5732014
net_weight 0.16
non_member_discount 51
non_member_price 11.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 27959
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.82
ta_dealer_c_price 6.9
ta_price 14.94
text
array
1 27959
2 5732014
3 14, filbert
timestamp 2015-03-27T14:46:51.403Z
vip_member_price 8.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872941
barcode_type UPC
col1 14
col1_sortorder 912
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 6.51
deal_of_the_week NO
description 14, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 62563
list_price 22.99
map NO
mfr_num 5731014
net_weight 0.12
non_member_discount 51
non_member_price 11.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 62563
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.82
ta_dealer_c_price 6.9
ta_price 14.94
text
array
1 62563
2 5731014
3 14, flat/bright
timestamp 2015-03-27T14:47:42.193Z
vip_member_price 8.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376873030
barcode_type UPC
col1 18
col1_sortorder 1043
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 8.7
deal_of_the_week NO
description 18, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 49583
list_price 30.69
map NO
mfr_num 5732018
net_weight 0.18
non_member_discount 51
non_member_price 15.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 49583
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.43
ta_dealer_c_price 9.21
ta_price 19.95
text
array
1 49583
2 5732018
3 18, filbert
timestamp 2015-03-27T14:47:24.127Z
vip_member_price 11.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872958
barcode_type UPC
col1 18
col1_sortorder 1043
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 8.7
deal_of_the_week NO
description 18, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 73049
list_price 30.69
map NO
mfr_num 5731018
net_weight 0.12
non_member_discount 51
non_member_price 15.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 73049
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.43
ta_dealer_c_price 9.21
ta_price 19.95
text
array
1 73049
2 5731018
3 18, flat/bright
timestamp 2015-03-27T14:48:03.214Z
vip_member_price 11.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870763
barcode_type UPC
col1 18
col1_sortorder 1043
col2 flat
col2_sortorder 209
col3 [empty string]
cost 8.7
deal_of_the_week NO
description 18, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 77490
list_price 30.69
map NO
mfr_num 5736018
net_weight 0.12
non_member_discount 51
non_member_price 15.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 77490
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.43
ta_dealer_c_price 9.21
ta_price 19.95
text
array
1 77490
2 5736018
3 18, flat
timestamp 2015-03-27T14:48:07.26Z
vip_member_price 11.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872811
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.98
deal_of_the_week NO
description 2, round
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 13761
list_price 10.49
map NO
mfr_num 5730002
net_weight 0.06
non_member_discount 51
non_member_price 5.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 13761
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 13761
2 5730002
3 2, round
timestamp 2015-03-27T14:46:29.362Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872989
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.92
deal_of_the_week NO
description 2, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 55227
list_price 10.29
map NO
mfr_num 5732002
net_weight 0.12
non_member_discount 51
non_member_price 5.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 55227
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.5
ta_dealer_c_price 3.09
ta_price 6.69
text
array
1 55227
2 5732002
3 2, filbert
timestamp 2015-03-27T14:47:29.823Z
vip_member_price 4.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870718
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.92
deal_of_the_week NO
description 2, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 81834
list_price 10.29
map NO
mfr_num 5736002
net_weight 0.06
non_member_discount 51
non_member_price 5.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 81834
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.5
ta_dealer_c_price 3.09
ta_price 6.69
text
array
1 81834
2 5736002
3 2, flat
timestamp 2015-03-27T14:48:12.62Z
vip_member_price 4.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872903
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 2.92
deal_of_the_week NO
description 2, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 86562
list_price 10.29
map NO
mfr_num 5731002
net_weight 0.08
non_member_discount 51
non_member_price 5.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 86562
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.5
ta_dealer_c_price 3.09
ta_price 6.69
text
array
1 86562
2 5731002
3 2, flat/bright
timestamp 2015-03-27T14:48:18.616Z
vip_member_price 4.01

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872965
barcode_type UPC
col1 22
col1_sortorder 1293
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 10.58
deal_of_the_week NO
description 22, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 27455
list_price 37.29
map NO
mfr_num 5731022
net_weight 0.14
non_member_discount 51
non_member_price 18.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 27455
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 27455
2 5731022
3 22, flat/bright
timestamp 2015-03-27T14:46:50.656Z
vip_member_price 14.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872897
barcode_type UPC
col1 28
col1_sortorder 1420
col2 round
col2_sortorder 434
col3 [empty string]
cost 13.94
deal_of_the_week NO
description 28, round
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 21223
list_price 49.19
map NO
mfr_num 5730028
net_weight 0.1
non_member_discount 51
non_member_price 24.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 21223
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.72
ta_dealer_c_price 14.76
ta_price 31.97
text
array
1 21223
2 5730028
3 28, round
timestamp 2015-03-27T14:46:41.688Z
vip_member_price 19.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870640
barcode_type UPC
col1 28
col1_sortorder 1420
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 13.94
deal_of_the_week NO
description 28, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 51018
list_price 49.19
map NO
mfr_num 5732028
net_weight 0.18
non_member_discount 51
non_member_price 24.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 51018
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.72
ta_dealer_c_price 14.76
ta_price 31.97
text
array
1 51018
2 5732028
3 28, filbert
timestamp 2015-03-27T14:47:25.213Z
vip_member_price 19.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870787
barcode_type UPC
col1 28
col1_sortorder 1420
col2 flat
col2_sortorder 209
col3 [empty string]
cost 13.94
deal_of_the_week NO
description 28, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 58838
list_price 49.19
map NO
mfr_num 5736028
net_weight 0.14
non_member_discount 51
non_member_price 24.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 58838
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.72
ta_dealer_c_price 14.76
ta_price 31.97
text
array
1 58838
2 5736028
3 28, flat
timestamp 2015-03-27T14:47:34.345Z
vip_member_price 19.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870695
barcode_type UPC
col1 3
col1_sortorder 1434
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3.84
deal_of_the_week NO
description 3, fan
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 61617
list_price 13.559
map NO
mfr_num 5735003
net_weight 0.06
non_member_discount 51
non_member_price 6.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 61617
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.61
ta_dealer_c_price 4.07
ta_price 8.81
text
array
1 61617
2 5735003
3 3, fan
timestamp 2015-03-27T14:47:41.069Z
vip_member_price 5.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870657
barcode_type UPC
col1 32
col1_sortorder 1646
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 16.21
deal_of_the_week NO
description 32, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 34995
list_price 57.19
map NO
mfr_num 5732032
net_weight 0.18
non_member_discount 51
non_member_price 28.02
prop65 NO
ship_rule_desc STD
shipping STD
sku 34995
sku_pix YES
supplier_id 1
ta_dealer_a_price 19.44
ta_dealer_c_price 17.16
ta_price 37.17
text
array
1 34995
2 5732032
3 32, filbert
timestamp 2015-03-27T14:47:05.522Z
vip_member_price 22.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870619
barcode_type UPC
col1 32
col1_sortorder 1646
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 16.21
deal_of_the_week NO
description 32, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 58855
list_price 57.19
map NO
mfr_num 5731032
net_weight 0.16
non_member_discount 51
non_member_price 28.02
prop65 NO
ship_rule_desc STD
shipping STD
sku 58855
sku_pix YES
supplier_id 1
ta_dealer_a_price 19.44
ta_dealer_c_price 17.16
ta_price 37.17
text
array
1 58855
2 5731032
3 32, flat/bright
timestamp 2015-03-27T14:47:34.355Z
vip_member_price 22.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870626
barcode_type UPC
col1 36
col1_sortorder 1677
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 19.08
deal_of_the_week NO
description 36, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 72981
list_price 67.29
map NO
mfr_num 5731036
net_weight 0.16
non_member_discount 51
non_member_price 32.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 72981
sku_pix YES
supplier_id 1
ta_dealer_a_price 22.88
ta_dealer_c_price 20.19
ta_price 43.74
text
array
1 72981
2 5731036
3 36, flat/bright
timestamp 2015-03-27T14:48:03.135Z
vip_member_price 26.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870800
barcode_type UPC
col1 36
col1_sortorder 1677
col2 flat
col2_sortorder 209
col3 [empty string]
cost 19.08
deal_of_the_week NO
description 36, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 76990
list_price 67.29
map NO
mfr_num 5736036
net_weight 0.14
non_member_discount 51
non_member_price 32.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 76990
sku_pix YES
supplier_id 1
ta_dealer_a_price 22.88
ta_dealer_c_price 20.19
ta_price 43.74
text
array
1 76990
2 5736036
3 36, flat
timestamp 2015-03-27T14:48:06.712Z
vip_member_price 26.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870725
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 4, flat
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 29253
list_price 10.99
map NO
mfr_num 5736004
net_weight 0.08
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 29253
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.3
ta_price 7.14
text
array
1 29253
2 5736004
3 4, flat
timestamp 2015-03-27T14:46:53.157Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872996
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 4, filbert
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 39664
list_price 10.99
map NO
mfr_num 5732004
net_weight 0.14
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 39664
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.3
ta_price 7.14
text
array
1 39664
2 5732004
3 4, filbert
timestamp 2015-03-27T14:47:11.834Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872828
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 4, round
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 83773
list_price 10.99
map NO
mfr_num 5730004
net_weight 0.08
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 83773
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.3
ta_price 7.14
text
array
1 83773
2 5730004
3 4, round
timestamp 2015-03-27T14:48:14.199Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872910
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 4, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 84023
list_price 10.99
map NO
mfr_num 5731004
net_weight 0.08
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 84023
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.3
ta_price 7.14
text
array
1 84023
2 5731004
3 4, flat/bright
timestamp 2015-03-27T14:48:14.335Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870633
barcode_type UPC
col1 40
col1_sortorder 1828
col2 flat/bright
col2_sortorder 221
col3 [empty string]
cost 20.67
deal_of_the_week NO
description 40, flat/bright
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 16918
list_price 72.89
map NO
mfr_num 5731040
net_weight 0.16
non_member_discount 51
non_member_price 35.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 16918
sku_pix YES
supplier_id 1
ta_dealer_a_price 24.78
ta_dealer_c_price 21.87
ta_price 47.38
text
array
1 16918
2 5731040
3 40, flat/bright
timestamp 2015-03-27T14:46:36.511Z
vip_member_price 28.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376870701
barcode_type UPC
col1 5
col1_sortorder 1906
col2 fan
col2_sortorder 198
col3 [empty string]
cost 4.73
deal_of_the_week NO
description 5, fan
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 20616
list_price 16.69
map NO
mfr_num 5735005
net_weight 0.06
non_member_discount 51
non_member_price 8.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 20616
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.67
ta_dealer_c_price 5.01
ta_price 10.85
text
array
1 20616
2 5735005
3 5, fan
timestamp 2015-03-27T14:46:40.735Z
vip_member_price 6.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html
urltoken CFID=29891754&CFTOKEN=91486400&jsessionid=e030233f77aeb5d0b1e9471446135d4e3e1c
validationerror [empty string]


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

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

ItemIDList: 41434,56221
AvailQtyList: 0E-12,2.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376872835
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.4
deal_of_the_week NO
description 6, round
group_id 1112
group_uname winsor-newton-galeria-long-handled-brushes
id 42099
list_price 11.99
map NO
mfr_num 5730006
net_weight 0.08
non_member_discount 51
non_member_price 5.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 42099
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.08
ta_dealer_c_price 3.6
ta_price 7.79
text
array
1 42099
2 5730006
3 6, round
timestamp 2015-03-27T14:47:14.575Z
vip_member_price 4.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 41434
2 2.000000000000 56221
CACHED false
EXECUTIONTIME 22
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] = '1116' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.175.216

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 06:05:44'}
sessionid e030233f77aeb5d0b1e9471446135d4e3e1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fp~6-9~&gr=winsor-newton-galeria-long-handled-brushes.html