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

Basswood Sticks

by Midwest


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040162
barcode_type UPC
col1 1/32 in.
col1_sortorder 72
col2 1/4 in. x 24 in.
col2_sortorder 32
col3 [empty string]
cost 0.2
deal_of_the_week NO
description 1/32 in., 1/4 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 64924
list_price 0.39
map NO
mfr_num 4016
net_weight 0.01
non_member_discount 20
non_member_price 0.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 64924
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.21
ta_dealer_c_price 0.21
ta_price 0.33
text
array
1 64924
2 4016
3 1/32 in., 1/4 in. x 24 in.
timestamp 2015-03-26T14:51:47.872Z
vip_member_price 0.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040193
barcode_type UPC
col1 1/32 in.
col1_sortorder 72
col2 1/8 in. x 24 in.
col2_sortorder 19
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 1/32 in., 1/8 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 64925
list_price 0.29
map NO
mfr_num 4019
net_weight 0.01
non_member_discount 20
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 64925
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 64925
2 4019
3 1/32 in., 1/8 in. x 24 in.
timestamp 2015-03-26T14:51:47.874Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040209
barcode_type UPC
col1 1/32 in.
col1_sortorder 72
col2 3/16 in. x 24 in.
col2_sortorder 27
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 1/32 in., 3/16 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 64926
list_price 0.29
map NO
mfr_num 4020
net_weight 0.01
non_member_discount 20
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 64926
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 64926
2 4020
3 1/32 in., 3/16 in. x 24 in.
timestamp 2015-03-26T14:51:47.876Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040506
barcode_type UPC
col1 5/32 in.
col1_sortorder 75
col2 5/32 in. x 24 in.
col2_sortorder 21
col3 [empty string]
cost 0.24
deal_of_the_week NO
description 5/32 in., 5/32 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 75447
list_price 0.49
map NO
mfr_num 4050
net_weight 0.08
non_member_discount 20
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 75447
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.42
text
array
1 75447
2 4050
3 5/32 in., 5/32 in. x 24 in.
timestamp 2015-03-26T14:52:05.732Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
VIP_member_discount 30
barcode 091157040667
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 1/4 in. x 24 in.
col2_sortorder 32
col3 [empty string]
cost 0.39
deal_of_the_week NO
description 1/4 in., 1/4 in. x 24 in.
flags
array
1 3
group_id 1275
group_uname midwest-basswood-sticks
id 17348
list_price 0.79
map NO
mfr_num 4066
net_weight 0.08
non_member_discount 20
non_member_price 0.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 17348
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.43
ta_dealer_c_price 0.43
ta_price 0.67
text
array
1 17348
2 4066
3 1/4 in., 1/4 in. x 24 in.
timestamp 2015-03-26T14:50:38.388Z
vip_member_price 0.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040698
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 1/2 in. x 24 in.
col2_sortorder 43
col3 [empty string]
cost 0.63
deal_of_the_week NO
description 1/4 in., 1/2 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 63974
list_price 1.29
map NO
mfr_num 4069
net_weight 0.08
non_member_discount 20
non_member_price 1.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 63974
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.7
ta_dealer_c_price 0.7
ta_price 1.1
text
array
1 63974
2 4069
3 1/4 in., 1/2 in. x 24 in.
timestamp 2015-03-26T14:51:45.96Z
vip_member_price 0.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040681
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 3/8 in. x 24 in.
col2_sortorder 37
col3 [empty string]
cost 0.54
deal_of_the_week NO
description 1/4 in., 3/8 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 80796
list_price 1.09
map NO
mfr_num 4068
net_weight 0.08
non_member_discount 20
non_member_price 0.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 80796
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.59
ta_price 0.93
text
array
1 80796
2 4068
3 1/4 in., 3/8 in. x 24 in.
timestamp 2015-03-26T14:52:13.836Z
vip_member_price 0.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040773
barcode_type UPC
col1 5/16 in.
col1_sortorder 78
col2 5/16 in. x 24 in.
col2_sortorder 34
col3 [empty string]
cost 0.49
deal_of_the_week NO
description 5/16 in., 5/16 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 10138
list_price 0.99
map NO
mfr_num 4077
net_weight 0.08
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 10138
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.53
ta_dealer_c_price 0.53
ta_price 0.84
text
array
1 10138
2 4077
3 5/16 in., 5/16 in. x 24 in.
timestamp 2015-03-26T14:50:26.538Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040995
barcode_type UPC
col1 1/2 in.
col1_sortorder 80
col2 1/2 in. x 24 in.
col2_sortorder 43
col3 [empty string]
cost 0.99
deal_of_the_week NO
description 1/2 in., 1/2 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 45931
list_price 1.99
map NO
mfr_num 4099
net_weight 0.15
non_member_discount 20
non_member_price 1.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 45931
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.07
ta_dealer_c_price 1.07
ta_price 1.69
text
array
1 45931
2 4099
3 1/2 in., 1/2 in. x 24 in.
timestamp 2015-03-26T14:51:16.515Z
vip_member_price 1.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 31
barcode 091157040230
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 3/32 in. x 24 in.
col2_sortorder 12
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 1/16 in., 3/32 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 25336
list_price 0.29
map NO
mfr_num 4023
net_weight 0.08
non_member_discount 21
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 25336
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 25336
2 4023
3 1/16 in., 3/32 in. x 24 in.
timestamp 2015-03-26T14:50:48.737Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
VIP_member_discount 30
barcode 091157040223
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 1/16 in. x 24 in.
col2_sortorder 6
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 1/16 in., 1/16 in. x 24 in.
flags
array
1 3
group_id 1275
group_uname midwest-basswood-sticks
id 38535
list_price 0.29
map NO
mfr_num 4022
net_weight 0.08
non_member_discount 20
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 38535
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 38535
2 4022
3 1/16 in., 1/16 in. x 24 in.
timestamp 2015-03-26T14:51:08.446Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
VIP_member_discount 31
barcode 091157040247
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 1/8 in. x 24 in.
col2_sortorder 19
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 1/16 in., 1/8 in. x 24 in.
flags
array
1 3
group_id 1275
group_uname midwest-basswood-sticks
id 55896
list_price 0.29
map NO
mfr_num 4024
net_weight 0.08
non_member_discount 21
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 55896
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 55896
2 4024
3 1/16 in., 1/8 in. x 24 in.
timestamp 2015-03-26T14:51:32.116Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 31
barcode 091157040285
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 3/8 in. x 24 in.
col2_sortorder 37
col3 [empty string]
cost 0.29
deal_of_the_week NO
description 1/16 in., 3/8 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 64927
list_price 0.59
map NO
mfr_num 4028
net_weight 0.01
non_member_discount 20
non_member_price 0.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 64927
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.32
ta_dealer_c_price 0.32
ta_price 0.5
text
array
1 64927
2 4028
3 1/16 in., 3/8 in. x 24 in.
timestamp 2015-03-26T14:51:47.878Z
vip_member_price 0.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040254
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 3/16 in. x 24 in.
col2_sortorder 27
col3 [empty string]
cost 0.2
deal_of_the_week NO
description 1/16 in., 3/16 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 65415
list_price 0.39
map NO
mfr_num 4025
net_weight 0.01
non_member_discount 20
non_member_price 0.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 65415
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.21
ta_dealer_c_price 0.21
ta_price 0.33
text
array
1 65415
2 4025
3 1/16 in., 3/16 in. x 24 in.
timestamp 2015-03-26T14:51:49.361Z
vip_member_price 0.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040292
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 1/2 in. x 24 in.
col2_sortorder 43
col3 [empty string]
cost 0.39
deal_of_the_week NO
description 1/16 in., 1/2 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 76246
list_price 0.79
map NO
mfr_num 4029
net_weight 0.08
non_member_discount 20
non_member_price 0.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 76246
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.43
ta_dealer_c_price 0.43
ta_price 0.67
text
array
1 76246
2 4029
3 1/16 in., 1/2 in. x 24 in.
timestamp 2015-03-26T14:52:06.914Z
vip_member_price 0.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040261
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 1/4 in. x 24 in.
col2_sortorder 32
col3 [empty string]
cost 0.24
deal_of_the_week NO
description 1/16 in., 1/4 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 84324
list_price 0.49
map NO
mfr_num 4026
net_weight 0.08
non_member_discount 20
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 84324
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.42
text
array
1 84324
2 4026
3 1/16 in., 1/4 in. x 24 in.
timestamp 2015-03-26T14:52:16.476Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040360
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 1/4 in. x 24 in.
col2_sortorder 32
col3 [empty string]
cost 0.24
deal_of_the_week NO
description 3/32 in., 1/4 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 26822
list_price 0.49
map NO
mfr_num 4036
net_weight 0.08
non_member_discount 20
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 26822
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.42
text
array
1 26822
2 4036
3 3/32 in., 1/4 in. x 24 in.
timestamp 2015-03-26T14:50:50.445Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
VIP_member_discount 30
barcode 091157040339
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 3/32 in. x 24 in.
col2_sortorder 12
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 3/32 in., 3/32 in. x 24 in.
flags
array
1 3
group_id 1275
group_uname midwest-basswood-sticks
id 56961
list_price 0.29
map NO
mfr_num 4033
net_weight 0.08
non_member_discount 20
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 56961
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 56961
2 4033
3 3/32 in., 3/32 in. x 24 in.
timestamp 2015-03-26T14:51:33.454Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040513
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 3/4 in. x 24 in.
col2_sortorder 22
col3 [empty string]
cost 0.7
deal_of_the_week NO
description 1/8 in., 3/4 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 04672
list_price 1.41
map NO
mfr_num 4051
net_weight 0.04
non_member_discount 20
non_member_price 1.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 04672
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.76
ta_dealer_c_price 0.76
ta_price 1.2
text
array
1 04672
2 4051
3 1/8 in., 3/4 in. x 24 in.
timestamp 2015-03-26T14:50:15.083Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 31
barcode 091157040469
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 1/4 in. x 24 in.
col2_sortorder 32
col3 [empty string]
cost 0.24
deal_of_the_week NO
description 1/8 in., 1/4 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 27088
list_price 0.49
map NO
mfr_num 4046
net_weight 0.08
non_member_discount 20
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 27088
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.42
text
array
1 27088
2 4046
3 1/8 in., 1/4 in. x 24 in.
timestamp 2015-03-26T14:50:50.718Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040452
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 3/16 in. x 24 in.
col2_sortorder 27
col3 [empty string]
cost 0.24
deal_of_the_week NO
description 1/8 in., 3/16 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 40698
list_price 0.49
map NO
mfr_num 4045
net_weight 0.08
non_member_discount 20
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 40698
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.42
text
array
1 40698
2 4045
3 1/8 in., 3/16 in. x 24 in.
timestamp 2015-03-26T14:51:10.434Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040483
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 3/8 in. x 24 in.
col2_sortorder 37
col3 [empty string]
cost 0.39
deal_of_the_week NO
description 1/8 in., 3/8 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 64928
list_price 0.79
map NO
mfr_num 4048
net_weight 0.02
non_member_discount 20
non_member_price 0.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 64928
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.43
ta_dealer_c_price 0.43
ta_price 0.67
text
array
1 64928
2 4048
3 1/8 in., 3/8 in. x 24 in.
timestamp 2015-03-26T14:51:47.88Z
vip_member_price 0.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
VIP_member_discount 30
barcode 091157040445
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 1/8 in. x 24 in.
col2_sortorder 19
col3 [empty string]
cost 0.15
deal_of_the_week NO
description 1/8 in., 1/8 in. x 24 in.
flags
array
1 3
group_id 1275
group_uname midwest-basswood-sticks
id 73735
list_price 0.29
map NO
mfr_num 4044
net_weight 0.08
non_member_discount 20
non_member_price 0.23
prop65 NO
ship_rule_desc STD
shipping STD
sku 73735
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.16
ta_dealer_c_price 0.16
ta_price 0.25
text
array
1 73735
2 4044
3 1/8 in., 1/8 in. x 24 in.
timestamp 2015-03-26T14:52:04.114Z
vip_member_price 0.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040490
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 1/2 in. x 24 in.
col2_sortorder 43
col3 [empty string]
cost 0.49
deal_of_the_week NO
description 1/8 in., 1/2 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 77084
list_price 0.99
map NO
mfr_num 4049
net_weight 0.08
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 77084
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.53
ta_dealer_c_price 0.53
ta_price 0.84
text
array
1 77084
2 4049
3 1/8 in., 1/2 in. x 24 in.
timestamp 2015-03-26T14:52:07.79Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040582
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 3/8 in. x 24 in.
col2_sortorder 37
col3 [empty string]
cost 0.44
deal_of_the_week NO
description 3/16 in., 3/8 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 20500
list_price 0.89
map NO
mfr_num 4058
net_weight 0.08
non_member_discount 20
non_member_price 0.71
prop65 NO
ship_rule_desc STD
shipping STD
sku 20500
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.48
ta_dealer_c_price 0.48
ta_price 0.76
text
array
1 20500
2 4058
3 3/16 in., 3/8 in. x 24 in.
timestamp 2015-03-26T14:50:42.583Z
vip_member_price 0.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
VIP_member_discount 31
barcode 091157040551
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 3/16 in. x 24 in.
col2_sortorder 27
col3 [empty string]
cost 0.24
deal_of_the_week NO
description 3/16 in., 3/16 in. x 24 in.
flags
array
1 3
group_id 1275
group_uname midwest-basswood-sticks
id 48741
list_price 0.49
map NO
mfr_num 4055
net_weight 0.08
non_member_discount 20
non_member_price 0.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 48741
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.26
ta_dealer_c_price 0.26
ta_price 0.42
text
array
1 48741
2 4055
3 3/16 in., 3/16 in. x 24 in.
timestamp 2015-03-26T14:51:21.325Z
vip_member_price 0.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040599
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 1/2 in. x 24 in.
col2_sortorder 43
col3 [empty string]
cost 0.54
deal_of_the_week NO
description 3/16 in., 1/2 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 58407
list_price 1.09
map NO
mfr_num 4059
net_weight 0.08
non_member_discount 20
non_member_price 0.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 58407
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.59
ta_price 0.93
text
array
1 58407
2 4059
3 3/16 in., 1/2 in. x 24 in.
timestamp 2015-03-26T14:51:34.792Z
vip_member_price 0.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 31
barcode 091157040568
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 1/4 in. x 24 in.
col2_sortorder 32
col3 [empty string]
cost 0.29
deal_of_the_week NO
description 3/16 in., 1/4 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 64929
list_price 0.59
map NO
mfr_num 4056
net_weight 0.03
non_member_discount 20
non_member_price 0.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 64929
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.32
ta_dealer_c_price 0.32
ta_price 0.5
text
array
1 64929
2 4056
3 3/16 in., 1/4 in. x 24 in.
timestamp 2015-03-26T14:51:47.883Z
vip_member_price 0.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


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

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

