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

Metallic Envelopes

by Stardream


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 antique gold
col1_sortorder 148
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 210-164-78.jpg
cost 4.97
deal_of_the_week NO
description antique gold, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 14503
list_price 9.58
map NO
mfr_num 9971074
net_weight 0.2
non_member_discount 15
non_member_price 8.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 14503
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.75
ta_dealer_c_price 5.75
ta_price 6.98
text
array
1 14503
2 9971074
3 antique gold, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:52:43.757Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 antique gold
col1_sortorder 148
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 210-164-78.jpg
cost 7.93
deal_of_the_week NO
description antique gold, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 16411
list_price 15.29
map NO
mfr_num 9971078
net_weight 0.4
non_member_discount 15
non_member_price 13
prop65 NO
ship_rule_desc STD
shipping STD
sku 16411
sku_pix NO
supplier_id 1
ta_dealer_a_price 9.17
ta_dealer_c_price 9.17
ta_price 10.54
text
array
1 16411
2 9971078
3 antique gold, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:52:47.599Z
vip_member_price 11.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 antique gold
col1_sortorder 148
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 210-164-78.jpg
cost 5.04
deal_of_the_week NO
description antique gold, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 31294
list_price 9.72
map NO
mfr_num 9971076
net_weight 0.26
non_member_discount 15
non_member_price 8.26
prop65 NO
ship_rule_desc STD
shipping STD
sku 31294
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.83
ta_dealer_c_price 5.83
ta_price 8.19
text
array
1 31294
2 9971076
3 antique gold, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:53:09.749Z
vip_member_price 7.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 antique gold
col1_sortorder 148
col2 no. 10 4 1/8 in. x 9 1/2 in.
col2_sortorder 2526
col3 [empty string]
color_swatch 210-164-78.jpg
cost 7.93
deal_of_the_week NO
description antique gold, no. 10 4 1/8 in. x 9 1/2 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 32518
list_price 15.29
map NO
mfr_num 9971084
net_weight 0.4
non_member_discount 15
non_member_price 13
prop65 NO
ship_rule_desc STD
shipping STD
sku 32518
sku_pix NO
supplier_id 1
ta_dealer_a_price 9.17
ta_dealer_c_price 9.17
ta_price 11.3
text
array
1 32518
2 9971084
3 antique gold, no. 10 4 1/8 in. x 9 1/2 in.
timestamp 2015-03-31T17:53:11.202Z
vip_member_price 11.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 azalea
col1_sortorder 268
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 250-103-171.jpg
cost 5.49
deal_of_the_week NO
description azalea, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id P0237
list_price 10.59
map NO
mfr_num AXP0237
net_weight 0.27
non_member_discount 15
non_member_price 9
prop65 NO
ship_rule_desc STD
shipping STD
sku P0237
sku_pix NO
supplier_id 1
ta_dealer_a_price 6.35
ta_dealer_c_price 6.35
ta_price 8.19
text
array
1 P0237
2 AXP0237
3 azalea, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:55:01.448Z
vip_member_price 7.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 azalea
col1_sortorder 268
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 250-103-171.jpg
cost 7.93
deal_of_the_week NO
description azalea, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id P0454
list_price 15.29
map NO
mfr_num AXP0454
net_weight 0.4
non_member_discount 15
non_member_price 13
prop65 NO
ship_rule_desc STD
shipping STD
sku P0454
sku_pix NO
supplier_id 1
ta_dealer_a_price 9.17
ta_dealer_c_price 9.17
ta_price 10.54
text
array
1 P0454
2 AXP0454
3 azalea, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:55:01.467Z
vip_member_price 11.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 azalea
col1_sortorder 268
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 250-103-171.jpg
cost 4.12
deal_of_the_week NO
description azalea, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id P0455
list_price 7.95
map NO
mfr_num AXP0455
net_weight 0.2
non_member_discount 15
non_member_price 6.76
prop65 NO
ship_rule_desc STD
shipping STD
sku P0455
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.77
ta_dealer_c_price 4.77
ta_price 6.98
text
array
1 P0455
2 AXP0455
3 azalea, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:55:01.47Z
vip_member_price 5.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 bronze
col1_sortorder 791
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 101-68-49.jpg
cost 4.05
deal_of_the_week NO
description bronze, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 17399
list_price 7.81
map NO
mfr_num 9971002
net_weight 0.2
non_member_discount 15
non_member_price 6.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 17399
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.69
ta_dealer_c_price 4.69
ta_price 6.98
text
array
1 17399
2 9971002
3 bronze, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:52:48.751Z
vip_member_price 5.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 bronze
col1_sortorder 791
col2 no. 10 4 1/8 in. x 9 1/2 in.
col2_sortorder 2526
col3 [empty string]
color_swatch 101-68-49.jpg
cost 6.16
deal_of_the_week NO
description bronze, no. 10 4 1/8 in. x 9 1/2 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 20027
list_price 11.88
map NO
mfr_num 9971012
net_weight 0.4
non_member_discount 15
non_member_price 10.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 20027
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.13
ta_dealer_c_price 7.13
ta_price 11.3
text
array
1 20027
2 9971012
3 bronze, no. 10 4 1/8 in. x 9 1/2 in.
timestamp 2015-03-31T17:52:53.195Z
vip_member_price 8.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 bronze
col1_sortorder 791
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 101-68-49.jpg
cost 6.01
deal_of_the_week NO
description bronze, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 29182
list_price 11.6
map NO
mfr_num 9971006
net_weight 0.4
non_member_discount 15
non_member_price 9.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 29182
sku_pix NO
supplier_id 1
ta_dealer_a_price 6.96
ta_dealer_c_price 6.96
ta_price 10.54
text
array
1 29182
2 9971006
3 bronze, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:53:06.597Z
vip_member_price 8.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 bronze
col1_sortorder 791
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 101-68-49.jpg
cost 4.6
deal_of_the_week NO
description bronze, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 32757
list_price 8.87
map NO
mfr_num 9971004
net_weight 0.26
non_member_discount 15
non_member_price 7.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 32757
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.32
ta_dealer_c_price 5.32
ta_price 8.19
text
array
1 32757
2 9971004
3 bronze, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:53:11.368Z
vip_member_price 6.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 copper
col1_sortorder 1529
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 183-87-41.jpg
cost 4.6
deal_of_the_week NO
description copper, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 12513
list_price 8.87
map NO
mfr_num 9971016
net_weight 0.26
non_member_discount 15
non_member_price 7.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 12513
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.32
ta_dealer_c_price 5.32
ta_price 8.19
text
array
1 12513
2 9971016
3 copper, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:52:38.901Z
vip_member_price 6.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 copper
col1_sortorder 1529
col2 no. 10 4 1/8 in. x 9 1/2 in.
col2_sortorder 2526
col3 [empty string]
color_swatch 183-87-41.jpg
cost 7.34
deal_of_the_week NO
description copper, no. 10 4 1/8 in. x 9 1/2 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 18608
list_price 14.16
map NO
mfr_num 9971024
net_weight 0.4
non_member_discount 15
non_member_price 12.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 18608
sku_pix NO
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 8.5
ta_price 11.3
text
array
1 18608
2 9971024
3 copper, no. 10 4 1/8 in. x 9 1/2 in.
timestamp 2015-03-31T17:52:50.499Z
vip_member_price 10.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 copper
col1_sortorder 1529
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 183-87-41.jpg
cost 6.67
deal_of_the_week NO
description copper, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 19965
list_price 12.87
map NO
mfr_num 9971018
net_weight 0.4
non_member_discount 15
non_member_price 10.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 19965
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.72
ta_dealer_c_price 7.72
ta_price 10.54
text
array
1 19965
2 9971018
3 copper, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:52:53.131Z
vip_member_price 9.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 copper
col1_sortorder 1529
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 183-87-41.jpg
cost 4.05
deal_of_the_week NO
description copper, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 26371
list_price 7.81
map NO
mfr_num 9971014
net_weight 0.2
non_member_discount 15
non_member_price 6.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 26371
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.69
ta_dealer_c_price 4.69
ta_price 6.98
text
array
1 26371
2 9971014
3 copper, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:53:03.406Z
vip_member_price 5.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 coral
col1_sortorder 1545
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 231-217-208.jpg
cost 4.12
deal_of_the_week NO
description coral, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id P0238
list_price 7.95
map NO
mfr_num AXP0238
net_weight 0.12
non_member_discount 15
non_member_price 6.76
prop65 NO
ship_rule_desc STD
shipping STD
sku P0238
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.77
ta_dealer_c_price 4.77
ta_price 6.98
text
array
1 P0238
2 AXP0238
3 coral, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:55:01.45Z
vip_member_price 5.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 coral
col1_sortorder 1545
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 231-217-208.jpg
cost 6.17
deal_of_the_week NO
description coral, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id P0457
list_price 11.91
map NO
mfr_num AXP0457
net_weight 0.4
non_member_discount 15
non_member_price 10.12
prop65 NO
ship_rule_desc STD
shipping STD
sku P0457
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.15
ta_dealer_c_price 7.15
ta_price 10.54
text
array
1 P0457
2 AXP0457
3 coral, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:55:01.475Z
vip_member_price 8.93

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 coral
col1_sortorder 1545
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 231-217-208.jpg
cost 5.49
deal_of_the_week NO
description coral, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id P0458
list_price 10.59
map NO
mfr_num AXP0458
net_weight 0.26
non_member_discount 15
non_member_price 9
prop65 NO
ship_rule_desc STD
shipping STD
sku P0458
sku_pix NO
supplier_id 1
ta_dealer_a_price 6.35
ta_dealer_c_price 6.35
ta_price 8.19
text
array
1 P0458
2 AXP0458
3 coral, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:55:01.478Z
vip_member_price 7.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 crystal
col1_sortorder 1627
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 239-238-246.jpg
cost 4.33
deal_of_the_week NO
description crystal, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 17648
list_price 8.35
map NO
mfr_num 9971124
net_weight 0.26
non_member_discount 15
non_member_price 7.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 17648
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.01
ta_dealer_c_price 5.01
ta_price 8.19
text
array
1 17648
2 9971124
3 crystal, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:52:48.997Z
vip_member_price 6.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
barcode DYL75E
barcode_type UPC-RANDOM
col1 crystal
col1_sortorder 1627
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 239-238-246.jpg
cost 6.01
deal_of_the_week NO
description crystal, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 17789
list_price 11.6
map NO
mfr_num 9971126
net_weight 0.4
non_member_discount 15
non_member_price 9.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 17789
sku_pix NO
supplier_id 1
ta_dealer_a_price 6.96
ta_dealer_c_price 6.96
ta_price 10.54
text
array
1 17789
2 9971126
3 crystal, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:52:49.095Z
vip_member_price 8.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 crystal
col1_sortorder 1627
col2 no. 10 4 1/8 in. x 9 1/2 in.
col2_sortorder 2526
col3 [empty string]
color_swatch 239-238-246.jpg
cost 6.56
deal_of_the_week NO
description crystal, no. 10 4 1/8 in. x 9 1/2 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 19151
list_price 12.66
map NO
mfr_num 9971132
net_weight 0.4
non_member_discount 15
non_member_price 10.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 19151
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.6
ta_dealer_c_price 7.6
ta_price 11.3
text
array
1 19151
2 9971132
3 crystal, no. 10 4 1/8 in. x 9 1/2 in.
timestamp 2015-03-31T17:52:51.699Z
vip_member_price 9.5

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 crystal
col1_sortorder 1627
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 239-238-246.jpg
cost 3.9
deal_of_the_week NO
description crystal, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 20517
list_price 7.53
map NO
mfr_num 9971122
net_weight 0.2
non_member_discount 15
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 20517
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.52
ta_dealer_c_price 4.52
ta_price 6.98
text
array
1 20517
2 9971122
3 crystal, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:52:54.043Z
vip_member_price 5.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 gold
col1_sortorder 2491
col2 no. 10 4 1/8 in. x 9 1/2 in.
col2_sortorder 2526
col3 [empty string]
color_swatch 232-196-108.jpg
cost 6.16
deal_of_the_week NO
description gold, no. 10 4 1/8 in. x 9 1/2 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 19588
list_price 11.88
map NO
mfr_num 9971036
net_weight 0.4
non_member_discount 15
non_member_price 10.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 19588
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.13
ta_dealer_c_price 7.13
ta_price 11.3
text
array
1 19588
2 9971036
3 gold, no. 10 4 1/8 in. x 9 1/2 in.
timestamp 2015-03-31T17:52:52.359Z
vip_member_price 8.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 gold
col1_sortorder 2491
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 232-196-108.jpg
cost 5.55
deal_of_the_week NO
description gold, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 28274
list_price 10.71
map NO
mfr_num 9971030
net_weight 0.4
non_member_discount 15
non_member_price 9.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 28274
sku_pix NO
supplier_id 1
ta_dealer_a_price 6.43
ta_dealer_c_price 6.43
ta_price 10.54
text
array
1 28274
2 9971030
3 gold, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:53:05.345Z
vip_member_price 8.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 gold
col1_sortorder 2491
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 232-196-108.jpg
cost 4.39
deal_of_the_week NO
description gold, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 31510
list_price 8.47
map NO
mfr_num 9971026
net_weight 0.2
non_member_discount 15
non_member_price 7.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 31510
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 5.08
ta_price 6.98
text
array
1 31510
2 9971026
3 gold, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:53:09.942Z
vip_member_price 6.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 gold
col1_sortorder 2491
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 232-196-108.jpg
cost 4.78
deal_of_the_week NO
description gold, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 32446
list_price 9.22
map NO
mfr_num 9971028
net_weight 0.26
non_member_discount 15
non_member_price 7.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 32446
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.53
ta_dealer_c_price 5.53
ta_price 8.19
text
array
1 32446
2 9971028
3 gold, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:53:11.154Z
vip_member_price 6.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 jupiter
col1_sortorder 3180
col2 A1 3 5/8 in. x 5 1/8 in.
col2_sortorder 2405
col3 [empty string]
color_swatch 189-51-77.jpg
cost 4.36
deal_of_the_week NO
description jupiter, A1 3 5/8 in. x 5 1/8 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 19912
list_price 8.4
map NO
mfr_num 9971086
net_weight 0.2
non_member_discount 15
non_member_price 7.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 19912
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 5.04
ta_price 6.98
text
array
1 19912
2 9971086
3 jupiter, A1 3 5/8 in. x 5 1/8 in.
timestamp 2015-03-31T17:52:52.896Z
vip_member_price 6.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 jupiter
col1_sortorder 3180
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 189-51-77.jpg
cost 5.39
deal_of_the_week NO
description jupiter, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 22459
list_price 10.4
map NO
mfr_num 9971088
net_weight 0.26
non_member_discount 15
non_member_price 8.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 22459
sku_pix NO
supplier_id 1
ta_dealer_a_price 6.24
ta_dealer_c_price 6.24
ta_price 8.19
text
array
1 22459
2 9971088
3 jupiter, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:52:58.045Z
vip_member_price 7.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 jupiter
col1_sortorder 3180
col2 A7 5 1/4 in. x 7 1/4 in.
col2_sortorder 2411
col3 [empty string]
color_swatch 189-51-77.jpg
cost 6.67
deal_of_the_week NO
description jupiter, A7 5 1/4 in. x 7 1/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 31919
list_price 12.87
map NO
mfr_num 9971090
net_weight 0.4
non_member_discount 15
non_member_price 10.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 31919
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.72
ta_dealer_c_price 7.72
ta_price 10.54
text
array
1 31919
2 9971090
3 jupiter, A7 5 1/4 in. x 7 1/4 in.
timestamp 2015-03-31T17:53:10.447Z
vip_member_price 9.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 kunzite
col1_sortorder 3223
col2 no. 10 4 1/8 in. x 9 1/2 in.
col2_sortorder 2526
col3 [empty string]
color_swatch 205-188-220.jpg
cost 6.71
deal_of_the_week NO
description kunzite, no. 10 4 1/8 in. x 9 1/2 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 15032
list_price 12.94
map NO
mfr_num 9971108
net_weight 0.4
non_member_discount 15
non_member_price 11
prop65 NO
ship_rule_desc STD
shipping STD
sku 15032
sku_pix NO
supplier_id 1
ta_dealer_a_price 7.76
ta_dealer_c_price 7.76
ta_price 11.3
text
array
1 15032
2 9971108
3 kunzite, no. 10 4 1/8 in. x 9 1/2 in.
timestamp 2015-03-31T17:52:45.38Z
vip_member_price 9.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000

struct
FLAGS 0
VIP_member_discount 25
col1 kunzite
col1_sortorder 3223
col2 A2 4 3/8 in. x 5 3/4 in.
col2_sortorder 2407
col3 [empty string]
color_swatch 205-188-220.jpg
cost 5.04
deal_of_the_week NO
description kunzite, A2 4 3/8 in. x 5 3/4 in.
group_id 6288
group_uname stardream-metallic-envelopes
id 19648
list_price 9.72
map NO
mfr_num 9971100
net_weight 0.26
non_member_discount 15
non_member_price 8.26
prop65 NO
ship_rule_desc STD
shipping STD
sku 19648
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.83
ta_dealer_c_price 5.83
ta_price 8.19
text
array
1 19648
2 9971100
3 kunzite, A2 4 3/8 in. x 5 3/4 in.
timestamp 2015-03-31T17:52:52.393Z
vip_member_price 7.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 54564
CACHED false
EXECUTIONTIME 4
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] = '6762' 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.145.180.58

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e0309171583226e3bcc6367b6a7722c6d591
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=clip-art&CatC=sort~1~fb~dover~fp~0-16~&gr=dover-treasury-of-ironwork-designs.html
urltoken CFID=30578377&CFTOKEN=20127202&jsessionid=e0309171583226e3bcc6367b6a7722c6d591
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:30:22'}
sessionid e030f37291d58c28f3006a52c2d794c437d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&gr=stardream-metallic-envelopes.html
urltoken CFID=30578375&CFTOKEN=95386076&jsessionid=e030f37291d58c28f3006a52c2d794c437d4
validationerror [empty string]


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

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

ItemIDList: 54564
AvailQtyList: 12.000000000000,22.000000000000,5.000000000000,11.000000000000,5.000000000000,14.000000000000,3.000000000000,10.000000000000,6.000000000000,9.000000000000,21.000000000000,21.000000000000,12.000000000000,14.000000000000,0E-12,3.000000000000,20.000000000000,15.000000000000,11.000000000000,16.000000000000,2.000000000000,22.000000000000,29.000000000000,9.000000000000,19.000000000000,15.000000000000,15.000000000000,15.000000000000,17.000000000000,19.000000000000,11.000000000000,18.000000000000,9.000000000000,11.000000000000,7.000000000000,28.000000000000,13.000000000000,20.000000000000,11.000000000000,15.000000000000,7.000000000000,25.000000000000,19.000000000000,21.000000000000,15.000000000000,15.000000000000,1.000000000000,19.000000000000,23.000000000000,8.000000000000,18.000000000000,0E-12,56.000000000000