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

Modeling Compound III

by Sculpey


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891120927
barcode_type UPC
col1 ballerina
col1_sortorder 307
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 249-203-216.jpg
cost 1.04
deal_of_the_week NO
description ballerina, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 50769
list_price 2.29
map NO
mfr_num S302-1209
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 50769
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 50769
2 S302-1209
3 ballerina, 2 oz.
timestamp 2015-03-31T17:53:37.488Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110935
barcode_type UPC
col1 beige
col1_sortorder 365
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 254-220-193.jpg
cost 1.04
deal_of_the_week NO
description beige, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 12811
list_price 2.29
map NO
mfr_num S302-093
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 12811
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 12811
2 S302-093
3 beige, 2 oz.
timestamp 2015-03-31T17:52:39.382Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110423
barcode_type UPC
col1 black
col1_sortorder 402
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 35-31-31.jpg
cost 1.04
deal_of_the_week NO
description black, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 51850
list_price 2.29
map NO
mfr_num S302-042
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 51850
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 51850
2 S302-042
3 black, 2 oz.
timestamp 2015-03-31T17:53:38.72Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110638
barcode_type UPC
col1 blue
col1_sortorder 542
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-83-149.jpg
cost 1.04
deal_of_the_week NO
description blue, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 52672
list_price 2.29
map NO
mfr_num S302-063
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 52672
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 52672
2 S302-063
3 blue, 2 oz.
timestamp 2015-03-31T17:53:45.669Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110089
barcode_type UPC
col1 blue pearl
col1_sortorder 590
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 26-77-122.jpg
cost 1.04
deal_of_the_week NO
description blue pearl, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 12350
list_price 2.29
map NO
mfr_num S302-1008
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 12350
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 12350
2 S302-1008
3 blue pearl, 2 oz.
timestamp 2015-03-31T17:52:38.799Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891113486
barcode_type UPC
col1 buried treasure
col1_sortorder 857
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 202-177-123.jpg
cost 1.04
deal_of_the_week NO
description buried treasure, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 02579
list_price 2.29
map NO
mfr_num S302-380
net_weight 0.13
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 02579
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 02579
2 S302-380
3 buried treasure, 2 oz.
timestamp 2015-03-31T17:52:17.793Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891113448
barcode_type UPC
col1 camouflage
col1_sortorder 1053
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 130-122-60.jpg
cost 1.04
deal_of_the_week NO
description camouflage, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 02575
list_price 2.29
map NO
mfr_num S302-360
net_weight 0.13
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 02575
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 02575
2 S302-360
3 camouflage, 2 oz.
timestamp 2015-03-31T17:52:17.785Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111420
barcode_type UPC
col1 candy pink
col1_sortorder 1073
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 234-102-149.jpg
cost 1.04
deal_of_the_week NO
description candy pink, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59783
list_price 2.29
map NO
mfr_num S302-1142
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59783
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59783
2 S302-1142
3 candy pink, 2 oz.
timestamp 2015-03-31T17:53:54.097Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110539
barcode_type UPC
col1 chocolate
col1_sortorder 1221
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 91-18-1.jpg
cost 1.04
deal_of_the_week NO
description chocolate, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 53241
list_price 2.29
map NO
mfr_num S302-053
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 53241
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 53241
2 S302-053
3 chocolate, 2 oz.
timestamp 2015-03-31T17:53:46.556Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111406
barcode_type UPC
col1 deep red pearl
col1_sortorder 1830
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 202-79-100.jpg
cost 1.04
deal_of_the_week NO
description deep red pearl, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59782
list_price 2.29
map NO
mfr_num S302-1140
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59782
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59782
2 S302-1140
3 deep red pearl, 2 oz.
timestamp 2015-03-31T17:53:54.094Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891113035
barcode_type UPC
col1 dusty rose
col1_sortorder 1982
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 246-163-183.jpg
cost 1.04
deal_of_the_week NO
description dusty rose, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 31020
list_price 2.29
map NO
mfr_num S302-303
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 31020
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 31020
2 S302-303
3 dusty rose, 2 oz.
timestamp 2015-03-31T17:53:09.304Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891164525
barcode_type UPC
col1 elephant gray
col1_sortorder 2027
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 211-204-185.jpg
cost 1.04
deal_of_the_week NO
description elephant gray, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 63129
list_price 2.29
map NO
mfr_num S302-1645
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 63129
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 63129
2 S302-1645
3 elephant gray, 2 oz.
timestamp 2015-03-31T17:54:05.314Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891113233
barcode_type UPC
col1 emerald
col1_sortorder 2031
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-162-97.jpg
cost 1.04
deal_of_the_week NO
description emerald, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 62398
list_price 2.29
map NO
mfr_num S302-323
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 62398
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 62398
2 S302-323
3 emerald, 2 oz.
timestamp 2015-03-31T17:54:03.357Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111123
barcode_type UPC
col1 fuchsia pearl
col1_sortorder 2362
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 184-89-153.jpg
cost 1.04
deal_of_the_week NO
description fuchsia pearl, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59777
list_price 2.29
map NO
mfr_num S302-1112
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59777
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59777
2 S302-1112
3 fuchsia pearl, 2 oz.
timestamp 2015-03-31T17:53:54.084Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891113424
barcode_type UPC
col1 gentle plum
col1_sortorder 2395
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 100-109-152.jpg
cost 1.04
deal_of_the_week NO
description gentle plum, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 02576
list_price 2.29
map NO
mfr_num S302-355
net_weight 0.13
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 02576
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 02576
2 S302-355
3 gentle plum, 2 oz.
timestamp 2015-03-31T17:52:17.787Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111130
barcode_type UPC
col1 glow in the dark
col1_sortorder 2483
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 235-239-216.jpg
cost 1.04
deal_of_the_week NO
description glow in the dark, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59778
list_price 2.29
map NO
mfr_num S302-1113
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59778
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59778
2 S302-1113
3 glow in the dark, 2 oz.
timestamp 2015-03-31T17:53:54.087Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110867
barcode_type UPC
col1 gold
col1_sortorder 2491
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 207-150-69.jpg
cost 1.04
deal_of_the_week NO
description gold, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 77393
list_price 2.29
map NO
mfr_num S302-1086
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 77393
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 77393
2 S302-1086
3 gold, 2 oz.
timestamp 2015-03-31T17:54:29.786Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891162927
barcode_type UPC
col1 granny smith
col1_sortorder 2575
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 122-192-67.jpg
cost 1.04
deal_of_the_week NO
description granny smith, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 85311
list_price 2.29
map NO
mfr_num S302-1629
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 85311
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 85311
2 S302-1629
3 granny smith, 2 oz.
timestamp 2015-03-31T17:54:38.904Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891165720
barcode_type UPC
col1 hazelnut
col1_sortorder 2777
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 126-84-59.jpg
cost 1.04
deal_of_the_week NO
description hazelnut, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 52268
list_price 2.29
map NO
mfr_num S302-1657
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 52268
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 52268
2 S302-1657
3 hazelnut, 2 oz.
timestamp 2015-03-31T17:53:39.08Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 32
barcode 715891115039
barcode_type UPC
col1 hot pink
col1_sortorder 2880
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 238-57-138.jpg
cost 1.04
deal_of_the_week NO
description hot pink, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 88843
list_price 2.29
map NO
mfr_num S302-503
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 88843
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 88843
2 S302-503
3 hot pink, 2 oz.
timestamp 2015-03-31T17:54:42.242Z
vip_member_price 1.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111321
barcode_type UPC
col1 jewelry gold
col1_sortorder 3164
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 247-224-174.jpg
cost 1.04
deal_of_the_week NO
description jewelry gold, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59773
list_price 2.29
map NO
mfr_num S302-1132
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59773
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59773
2 S302-1132
3 jewelry gold, 2 oz.
timestamp 2015-03-31T17:53:54.078Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891163429
barcode_type UPC
col1 just orange
col1_sortorder 3181
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 247-143-30.jpg
cost 1.04
deal_of_the_week NO
description just orange, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 16754
list_price 2.29
map NO
mfr_num S302-1634
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 16754
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 16754
2 S302-1634
3 just orange, 2 oz.
timestamp 2015-03-31T17:52:48.023Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891113226
barcode_type UPC
col1 leaf green
col1_sortorder 3260
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-72-17.jpg
cost 1.04
deal_of_the_week NO
description leaf green, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 23958
list_price 2.29
map NO
mfr_num S302-322
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 23958
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 23958
2 S302-322
3 leaf green, 2 oz.
timestamp 2015-03-31T17:52:59.617Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111505
barcode_type UPC
col1 lemonade
col1_sortorder 3290
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 254-241-100.jpg
cost 1.04
deal_of_the_week NO
description lemonade, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59781
list_price 2.29
map NO
mfr_num S302-1150
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59781
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59781
2 S302-1150
3 lemonade, 2 oz.
timestamp 2015-03-31T17:53:54.092Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111031
barcode_type UPC
col1 light blue pearl
col1_sortorder 3321
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 167-218-239.jpg
cost 1.04
deal_of_the_week NO
description light blue pearl, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 61638
list_price 2.29
map NO
mfr_num S302-1103
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 61638
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 61638
2 S302-1103
3 light blue pearl, 2 oz.
timestamp 2015-03-31T17:54:01.563Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111017
barcode_type UPC
col1 pearl
col1_sortorder 4456
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 254-249-243.jpg
cost 1.04
deal_of_the_week NO
description pearl, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 31948
list_price 2.29
map NO
mfr_num S302-1101
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 31948
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 31948
2 S302-1101
3 pearl, 2 oz.
timestamp 2015-03-31T17:53:10.477Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111055
barcode_type UPC
col1 pewter
col1_sortorder 4653
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 195-186-177.jpg
cost 1.04
deal_of_the_week NO
description pewter, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59774
list_price 2.29
map NO
mfr_num S302-1105
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59774
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59774
2 S302-1105
3 pewter, 2 oz.
timestamp 2015-03-31T17:53:54.08Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111345
barcode_type UPC
col1 plum
col1_sortorder 4786
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 87-38-60.jpg
cost 1.04
deal_of_the_week NO
description plum, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 59779
list_price 2.29
map NO
mfr_num S302-1134
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 59779
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 59779
2 S302-1134
3 plum, 2 oz.
timestamp 2015-03-31T17:53:54.088Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891115138
barcode_type UPC
col1 purple
col1_sortorder 4938
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 49-38-116.jpg
cost 1.04
deal_of_the_week NO
description purple, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 41076
list_price 2.29
map NO
mfr_num S302-513
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 41076
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 41076
2 S302-513
3 purple, 2 oz.
timestamp 2015-03-31T17:53:24.462Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891110843
barcode_type UPC
col1 red
col1_sortorder 5088
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 178-8-55.jpg
cost 1.04
deal_of_the_week NO
description red, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 78241
list_price 2.29
map NO
mfr_num S302-083
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 78241
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 78241
2 S302-083
3 red, 2 oz.
timestamp 2015-03-31T17:54:31.082Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891115831
barcode_type UPC
col1 red hot red
col1_sortorder 5122
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 229-24-55.jpg
cost 1.04
deal_of_the_week NO
description red hot red, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 19212
list_price 2.29
map NO
mfr_num S302-583
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 19212
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 19212
2 S302-583
3 red hot red, 2 oz.
timestamp 2015-03-31T17:52:51.795Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e0303bda2a50a5611d3b1f203d744f1b9e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=glue&CatC=sort~1~fb~surebonder~fp~2-3~&gr=surebonder-all-purpose-stik-glue-sticks.html
urltoken CFID=30632298&CFTOKEN=46301897&jsessionid=e0303bda2a50a5611d3b1f203d744f1b9e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:22:16'}
sessionid e030688e4d8f503321f02d64411533424c76
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~sculpey~&gr=sculpey-modeling-compound-iii.html
urltoken CFID=30632297&CFTOKEN=25016437&jsessionid=e030688e4d8f503321f02d64411533424c76
validationerror [empty string]


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

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

ItemIDList: 44408,82186
AvailQtyList: 141.000000000000,104.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 715891111307
barcode_type UPC
col1 silver
col1_sortorder 5572
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 199-203-206.jpg
cost 1.04
deal_of_the_week NO
description silver, 2 oz.
group_id 307
group_uname sculpey-modeling-compound-iii
id 43168
list_price 2.29
map NO
mfr_num S302-1130
net_weight 0.14
non_member_discount 19
non_member_price 1.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 43168
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.15
ta_price 1.83
text
array
1 43168
2 S302-1130
3 silver, 2 oz.
timestamp 2015-03-31T17:53:27.743Z
vip_member_price 1.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 141.000000000000 44408
2 104.000000000000 82186
CACHED false
EXECUTIONTIME 16
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] = '39' 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.89.118.108

URL: