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

500 Series Art Books

by Lark


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579907570
barcode_type EAN
col1 Animals in Clay
col1_sortorder 266
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Animals in Clay
group_id 4509
group_uname lark-500-series-art-books
id 73741
list_price 24.95
map NO
mfr_num 9781579907570
net_weight 2.56
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 73741
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 73741
2 9781579907570
3 Animals in Clay
timestamp 2015-04-01T21:27:11.564Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600590580
barcode_type EAN
col1 Art Quilts
col1_sortorder 334
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Art Quilts
group_id 4509
group_uname lark-500-series-art-books
id 43968
list_price 24.95
map NO
mfr_num 9781600590580
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 43968
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 43968
2 9781600590580
3 Art Quilts
timestamp 2015-04-01T21:26:17.239Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 1579904807
barcode_type ISBN10
col1 Bracelets
col1_sortorder 479
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Bracelets
group_id 4509
group_uname lark-500-series-art-books
id 32355
list_price 24.95
map NO
mfr_num 9781579904807
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 32355
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 32355
2 9781579904807
3 Bracelets
timestamp 2015-04-01T21:25:59.572Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600592478
barcode_type EAN
col1 Ceramic Sculptures
col1_sortorder 585
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Ceramic Sculptures
group_id 4509
group_uname lark-500-series-art-books
id 42144
list_price 24.95
map NO
mfr_num 9781600592478
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 42144
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 42144
2 9781600592478
3 Ceramic Sculptures
timestamp 2015-04-01T21:26:15.579Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908720
barcode_type EAN
col1 Chairs
col1_sortorder 590
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Chairs
group_id 4509
group_uname lark-500-series-art-books
id 95023
list_price 24.95
map NO
mfr_num 9781579908720
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 95023
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 95023
2 9781579908720
3 Chairs
timestamp 2015-04-01T21:27:36.606Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908232
barcode_type EAN
col1 Earrings
col1_sortorder 1032
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Earrings
group_id 4509
group_uname lark-500-series-art-books
id 15972
list_price 24.95
map NO
mfr_num 9781579908232
net_weight 2.45
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 15972
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 15972
2 9781579908232
3 Earrings
timestamp 2015-04-01T21:25:38.065Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600593451
barcode_type EAN
col1 Enameled Objects
col1_sortorder 1066
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Enameled Objects
group_id 4509
group_uname lark-500-series-art-books
id 43422
list_price 24.95
map NO
mfr_num 9781600593451
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 43422
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 43422
2 9781600593451
3 Enameled Objects
timestamp 2015-04-01T21:26:16.854Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600593413
barcode_type EAN
col1 Gemstone Jewels
col1_sortorder 1343
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Gemstone Jewels
group_id 4509
group_uname lark-500-series-art-books
id 43969
list_price 24.95
map NO
mfr_num 9781600593413
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 43969
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 43969
2 9781600593413
3 Gemstone Jewels
timestamp 2015-04-01T21:26:17.244Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579906931
barcode_type EAN
col1 Glass Objects
col1_sortorder 1374
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Glass Objects
group_id 4509
group_uname lark-500-series-art-books
id 59800
list_price 24.95
map NO
mfr_num 9781579906931
net_weight 2.41
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 59800
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 59800
2 9781579906931
3 Glass Objects
timestamp 2015-04-01T21:26:40.67Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908775
barcode_type EAN
col1 Handmade Books
col1_sortorder 1448
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Handmade Books
group_id 4509
group_uname lark-500-series-art-books
id 95017
list_price 24.95
map NO
mfr_num 9781579908775
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 95017
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 95017
2 9781579908775
3 Handmade Books
timestamp 2015-04-01T21:27:36.602Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908676
barcode_type EAN
col1 Handmade Dolls
col1_sortorder 1451
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Handmade Dolls
group_id 4509
group_uname lark-500-series-art-books
id 90046
list_price 24.95
map NO
mfr_num 9781579908676
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 90046
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 90046
2 9781579908676
3 Handmade Dolls
timestamp 2015-04-01T21:27:29.682Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908768
barcode_type EAN
col1 Metal Vessels
col1_sortorder 1935
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Metal Vessels
group_id 4509
group_uname lark-500-series-art-books
id 90047
list_price 24.95
map NO
mfr_num 9781579908768
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 90047
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 90047
2 9781579908768
3 Metal Vessels
timestamp 2015-04-01T21:27:29.687Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579907013
barcode_type EAN
col1 Necklaces
col1_sortorder 2050
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Necklaces
group_id 4509
group_uname lark-500-series-art-books
id 13368
list_price 24.95
map NO
mfr_num 9781579907013
net_weight 2.54
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 13368
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 13368
2 9781579907013
3 Necklaces
timestamp 2015-04-01T21:25:32.336Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781454703303
barcode_type EAN
col1 Paper Objects
col1_sortorder 2196
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Paper Objects
group_id 4509
group_uname lark-500-series-art-books
id 01901
list_price 24.95
map NO
mfr_num 9781454703303
net_weight 2.56
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 01901
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 01901
2 9781454703303
3 Paper Objects
timestamp 2015-04-01T21:25:04.655Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600590382
barcode_type EAN
col1 Pendants & Lockets
col1_sortorder 2236
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Pendants & Lockets
group_id 4509
group_uname lark-500-series-art-books
id 94855
list_price 24.95
map NO
mfr_num 9781600590382
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 94855
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 94855
2 9781600590382
3 Pendants & Lockets
timestamp 2015-04-01T21:27:35.789Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579906870
barcode_type EAN
col1 Pitchers
col1_sortorder 2265
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Pitchers
group_id 4509
group_uname lark-500-series-art-books
id 38552
list_price 24.95
map NO
mfr_num 9781579906870
net_weight 1.16
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 38552
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 38552
2 9781579906870
3 Pitchers
timestamp 2015-04-01T21:26:12.543Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579906887
barcode_type EAN
col1 Plates & Chargers
col1_sortorder 2268
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Plates & Chargers
group_id 4509
group_uname lark-500-series-art-books
id 95018
list_price 24.95
map NO
mfr_num 9781579906887
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 95018
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 95018
2 9781579906887
3 Plates & Chargers
timestamp 2015-04-01T21:27:36.604Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781454703310
barcode_type EAN
col1 Prints on Clay
col1_sortorder 2311
col2 [empty string]
col3 [empty string]
cost 12.18
deal_of_the_week NO
description Prints on Clay
group_id 4509
group_uname lark-500-series-art-books
id 01893
list_price 19.95
map NO
mfr_num 9781454703310
net_weight 2.5
non_member_discount 10
non_member_price 17.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 01893
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.96
ta_dealer_c_price 14.96
ta_price 19.95
text
array
1 01893
2 9781454703310
3 Prints on Clay
timestamp 2015-04-01T21:25:04.633Z
vip_member_price 15.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781454702887
barcode_type EAN
col1 rings
col1_sortorder 2367
col2 [empty string]
col3 [empty string]
cost 17.06
deal_of_the_week NO
description rings
group_id 4509
group_uname lark-500-series-art-books
id 46836
list_price 27.95
map NO
mfr_num 9781454702887
net_weight 2.53
non_member_discount 10
non_member_price 25.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 46836
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.96
ta_dealer_c_price 20.96
ta_price 27.95
text
array
1 46836
2 9781454702887
3 rings
timestamp 2015-04-01T21:26:21.549Z
vip_member_price 22.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579907143
barcode_type EAN
col1 Tiles
col1_sortorder 2766
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Tiles
group_id 4509
group_uname lark-500-series-art-books
id 90048
list_price 24.95
map NO
mfr_num 9781579907143
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 90048
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 90048
2 9781579907143
3 Tiles
timestamp 2015-04-01T21:27:29.69Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600592461
barcode_type EAN
col1 Vases
col1_sortorder 2842
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description Vases
group_id 4509
group_uname lark-500-series-art-books
id 44856
list_price 24.95
map NO
mfr_num 9781600592461
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 44856
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 44856
2 9781600592461
3 Vases
timestamp 2015-04-01T21:26:18.877Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


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

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

