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

Lumiere Artist Acrylics

by Jacquard


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154501
barcode_type UPC
col1 burgundy
col1_sortorder 849
col2 [empty string]
col3 [empty string]
color_swatch 119-0-96.jpg
cost 2.51
deal_of_the_week NO
description burgundy
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 10523
list_price 5.49
map NO
mfr_num JAC1545
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 10523
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 10523
2 JAC1545
3 burgundy
timestamp 2015-03-27T14:46:24.479Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154303
barcode_type UPC
col1 burnt orange
col1_sortorder 869
col2 [empty string]
col3 [empty string]
color_swatch 210-144-0.jpg
cost 2.51
deal_of_the_week NO
description burnt orange
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 27962
list_price 5.49
map NO
mfr_num JAC1543
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 27962
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 27962
2 JAC1543
3 burnt orange
timestamp 2015-03-27T14:46:51.411Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154204
barcode_type UPC
col1 citrine
col1_sortorder 1293
col2 [empty string]
col3 [empty string]
color_swatch 47-195-93.jpg
cost 2.51
deal_of_the_week NO
description citrine
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 61332
list_price 5.49
map NO
mfr_num JAC1542
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 61332
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 61332
2 JAC1542
3 citrine
timestamp 2015-03-27T14:47:40.727Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154402
barcode_type UPC
col1 crimson
col1_sortorder 1607
col2 [empty string]
col3 [empty string]
color_swatch 164-0-0.jpg
cost 2.51
deal_of_the_week NO
description crimson
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 85408
list_price 5.49
map NO
mfr_num JAC1544
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 85408
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 85408
2 JAC1544
3 crimson
timestamp 2015-03-27T14:48:16.441Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154600
barcode_type UPC
col1 grape
col1_sortorder 2571
col2 [empty string]
col3 [empty string]
color_swatch 140-0-164.jpg
cost 2.51
deal_of_the_week NO
description grape
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 86768
list_price 5.49
map NO
mfr_num JAC1546
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 86768
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 86768
2 JAC1546
3 grape
timestamp 2015-03-27T14:48:18.764Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157601
barcode_type UPC
col1 hi-lite blue
col1_sortorder 2794
col2 [empty string]
col3 [empty string]
color_swatch 77-120-255.jpg
cost 2.51
deal_of_the_week NO
description hi-lite blue
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 66794
list_price 5.49
map NO
mfr_num JAC1576
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 66794
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 66794
2 JAC1576
3 hi-lite blue
timestamp 2015-03-27T14:47:49.473Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157403
barcode_type UPC
col1 hi-lite red
col1_sortorder 2796
col2 [empty string]
col3 [empty string]
color_swatch 240-47-91.jpg
cost 2.51
deal_of_the_week NO
description hi-lite red
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 45625
list_price 5.49
map NO
mfr_num JAC1574
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 45625
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 45625
2 JAC1574
3 hi-lite red
timestamp 2015-03-27T14:47:18.697Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157502
barcode_type UPC
col1 hi-lite violet
col1_sortorder 2797
col2 [empty string]
col3 [empty string]
color_swatch 128-77-210.jpg
cost 2.51
deal_of_the_week NO
description hi-lite violet
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 62804
list_price 5.49
map NO
mfr_num JAC1575
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 62804
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 62804
2 JAC1575
3 hi-lite violet
timestamp 2015-03-27T14:47:42.535Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154709
barcode_type UPC
col1 indigo
col1_sortorder 2945
col2 [empty string]
col3 [empty string]
color_swatch 65-0-119.jpg
cost 2.51
deal_of_the_week NO
description indigo
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 49543
list_price 5.49
map NO
mfr_num JAC1547
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 49543
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 49543
2 JAC1547
3 indigo
timestamp 2015-03-27T14:47:24.106Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156505
barcode_type UPC
col1 metallic bronze
col1_sortorder 3693
col2 [empty string]
col3 [empty string]
color_swatch 164-115-77.jpg
cost 2.51
deal_of_the_week NO
description metallic bronze
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 21027
list_price 5.49
map NO
mfr_num JAC1565
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 21027
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 21027
2 JAC1565
3 metallic bronze
timestamp 2015-03-27T14:46:41.411Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156109
barcode_type UPC
col1 metallic gold
col1_sortorder 3703
col2 [empty string]
col3 [empty string]
color_swatch 195-174-47.jpg
cost 2.51
deal_of_the_week NO
description metallic gold
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 17797
list_price 5.49
map NO
mfr_num JAC1561
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 17797
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 17797
2 JAC1561
3 metallic gold
timestamp 2015-03-27T14:46:37.798Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156208
barcode_type UPC
col1 metallic olive green
col1_sortorder 3714
col2 [empty string]
col3 [empty string]
color_swatch 109-119-77.jpg
cost 2.51
deal_of_the_week NO
description metallic olive green
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 27492
list_price 5.49
map NO
mfr_num JAC1562
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 27492
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 27492
2 JAC1562
3 metallic olive green
timestamp 2015-03-27T14:46:50.713Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156604
barcode_type UPC
col1 metallic russet
col1_sortorder 3722
col2 [empty string]
col3 [empty string]
color_swatch 164-93-77.jpg
cost 2.51
deal_of_the_week NO
description metallic russet
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 23798
list_price 5.49
map NO
mfr_num JAC1566
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 23798
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 23798
2 JAC1566
3 metallic russet
timestamp 2015-03-27T14:46:45.049Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154907
barcode_type UPC
col1 metallic rust
col1_sortorder 3723
col2 [empty string]
col3 [empty string]
color_swatch 119-79-0.jpg
cost 2.51
deal_of_the_week NO
description metallic rust
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 12974
list_price 5.49
map NO
mfr_num JAC1549
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 12974
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 12974
2 JAC1549
3 metallic rust
timestamp 2015-03-27T14:46:28.29Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156307
barcode_type UPC
col1 metallic silver
col1_sortorder 3724
col2 [empty string]
col3 [empty string]
color_swatch 210-210-210.jpg
cost 2.51
deal_of_the_week NO
description metallic silver
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 69733
list_price 5.49
map NO
mfr_num JAC1563
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 69733
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 69733
2 JAC1563
3 metallic silver
timestamp 2015-03-27T14:47:54.826Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772154808
barcode_type UPC
col1 old brass
col1_sortorder 4126
col2 [empty string]
col3 [empty string]
color_swatch 164-146-0.jpg
cost 2.51
deal_of_the_week NO
description old brass
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 83484
list_price 5.49
map NO
mfr_num JAC1548
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 83484
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 83484
2 JAC1548
3 old brass
timestamp 2015-03-27T14:48:13.788Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157007
barcode_type UPC
col1 pearl blue
col1_sortorder 4451
col2 [empty string]
col3 [empty string]
color_swatch 0-0-164.jpg
cost 2.51
deal_of_the_week NO
description pearl blue
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 44588
list_price 5.49
map NO
mfr_num JAC1570
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 44588
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 44588
2 JAC1570
3 pearl blue
timestamp 2015-03-27T14:47:17.329Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157205
barcode_type UPC
col1 pearl emerald green
col1_sortorder 4457
col2 [empty string]
col3 [empty string]
color_swatch 92-195-162.jpg
cost 2.51
deal_of_the_week NO
description pearl emerald green
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 29692
list_price 5.49
map NO
mfr_num JAC1572
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 29692
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 29692
2 JAC1572
3 pearl emerald green
timestamp 2015-03-27T14:46:53.615Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157304
barcode_type UPC
col1 pearl magenta
col1_sortorder 4466
col2 [empty string]
col3 [empty string]
color_swatch 210-0-210.jpg
cost 2.51
deal_of_the_week NO
description pearl magenta
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 16179
list_price 5.49
map NO
mfr_num JAC1573
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 16179
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 16179
2 JAC1573
3 pearl magenta
timestamp 2015-03-27T14:46:35.627Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772157106
barcode_type UPC
col1 pearl turquoise
col1_sortorder 4477
col2 [empty string]
col3 [empty string]
color_swatch 138-211-240.jpg
cost 2.51
deal_of_the_week NO
description pearl turquoise
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 15659
list_price 5.49
map NO
mfr_num JAC1571
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 15659
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 15659
2 JAC1571
3 pearl turquoise
timestamp 2015-03-27T14:46:34.787Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156901
barcode_type UPC
col1 pearl violet
col1_sortorder 4478
col2 [empty string]
col3 [empty string]
color_swatch 99-47-149.jpg
cost 2.51
deal_of_the_week NO
description pearl violet
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 62437
list_price 5.49
map NO
mfr_num JAC1569
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 62437
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 62437
2 JAC1569
3 pearl violet
timestamp 2015-03-27T14:47:42.058Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156802
barcode_type UPC
col1 pearl white
col1_sortorder 4480
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 2.51
deal_of_the_week NO
description pearl white
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 38611
list_price 5.49
map NO
mfr_num JAC1568
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 38611
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 38611
2 JAC1568
3 pearl white
timestamp 2015-03-27T14:47:10.752Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772155102
barcode_type UPC
col1 pewter
col1_sortorder 4645
col2 [empty string]
col3 [empty string]
cost 2.51
deal_of_the_week NO
description pewter
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 01432
list_price 5.49
map NO
mfr_num JAC1551
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 01432
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.75
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 01432
2 JAC1551
3 pewter
timestamp 2015-03-27T14:46:01.442Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156406
barcode_type UPC
col1 super copper
col1_sortorder 5887
col2 [empty string]
col3 [empty string]
color_swatch 149-92-47.jpg
cost 2.51
deal_of_the_week NO
description super copper
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 67537
list_price 5.49
map NO
mfr_num JAC1564
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 67537
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 67537
2 JAC1564
3 super copper
timestamp 2015-03-27T14:47:50.258Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


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

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

ItemIDList: 37551,37551-PK,78946
AvailQtyList: 107.000000000000,17.000000000000,55.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772156703
barcode_type UPC
col1 super sparkle
col1_sortorder 5894
col2 [empty string]
col3 [empty string]
cost 2.51
deal_of_the_week NO
description super sparkle
group_id 7687
group_uname jacquard-lumiere-artist-acrylics
id 28646
list_price 5.49
map NO
mfr_num JAC1567
net_weight 0.2
non_member_discount 30
non_member_price 3.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 28646
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.75
ta_price 4.39
text
array
1 28646
2 JAC1567
3 super sparkle
timestamp 2015-03-27T14:46:52.327Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 107.000000000000 37551
2 17.000000000000 37551-PK
3 55.000000000000 78946
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '923' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.23.36.47

URL: www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e03028cc864e36cf33dd3f19665d1d3f3766
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~fb~krylon~fp~5-7~c2~for-the-professional-artist~c3~tools~&gr=krylon-crystal-clear.html
urltoken CFID=29700779&CFTOKEN=80115703&jsessionid=e03028cc864e36cf33dd3f19665d1d3f3766
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 14:03:53'}
sessionid e0301649703b82201c921e661e1026671d7f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=decorative-painting&gr=jacquard-lumiere-artist-acrylics.html
urltoken CFID=29700780&CFTOKEN=99302611&jsessionid=e0301649703b82201c921e661e1026671d7f
validationerror [empty string]


Lumiere Artist Acrylics are brilliant metallics, perfect for a variety of surfaces including wood, canvas, paper, Styrofoam, and natural or synthetic fabrics from lightweight silk to denim and leather.

The colors are opaque and exceptionally vibrant, even on black or dark backgrounds. Hi Lite colors are meant only for use on dark colors. Super Sparkle has multi-color sparkles.

Jacquard Lumiere can be screened, stamped, stenciled, marbled, printed, or airbrushed (25% water mix required for airbrush). The colors come in 2 1/4 oz. jars.

Share on Facebook Twitter Pinterest

Ask a question about Lumiere Artist Acrylics Ask a question about this product  |  See all questions & answers (3)

Lumiere Artist Acrylics

by Jacquard

Average User Rating: Based on (22 Reviews)

5 22

Jennifer Rowland from Sun City,Ca says:

Violet Yummy! Hi-Lite Violet even yummier! Thanks MisterArt.com for always lightening fast delivery!

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
10523
Lumiere Artist Acrylics burgundy
Zoom Image
burgundy JAC1545 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
27962
Lumiere Artist Acrylics burnt orange
Zoom Image
burnt orange JAC1543 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
61332
Lumiere Artist Acrylics citrine
Zoom Image
citrine JAC1542 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
85408
Lumiere Artist Acrylics crimson
Zoom Image
crimson JAC1544 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
86768
Lumiere Artist Acrylics grape
Zoom Image
grape JAC1546 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
66794
Lumiere Artist Acrylics hi-lite blue
Zoom Image
hi-lite blue JAC1576 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
45625
Lumiere Artist Acrylics hi-lite red
Zoom Image
hi-lite red JAC1574 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
62804
Lumiere Artist Acrylics hi-lite violet
Zoom Image
hi-lite violet JAC1575 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
49543
Lumiere Artist Acrylics indigo
Zoom Image
indigo JAC1547 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
21027
Lumiere Artist Acrylics metallic bronze
Zoom Image
metallic bronze JAC1565 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
17797
Lumiere Artist Acrylics metallic gold
Zoom Image
metallic gold JAC1561 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
27492
Lumiere Artist Acrylics metallic olive green
Zoom Image
metallic olive green JAC1562 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
23798
Lumiere Artist Acrylics metallic russet
Zoom Image
metallic russet JAC1566 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
12974
Lumiere Artist Acrylics metallic rust
Zoom Image
metallic rust JAC1549 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
69733
Lumiere Artist Acrylics metallic silver
Zoom Image
metallic silver JAC1563 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
83484
Lumiere Artist Acrylics old brass
Zoom Image
old brass JAC1548 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
44588
Lumiere Artist Acrylics pearl blue
Zoom Image
pearl blue JAC1570 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
29692
Lumiere Artist Acrylics pearl emerald green
Zoom Image
pearl emerald green JAC1572 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
16179
Lumiere Artist Acrylics pearl magenta
Zoom Image
pearl magenta JAC1573 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
15659
Lumiere Artist Acrylics pearl turquoise
Zoom Image
pearl turquoise JAC1571 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
62437
Lumiere Artist Acrylics pearl violet
Zoom Image
pearl violet JAC1569 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
38611
Lumiere Artist Acrylics pearl white
Zoom Image
pearl white JAC1568 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
01432
Lumiere Artist Acrylics pewter
Zoom Image
pewter JAC1551 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
67537
Lumiere Artist Acrylics super copper
Zoom Image
super copper JAC1564 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock
Add to Favorites
28646
Lumiere Artist Acrylics super sparkle
Zoom Image
super sparkle JAC1567 $5.49 $3.84 30% Off $3.29 40% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



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

The Original Wax Metallic Finish

by Rub 'n Buff

Orignal wax metallic finish!

From $4.10

Neopaque Colors

by Jacquard

Top brands for less

From $3.29

Pearl Ex Powdered Pigments

by Jacquard

Use to simulate all kinds of finishes

From $2.69

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 »

Product Questions and Answers

Ask a Question
Ask a Question

Some of my Lumiere paints have hardened. How can I make them usable again?

- Asked by Stampinmama on 14-Nov-13
Answer

If they are already hardened, it is too late to do anything. This is because acrylic is polymer (plastic). If they are at the stage where you can peel off the hardened shell and it is still moist underneath, then just plain water will make them usable.

- Answered by MisterArt on 14-Nov-13

Can I use Lumiere paint on canvas?

- Asked by Rita on 08-Jan-13
Answer

Yes, this paint can be used on canvas.

- Answered by MisterArt on 08-Jan-13

Can these paints be used on glass specifically on the bottom of a plate? Will the paint be permanent?

- Asked by carol n on 29-Aug-12
Answer

Lumiere Artist Acrylics can be used on glass, but need to be sealed with an acrylic varnish to ensure longevity. These paints are not food-safe or dishwasher-safe. You may consider a paint formulated specifically for glass painting, such as Pebeo Vitrea 160.

- Answered by MisterArt on 29-Aug-12

Ask a Question About Lumiere Artist Acrylics


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.

Customer Product Reviews
Write a Review
Write a Review
Rated by: Jennifer Rowland in Sun City,Ca
Violet Yummy! Hi-Lite Violet even yummier! Thanks MisterArt.com for always lightening fast delivery!
Rated by: Jennifer Rowland in Sun City,Ca
I get fantastic results on canvas with Lumiere products mixed with dark acrylics; and I am still experimenting all the time. Great products, and can depend upon super fast MisterArt.com shipping. When I get ideas I want the product fast and this company has never let me down!
Rated by: Pat B. in rochester, NY
I have used this paint on a variety of surfaces and have been very pleased with both the experience and the results.
Rated by: Cathy M. in Chino Valley, AZ
I love Jacquard Lumiere paints! I use them in my art quilts. The colors are strong and bright; they work well for stenciling, painting with a brush and for printing with screens and stamps
Rated by: M M. in W. Norriton, PA
I really, really love this paint!! It is so wonderful to work with and the first I reach for when I am crafting.
Rated by: avigayil m. in east brunswick, NJ
i love using these paints and am very happy doing business with mister art. delivery was quick, well packed and the materials i received were all great quality. i highly recommend this site, i will be back.
Rated by: Karina A. in New Orleans, LA
This is a wonderful medium! I just love the sparkle the color gives... and you can do so much with it!
Rated by: Liz L. in Gilbert, AZ
I absolutely love these paints! The richness of the colors and quality are top notch.
Rated by: Dawn M. in Falls Church, VA
I use these paints with just about everything. I use them on polymer clay, wood tiles, paper mache boxes. The colors are AMAZING. They do tend to have a kind of weird smell, not toxic, just weird-But they only smell that way when you're painting it on, not once it's dry.
Rated by: Susan B. in Plain Dealing, LA
The Lumiere Colors by Jacquard is such a wonderful product. When using the Pearl White it may be blended with other colors and retain the pearl appearance or it may be used as a blaze over white. I was commissioned to create a table top replica of an Ornament that I created for the White House Christmas Tree in 2002. The Pearl White and Hi-Lite Violet worked wonderfully on the appearance of the Great Egrate in the scene. The Pearl Violet will be used in creating the Fleur de lie design on a gourd bowl. The coverage is excellent with no prior base coating applied. I intend to expand my color usage and eventually replace my other, more common acrylic brands with the Jacquard and intend to try more of their products. Thank you Jacquard, Susan
Rated by: Ann M. in Grayton Beach, FL
These paints are wonderful...they go on smooth and they just glow...I use them on clay, fabric, gourds, wood, and watercolor paper. Wish I could afford every color!
Rated by: DeBorah B. in Walla Walla, WA
This one product continues to amaze me. No matter what surface I use it on, the result is always better than I expected. I've used it on wall pieces, silk clothing, modeling clay, wood, polymer clay, air dry clay, metal, cardboard, formica and the list goes on and on. If you can only have one toy to play with, I recommend this one!
Rated by: Kathy S. in Palatine, IL
The gold lumeire acrylic paint is so wonderful...it has a transparency that lets other colors show through, but provides a wonderful sheen...it is one of my favorite colors to use...try it over bright colored inks/paints.
Rated by: Peggy H. in Loveland, CO
Great product to use with polymer clays..you can combine these with shaving cream (see Gwen Gibson's article in PolymerCafe) and do fabulous colors on polymer clay beads!
Rated by: Migdalia D. in Camden, NJ
The colors are beautiful. It glides on easily and dries quickly; this is especially good for me since I am impatient and like to work quickly. It gives a pearl like effect, which I just love. I would definately recommend it for all your painting projects.
Rated by: Punkin N. in Austin, TX
I screenprinted the Super Sparkle on an existing printed color and the results were awesome! The only problem was keeping the screen from clogging with the glitter particles and the medium dried pretty quickly so I was having to wash the screen between every few prints. The medium is fully washable and dryable as long as it is printed over a previously screened ink base.
Rated by: Anne Marie B. in Beverly, MA
These paints are simply to die for! The colors are shimmery and soft. Excellent for the collage work and handmade cards I create. I use Lumiere paint constantly in my work and have never been unhappy with the results.
Rated by: Christy G. in Mechanicsville, VA
Lumieres are fantastic! I work in altered books and they give a satiny/silky sheet to pages and make fabric-textured covers of books look like antique satin. The pages take on a flexible, fabric-like feel and it is NOT sticky as some acrylics are. Living in the South with humid summers, sticky pages are a problem. Will buy again!
Rated by: Heather L. in Atlanta, GA
Lovely colors but leaves silk rather stiff even after washing. Dries very quickly.
Rated by: Catrina A. in N., MN
This is my first time buing/using these. I love them! They are beautiful on any surface. I used them for making cards and rubberstamping. Very easy to use.
Rated by: Crystal M. in Berkeley, CA
Wonderful product for a number of uses, including adding beautiful, sparkling accents to ceramics! I use it to paint mythical animals like dragons and unicorns. Go subtle or bold - they have both!
Rated by: Dragon L. in San Bernardino, CA
Great product. Covers paper, wood, plastic AND metal. I will buy again and again. Goes a LONG way, too. A bottle of this paint will paint lots of items. Well worth the price.

Write a Product Review for Lumiere Artist Acrylics

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