ItemIDList: 97798,97799,97800,97801
AvailQtyList: 3.000000000000,3.000000000000,6.000000000000,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157040889
barcode_type UPC
col1 3/8 in.
col1_sortorder 87
col2 3/8 in. x 24 in.
col2_sortorder 37
col3 [empty string]
cost 0.63
deal_of_the_week NO
description 3/8 in., 3/8 in. x 24 in.
group_id 1275
group_uname midwest-basswood-sticks
id 61403
list_price 1.29
map NO
mfr_num 4088
net_weight 0.08
non_member_discount 20
non_member_price 1.03
prop65 NO
ship_rule_desc STD
shipping STD
sku 61403
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.7
ta_dealer_c_price 0.7
ta_price 1.1
text
array
1 61403
2 4088
3 3/8 in., 3/8 in. x 24 in.
timestamp 2015-03-26T14:51:40.735Z
vip_member_price 0.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 97798
2 3.000000000000 97799
3 6.000000000000 97800
4 0E-12 97801
CACHED false
EXECUTIONTIME 5
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] = '10007' 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-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
savedquery 1226
sessionid e0309875f8126fb6c9897c55256e7b5a1cd5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~1226~=
urltoken CFID=29246200&CFTOKEN=99032658&jsessionid=e0309875f8126fb6c9897c55256e7b5a1cd5
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 22:39:51'}
sessionid e03099c9ca54527cca7a5447c4c20a381644
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~midwest~&gr=midwest-basswood-sticks.html
urltoken CFID=29246202&CFTOKEN=19195468&jsessionid=e03099c9ca54527cca7a5447c4c20a381644
validationerror [empty string]


This domestic wood, selectively cut in Northern Michigan and Wisconsin, is desired because of its economy, workability, and finishing qualities. Its close, tight, homogenous grain structure makes it ideal for a wide variety of hobbies, crafts, and miniatures.

Thin basswood may be cut with a hobby knife; thicker basswood requires a saw for cutting. Basswood may be stained or painted to represent any wood type.

Also available in sheets.



Share on Facebook Twitter Pinterest

Ask a question about Basswood Sticks Ask a question about this product

Basswood Sticks

by Midwest

Average User Rating: Based on (6 Reviews)

5 6

Arik L. from College Park, MD says:

Great quality and precision cut. 3' lengths are very nice - most other place only have 18" or shorter.

[Read All Reviews] [Write a Review]









  Item# Image thickness
Ascending
dimensions Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
64924
Basswood Sticks 1/32 in. 1/4 in. x 24 in.
Zoom Image
1/32 in. 1/4 in. x 24 in. 4016 $0.39 $0.31 20% Off $0.27 30% Off Email When In Stock
Add to Favorites
64925
Basswood Sticks 1/32 in. 1/8 in. x 24 in.
Zoom Image
1/32 in. 1/8 in. x 24 in. 4019 $0.29 $0.23 20% Off $0.20 30% Off Email When In Stock
Add to Favorites
64926
Basswood Sticks 1/32 in. 3/16 in. x 24 in.
Zoom Image
1/32 in. 3/16 in. x 24 in. 4020 $0.29 $0.23 20% Off $0.20 30% Off Email When In Stock
Add to Favorites
75447
Basswood Sticks 5/32 in. 5/32 in. x 24 in.
Zoom Image
5/32 in. 5/32 in. x 24 in. 4050 $0.49 $0.39 20% Off $0.34 30% Off Email When In Stock
Add to Favorites
17348
Basswood Sticks 1/4 in. 1/4 in. x 24 in.
Zoom Image
1/4 in. 1/4 in. x 24 in. 4066 $0.79 $0.63 20% Off $0.55 30% Off Email When In Stock
Add to Favorites
63974
Basswood Sticks 1/4 in. 1/2 in. x 24 in.
Zoom Image
1/4 in. 1/2 in. x 24 in. 4069 $1.29 $1.03 20% Off $0.90 30% Off Email When In Stock
Add to Favorites
80796
Basswood Sticks 1/4 in. 3/8 in. x 24 in.
Zoom Image
1/4 in. 3/8 in. x 24 in. 4068 $1.09 $0.87 20% Off $0.76 30% Off Email When In Stock
Add to Favorites
10138
Basswood Sticks 5/16 in. 5/16 in. x 24 in.
Zoom Image
5/16 in. 5/16 in. x 24 in. 4077 $0.99 $0.79 20% Off $0.69 30% Off Email When In Stock
Add to Favorites
45931
Basswood Sticks 1/2 in. 1/2 in. x 24 in.
Zoom Image
1/2 in. 1/2 in. x 24 in. 4099 $1.99 $1.59 20% Off $1.39 30% Off Email When In Stock
Add to Favorites
25336
Basswood Sticks 1/16 in. 3/32 in. x 24 in.
Zoom Image
1/16 in. 3/32 in. x 24 in. 4023 $0.29 $0.23 21% Off $0.20 31% Off Email When In Stock
Add to Favorites
38535
Basswood Sticks 1/16 in. 1/16 in. x 24 in.
Zoom Image
1/16 in. 1/16 in. x 24 in. 4022 $0.29 $0.23 20% Off $0.20 30% Off Email When In Stock
Add to Favorites
55896
Basswood Sticks 1/16 in. 1/8 in. x 24 in.
Zoom Image
1/16 in. 1/8 in. x 24 in. 4024 $0.29 $0.23 21% Off $0.20 31% Off Email When In Stock
Add to Favorites
64927
Basswood Sticks 1/16 in. 3/8 in. x 24 in.
Zoom Image
1/16 in. 3/8 in. x 24 in. 4028 $0.59 $0.47 20% Off $0.41 31% Off Email When In Stock
Add to Favorites
65415
Basswood Sticks 1/16 in. 3/16 in. x 24 in.
Zoom Image
1/16 in. 3/16 in. x 24 in. 4025 $0.39 $0.31 20% Off $0.27 30% Off Email When In Stock
Add to Favorites
76246
Basswood Sticks 1/16 in. 1/2 in. x 24 in.
Zoom Image
1/16 in. 1/2 in. x 24 in. 4029 $0.79 $0.63 20% Off $0.55 30% Off Email When In Stock
Add to Favorites
84324
Basswood Sticks 1/16 in. 1/4 in. x 24 in.
Zoom Image
1/16 in. 1/4 in. x 24 in. 4026 $0.49 $0.39 20% Off $0.34 30% Off Email When In Stock
Add to Favorites
26822
Basswood Sticks 3/32 in. 1/4 in. x 24 in.
Zoom Image
3/32 in. 1/4 in. x 24 in. 4036 $0.49 $0.39 20% Off $0.34 30% Off Email When In Stock
Add to Favorites
56961
Basswood Sticks 3/32 in. 3/32 in. x 24 in.
Zoom Image
3/32 in. 3/32 in. x 24 in. 4033 $0.29 $0.23 20% Off $0.20 30% Off Email When In Stock
Add to Favorites
04672
Basswood Sticks 1/8 in. 3/4 in. x 24 in.
Zoom Image
1/8 in. 3/4 in. x 24 in. 4051 $1.41 $1.13 20% Off $0.99 30% Off Email When In Stock
Add to Favorites
27088
Basswood Sticks 1/8 in. 1/4 in. x 24 in.
Zoom Image
1/8 in. 1/4 in. x 24 in. 4046 $0.49 $0.39 20% Off $0.34 31% Off Email When In Stock
Add to Favorites
40698
Basswood Sticks 1/8 in. 3/16 in. x 24 in.
Zoom Image
1/8 in. 3/16 in. x 24 in. 4045 $0.49 $0.39 20% Off $0.34 30% Off Email When In Stock
Add to Favorites
64928
Basswood Sticks 1/8 in. 3/8 in. x 24 in.
Zoom Image
1/8 in. 3/8 in. x 24 in. 4048 $0.79 $0.63 20% Off $0.55 30% Off Email When In Stock
Add to Favorites
73735
Basswood Sticks 1/8 in. 1/8 in. x 24 in.
Zoom Image
1/8 in. 1/8 in. x 24 in. 4044 $0.29 $0.23 20% Off $0.20 30% Off Email When In Stock
Add to Favorites
77084
Basswood Sticks 1/8 in. 1/2 in. x 24 in.
Zoom Image
1/8 in. 1/2 in. x 24 in. 4049 $0.99 $0.79 20% Off $0.69 30% Off Email When In Stock
Add to Favorites
20500
Basswood Sticks 3/16 in. 3/8 in. x 24 in.
Zoom Image
3/16 in. 3/8 in. x 24 in. 4058 $0.89 $0.71 20% Off $0.62 30% Off Email When In Stock
Add to Favorites
48741
Basswood Sticks 3/16 in. 3/16 in. x 24 in.
Zoom Image
3/16 in. 3/16 in. x 24 in. 4055 $0.49 $0.39 20% Off $0.34 31% Off Email When In Stock
Add to Favorites
58407
Basswood Sticks 3/16 in. 1/2 in. x 24 in.
Zoom Image
3/16 in. 1/2 in. x 24 in. 4059 $1.09 $0.87 20% Off $0.76 30% Off Email When In Stock
Add to Favorites
64929
Basswood Sticks 3/16 in. 1/4 in. x 24 in.
Zoom Image
3/16 in. 1/4 in. x 24 in. 4056 $0.59 $0.47 20% Off $0.41 31% Off Email When In Stock
Add to Favorites
61403
Basswood Sticks 3/8 in. 3/8 in. x 24 in.
Zoom Image
3/8 in. 3/8 in. x 24 in. 4088 $1.29 $1.03 20% Off $0.90 30% Off Email When In Stock

Click the to add item to your Favorites.



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

Birch Wood Dowels

by Midwest

Essential to any modeling project

From $0.26