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

Museum Metal Sculpting Tools

by Martin/F. Weber


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049087
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 no. 1
col2_sortorder 326
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., no. 1
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15020
list_price 3.79
map NO
mfr_num 5205-1
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15020
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15020
2 5205-1
3 6 in., no. 1
timestamp 2015-03-31T17:52:45.339Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049094
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 no. 2
col2_sortorder 327
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., no. 2
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15021
list_price 3.79
map NO
mfr_num 5205-2
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15021
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15021
2 5205-2
3 6 in., no. 2
timestamp 2015-03-31T17:52:45.344Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049100
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 no. 3
col2_sortorder 328
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., no. 3
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15023
list_price 3.79
map NO
mfr_num 5205-3
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15023
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15023
2 5205-3
3 6 in., no. 3
timestamp 2015-03-31T17:52:45.355Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049117
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 no. 4
col2_sortorder 329
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., no. 4
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15026
list_price 3.79
map NO
mfr_num 5205-4
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15026
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15026
2 5205-4
3 6 in., no. 4
timestamp 2015-03-31T17:52:45.372Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049124
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 no. 5
col2_sortorder 330
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., no. 5
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15027
list_price 3.79
map NO
mfr_num 5205-5
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15027
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15027
2 5205-5
3 6 in., no. 5
timestamp 2015-03-31T17:52:45.375Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049131
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 No. 6
col2_sortorder 331
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., No. 6
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15033
list_price 3.79
map NO
mfr_num 5205-6
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15033
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15033
2 5205-6
3 6 in., No. 6
timestamp 2015-03-31T17:52:45.384Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049209
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 No. 7
col2_sortorder 332
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., No. 7
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15035
list_price 3.79
map NO
mfr_num 5205-7
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15035
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15035
2 5205-7
3 6 in., No. 7
timestamp 2015-03-31T17:52:45.394Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049216
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 No. 8
col2_sortorder 333
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., No. 8
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15036
list_price 3.79
map NO
mfr_num 5205-8
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15036
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15036
2 5205-8
3 6 in., No. 8
timestamp 2015-03-31T17:52:45.397Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049223
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 no. 9
col2_sortorder 334
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., no. 9
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15037
list_price 3.79
map NO
mfr_num 5205-9
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15037
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15037
2 5205-9
3 6 in., no. 9
timestamp 2015-03-31T17:52:45.399Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049230
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 No. 10
col2_sortorder 335
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., No. 10
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15040
list_price 3.79
map NO
mfr_num 5205-10
net_weight 0.03
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15040
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15040
2 5205-10
3 6 in., No. 10
timestamp 2015-03-31T17:52:45.406Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049247
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 No. 11
col2_sortorder 336
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., No. 11
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15042
list_price 3.79
map NO
mfr_num 5205-11
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15042
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15042
2 5205-11
3 6 in., No. 11
timestamp 2015-03-31T17:52:45.418Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049254
barcode_type UPC
col1 6 in.
col1_sortorder 2107
col2 No. 12
col2_sortorder 337
col3 [empty string]
cost 1.29
deal_of_the_week NO
description 6 in., No. 12
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15046
list_price 3.79
map NO
mfr_num 5205-12
net_weight 0.02
non_member_discount 40
non_member_price 2.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 15046
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.12
text
array
1 15046
2 5205-12
3 6 in., No. 12
timestamp 2015-03-31T17:52:45.434Z
vip_member_price 1.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049018
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 no. 1
col2_sortorder 326
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., no. 1
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14977
list_price 4.49
map NO
mfr_num 5204-1
net_weight 0.02
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14977
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14977
2 5204-1
3 8 in., no. 1
timestamp 2015-03-31T17:52:45.071Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049025
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 no. 2
col2_sortorder 327
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., no. 2
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14981
list_price 4.49
map NO
mfr_num 5204-2
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14981
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14981
2 5204-2
3 8 in., no. 2
timestamp 2015-03-31T17:52:45.256Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049032
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 no. 3
col2_sortorder 328
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., no. 3
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14987
list_price 4.49
map NO
mfr_num 5204-3
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14987
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14987
2 5204-3
3 8 in., no. 3
timestamp 2015-03-31T17:52:45.274Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049049
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 no. 4
col2_sortorder 329
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., no. 4
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14995
list_price 4.49
map NO
mfr_num 5204-4
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14995
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14995
2 5204-4
3 8 in., no. 4
timestamp 2015-03-31T17:52:45.284Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049056
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 no. 5
col2_sortorder 330
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., no. 5
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14996
list_price 4.49
map NO
mfr_num 5204-5
net_weight 0.02
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14996
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14996
2 5204-5
3 8 in., no. 5
timestamp 2015-03-31T17:52:45.287Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049063
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 No. 6
col2_sortorder 331
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., No. 6
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14998
list_price 4.49
map NO
mfr_num 5204-6
net_weight 0.02
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14998
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14998
2 5204-6
3 8 in., No. 6
timestamp 2015-03-31T17:52:45.292Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049285
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 No. 7
col2_sortorder 332
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., No. 7
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 14999
list_price 4.49
map NO
mfr_num 5204-7
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 14999
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 14999
2 5204-7
3 8 in., No. 7
timestamp 2015-03-31T17:52:45.297Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049292
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 No. 8
col2_sortorder 333
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., No. 8
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15011
list_price 4.49
map NO
mfr_num 5204-8
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 15011
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 15011
2 5204-8
3 8 in., No. 8
timestamp 2015-03-31T17:52:45.317Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049308
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 no. 9
col2_sortorder 334
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., no. 9
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15013
list_price 4.49
map NO
mfr_num 5204-9
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 15013
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 15013
2 5204-9
3 8 in., no. 9
timestamp 2015-03-31T17:52:45.322Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049315
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 No. 10
col2_sortorder 335
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., No. 10
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15015
list_price 4.49
map NO
mfr_num 5204-10
net_weight 0.02
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 15015
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 15015
2 5204-10
3 8 in., No. 10
timestamp 2015-03-31T17:52:45.331Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049322
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 No. 11
col2_sortorder 336
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., No. 11
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15016
list_price 4.49
map NO
mfr_num 5204-11
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 15016
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 15016
2 5204-11
3 8 in., No. 11
timestamp 2015-03-31T17:52:45.333Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


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

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

