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

Origami Paper

by Aitoh


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161006053
barcode_type EAN
col1 2 3/8 in. x 2 3/8 in.
col1_sortorder 611
col2 yusen chiyogami washi
col2_sortorder 1303
col3 40 sheets
col3_sortorder 190
cost 4.27
deal_of_the_week NO
description 2 3/8 in. x 2 3/8 in., yusen chiyogami washi, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69544
list_price 8.75
map NO
mfr_num 83-0605
net_weight 0.04
non_member_discount 18
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 69544
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.25
ta_dealer_c_price 5.25
ta_price 7
text
array
1 69544
2 83-0605
3 2 3/8 in. x 2 3/8 in., yusen chiyogami washi, 40 sheets
timestamp 2015-03-27T14:47:54.516Z
vip_member_price 6.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867013615
barcode_type UPC
col1 10 assorted sizes
col1_sortorder 700
col2 10 assorted solid colors
col2_sortorder 1
col3 100 sheets
col3_sortorder 205
cost 2.87
deal_of_the_week NO
description 10 assorted sizes, 10 assorted solid colors, 100 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81195
list_price 5.88
map NO
mfr_num TS200
net_weight 0.19
non_member_discount 18
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 81195
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 4.7
text
array
1 81195
2 TS200
3 10 assorted sizes, 10 assorted solid colors, 100 sheets
timestamp 2015-03-27T14:48:12.102Z
vip_member_price 4.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867110352
barcode_type UPC
col1 3 in. x 3 in.
col1_sortorder 1481
col2 miyabi chiyogami
col2_sortorder 772
col3 300 sheets
col3_sortorder 211
cost 5.25
deal_of_the_week NO
description 3 in. x 3 in., miyabi chiyogami, 300 sheets
group_id 9561
group_uname aitoh-origami-paper
id 59557
list_price 10.75
map NO
mfr_num FLC3-300
net_weight 0.22
non_member_discount 18
non_member_price 8.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 59557
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.45
ta_dealer_c_price 6.45
ta_price 8.6
text
array
1 59557
2 FLC3-300
3 3 in. x 3 in., miyabi chiyogami, 300 sheets
timestamp 2015-03-27T14:47:36.176Z
vip_member_price 7.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867110345
barcode_type UPC
col1 3 in. x 3 in.
col1_sortorder 1481
col2 print chiyogami
col2_sortorder 928
col3 300 sheets
col3_sortorder 211
cost 4.03
deal_of_the_week NO
description 3 in. x 3 in., print chiyogami, 300 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69492
list_price 8.25
map NO
mfr_num PC3-300
net_weight 0.22
non_member_discount 18
non_member_price 6.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 69492
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.95
ta_dealer_c_price 4.95
ta_price 6.6
text
array
1 69492
2 PC3-300
3 3 in. x 3 in., print chiyogami, 300 sheets
timestamp 2015-03-27T14:47:54.442Z
vip_member_price 5.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014629
barcode_type UPC-RANDOM
col1 3 in. x 3 in.
col1_sortorder 1481
col2 assorted foil
col2_sortorder 70
col3 300 sheets
col3_sortorder 211
cost 6.34
deal_of_the_week NO
description 3 in. x 3 in., assorted foil, 300 sheets
group_id 9561
group_uname aitoh-origami-paper
id 71195
list_price 13
map NO
mfr_num CF-3-300
net_weight 0.2
non_member_discount 18
non_member_price 10.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 71195
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.8
ta_dealer_c_price 7.8
ta_price 10.4
text
array
1 71195
2 CF-3-300
3 3 in. x 3 in., assorted foil, 300 sheets
timestamp 2015-03-27T14:47:58.946Z
vip_member_price 9.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014148
barcode_type UPC
col1 4 1/2 in. x 4 1/2 in.
col1_sortorder 1737
col2 yusen chiyogami washi
col2_sortorder 1303
col3 40 sheets
col3_sortorder 190
cost 6.83
deal_of_the_week NO
description 4 1/2 in. x 4 1/2 in., yusen chiyogami washi, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69542
list_price 14
map NO
mfr_num YW-112
net_weight 0.08
non_member_discount 18
non_member_price 11.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 69542
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.4
ta_dealer_c_price 8.4
ta_price 11.2
text
array
1 69542
2 YW-112
3 4 1/2 in. x 4 1/2 in., yusen chiyogami washi, 40 sheets
timestamp 2015-03-27T14:47:54.512Z
vip_member_price 10.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867010706
barcode_type UPC
col1 4 1/2 in. x 4 1/2 in.
col1_sortorder 1737
col2 kimono and folk art washi
col2_sortorder 656
col3 40 sheets
col3_sortorder 190
cost 1.59
deal_of_the_week NO
description 4 1/2 in. x 4 1/2 in., kimono and folk art washi, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81188
list_price 3.25
map NO
mfr_num KM-1
net_weight 0.11
non_member_discount 18
non_member_price 2.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 81188
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.95
ta_dealer_c_price 1.95
ta_price 2.6
text
array
1 81188
2 KM-1
3 4 1/2 in. x 4 1/2 in., kimono and folk art washi, 40 sheets
timestamp 2015-03-27T14:48:11.891Z
vip_member_price 2.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867013585
barcode_type UPC
col1 4 in. x 4 in.
col1_sortorder 1777
col2 Aizome Chiyogami
col2_sortorder 29
col3 24 sheets
col3_sortorder 180
cost 6.04
deal_of_the_week NO
description 4 in. x 4 in., Aizome Chiyogami, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 28735
list_price 12.38
map NO
mfr_num YW-622
net_weight 0.06
non_member_discount 18
non_member_price 10.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 28735
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.43
ta_dealer_c_price 7.43
ta_price 9.9
text
array
1 28735
2 YW-622
3 4 in. x 4 in., Aizome Chiyogami, 24 sheets
timestamp 2015-03-27T14:46:52.434Z
vip_member_price 8.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867010904
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 Washi Chiyogami
col2_sortorder 1247
col3 24 sheets
col3_sortorder 180
cost 2.32
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., Washi Chiyogami, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 16313
list_price 4.75
map NO
mfr_num YZ-2
net_weight 0.14
non_member_discount 18
non_member_price 3.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 16313
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.85
ta_dealer_c_price 2.85
ta_price 3.8
text
array
1 16313
2 YZ-2
3 5 7/8 in. x 5 7/8 in., Washi Chiyogami, 24 sheets
timestamp 2015-03-27T14:46:35.726Z
vip_member_price 3.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867110239
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 tie dye
col2_sortorder 1162
col3 200 sheets
col3_sortorder 210
cost 6.1
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., tie dye, 200 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69491
list_price 12.5
map NO
mfr_num AI-1933/4-200
net_weight 0.53
non_member_discount 18
non_member_price 10.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 69491
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.5
ta_dealer_c_price 7.5
ta_price 10
text
array
1 69491
2 AI-1933/4-200
3 5 7/8 in. x 5 7/8 in., tie dye, 200 sheets
timestamp 2015-03-27T14:47:54.44Z
vip_member_price 9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161007319
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 kira chiyogami plum leaves
col2_sortorder 659
col3 12 sheets
col3_sortorder 176
cost 5.12
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., kira chiyogami plum leaves, 12 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69497
list_price 10.5
map NO
mfr_num 83-0731
net_weight 0.09
non_member_discount 18
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 69497
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.3
ta_dealer_c_price 6.3
ta_price 8.4
text
array
1 69497
2 83-0731
3 5 7/8 in. x 5 7/8 in., kira chiyogami plum leaves, 12 sheets
timestamp 2015-03-27T14:47:54.451Z
vip_member_price 7.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014216
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 diagonal stripes
col2_sortorder 355
col3 55 sheets
col3_sortorder 142
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., diagonal stripes, 55 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69534
list_price 6.13
map NO
mfr_num BKD200
net_weight 0.19
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 69534
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 69534
2 BKD200
3 5 7/8 in. x 5 7/8 in., diagonal stripes, 55 sheets
timestamp 2015-03-27T14:47:54.496Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014124
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 washi aya no chiyogami
col2_sortorder 1246
col3 24 sheets
col3_sortorder 180
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., washi aya no chiyogami, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69535
list_price 6.13
map NO
mfr_num WCAC200
net_weight 0.12
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 69535
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 69535
2 WCAC200
3 5 7/8 in. x 5 7/8 in., washi aya no chiyogami, 24 sheets
timestamp 2015-03-27T14:47:54.498Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161018872
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 double sided strawberries
col2_sortorder 368
col3 32 sheets
col3_sortorder 185
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., double sided strawberries, 32 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69536
list_price 6.13
map NO
mfr_num 23-1887
net_weight 0.15
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 69536
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 69536
2 23-1887
3 5 7/8 in. x 5 7/8 in., double sided strawberries, 32 sheets
timestamp 2015-03-27T14:47:54.5Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161015215
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 double sided harmony
col2_sortorder 367
col3 35 sheets
col3_sortorder 187
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., double sided harmony, 35 sheets
group_id 9561
group_uname aitoh-origami-paper
id 69540
list_price 6.13
map NO
mfr_num 23-1521
net_weight 0.16
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 69540
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 69540
2 23-1521
3 5 7/8 in. x 5 7/8 in., double sided harmony, 35 sheets
timestamp 2015-03-27T14:47:54.508Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014452
barcode_type UPC-RANDOM
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 single heart chiyogami
col2_sortorder 1044
col3 40 sheets
col3_sortorder 190
cost 3.23
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., single heart chiyogami, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 71141
list_price 6.63
map NO
mfr_num SHC200
net_weight 0.17
non_member_discount 18
non_member_price 5.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 71141
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.98
ta_dealer_c_price 3.98
ta_price 5.3
text
array
1 71141
2 SHC200
3 5 7/8 in. x 5 7/8 in., single heart chiyogami, 40 sheets
timestamp 2015-03-27T14:47:58.592Z
vip_member_price 4.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014421
barcode_type UPC-RANDOM
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 stars chiyogami
col2_sortorder 1088
col3 40 sheets
col3_sortorder 190
cost 3.23
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., stars chiyogami, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 71145
list_price 6.63
map NO
mfr_num STAR200
net_weight 0.14
non_member_discount 18
non_member_price 5.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 71145
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.98
ta_dealer_c_price 3.98
ta_price 5.3
text
array
1 71145
2 STAR200
3 5 7/8 in. x 5 7/8 in., stars chiyogami, 40 sheets
timestamp 2015-03-27T14:47:58.601Z
vip_member_price 4.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014476
barcode_type UPC-RANDOM
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 pines waves chiyogami
col2_sortorder 901
col3 40 sheets
col3_sortorder 190
cost 3.23
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., pines waves chiyogami, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 71158
list_price 6.63
map NO
mfr_num CPW200
net_weight 0.14
non_member_discount 18
non_member_price 5.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 71158
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.98
ta_dealer_c_price 3.98
ta_price 5.3
text
array
1 71158
2 CPW200
3 5 7/8 in. x 5 7/8 in., pines waves chiyogami, 40 sheets
timestamp 2015-03-27T14:47:58.831Z
vip_member_price 4.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014513
barcode_type UPC-RANDOM
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 robin joy pencil drawing
col2_sortorder 972
col3 40 sheets
col3_sortorder 190
cost 2.26
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., robin joy pencil drawing, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 71178
list_price 4.63
map NO
mfr_num RJR-05
net_weight 0.14
non_member_discount 18
non_member_price 3.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 71178
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.78
ta_dealer_c_price 2.78
ta_price 3.7
text
array
1 71178
2 RJR-05
3 5 7/8 in. x 5 7/8 in., robin joy pencil drawing, 40 sheets
timestamp 2015-03-27T14:47:58.891Z
vip_member_price 3.33

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161007265
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 kasane hemp
col2_sortorder 650
col3 12 sheets
col3_sortorder 176
cost 5.12
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., kasane hemp, 12 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81168
list_price 10.5
map NO
mfr_num 83-0726
net_weight 0.09
non_member_discount 18
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 81168
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.3
ta_dealer_c_price 6.3
ta_price 8.4
text
array
1 81168
2 83-0726
3 5 7/8 in. x 5 7/8 in., kasane hemp, 12 sheets
timestamp 2015-03-27T14:48:11.823Z
vip_member_price 7.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161007258
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 kasane plum blossom
col2_sortorder 651
col3 12 sheets
col3_sortorder 176
cost 5.12
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., kasane plum blossom, 12 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81169
list_price 10.5
map NO
mfr_num 83-0725
net_weight 0.09
non_member_discount 18
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 81169
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.3
ta_dealer_c_price 6.3
ta_price 8.4
text
array
1 81169
2 83-0725
3 5 7/8 in. x 5 7/8 in., kasane plum blossom, 12 sheets
timestamp 2015-03-27T14:48:11.833Z
vip_member_price 7.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161007296
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 Yuzen Chiyogami
col2_sortorder 1304
col3 5 sheets
col3_sortorder 173
cost 5.12
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., Yuzen Chiyogami, 5 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81170
list_price 10.5
map NO
mfr_num YZA-300H
net_weight 0.07
non_member_discount 18
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 81170
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.3
ta_dealer_c_price 6.3
ta_price 8.4
text
array
1 81170
2 YZA-300H
3 5 7/8 in. x 5 7/8 in., Yuzen Chiyogami, 5 sheets
timestamp 2015-03-27T14:48:11.835Z
vip_member_price 7.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161019602
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 mosaic hearts and diamonds
col2_sortorder 791
col3 24 sheets
col3_sortorder 180
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., mosaic hearts and diamonds, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81173
list_price 6.13
map NO
mfr_num 23-1960
net_weight 0.13
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 81173
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 81173
2 23-1960
3 5 7/8 in. x 5 7/8 in., mosaic hearts and diamonds, 24 sheets
timestamp 2015-03-27T14:48:11.849Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161020561
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 magical move
col2_sortorder 730
col3 24 sheets
col3_sortorder 180
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., magical move, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81175
list_price 6.13
map NO
mfr_num 23-2056
net_weight 0.1
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 81175
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 81175
2 23-2056
3 5 7/8 in. x 5 7/8 in., magical move, 24 sheets
timestamp 2015-03-27T14:48:11.852Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867014162
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 bubble in water
col2_sortorder 204
col3 24 sheets
col3_sortorder 180
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., bubble in water, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81176
list_price 6.13
map NO
mfr_num NPO200
net_weight 0.1
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 81176
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 81176
2 NPO200
3 5 7/8 in. x 5 7/8 in., bubble in water, 24 sheets
timestamp 2015-03-27T14:48:11.858Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161007159
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 yuzen chiyogami washi
col2_sortorder 1305
col3 5 sheets
col3_sortorder 173
cost 5.12
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., yuzen chiyogami washi, 5 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81177
list_price 10.5
map NO
mfr_num 83-0715
net_weight 0.07
non_member_discount 18
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 81177
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.3
ta_dealer_c_price 6.3
ta_price 8.4
text
array
1 81177
2 83-0715
3 5 7/8 in. x 5 7/8 in., yuzen chiyogami washi, 5 sheets
timestamp 2015-03-27T14:48:11.86Z
vip_member_price 7.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867110376
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 saikai chiyogami fun
col2_sortorder 999
col3 48 sheets
col3_sortorder 193
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., saikai chiyogami fun, 48 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81179
list_price 6.13
map NO
mfr_num SRF200
net_weight 0.16
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 81179
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 81179
2 SRF200
3 5 7/8 in. x 5 7/8 in., saikai chiyogami fun, 48 sheets
timestamp 2015-03-27T14:48:11.866Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867013929
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 Washi Chiyogami
col2_sortorder 1247
col3 28 sheets
col3_sortorder 182
cost 2.56
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., Washi Chiyogami, 28 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81180
list_price 5.25
map NO
mfr_num WCF200
net_weight 0.12
non_member_discount 18
non_member_price 4.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 81180
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 3.15
ta_price 4.2
text
array
1 81180
2 WCF200
3 5 7/8 in. x 5 7/8 in., Washi Chiyogami, 28 sheets
timestamp 2015-03-27T14:48:11.868Z
vip_member_price 3.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161019268
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 ryomen chiyogami ichimatsu
col2_sortorder 995
col3 28 sheets
col3_sortorder 182
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., ryomen chiyogami ichimatsu, 28 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81183
list_price 6.13
map NO
mfr_num 23-1926
net_weight 0.13
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 81183
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 81183
2 23-1926
3 5 7/8 in. x 5 7/8 in., ryomen chiyogami ichimatsu, 28 sheets
timestamp 2015-03-27T14:48:11.874Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 762867013981
barcode_type UPC
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 print chiyogami
col2_sortorder 928
col3 40 sheets
col3_sortorder 190
cost 2.87
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., print chiyogami, 40 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81184
list_price 5.88
map NO
mfr_num AYC200
net_weight 0.15
non_member_discount 18
non_member_price 4.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 81184
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 4.7
text
array
1 81184
2 AYC200
3 5 7/8 in. x 5 7/8 in., print chiyogami, 40 sheets
timestamp 2015-03-27T14:48:11.879Z
vip_member_price 4.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161018513
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 double sided color flora
col2_sortorder 366
col3 32 sheets
col3_sortorder 185
cost 2.99
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., double sided color flora, 32 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81187
list_price 6.13
map NO
mfr_num 23-1851
net_weight 0.15
non_member_discount 18
non_member_price 5.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 81187
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.68
ta_price 4.9
text
array
1 81187
2 23-1851
3 5 7/8 in. x 5 7/8 in., double sided color flora, 32 sheets
timestamp 2015-03-27T14:48:11.888Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e030a91f3ff76228184b26b95f2766141d22
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html
urltoken CFID=29408636&CFTOKEN=21822072&jsessionid=e030a91f3ff76228184b26b95f2766141d22
validationerror [empty string]


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

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