ItemIDList: 17835,31302,35802,45685,60780,85802,86188
AvailQtyList: 19.000000000000,1.000000000000,8.000000000000,5.000000000000,44.000000000000,36.000000000000,3.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600590542
barcode_type EAN
col1 wedding rings
col1_sortorder 2907
col2 [empty string]
col3 [empty string]
cost 15.23
deal_of_the_week NO
description wedding rings
group_id 4509
group_uname lark-500-series-art-books
id 90049
list_price 24.95
map NO
mfr_num 9781600590542
net_weight 2.55
non_member_discount 10
non_member_price 22.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 90049
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.71
ta_dealer_c_price 18.71
ta_price 24.95
text
array
1 90049
2 9781600590542
3 wedding rings
timestamp 2015-04-01T21:27:29.692Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 19.000000000000 17835
2 1.000000000000 31302
3 8.000000000000 35802
4 5.000000000000 45685
5 44.000000000000 60780
6 36.000000000000 85802
7 3.000000000000 86188
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8703' 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.226.10.234

URL: www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e0303dd0df0583c35baa5462177b37138537
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fp~8-13~&gr=rapidesign-engineers-drafting-and-design-templates.html
urltoken CFID=30865373&CFTOKEN=89576140&jsessionid=e0303dd0df0583c35baa5462177b37138537
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 18:14:09'}
sessionid e030ed7f9e58e68c599576112a292522f324
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~8-31~&gr=lark-500-series-art-books.html
urltoken CFID=30865374&CFTOKEN=29475630&jsessionid=e030ed7f9e58e68c599576112a292522f324
validationerror [empty string]


