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

Fantasy Moon Effect Paint

by Pebeo


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074590
barcode_type EAN
col1 antique pink
col1_sortorder 156
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 187-175-172.jpg
cost 3.71
deal_of_the_week NO
description antique pink, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60735
list_price 7.6
map NO
mfr_num 167021CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60735
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60735
2 167021CAN
3 antique pink, 45 ml
timestamp 2015-03-31T17:53:57.498Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074552
barcode_type EAN
col1 apricot
col1_sortorder 179
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 254-162-85.jpg
cost 3.71
deal_of_the_week NO
description apricot, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60731
list_price 7.6
map NO
mfr_num 167016CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60731
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60731
2 167016CAN
3 apricot, 45 ml
timestamp 2015-03-31T17:53:57.49Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074576
barcode_type EAN
col1 carmine
col1_sortorder 1111
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 167-28-71.jpg
cost 3.71
deal_of_the_week NO
description carmine, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60733
list_price 7.6
map NO
mfr_num 167012CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60733
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60733
2 167012CAN
3 carmine, 45 ml
timestamp 2015-03-31T17:53:57.494Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074675
barcode_type EAN
col1 chocolate
col1_sortorder 1221
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 119-75-0.jpg
cost 3.71
deal_of_the_week NO
description chocolate, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60746
list_price 7.6
map NO
mfr_num 167034CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60746
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60746
2 167034CAN
3 chocolate, 45 ml
timestamp 2015-03-31T17:53:57.514Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074712
barcode_type EAN
col1 ebony
col1_sortorder 2002
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 62-61-59.jpg
cost 3.71
deal_of_the_week NO
description ebony, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60752
list_price 7.6
map NO
mfr_num 167026CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60752
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60752
2 167026CAN
3 ebony, 45 ml
timestamp 2015-03-31T17:53:57.53Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074637
barcode_type EAN
col1 emerald
col1_sortorder 2031
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 0-150-79.jpg
cost 3.71
deal_of_the_week NO
description emerald, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60740
list_price 7.6
map NO
mfr_num 167018CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60740
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60740
2 167018CAN
3 emerald, 45 ml
timestamp 2015-03-31T17:53:57.506Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074651
barcode_type EAN
col1 gold
col1_sortorder 2491
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 185-147-75.jpg
cost 3.71
deal_of_the_week NO
description gold, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60742
list_price 7.6
map NO
mfr_num 167032CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60742
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60742
2 167032CAN
3 gold, 45 ml
timestamp 2015-03-31T17:53:57.51Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074606
barcode_type EAN
col1 lilac
col1_sortorder 3454
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 139-126-193.jpg
cost 3.71
deal_of_the_week NO
description lilac, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60736
list_price 7.6
map NO
mfr_num 167022CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60736
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60736
2 167022CAN
3 lilac, 45 ml
timestamp 2015-03-31T17:53:57.5Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074613
barcode_type EAN
col1 metal blue
col1_sortorder 3692
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 47-78-139.jpg
cost 3.71
deal_of_the_week NO
description metal blue, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60738
list_price 7.6
map NO
mfr_num 167038CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60738
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60738
2 167038CAN
3 metal blue, 45 ml
timestamp 2015-03-31T17:53:57.502Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074644
barcode_type EAN
col1 mystic green
col1_sortorder 3894
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 170-183-167.jpg
cost 3.71
deal_of_the_week NO
description mystic green, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60741
list_price 7.6
map NO
mfr_num 167017CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60741
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60741
2 167017CAN
3 mystic green, 45 ml
timestamp 2015-03-31T17:53:57.508Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074682
barcode_type EAN
col1 pearl
col1_sortorder 4456
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 215-202-177.jpg
cost 3.71
deal_of_the_week NO
description pearl, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60747
list_price 7.6
map NO
mfr_num 167020CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60747
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60747
2 167020CAN
3 pearl, 45 ml
timestamp 2015-03-31T17:53:57.517Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074583
barcode_type EAN
col1 rosewood
col1_sortorder 5263
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 215-130-143.jpg
cost 3.71
deal_of_the_week NO
description rosewood, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60734
list_price 7.6
map NO
mfr_num 167023CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60734
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60734
2 167023CAN
3 rosewood, 45 ml
timestamp 2015-03-31T17:53:57.496Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074569
barcode_type EAN
col1 salmon
col1_sortorder 5334
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 252-135-81.jpg
cost 3.71
deal_of_the_week NO
description salmon, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60732
list_price 7.6
map NO
mfr_num 167019CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60732
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60732
2 167019CAN
3 salmon, 45 ml
timestamp 2015-03-31T17:53:57.493Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074545
barcode_type EAN
col1 sand
col1_sortorder 5342
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 223-200-163.jpg
cost 3.71
deal_of_the_week NO
description sand, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60730
list_price 7.6
map NO
mfr_num 167015CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60730
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60730
2 167015CAN
3 sand, 45 ml
timestamp 2015-03-31T17:53:57.488Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074705
barcode_type EAN
col1 silver
col1_sortorder 5572
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 183-186-190.jpg
cost 3.71
deal_of_the_week NO
description silver, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60750
list_price 7.6
map NO
mfr_num 167035CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60750
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60750
2 167035CAN
3 silver, 45 ml
timestamp 2015-03-31T17:53:57.522Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074620
barcode_type EAN
col1 turquoise
col1_sortorder 6215
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 0-171-206.jpg
cost 3.71
deal_of_the_week NO
description turquoise, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60739
list_price 7.6
map NO
mfr_num 167036CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60739
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60739
2 167036CAN
3 turquoise, 45 ml
timestamp 2015-03-31T17:53:57.504Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074699
barcode_type EAN
col1 veil of smoke
col1_sortorder 6339
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 190-187-185.jpg
cost 3.71
deal_of_the_week NO
description veil of smoke, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60749
list_price 7.6
map NO
mfr_num 167011CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60749
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60749
2 167011CAN
3 veil of smoke, 45 ml
timestamp 2015-03-31T17:53:57.52Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


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

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

ItemIDList: 10279
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 27
barcode 3167860074668
barcode_type EAN
col1 vermeil
col1_sortorder 6360
col2 45 ml
col2_sortorder 1877
col3 [empty string]
color_swatch 173-99-0.jpg
cost 3.71
deal_of_the_week NO
description vermeil, 45 ml
group_id 11008
group_uname pebeo-fantasy-moon-effect-paint
id 60744
list_price 7.6
map NO
mfr_num 167033CAN
net_weight 0.13
non_member_discount 17
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 60744
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.1
ta_dealer_c_price 4.1
ta_price 6.08
text
array
1 60744
2 167033CAN
3 vermeil, 45 ml
timestamp 2015-03-31T17:53:57.512Z
vip_member_price 5.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 10279
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] = '2560' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.215.49

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e0309675483ed84944b44b154c46357c4681
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=jewelry-making&CatC=sort~1~fb~x-acto~fp~7-9999.99~&gr=x-acto-precision-soldering-iron-and-hot-knife-tip.html
urltoken CFID=30791544&CFTOKEN=41002775&jsessionid=e0309675483ed84944b44b154c46357c4681
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:25:09'}
sessionid e030179d0a20039dbfe84133b1c2b7d562a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=pebeo-fantasy-moon-effect-paint.html
urltoken CFID=30791543&CFTOKEN=94247642&jsessionid=e030179d0a20039dbfe84133b1c2b7d562a1
validationerror [empty string]


Pebeo Fantasy Moon Colours feature an amazing hammered finish when dry. Opalescent and pearlescent, Moon Colours give jewelry and crafts a precious stone quality finish. They are easy to use, and are effective on a variety of surfaces, including metal, porcelain, terracotta, acetate, ceramic, canvas, mirror, glass and more! Mixing Fantasy Moon Colours with Vitrail or Ceramic paints will result in beautiful marbled combinations of color, opacity, and texture.

Available in 45-milliliter bottles.



Share on Facebook Twitter Pinterest

Ask a question about Fantasy Moon Effect Paint Ask a question about this product

Fantasy Moon Effect Paint

by Pebeo

Be the first to write a review on this product!









  Item# Swatch Image color
Ascending
size Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
60735
Fantasy Moon Effect Paint antique pink 45 ml
Zoom Image
antique pink 45 ml 167021CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60731
Fantasy Moon Effect Paint apricot 45 ml
Zoom Image
apricot 45 ml 167016CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60733
Fantasy Moon Effect Paint carmine 45 ml
Zoom Image
carmine 45 ml 167012CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60746
Fantasy Moon Effect Paint chocolate 45 ml
Zoom Image
chocolate 45 ml 167034CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60752
Fantasy Moon Effect Paint ebony 45 ml
Zoom Image
ebony 45 ml 167026CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60740
Fantasy Moon Effect Paint emerald 45 ml
Zoom Image
emerald 45 ml 167018CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60742
Fantasy Moon Effect Paint gold 45 ml
Zoom Image
gold 45 ml 167032CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60736
Fantasy Moon Effect Paint lilac 45 ml
Zoom Image
lilac 45 ml 167022CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60738
Fantasy Moon Effect Paint metal blue 45 ml
Zoom Image
metal blue 45 ml 167038CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60741
Fantasy Moon Effect Paint mystic green 45 ml
Zoom Image
mystic green 45 ml 167017CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60747
Fantasy Moon Effect Paint pearl 45 ml
Zoom Image
pearl 45 ml 167020CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60734
Fantasy Moon Effect Paint rosewood 45 ml
Zoom Image
rosewood 45 ml 167023CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60732
Fantasy Moon Effect Paint salmon 45 ml
Zoom Image
salmon 45 ml 167019CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60730
Fantasy Moon Effect Paint sand 45 ml
Zoom Image
sand 45 ml 167015CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60750
Fantasy Moon Effect Paint silver 45 ml
Zoom Image
silver 45 ml 167035CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60739
Fantasy Moon Effect Paint turquoise 45 ml
Zoom Image
turquoise 45 ml 167036CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60749
Fantasy Moon Effect Paint veil of smoke 45 ml
Zoom Image
veil of smoke 45 ml 167011CAN $7.60 $6.29 17% Off $5.55 27% Off Email When In Stock
Add to Favorites
60744
Fantasy Moon Effect Paint vermeil 45 ml
Zoom Image
vermeil 45 ml 167033CAN $7.60 $6.29 17% Off $5.55 27% 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...

From $4.97

Precision Razor Saw Set

by X-Acto

Great for metal, balsa wood, and plastic

From $7.43

The Chopper

by NorthWest Short Line

Quality tools for quality modeling

From $4.54

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 Fantasy Moon Effect Paint

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 Fantasy Moon Effect Paint

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