#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: 66703
AvailQtyList: 10.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-03-27T14:48:03.894Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:47:16.489Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:46:58.316Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:47:14.609Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:48:35.037Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:46:35.055Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:47:16.065Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:47:16.491Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.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-03-27T14:47:36.935Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908775
barcode_type EAN
col1 Handmade Books
col1_sortorder 1447
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-03-27T14:48:35.025Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908676
barcode_type EAN
col1 Handmade Dolls
col1_sortorder 1450
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-03-27T14:48:24.787Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579908768
barcode_type EAN
col1 Metal Vessels
col1_sortorder 1932
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-03-27T14:48:24.79Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579907013
barcode_type EAN
col1 Necklaces
col1_sortorder 2047
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-03-27T14:46:28.819Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781454703303
barcode_type EAN
col1 Paper Objects
col1_sortorder 2193
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-03-27T14:46:03.194Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600590382
barcode_type EAN
col1 Pendants & Lockets
col1_sortorder 2232
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-03-27T14:48:34.523Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579906870
barcode_type EAN
col1 Pitchers
col1_sortorder 2261
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-03-27T14:47:10.716Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579906887
barcode_type EAN
col1 Plates & Chargers
col1_sortorder 2264
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-03-27T14:48:35.031Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781454703310
barcode_type EAN
col1 Prints on Clay
col1_sortorder 2307
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-03-27T14:46:03.148Z
vip_member_price 15.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781454702887
barcode_type EAN
col1 rings
col1_sortorder 2363
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-03-27T14:47:21.133Z
vip_member_price 22.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781579907143
barcode_type EAN
col1 Tiles
col1_sortorder 2762
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-03-27T14:48:24.794Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600592461
barcode_type EAN
col1 Vases
col1_sortorder 2838
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-03-27T14:47:17.545Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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: 66703
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9781600590542
barcode_type EAN
col1 wedding rings
col1_sortorder 2903
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-03-27T14:48:24.796Z
vip_member_price 19.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 66703
CACHED false
EXECUTIONTIME 12
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] = '3075' 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.163.89.150

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

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 12:41:42'}
sessionid e030147e7d0d2b30494d2012736f82611613
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=fp~20-9999.99~&gr=lark-500-series-art-books.html
urltoken CFID=29392088&CFTOKEN=40116243&jsessionid=e030147e7d0d2b30494d2012736f82611613
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...

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

Incising Tool

by Kemper

Ceramics essentials

From $1.97

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...