ItemIDList: 25760
AvailQtyList: 23.000000000000

struct
FLAGS 0
VIP_member_discount 28
barcode 4901161019503
barcode_type EAN
col1 5 7/8 in. x 5 7/8 in.
col1_sortorder 1943
col2 miyabi chiyogami washi
col2_sortorder 773
col3 24 sheets
col3_sortorder 180
cost 4.27
deal_of_the_week NO
description 5 7/8 in. x 5 7/8 in., miyabi chiyogami washi, 24 sheets
group_id 9561
group_uname aitoh-origami-paper
id 81189
list_price 8.75
map NO
mfr_num 23-1950
net_weight 0.12
non_member_discount 18
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 81189
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.25
ta_dealer_c_price 5.25
ta_price 7
text
array
1 81189
2 23-1950
3 5 7/8 in. x 5 7/8 in., miyabi chiyogami washi, 24 sheets
timestamp 2015-03-27T14:48:11.894Z
vip_member_price 6.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 23.000000000000 25760
CACHED false
EXECUTIONTIME 1
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] = '587' 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.159.166.21

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=hobby-decorative-paper&CatC=sort~1~&gr=aitoh-origami-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 14:14:04'}
sessionid e03061a05d543c67998414515f14242f5c44
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=candle-making&CatC=fp~0-3~&gr=lundmark-pure-beeswax.html
urltoken CFID=29408635&CFTOKEN=84255934&jsessionid=e03061a05d543c67998414515f14242f5c44
validationerror [empty string]


EndSessionVariables: