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

Simply Simmons Long Handle Brushes

by Robert Simmons


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014363
barcode_type UPC
col1 1
col1_sortorder 275
col2 bristle bright
col2_sortorder 117
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 1, bristle bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98655
list_price 4.7
map NO
mfr_num 255141001
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98655
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98655
2 255141001
3 1, bristle bright
timestamp 2015-04-01T21:27:45.17Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014424
barcode_type UPC
col1 1
col1_sortorder 275
col2 bristle flat
col2_sortorder 120
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 1, bristle flat
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98661
list_price 4.7
map NO
mfr_num 255144001
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98661
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98661
2 255144001
3 1, bristle flat
timestamp 2015-04-01T21:27:45.194Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014486
barcode_type UPC
col1 1
col1_sortorder 275
col2 bristle filbert
col2_sortorder 119
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 1, bristle filbert
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98667
list_price 4.7
map NO
mfr_num 255142001
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98667
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98667
2 255142001
3 1, bristle filbert
timestamp 2015-04-01T21:27:45.208Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014417
barcode_type UPC
col1 10
col1_sortorder 692
col2 bristle bright
col2_sortorder 117
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 10, bristle bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98660
list_price 4.7
map NO
mfr_num 255141010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98660
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98660
2 255141010
3 10, bristle bright
timestamp 2015-04-01T21:27:45.188Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014479
barcode_type UPC
col1 10
col1_sortorder 692
col2 bristle flat
col2_sortorder 120
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 10, bristle flat
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98666
list_price 4.7
map NO
mfr_num 255144010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98666
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98666
2 255144010
3 10, bristle flat
timestamp 2015-04-01T21:27:45.204Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014530
barcode_type UPC
col1 10
col1_sortorder 692
col2 bristle filbert
col2_sortorder 119
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 10, bristle filbert
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98672
list_price 4.7
map NO
mfr_num 255142010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98672
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98672
2 255142010
3 10, bristle filbert
timestamp 2015-04-01T21:27:45.226Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014585
barcode_type UPC
col1 10
col1_sortorder 692
col2 bristle round
col2_sortorder 121
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 10, bristle round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98677
list_price 4.7
map NO
mfr_num 255145010
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98677
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98677
2 255145010
3 10, bristle round
timestamp 2015-04-01T21:27:45.246Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014639
barcode_type UPC
col1 12
col1_sortorder 816
col2 synthetic bright
col2_sortorder 509
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 12, synthetic bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98682
list_price 4.7
map NO
mfr_num 255160012
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98682
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98682
2 255160012
3 12, synthetic bright
timestamp 2015-04-01T21:27:45.265Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014684
barcode_type UPC
col1 12
col1_sortorder 816
col2 synthetic round
col2_sortorder 510
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 12, synthetic round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98687
list_price 4.7
map NO
mfr_num 255161012
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98687
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98687
2 255161012
3 12, synthetic round
timestamp 2015-04-01T21:27:45.303Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014646
barcode_type UPC
col1 16
col1_sortorder 979
col2 synthetic bright
col2_sortorder 509
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 16, synthetic bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98683
list_price 4.7
map NO
mfr_num 255160016
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98683
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98683
2 255160016
3 16, synthetic bright
timestamp 2015-04-01T21:27:45.267Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014691
barcode_type UPC
col1 16
col1_sortorder 979
col2 synthetic round
col2_sortorder 510
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 16, synthetic round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98688
list_price 4.7
map NO
mfr_num 255161016
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98688
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98688
2 255161016
3 16, synthetic round
timestamp 2015-04-01T21:27:45.309Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014707
barcode_type UPC
col1 18
col1_sortorder 1043
col2 synthetic round
col2_sortorder 510
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 18, synthetic round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98689
list_price 4.7
map NO
mfr_num 255161018
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98689
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98689
2 255161018
3 18, synthetic round
timestamp 2015-04-01T21:27:45.311Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014370
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bristle bright
col2_sortorder 117
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 2, bristle bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98656
list_price 4.7
map NO
mfr_num 255141002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98656
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98656
2 255141002
3 2, bristle bright
timestamp 2015-04-01T21:27:45.173Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014431
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bristle flat
col2_sortorder 120
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 2, bristle flat
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98662
list_price 4.7
map NO
mfr_num 255144002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98662
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98662
2 255144002
3 2, bristle flat
timestamp 2015-04-01T21:27:45.195Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014493
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bristle filbert
col2_sortorder 119
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 2, bristle filbert
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98668
list_price 4.7
map NO
mfr_num 255142002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98668
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98668
2 255142002
3 2, bristle filbert
timestamp 2015-04-01T21:27:45.213Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014547
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bristle round
col2_sortorder 121
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 2, bristle round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98673
list_price 4.7
map NO
mfr_num 255145002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98673
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98673
2 255145002
3 2, bristle round
timestamp 2015-04-01T21:27:45.23Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014592
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bristle fan
col2_sortorder 118
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 2, bristle fan
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98678
list_price 4.7
map NO
mfr_num 255146002
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98678
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98678
2 255146002
3 2, bristle fan
timestamp 2015-04-01T21:27:45.248Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014653
barcode_type UPC
col1 20
col1_sortorder 1248
col2 synthetic bright
col2_sortorder 509
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 20, synthetic bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98684
list_price 4.7
map NO
mfr_num 255160020
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98684
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98684
2 255160020
3 20, synthetic bright
timestamp 2015-04-01T21:27:45.269Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014714
barcode_type UPC
col1 20
col1_sortorder 1248
col2 synthetic round
col2_sortorder 510
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 20, synthetic round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98690
list_price 4.7
map NO
mfr_num 255161020
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98690
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98690
2 255161020
3 20, synthetic round
timestamp 2015-04-01T21:27:45.313Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014387
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bristle bright
col2_sortorder 117
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 4, bristle bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98657
list_price 4.7
map NO
mfr_num 255141004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98657
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98657
2 255141004
3 4, bristle bright
timestamp 2015-04-01T21:27:45.177Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014448
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bristle flat
col2_sortorder 120
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 4, bristle flat
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98663
list_price 4.7
map NO
mfr_num 255144004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98663
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98663
2 255144004
3 4, bristle flat
timestamp 2015-04-01T21:27:45.198Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014509
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bristle filbert
col2_sortorder 119
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 4, bristle filbert
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98669
list_price 4.7
map NO
mfr_num 255142004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98669
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98669
2 255142004
3 4, bristle filbert
timestamp 2015-04-01T21:27:45.22Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014554
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bristle round
col2_sortorder 121
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 4, bristle round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98674
list_price 4.7
map NO
mfr_num 255145004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98674
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98674
2 255145004
3 4, bristle round
timestamp 2015-04-01T21:27:45.235Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014608
barcode_type UPC
col1 4
col1_sortorder 1724
col2 synthetic bright
col2_sortorder 509
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 4, synthetic bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98679
list_price 4.7
map NO
mfr_num 255160004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98679
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98679
2 255160004
3 4, synthetic bright
timestamp 2015-04-01T21:27:45.25Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014660
barcode_type UPC
col1 4
col1_sortorder 1724
col2 synthetic round
col2_sortorder 510
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 4, synthetic round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98685
list_price 4.7
map NO
mfr_num 255161004
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98685
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98685
2 255161004
3 4, synthetic round
timestamp 2015-04-01T21:27:45.292Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014394
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bristle bright
col2_sortorder 117
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 6, bristle bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98658
list_price 4.7
map NO
mfr_num 255141006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98658
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98658
2 255141006
3 6, bristle bright
timestamp 2015-04-01T21:27:45.181Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014455
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bristle flat
col2_sortorder 120
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 6, bristle flat
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98664
list_price 4.7
map NO
mfr_num 255144006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98664
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98664
2 255144006
3 6, bristle flat
timestamp 2015-04-01T21:27:45.2Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014516
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bristle filbert
col2_sortorder 119
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 6, bristle filbert
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98670
list_price 4.7
map NO
mfr_num 255142006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98670
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98670
2 255142006
3 6, bristle filbert
timestamp 2015-04-01T21:27:45.222Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014561
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bristle round
col2_sortorder 121
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 6, bristle round
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98675
list_price 4.7
map NO
mfr_num 255145006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98675
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98675
2 255145006
3 6, bristle round
timestamp 2015-04-01T21:27:45.241Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014615
barcode_type UPC
col1 6
col1_sortorder 2077
col2 synthetic bright
col2_sortorder 509
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 6, synthetic bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98680
list_price 4.7
map NO
mfr_num 255160006
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98680
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98680
2 255160006
3 6, synthetic bright
timestamp 2015-04-01T21:27:45.254Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014400
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bristle bright
col2_sortorder 117
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 8, bristle bright
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98659
list_price 4.7
map NO
mfr_num 255141008
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98659
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98659
2 255141008
3 8, bristle bright
timestamp 2015-04-01T21:27:45.186Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0305012547ecd45e3a7722c391ca3d73392
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html
urltoken CFID=30852417&CFTOKEN=45825436&jsessionid=e0305012547ecd45e3a7722c391ca3d73392
validationerror [empty string]


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

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

ItemIDList: 78593
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 038372014462
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bristle flat
col2_sortorder 120
col3 [empty string]
cost 1.61
deal_of_the_week NO
description 8, bristle flat
group_id 10144
group_uname robert-simmons-simply-simmons-long-handle-brushes
id 98665
list_price 4.7
map NO
mfr_num 255144008
net_weight 0.04
non_member_discount 33
non_member_price 3.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 98665
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.74
ta_dealer_c_price 1.74
ta_price 2.82
text
array
1 98665
2 255144008
3 8, bristle flat
timestamp 2015-04-01T21:27:45.202Z
vip_member_price 2.68

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

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&CatC=fb~robert-simmons~fp~0-5~&gr=robert-simmons-simply-simmons-long-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 17:16:55'}
sessionid e0308202d0ded095f4625b2f751f26221718
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=inks-powders&CatD=fp~4-8~&gr=ranger-enamel-accents-black-and-white-pack-of-2.html
urltoken CFID=30852418&CFTOKEN=22541756&jsessionid=e0308202d0ded095f4625b2f751f26221718
validationerror [empty string]


EndSessionVariables: