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

Premo Premium Polymer Clay

by Sculpey


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891505526
barcode_type UPC
col1 18 KT gold
col1_sortorder 28
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 233-194-85.jpg
cost 1.21
deal_of_the_week NO
description 18 KT gold, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67949
list_price 2.64
map NO
mfr_num PE02-5055
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67949
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67949
2 PE02-5055
3 18 KT gold, 2 oz.
timestamp 2015-03-30T16:21:15.411Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891538326
barcode_type UPC
col1 alizarin crimson
col1_sortorder 81
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 166-22-86.jpg
cost 1.21
deal_of_the_week NO
description alizarin crimson, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 13427
list_price 2.64
map NO
mfr_num PE02-5383
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 13427
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 13427
2 PE02-5383
3 alizarin crimson, 2 oz.
timestamp 2015-03-30T16:19:20.437Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891551721
barcode_type UPC
col1 antique gold
col1_sortorder 148
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 206-180-10.jpg
cost 1.21
deal_of_the_week NO
description antique gold, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67946
list_price 2.64
map NO
mfr_num PE02-5517
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67946
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67946
2 PE02-5517
3 antique gold, 2 oz.
timestamp 2015-03-30T16:21:15.401Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891509227
barcode_type UPC
col1 beige
col1_sortorder 365
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 221-178-163.jpg
cost 1.21
deal_of_the_week NO
description beige, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 71408
list_price 2.64
map NO
mfr_num PE02-5092
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 71408
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 71408
2 PE02-5092
3 beige, 2 oz.
timestamp 2015-03-30T16:21:29.783Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891504222
barcode_type UPC
col1 black
col1_sortorder 402
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.21
deal_of_the_week NO
description black, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 55254
list_price 2.64
map NO
mfr_num PE02-5042
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 55254
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 55254
2 PE02-5042
3 black, 2 oz.
timestamp 2015-03-30T16:20:46.969Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891504925
barcode_type UPC
col1 blue glitter
col1_sortorder 570
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 47-83-195.jpg
cost 1.21
deal_of_the_week NO
description blue glitter, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67955
list_price 2.64
map NO
mfr_num PE02-5049
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67955
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67955
2 PE02-5049
3 blue glitter, 2 oz.
timestamp 2015-03-30T16:21:15.434Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891502020
barcode_type UPC
col1 blush
col1_sortorder 641
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 228-121-161.jpg
cost 1.21
deal_of_the_week NO
description blush, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67929
list_price 2.64
map NO
mfr_num PE02-5020
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67929
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67929
2 PE02-5020
3 blush, 2 oz.
timestamp 2015-03-30T16:21:15.328Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891503522
barcode_type UPC
col1 bright green pearl
col1_sortorder 710
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 153-181-69.jpg
cost 1.21
deal_of_the_week NO
description bright green pearl, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67941
list_price 2.64
map NO
mfr_num PE02-5035
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67941
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67941
2 PE02-5035
3 bright green pearl, 2 oz.
timestamp 2015-03-30T16:21:15.372Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891551929
barcode_type UPC
col1 bronze
col1_sortorder 791
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 213-168-158.jpg
cost 1.21
deal_of_the_week NO
description bronze, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67945
list_price 2.64
map NO
mfr_num PE02-5519
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67945
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67945
2 PE02-5519
3 bronze, 2 oz.
timestamp 2015-03-30T16:21:15.396Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891505328
barcode_type UPC
col1 burnt umber
col1_sortorder 887
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 97-30-25.jpg
cost 1.21
deal_of_the_week NO
description burnt umber, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 76734
list_price 2.64
map NO
mfr_num PE02-5053
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 76734
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 76734
2 PE02-5053
3 burnt umber, 2 oz.
timestamp 2015-03-30T16:21:41.741Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891538227
barcode_type UPC
col1 cadmium red hue
col1_sortorder 969
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 226-43-54.jpg
cost 1.21
deal_of_the_week NO
description cadmium red hue, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 56505
list_price 2.64
map NO
mfr_num PE02-5382
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 56505
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 56505
2 PE02-5382
3 cadmium red hue, 2 oz.
timestamp 2015-03-30T16:20:48.377Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891557228
barcode_type UPC
col1 cadmium yellow hue
col1_sortorder 1009
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 229-206-30.jpg
cost 1.21
deal_of_the_week NO
description cadmium yellow hue, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 13265
list_price 2.64
map NO
mfr_num PE02-5572
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 13265
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 13265
2 PE02-5572
3 cadmium yellow hue, 2 oz.
timestamp 2015-03-30T16:19:20.203Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891506721
barcode_type UPC
col1 copper
col1_sortorder 1529
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 219-173-144.jpg
cost 1.21
deal_of_the_week NO
description copper, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67943
list_price 2.64
map NO
mfr_num PE02-5067
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67943
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67943
2 PE02-5067
3 copper, 2 oz.
timestamp 2015-03-30T16:21:15.38Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891500323
barcode_type UPC
col1 denim
col1_sortorder 1853
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 90-148-174.jpg
cost 1.21
deal_of_the_week NO
description denim, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67935
list_price 2.64
map NO
mfr_num PE02-5003
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67935
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67935
2 PE02-5003
3 denim, 2 oz.
timestamp 2015-03-30T16:21:15.354Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891509326
barcode_type UPC
col1 ecru
col1_sortorder 2006
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 246-217-183.jpg
cost 1.21
deal_of_the_week NO
description ecru, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 47648
list_price 2.64
map NO
mfr_num PE02-5093
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 47648
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 47648
2 PE02-5093
3 ecru, 2 oz.
timestamp 2015-03-30T16:20:33.513Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891505724
barcode_type UPC
col1 frost white glitter
col1_sortorder 2348
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-240-240.jpg
cost 1.21
deal_of_the_week NO
description frost white glitter, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67958
list_price 2.64
map NO
mfr_num PE02-5057
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67958
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67958
2 PE02-5057
3 frost white glitter, 2 oz.
timestamp 2015-03-30T16:21:15.442Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891550427
barcode_type UPC
col1 fuchsia
col1_sortorder 2359
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 196-38-161.jpg
cost 1.21
deal_of_the_week NO
description fuchsia, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 76965
list_price 2.64
map NO
mfr_num PE02-5504
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 76965
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 76965
2 PE02-5504
3 fuchsia, 2 oz.
timestamp 2015-03-30T16:21:41.911Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891530320
barcode_type UPC
col1 gold
col1_sortorder 2491
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 199-122-58.jpg
cost 1.21
deal_of_the_week NO
description gold, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 25259
list_price 2.64
map NO
mfr_num PE02-5303
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 25259
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 25259
2 PE02-5303
3 gold, 2 oz.
timestamp 2015-03-30T16:19:47.886Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891506523
barcode_type UPC
col1 gray granite
col1_sortorder 2611
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 206-207-209.jpg
cost 1.21
deal_of_the_week NO
description gray granite, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67962
list_price 2.64
map NO
mfr_num PE02-5065
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67962
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67962
2 PE02-5065
3 gray granite, 2 oz.
timestamp 2015-03-30T16:21:15.45Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891532324
barcode_type UPC
col1 green
col1_sortorder 2626
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 16-154-91.jpg
cost 1.21
deal_of_the_week NO
description green, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 17550
list_price 2.64
map NO
mfr_num PE02-5323
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 17550
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 17550
2 PE02-5323
3 green, 2 oz.
timestamp 2015-03-30T16:19:34.419Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891533123
barcode_type UPC
col1 green glitter
col1_sortorder 2647
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 16-188-117.jpg
cost 1.21
deal_of_the_week NO
description green glitter, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 02573
list_price 2.64
map NO
mfr_num PE02-5550
net_weight 0.13
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 02573
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 02573
2 PE02-5550
3 green glitter, 2 oz.
timestamp 2015-03-30T16:18:56.77Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891552797
barcode_type UPC
col1 jungle
col1_sortorder 3174
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 103-143-133.jpg
cost 1.21
deal_of_the_week NO
description jungle, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 02570
list_price 2.64
map NO
mfr_num PE02-5535
net_weight 0.13
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 02570
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 02570
2 PE02-5535
3 jungle, 2 oz.
timestamp 2015-03-30T16:18:56.766Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891502921
barcode_type UPC
col1 magenta pearl
col1_sortorder 3542
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 235-175-204.jpg
cost 1.21
deal_of_the_week NO
description magenta pearl, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67938
list_price 2.64
map NO
mfr_num PE02-5029
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67938
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67938
2 PE02-5029
3 magenta pearl, 2 oz.
timestamp 2015-03-30T16:21:15.363Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891501023
barcode_type UPC
col1 navy blue
col1_sortorder 3969
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 45-102-148.jpg
cost 1.21
deal_of_the_week NO
description navy blue, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67922
list_price 2.64
map NO
mfr_num PE02-5010
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67922
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67922
2 PE02-5010
3 navy blue, 2 oz.
timestamp 2015-03-30T16:21:15.302Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891503324
barcode_type UPC
col1 orange
col1_sortorder 4222
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 224-81-45.jpg
cost 1.21
deal_of_the_week NO
description orange, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67097
list_price 2.64
map NO
mfr_num PE02-5033
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67097
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67097
2 PE02-5033
3 orange, 2 oz.
timestamp 2015-03-30T16:21:13.081Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891503829
barcode_type UPC
col1 peacock pearl
col1_sortorder 4452
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-161-168.jpg
cost 1.21
deal_of_the_week NO
description peacock pearl, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67942
list_price 2.64
map NO
mfr_num PE02-5038
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67942
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67942
2 PE02-5038
3 peacock pearl, 2 oz.
timestamp 2015-03-30T16:21:15.375Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891510124
barcode_type UPC
col1 pearl
col1_sortorder 4456
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 255-245-245.jpg
cost 1.21
deal_of_the_week NO
description pearl, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 15727
list_price 2.64
map NO
mfr_num PE02-5101
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 15727
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 15727
2 PE02-5101
3 pearl, 2 oz.
timestamp 2015-03-30T16:19:31.273Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891502624
barcode_type UPC
col1 pomegranate
col1_sortorder 4811
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 207-89-115.jpg
cost 1.21
deal_of_the_week NO
description pomegranate, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 67933
list_price 2.64
map NO
mfr_num PE02-5026
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 67933
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 67933
2 PE02-5026
3 pomegranate, 2 oz.
timestamp 2015-03-30T16:21:15.346Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTOKEN=33075984&jsessionid=e030920f6f09bdcaff3341a5a66751b5d481
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e03015164e7c4fdc83e5373836365a233437
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html
urltoken CFID=30279994&CFTOKEN=76407876&jsessionid=e03015164e7c4fdc83e5373836365a233437
validationerror [empty string]


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

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

ItemIDList: 94805,94806,94807,94808,94809,94810,94811,94812,94813,94814,94816,94817,94818,94820,94821,94822,94823
AvailQtyList: 0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 715891551325
barcode_type UPC
col1 purple
col1_sortorder 4938
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 54-37-165.jpg
cost 1.21
deal_of_the_week NO
description purple, 2 oz.
group_id 147
group_uname sculpey-premo-premium-polymer-clay
id 71522
list_price 2.64
map NO
mfr_num PE02-5513
net_weight 0.14
non_member_discount 27
non_member_price 1.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 71522
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.32
ta_price 2.11
text
array
1 71522
2 PE02-5513
3 purple, 2 oz.
timestamp 2015-03-30T16:21:30.566Z
vip_member_price 1.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94805
2 0E-12 94806
3 0E-12 94807
4 0E-12 94808
5 0E-12 94809
6 0E-12 94810
7 0E-12 94811
8 0E-12 94812
9 0E-12 94813
10 0E-12 94814
11 0E-12 94816
12 0E-12 94817
13 0E-12 94818
14 0E-12 94820
15 0E-12 94821
16 0E-12 94822
17 0E-12 94823
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] = '11126' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~fp~0-3~&gr=sculpey-premo-premium-polymer-clay.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:38:00'}
sessionid e030920f6f09bdcaff3341a5a66751b5d481
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-7~&gr=art-institute-glitter-elements-textures.html
urltoken CFID=30279995&CFTO