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

Mi-Teintes Tinted Paper

by Canson


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735503
barcode_type EAN
col1 anise
col1_sortorder 128
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 210-197-122.jpg
cost 1.13
deal_of_the_week NO
description anise, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 24638
list_price 2.85
map NO
mfr_num 100511273
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 24638
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 24638
2 100511273
3 anise, 19 in. x 25 in.
timestamp 2015-03-31T17:53:00.334Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955733851
barcode_type EAN
col1 azure
col1_sortorder 283
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 183-197-240.jpg
cost 1.13
deal_of_the_week NO
description azure, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 65780
list_price 2.85
map NO
mfr_num 100511218
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 65780
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 65780
2 100511218
3 azure, 19 in. x 25 in.
timestamp 2015-03-31T17:54:09.366Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
col1 bisque
col1_sortorder 397
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 149-102-47.jpg
cost 1.13
deal_of_the_week NO
description bisque, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 42278
list_price 2.85
map NO
mfr_num 100511256
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 42278
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 42278
2 100511256
3 bisque, 19 in. x 25 in.
timestamp 2015-03-31T17:53:26.106Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736791
barcode_type EAN
col1 bisque
col1_sortorder 397
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 149-102-47.jpg
cost 0.31
deal_of_the_week NO
description bisque, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 66338
list_price 0.8
map NO
mfr_num 100511316
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 66338
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 66338
2 100511316
3 bisque, 8.5 in. x 11 in.
timestamp 2015-03-31T17:54:10.606Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736401
barcode_type EAN
col1 black
col1_sortorder 402
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.31
deal_of_the_week NO
description black, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 27955
list_price 0.8
map NO
mfr_num 100511303
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 27955
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 27955
2 100511303
3 black, 8.5 in. x 11 in.
timestamp 2015-03-31T17:53:05.126Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734605
barcode_type EAN
col1 black
col1_sortorder 402
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.13
deal_of_the_week NO
description black, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 42922
list_price 2.85
map NO
mfr_num 100511243
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 42922
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 42922
2 100511243
3 black, 19 in. x 25 in.
timestamp 2015-03-31T17:53:27.051Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735299
barcode_type EAN
col1 Bordeaux
col1_sortorder 663
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-157-138.jpg
cost 1.13
deal_of_the_week NO
description Bordeaux, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 87244
list_price 2.85
map NO
mfr_num 100511266
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 87244
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 87244
2 100511266
3 Bordeaux, 19 in. x 25 in.
timestamp 2015-03-31T17:54:40.559Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734513
barcode_type EAN
col1 buff
col1_sortorder 844
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-202-183.jpg
cost 1.13
deal_of_the_week NO
description buff, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 69760
list_price 2.85
map NO
mfr_num 100511240
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 69760
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 69760
2 100511240
3 buff, 19 in. x 25 in.
timestamp 2015-03-31T17:54:17.318Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735022
barcode_type EAN
col1 burgundy
col1_sortorder 850
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 119-0-96.jpg
cost 1.13
deal_of_the_week NO
description burgundy, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 17517
list_price 2.85
map NO
mfr_num 100511257
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 17517
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 17517
2 100511257
3 burgundy, 19 in. x 25 in.
timestamp 2015-03-31T17:52:48.865Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736821
barcode_type EAN
col1 burgundy
col1_sortorder 850
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 119-0-96.jpg
cost 0.31
deal_of_the_week NO
description burgundy, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 25548
list_price 0.8
map NO
mfr_num 100511317
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 25548
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 25548
2 100511317
3 burgundy, 8.5 in. x 11 in.
timestamp 2015-03-31T17:53:01.696Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736975
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 240-229-92.jpg
cost 0.31
deal_of_the_week NO
description cadmium yellow deep, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 21891
list_price 0.8
map NO
mfr_num 100511322
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 21891
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 21891
2 100511322
3 cadmium yellow deep, 8.5 in. x 11 in.
timestamp 2015-03-31T17:52:56.593Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735176
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-229-92.jpg
cost 1.13
deal_of_the_week NO
description cadmium yellow deep, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 41077
list_price 2.85
map NO
mfr_num 100511262
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 41077
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 41077
2 100511262
3 cadmium yellow deep, 19 in. x 25 in.
timestamp 2015-03-31T17:53:24.464Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736340
barcode_type EAN
col1 canary
col1_sortorder 1058
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 241-255-122.jpg
cost 0.31
deal_of_the_week NO
description canary, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 33063
list_price 0.8
map NO
mfr_num 100511301
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 33063
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 33063
2 100511301
3 canary, 8.5 in. x 11 in.
timestamp 2015-03-31T17:53:13.876Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
col1 canary
col1_sortorder 1058
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 241-255-122.jpg
cost 1.13
deal_of_the_week NO
description canary, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 57933
list_price 2.85
map NO
mfr_num 100511241
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 57933
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 57933
2 100511241
3 canary, 19 in. x 25 in.
timestamp 2015-03-31T17:53:51.718Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734780
barcode_type EAN
col1 champagne
col1_sortorder 1176
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-219-183.jpg
cost 1.13
deal_of_the_week NO
description champagne, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 88069
list_price 2.85
map NO
mfr_num 100511249
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 88069
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 88069
2 100511249
3 champagne, 19 in. x 25 in.
timestamp 2015-03-31T17:54:41.483Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736371
barcode_type EAN
col1 cream
col1_sortorder 1595
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 240-240-183.jpg
cost 0.31
deal_of_the_week NO
description cream, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 14851
list_price 0.8
map NO
mfr_num 100511302
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 14851
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 14851
2 100511302
3 cream, 8.5 in. x 11 in.
timestamp 2015-03-31T17:52:44.557Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
col1 cream
col1_sortorder 1595
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-240-183.jpg
cost 1.13
deal_of_the_week NO
description cream, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 42224
list_price 2.85
map NO
mfr_num 100511242
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 42224
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 42224
2 100511242
3 cream, 19 in. x 25 in.
timestamp 2015-03-31T17:53:26.052Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734360
barcode_type EAN
col1 dark gray
col1_sortorder 1709
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 105-105-105.jpg
cost 1.13
deal_of_the_week NO
description dark gray, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 16715
list_price 2.85
map NO
mfr_num 100511235
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 16715
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 16715
2 100511235
3 dark gray, 19 in. x 25 in.
timestamp 2015-03-31T17:52:47.984Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736166
barcode_type EAN
col1 dark gray
col1_sortorder 1709
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 105-105-105.jpg
cost 0.31
deal_of_the_week NO
description dark gray, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 32225
list_price 0.8
map NO
mfr_num 100511295
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 32225
sku_pix NO
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 32225
2 100511295
3 dark gray, 8.5 in. x 11 in.
timestamp 2015-03-31T17:53:10.98Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955733882
barcode_type EAN
col1 dawn pink
col1_sortorder 1783
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-214-183.jpg
cost 1.13
deal_of_the_week NO
description dawn pink, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 16800
list_price 2.85
map NO
mfr_num 100511219
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 16800
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 16800
2 100511219
3 dawn pink, 19 in. x 25 in.
timestamp 2015-03-31T17:52:48.079Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734001
barcode_type EAN
col1 egg shell
col1_sortorder 2008
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 251-255-213.jpg
cost 1.13
deal_of_the_week NO
description egg shell, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 16709
list_price 2.85
map NO
mfr_num 100511223
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 16709
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 16709
2 100511223
3 egg shell, 19 in. x 25 in.
timestamp 2015-03-31T17:52:47.975Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734667
barcode_type EAN
col1 felt gray
col1_sortorder 2113
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 120-120-120.jpg
cost 1.13
deal_of_the_week NO
description felt gray, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 87142
list_price 2.85
map NO
mfr_num 100511245
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 87142
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 87142
2 100511245
3 felt gray, 19 in. x 25 in.
timestamp 2015-03-31T17:54:40.499Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736463
barcode_type EAN
col1 felt grey
col1_sortorder 2115
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 120-120-120.jpg
cost 0.31
deal_of_the_week NO
description felt grey, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 41970
list_price 0.8
map NO
mfr_num 100511305
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 41970
sku_pix NO
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 41970
2 100511305
3 felt grey, 8.5 in. x 11 in.
timestamp 2015-03-31T17:53:25.851Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735862
barcode_type EAN
col1 flannel grey
col1_sortorder 2177
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 150-150-150.jpg
cost 0.31
deal_of_the_week NO
description flannel grey, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 48467
list_price 0.8
map NO
mfr_num 100511285
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 48467
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 48467
2 100511285
3 flannel grey, 8.5 in. x 11 in.
timestamp 2015-03-31T17:53:34.955Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734063
barcode_type EAN
col1 flannel grey
col1_sortorder 2177
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 150-150-150.jpg
cost 1.13
deal_of_the_week NO
description flannel grey, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 71382
list_price 2.85
map NO
mfr_num 100511225
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 71382
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 71382
2 100511225
3 flannel grey, 19 in. x 25 in.
timestamp 2015-03-31T17:54:21.113Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736616
barcode_type EAN
col1 green
col1_sortorder 2626
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 122-210-122.jpg
cost 0.31
deal_of_the_week NO
description green, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 66340
list_price 0.8
map NO
mfr_num 100511310
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 66340
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 66340
2 100511310
3 green, 8.5 in. x 11 in.
timestamp 2015-03-31T17:54:10.617Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734810
barcode_type EAN
col1 green
col1_sortorder 2626
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 122-210-122.jpg
cost 1.13
deal_of_the_week NO
description green, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 74678
list_price 2.85
map NO
mfr_num 100511250
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 74678
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 74678
2 100511250
3 green, 19 in. x 25 in.
timestamp 2015-03-31T17:54:26.654Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734483
barcode_type EAN
col1 hemp
col1_sortorder 2794
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-208-183.jpg
cost 1.13
deal_of_the_week NO
description hemp, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 77447
list_price 2.85
map NO
mfr_num 100511239
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 77447
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 77447
2 100511239
3 hemp, 19 in. x 25 in.
timestamp 2015-03-31T17:54:29.837Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734391
barcode_type EAN
col1 honeysuckle
col1_sortorder 2842
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-208-183.jpg
cost 1.13
deal_of_the_week NO
description honeysuckle, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 12711
list_price 2.85
map NO
mfr_num 100511236
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 12711
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 12711
2 100511236
3 honeysuckle, 19 in. x 25 in.
timestamp 2015-03-31T17:52:39.073Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735350
barcode_type EAN
col1 icy blue
col1_sortorder 2908
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 180-180-180.jpg
cost 1.13
deal_of_the_week NO
description icy blue, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 34550
list_price 2.85
map NO
mfr_num 100511268
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 34550
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 34550
2 100511268
3 icy blue, 19 in. x 25 in.
timestamp 2015-03-31T17:53:16.437Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734186
barcode_type EAN
col1 indigo blue
col1_sortorder 2954
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 47-47-149.jpg
cost 1.13
deal_of_the_week NO
description indigo blue, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 45888
list_price 2.85
map NO
mfr_num 100511229
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 45888
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 45888
2 100511229
3 indigo blue, 19 in. x 25 in.
timestamp 2015-03-31T17:53:31.3Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

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

ItemIDList: 28831
AvailQtyList: 7.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955733974
barcode_type EAN
col1 ivory
col1_sortorder 3124
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 255-252-213.jpg
cost 1.13
deal_of_the_week NO
description ivory, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 74641
list_price 2.85
map NO
mfr_num 100511222
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 74641
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 74641
2 100511222
3 ivory, 19 in. x 25 in.
timestamp 2015-03-31T17:54:26.594Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 28831
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5825' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030d3ddc4642f4c452342498a6967f1622c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fb~floracraft~&gr=floracraft-fun-learning-molecule-kit.html
urltoken CFID=30741816&CFTOKEN=13052491&jsessionid=e030d3ddc4642f4c452342498a6967f1622c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:14:05'}
sessionid e030928527af3bc3bc64331b7d341536e554
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=fb~canson~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30741815&CFTOKEN=38351418&jsessionid=e030928527af3bc3bc64331b7d341536e554
validationerror [empty string]


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

SOLR Query: h