One of Lark's most distinctive and popular lines, this is the series lovers of fine craftsmanship rave about. it provides an overview of the best contemporary work in fields such as ceramics, jewelry making, woodworking, and more. Each book is juried by an expert, features informative introductory text, and showcases spectacular images of state-of-the-art work. With an international roster of contributors that includes both established names and up-and-coming craftspeople, each volume spotlights the shared and divergent approaches taken by artists who are producing visionary work. Filled with lavish photographs, these gorgeous books inspire crafters and collectors, artists and aficionados--anyone who enjoys celebrating the creative spirit. Publisher: Lark.

Share on Facebook Twitter Pinterest

Ask a question about 500 Series Art Books Ask a question about this product

500 Series Art Books

by Lark









  Item# Image title
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
73741
500 Series Art Books Animals in Clay
Zoom Image
Animals in Clay 9781579907570 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
43968
500 Series Art Books Art Quilts
Zoom Image
Art Quilts 9781600590580 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
32355
500 Series Art Books Bracelets
Zoom Image
Bracelets 9781579904807 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
42144
500 Series Art Books Ceramic Sculptures
Zoom Image
Ceramic Sculptures 9781600592478 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
95023
500 Series Art Books Chairs
Zoom Image
Chairs 9781579908720 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
15972
500 Series Art Books Earrings
Zoom Image
Earrings 9781579908232 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
43422
500 Series Art Books Enameled Objects
Zoom Image
Enameled Objects 9781600593451 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
43969
500 Series Art Books Gemstone Jewels
Zoom Image
Gemstone Jewels 9781600593413 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
59800
500 Series Art Books Glass Objects
Zoom Image
Glass Objects 9781579906931 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
95017
500 Series Art Books Handmade Books
Zoom Image
Handmade Books 9781579908775 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
90046
500 Series Art Books Handmade Dolls
Zoom Image
Handmade Dolls 9781579908676 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
90047
500 Series Art Books Metal Vessels
Zoom Image
Metal Vessels 9781579908768 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
13368
500 Series Art Books Necklaces
Zoom Image
Necklaces 9781579907013 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
01901
500 Series Art Books Paper Objects
Zoom Image
Paper Objects 9781454703303 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
94855
500 Series Art Books Pendants & Lockets
Zoom Image
Pendants & Lockets 9781600590382 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
38552
500 Series Art Books Pitchers
Zoom Image
Pitchers 9781579906870 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
95018
500 Series Art Books Plates & Chargers
Zoom Image
Plates & Chargers 9781579906887 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
01893
500 Series Art Books Prints on Clay
Zoom Image
Prints on Clay 9781454703310 $19.95 $17.96 10% Off $15.96 20% Off Email When In Stock
Add to Favorites
46836
500 Series Art Books rings
Zoom Image
rings 9781454702887 $27.95 $25.16 10% Off $22.36 20% Off Email When In Stock
Add to Favorites
90048
500 Series Art Books Tiles
Zoom Image
Tiles 9781579907143 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
44856
500 Series Art Books Vases
Zoom Image
Vases 9781600592461 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock
Add to Favorites
90049
500 Series Art Books wedding rings
Zoom Image
wedding rings 9781600590542 $24.95 $22.46 10% Off $19.96 20% Off Email When In Stock

Click the to add item to your Favorites.



Please wait...
You May Also Like...

Incising Tool

by Kemper

Ceramics essentials

From $1.97

Silver Leaf

by Brambilla

Made from genuine silver containing no gold or other alloys

From $24.68

Premo Premium Polymer Clay

by Sculpey

Easy to work and condition

From $1.68

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About 500 Series Art Books

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for 500 Series Art Books

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...