ItemIDList: 61971,64837
AvailQtyList: 52.000000000000,18.000000000000

struct
VIP_member_discount 50
barcode 080031049339
barcode_type UPC
col1 8 in.
col1_sortorder 2283
col2 No. 12
col2_sortorder 337
col3 [empty string]
cost 1.54
deal_of_the_week NO
description 8 in., No. 12
flags
array
1 1
group_id 10856
group_uname martin-f-weber-museum-metal-sculpting-tools
id 15018
list_price 4.49
map NO
mfr_num 5204-12
net_weight 0.03
non_member_discount 40
non_member_price 2.69
prop65 NO
ship_rule_desc STD
shipping STD
sku 15018
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.66
ta_dealer_c_price 1.66
ta_price 2.51
text
array
1 15018
2 5204-12
3 8 in., No. 12
timestamp 2015-03-31T17:52:45.335Z
vip_member_price 2.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 52.000000000000 61971
2 18.000000000000 64837
CACHED false
EXECUTIONTIME 28
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] = '7809' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:41:19'}
sessionid e030e4e27d7b1f6ed67d7c39471f6378157d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~martin-f-weber~fp~0-7~&gr=martin-f-weber-museum-metal-sculpting-tools.html
urltoken CFID=30636365&CFTOKEN=47545213&jsessionid=e030e4e27d7b1f6ed67d7c39471f6378157d
validationerror [empty string]


These Weber Museum Metal Sculpting Tools feature the finest handmade wooden handles, topped with metal ferrules, and shaped metal ends. The shaped metal ends of these tools come in a large variety of shapes and sizes, to accommodate a variety of needs while creating great sculpture. Every possibility was considered in order to create these smooth and ergonomic tools to satisfy the sculptural task at hand. This range of tools is available in 6-inch or 8-inch sizes.

Share on Facebook Twitter Pinterest

Ask a question about Museum Metal Sculpting Tools Ask a question about this product

Museum Metal Sculpting Tools

by Martin/F. Weber

Be the first to write a review on this product!









  Item# Image size
Ascending
shape Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
15020
Museum Metal Sculpting Tools 6 in. no. 1
Zoom Image
6 in. no. 1 5205-1 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15021
Museum Metal Sculpting Tools 6 in. no. 2
Zoom Image
6 in. no. 2 5205-2 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15023
Museum Metal Sculpting Tools 6 in. no. 3
Zoom Image
6 in. no. 3 5205-3 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15026
Museum Metal Sculpting Tools 6 in. no. 4
Zoom Image
6 in. no. 4 5205-4 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15027
Museum Metal Sculpting Tools 6 in. no. 5
Zoom Image
6 in. no. 5 5205-5 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15033
Museum Metal Sculpting Tools 6 in. No. 6
Zoom Image
6 in. No. 6 5205-6 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15035
Museum Metal Sculpting Tools 6 in. No. 7
Zoom Image
6 in. No. 7 5205-7 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15036
Museum Metal Sculpting Tools 6 in. No. 8
Zoom Image
6 in. No. 8 5205-8 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15037
Museum Metal Sculpting Tools 6 in. no. 9
Zoom Image
6 in. no. 9 5205-9 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15040
Museum Metal Sculpting Tools 6 in. No. 10
Zoom Image
6 in. No. 10 5205-10 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15042
Museum Metal Sculpting Tools 6 in. No. 11
Zoom Image
6 in. No. 11 5205-11 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
15046
Museum Metal Sculpting Tools 6 in. No. 12
Zoom Image
6 in. No. 12 5205-12 $3.79 $2.27 40% Off $1.90 50% Off Email When In Stock
Add to Favorites
14977
Museum Metal Sculpting Tools 8 in. no. 1
Zoom Image
8 in. no. 1 5204-1 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
14981
Museum Metal Sculpting Tools 8 in. no. 2
Zoom Image
8 in. no. 2 5204-2 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
14987
Museum Metal Sculpting Tools 8 in. no. 3
Zoom Image
8 in. no. 3 5204-3 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
14995
Museum Metal Sculpting Tools 8 in. no. 4
Zoom Image
8 in. no. 4 5204-4 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
14996
Museum Metal Sculpting Tools 8 in. no. 5
Zoom Image
8 in. no. 5 5204-5 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
14998
Museum Metal Sculpting Tools 8 in. No. 6
Zoom Image
8 in. No. 6 5204-6 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
14999
Museum Metal Sculpting Tools 8 in. No. 7
Zoom Image
8 in. No. 7 5204-7 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
15011
Museum Metal Sculpting Tools 8 in. No. 8
Zoom Image
8 in. No. 8 5204-8 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
15013
Museum Metal Sculpting Tools 8 in. no. 9
Zoom Image
8 in. no. 9 5204-9 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
15015
Museum Metal Sculpting Tools 8 in. No. 10
Zoom Image
8 in. No. 10 5204-10 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
15016
Museum Metal Sculpting Tools 8 in. No. 11
Zoom Image
8 in. No. 11 5204-11 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock
Add to Favorites
15018
Museum Metal Sculpting Tools 8 in. No. 12
Zoom Image
8 in. No. 12 5204-12 $4.49 $2.69 40% Off $2.25 50% Off Email When In Stock

Click the to add item to your Favorites.



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

From $16.64

From $4.97

3-in-1 Craft and Jewelry Tool

by Cousin

Great for looping, crimping, cutting, and more

From $3.54

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Museum Metal Sculpting Tools

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for Museum Metal Sculpting Tools

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...