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

Goldenedge Oil and Acrylic Brushes

by Grumbacher


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361448
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 [empty string]
cost 1.87
deal_of_the_week NO
description 1, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 57224
list_price 6.8
map NO
mfr_num 630B1G
net_weight 0.1
non_member_discount 51
non_member_price 3.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 57224
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.18
ta_dealer_c_price 2.04
ta_price 4.08
text
array
1 57224
2 630B1G
3 1, bright
timestamp 2015-03-27T14:47:32.303Z
vip_member_price 2.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173361455
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 [empty string]
cost 1.87
deal_of_the_week NO
description 1, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91325
list_price 6.8
map NO
mfr_num 630F1G
net_weight 0.1
non_member_discount 51
non_member_price 3.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 91325
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.18
ta_dealer_c_price 2.04
ta_price 4.08
text
array
1 91325
2 630F1G
3 1, flat
timestamp 2015-03-27T14:48:26.998Z
vip_member_price 2.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357243
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 [empty string]
cost 1.87
deal_of_the_week NO
description 1, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91334
list_price 6.8
map NO
mfr_num 630R1G
net_weight 0.1
non_member_discount 51
non_member_price 3.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 91334
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.18
ta_dealer_c_price 2.04
ta_price 4.08
text
array
1 91334
2 630R1G
3 1, round
timestamp 2015-03-27T14:48:27.032Z
vip_member_price 2.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362803
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 1.87
deal_of_the_week NO
description 1, filbert
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91346
list_price 6.8
map NO
mfr_num 630T1G
net_weight 0.1
non_member_discount 51
non_member_price 3.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 91346
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.18
ta_dealer_c_price 2.04
ta_price 4.08
text
array
1 91346
2 630T1G
3 1, filbert
timestamp 2015-03-27T14:48:27.076Z
vip_member_price 2.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357076
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 [empty string]
cost 4.89
deal_of_the_week NO
description 10, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91323
list_price 17.8
map NO
mfr_num 630B10G
net_weight 0.1
non_member_discount 51
non_member_price 8.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91323
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.7
ta_dealer_c_price 5.34
ta_price 10.68
text
array
1 91323
2 630B10G
3 10, bright
timestamp 2015-03-27T14:48:26.99Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357151
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 [empty string]
cost 4.89
deal_of_the_week NO
description 10, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91332
list_price 17.8
map NO
mfr_num 630F10G
net_weight 0.1
non_member_discount 51
non_member_price 8.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91332
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.7
ta_dealer_c_price 5.34
ta_price 10.68
text
array
1 91332
2 630F10G
3 10, flat
timestamp 2015-03-27T14:48:27.023Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362797
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 4.89
deal_of_the_week NO
description 10, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91341
list_price 17.8
map NO
mfr_num 630R10G
net_weight 0.1
non_member_discount 51
non_member_price 8.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91341
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.7
ta_dealer_c_price 5.34
ta_price 10.68
text
array
1 91341
2 630R10G
3 10, round
timestamp 2015-03-27T14:48:27.063Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362841
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 4.89
deal_of_the_week NO
description 10, filbert
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91351
list_price 17.8
map NO
mfr_num 630T10G
net_weight 0.1
non_member_discount 51
non_member_price 8.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91351
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.7
ta_dealer_c_price 5.34
ta_price 10.68
text
array
1 91351
2 630T10G
3 10, filbert
timestamp 2015-03-27T14:48:27.096Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357083
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 [empty string]
cost 5.51
deal_of_the_week NO
description 12, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91324
list_price 20.1
map NO
mfr_num 630B12G
net_weight 0.1
non_member_discount 51
non_member_price 9.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 91324
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.43
ta_dealer_c_price 6.03
ta_price 12.06
text
array
1 91324
2 630B12G
3 12, bright
timestamp 2015-03-27T14:48:26.992Z
vip_member_price 7.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357168
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 5.51
deal_of_the_week NO
description 12, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91333
list_price 20.1
map NO
mfr_num 630F12G
net_weight 0.1
non_member_discount 51
non_member_price 9.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 91333
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.43
ta_dealer_c_price 6.03
ta_price 12.06
text
array
1 91333
2 630F12G
3 12, flat
timestamp 2015-03-27T14:48:27.029Z
vip_member_price 7.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357250
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 5.51
deal_of_the_week NO
description 12, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91342
list_price 20.1
map NO
mfr_num 630R12G
net_weight 0.1
non_member_discount 51
non_member_price 9.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 91342
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.43
ta_dealer_c_price 6.03
ta_price 12.06
text
array
1 91342
2 630R12G
3 12, round
timestamp 2015-03-27T14:48:27.065Z
vip_member_price 7.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362858
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 5.51
deal_of_the_week NO
description 12, filbert
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91352
list_price 20.1
map NO
mfr_num 630T12G
net_weight 0.1
non_member_discount 51
non_member_price 9.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 91352
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.43
ta_dealer_c_price 6.03
ta_price 12.06
text
array
1 91352
2 630T12G
3 12, filbert
timestamp 2015-03-27T14:48:27.097Z
vip_member_price 7.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357090
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.09
deal_of_the_week NO
description 2, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91318
list_price 7.6
map NO
mfr_num 630B2G
net_weight 0.1
non_member_discount 51
non_member_price 3.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91318
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.43
ta_dealer_c_price 2.28
ta_price 4.56
text
array
1 91318
2 630B2G
3 2, bright
timestamp 2015-03-27T14:48:26.972Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357175
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.09
deal_of_the_week NO
description 2, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91326
list_price 7.6
map NO
mfr_num 630F2G
net_weight 0.1
non_member_discount 51
non_member_price 3.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91326
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.43
ta_dealer_c_price 2.28
ta_price 4.56
text
array
1 91326
2 630F2G
3 2, flat
timestamp 2015-03-27T14:48:27Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357267
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.09
deal_of_the_week NO
description 2, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91335
list_price 7.6
map NO
mfr_num 630R2G
net_weight 0.1
non_member_discount 51
non_member_price 3.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91335
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.43
ta_dealer_c_price 2.28
ta_price 4.56
text
array
1 91335
2 630R2G
3 2, round
timestamp 2015-03-27T14:48:27.036Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357212
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 [empty string]
cost 3.31
deal_of_the_week NO
description 2, fan
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91343
list_price 12.05
map NO
mfr_num 630N2G
net_weight 0.1
non_member_discount 51
non_member_price 5.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 91343
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.86
ta_dealer_c_price 3.62
ta_price 7.23
text
array
1 91343
2 630N2G
3 2, fan
timestamp 2015-03-27T14:48:27.068Z
vip_member_price 4.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362810
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.09
deal_of_the_week NO
description 2, filbert
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91347
list_price 7.6
map NO
mfr_num 630T2G
net_weight 0.1
non_member_discount 51
non_member_price 3.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91347
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.43
ta_dealer_c_price 2.28
ta_price 4.56
text
array
1 91347
2 630T2G
3 2, filbert
timestamp 2015-03-27T14:48:27.078Z
vip_member_price 2.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362766
barcode_type UPC
col1 3
col1_sortorder 1434
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.45
deal_of_the_week NO
description 3, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91327
list_price 8.95
map NO
mfr_num 630F3G
net_weight 0.1
non_member_discount 51
non_member_price 4.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 91327
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.86
ta_dealer_c_price 2.69
ta_price 5.37
text
array
1 91327
2 630F3G
3 3, flat
timestamp 2015-03-27T14:48:27.002Z
vip_member_price 3.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362773
barcode_type UPC
col1 3
col1_sortorder 1434
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.45
deal_of_the_week NO
description 3, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91336
list_price 8.95
map NO
mfr_num 630R3G
net_weight 0.1
non_member_discount 51
non_member_price 4.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 91336
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.86
ta_dealer_c_price 2.69
ta_price 5.37
text
array
1 91336
2 630R3G
3 3, round
timestamp 2015-03-27T14:48:27.039Z
vip_member_price 3.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357106
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 2.59
deal_of_the_week NO
description 4, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91319
list_price 9.4
map NO
mfr_num 630B4G
net_weight 0.1
non_member_discount 51
non_member_price 4.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 91319
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.01
ta_dealer_c_price 2.82
ta_price 5.64
text
array
1 91319
2 630B4G
3 4, bright
timestamp 2015-03-27T14:48:26.974Z
vip_member_price 3.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357182
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 2.59
deal_of_the_week NO
description 4, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91328
list_price 9.4
map NO
mfr_num 630F4G
net_weight 0.1
non_member_discount 51
non_member_price 4.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 91328
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.01
ta_dealer_c_price 2.82
ta_price 5.64
text
array
1 91328
2 630F4G
3 4, flat
timestamp 2015-03-27T14:48:27.005Z
vip_member_price 3.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357274
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 2.59
deal_of_the_week NO
description 4, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91337
list_price 9.4
map NO
mfr_num 630R4G
net_weight 0.1
non_member_discount 51
non_member_price 4.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 91337
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.01
ta_dealer_c_price 2.82
ta_price 5.64
text
array
1 91337
2 630R4G
3 4, round
timestamp 2015-03-27T14:48:27.044Z
vip_member_price 3.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357229
barcode_type UPC
col1 4
col1_sortorder 1724
col2 fan
col2_sortorder 198
col3 [empty string]
cost 4.49
deal_of_the_week NO
description 4, fan
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91344
list_price 16.35
map NO
mfr_num 630N4G
net_weight 0.1
non_member_discount 51
non_member_price 8.01
prop65 NO
ship_rule_desc STD
shipping STD
sku 91344
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.23
ta_dealer_c_price 4.91
ta_price 9.81
text
array
1 91344
2 630N4G
3 4, fan
timestamp 2015-03-27T14:48:27.07Z
vip_member_price 6.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357304
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 2.59
deal_of_the_week NO
description 4, filbert
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91348
list_price 9.4
map NO
mfr_num 630T4G
net_weight 0.1
non_member_discount 51
non_member_price 4.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 91348
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.01
ta_dealer_c_price 2.82
ta_price 5.64
text
array
1 91348
2 630T4G
3 4, filbert
timestamp 2015-03-27T14:48:27.08Z
vip_member_price 3.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362759
barcode_type UPC
col1 5
col1_sortorder 1906
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.03
deal_of_the_week NO
description 5, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91320
list_price 11
map NO
mfr_num 630B5G
net_weight 0.1
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 91320
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.52
ta_dealer_c_price 3.3
ta_price 6.6
text
array
1 91320
2 630B5G
3 5, bright
timestamp 2015-03-27T14:48:26.977Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173364531
barcode_type UPC
col1 5
col1_sortorder 1906
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.03
deal_of_the_week NO
description 5, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91329
list_price 11
map NO
mfr_num 630F5G
net_weight 0.1
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 91329
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.52
ta_dealer_c_price 3.3
ta_price 6.6
text
array
1 91329
2 630F5G
3 5, flat
timestamp 2015-03-27T14:48:27.007Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362780
barcode_type UPC
col1 5
col1_sortorder 1906
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.03
deal_of_the_week NO
description 5, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91338
list_price 11
map NO
mfr_num 630R5G
net_weight 0.1
non_member_discount 51
non_member_price 5.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 91338
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.52
ta_dealer_c_price 3.3
ta_price 6.6
text
array
1 91338
2 630R5G
3 5, round
timestamp 2015-03-27T14:48:27.05Z
vip_member_price 4.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357113
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 6, bright
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91321
list_price 11.35
map NO
mfr_num 630B6G
net_weight 0.1
non_member_discount 51
non_member_price 5.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 91321
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.63
ta_dealer_c_price 3.41
ta_price 6.81
text
array
1 91321
2 630B6G
3 6, bright
timestamp 2015-03-27T14:48:26.979Z
vip_member_price 4.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357199
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 6, flat
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91330
list_price 11.35
map NO
mfr_num 630F6G
net_weight 0.1
non_member_discount 51
non_member_price 5.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 91330
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.63
ta_dealer_c_price 3.41
ta_price 6.81
text
array
1 91330
2 630F6G
3 6, flat
timestamp 2015-03-27T14:48:27.011Z
vip_member_price 4.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357281
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 6, round
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91339
list_price 11.35
map NO
mfr_num 630R6G
net_weight 0.1
non_member_discount 51
non_member_price 5.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 91339
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.63
ta_dealer_c_price 3.41
ta_price 6.81
text
array
1 91339
2 630R6G
3 6, round
timestamp 2015-03-27T14:48:27.053Z
vip_member_price 4.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173357236
barcode_type UPC
col1 6
col1_sortorder 2077
col2 fan
col2_sortorder 198
col3 [empty string]
cost 4.89
deal_of_the_week NO
description 6, fan
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91345
list_price 17.8
map NO
mfr_num 630N6G
net_weight 0.1
non_member_discount 51
non_member_price 8.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 91345
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.7
ta_dealer_c_price 5.34
ta_price 10.68
text
array
1 91345
2 630N6G
3 6, fan
timestamp 2015-03-27T14:48:27.074Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: 35853
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 014173362834
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.11
deal_of_the_week NO
description 6, filbert
group_id 12158
group_uname grumbacher-goldenedge-oil-and-acrylic-brushes
id 91349
list_price 11.35
map NO
mfr_num 630T6G
net_weight 0.1
non_member_discount 51
non_member_price 5.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 91349
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.63
ta_dealer_c_price 3.41
ta_price 6.81
text
array
1 91349
2 630T6G
3 6, filbert
timestamp 2015-03-27T14:48:27.085Z
vip_member_price 4.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 35853
CACHED false
EXECUTIONTIME 3
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] = '7791' 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.158.71

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e030686310ab694d8db819c7b512422b3a52
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fb~x-acto~fp~5-36~&gr=x-acto-needle-file-set.html
urltoken CFID=29948058&CFTOKEN=11316474&jsessionid=e030686310ab694d8db819c7b512422b3a52
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 11:06:50'}
sessionid e03060486df08ec3648b1c55597e24838277
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=sort~1~&gr=grumbacher-goldenedge-oil-and-acrylic-brushes.html
urltoken CFID=29948057&CFTOKEN=22343606&jsessionid=e03060486df08ec3648b1c55597e24838277
validationerror [empty string]


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

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

ItemIDList: