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

Heavy Duty Pine Super Stretcher Bars

by Best


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006637
barcode_type UPC
col1 16 in.
col1_sortorder 983
col2 [empty string]
col3 [empty string]
cost 2.42
deal_of_the_week NO
description 16 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 60037
list_price 6.6
map NO
mfr_num 890005
net_weight 0.75
non_member_discount 32
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 60037
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.97
ta_dealer_c_price 2.64
ta_price 3.96
text
array
1 60037
2 890005
3 16 in.
timestamp 2015-03-31T17:53:54.644Z
vip_member_price 3.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006644
barcode_type UPC
col1 18 in.
col1_sortorder 1055
col2 [empty string]
col3 [empty string]
cost 2.59
deal_of_the_week NO
description 18 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 82679
list_price 7.05
map NO
mfr_num 890006
net_weight 0.75
non_member_discount 31
non_member_price 4.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 82679
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.17
ta_dealer_c_price 2.82
ta_price 4.23
text
array
1 82679
2 890006
3 18 in.
timestamp 2015-03-31T17:54:36.531Z
vip_member_price 4.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006651
barcode_type UPC
col1 20 in.
col1_sortorder 1253
col2 [empty string]
col3 [empty string]
cost 2.89
deal_of_the_week NO
description 20 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 65321
list_price 7.9
map NO
mfr_num 890007
net_weight 1.38
non_member_discount 31
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 65321
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.56
ta_dealer_c_price 3.16
ta_price 4.74
text
array
1 65321
2 890007
3 20 in.
timestamp 2015-03-31T17:54:08.734Z
vip_member_price 4.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006675
barcode_type UPC
col1 24 in.
col1_sortorder 1331
col2 [empty string]
col3 [empty string]
cost 3.36
deal_of_the_week NO
description 24 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 35824
list_price 9.15
map NO
mfr_num 890009
net_weight 0.84
non_member_discount 31
non_member_price 6.3
prop65 NO
ship_rule_desc STD
shipping STD
sku 35824
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.12
ta_dealer_c_price 3.66
ta_price 5.49
text
array
1 35824
2 890009
3 24 in.
timestamp 2015-03-31T17:53:18.652Z
vip_member_price 5.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006699
barcode_type UPC
col1 26 in.
col1_sortorder 1407
col2 [empty string]
col3 [empty string]
cost 3.92
deal_of_the_week NO
description 26 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 70280
list_price 10.7
map NO
mfr_num 890011
net_weight 0.96
non_member_discount 31
non_member_price 7.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 70280
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.82
ta_dealer_c_price 4.28
ta_price 6.42
text
array
1 70280
2 890011
3 26 in.
timestamp 2015-03-31T17:54:18.273Z
vip_member_price 6.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006736
barcode_type UPC
col1 30 in.
col1_sortorder 1607
col2 [empty string]
col3 [empty string]
cost 4.47
deal_of_the_week NO
description 30 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 72651
list_price 12.2
map NO
mfr_num 890015
net_weight 1.04
non_member_discount 31
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 72651
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.49
ta_dealer_c_price 4.88
ta_price 7.32
text
array
1 72651
2 890015
3 30 in.
timestamp 2015-03-31T17:54:23.84Z
vip_member_price 7.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006798
barcode_type UPC
col1 36 in.
col1_sortorder 1679
col2 [empty string]
col3 [empty string]
cost 5.34
deal_of_the_week NO
description 36 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 37473
list_price 14.6
map NO
mfr_num 890021
net_weight 1.18
non_member_discount 31
non_member_price 10.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 37473
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.57
ta_dealer_c_price 5.84
ta_price 8.76
text
array
1 37473
2 890021
3 36 in.
timestamp 2015-03-31T17:53:20.785Z
vip_member_price 8.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006835
barcode_type UPC
col1 40 in.
col1_sortorder 1833
col2 [empty string]
col3 [empty string]
cost 6.39
deal_of_the_week NO
description 40 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 19518
list_price 17.45
map NO
mfr_num 890025
net_weight 1.4
non_member_discount 31
non_member_price 12.01
prop65 NO
ship_rule_desc STD
shipping STD
sku 19518
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.85
ta_dealer_c_price 6.98
ta_price 10.47
text
array
1 19518
2 890025
3 40 in.
timestamp 2015-03-31T17:52:52.239Z
vip_member_price 10.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006842
barcode_type UPC
col1 42 in.
col1_sortorder 1862
col2 [empty string]
col3 [empty string]
cost 6.48
deal_of_the_week NO
description 42 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 47786
list_price 17.7
map NO
mfr_num 890026
net_weight 1.22
non_member_discount 31
non_member_price 12.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 47786
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.97
ta_dealer_c_price 7.08
ta_price 10.62
text
array
1 47786
2 890026
3 42 in.
timestamp 2015-03-31T17:53:33.614Z
vip_member_price 10.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006873
barcode_type UPC
col1 48 in.
col1_sortorder 1884
col2 [empty string]
col3 [empty string]
cost 7.38
deal_of_the_week NO
description 48 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 52439
list_price 20.15
map NO
mfr_num 890029
net_weight 1.28
non_member_discount 31
non_member_price 13.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 52439
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.07
ta_dealer_c_price 8.06
ta_price 12.09
text
array
1 52439
2 890029
3 48 in.
timestamp 2015-03-31T17:53:45.209Z
vip_member_price 11.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006880
barcode_type UPC
col1 50 in.
col1_sortorder 2020
col2 [empty string]
col3 [empty string]
cost 7.5
deal_of_the_week NO
description 50 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 14200
list_price 20.5
map NO
mfr_num 890030
net_weight 1.64
non_member_discount 31
non_member_price 14.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 14200
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.23
ta_dealer_c_price 8.2
ta_price 12.3
text
array
1 14200
2 890030
3 50 in.
timestamp 2015-03-31T17:52:42.581Z
vip_member_price 12.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006903
barcode_type UPC
col1 54 in.
col1_sortorder 2053
col2 [empty string]
col3 [empty string]
cost 8.02
deal_of_the_week NO
description 54 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 57724
list_price 21.9
map NO
mfr_num 890032
net_weight 2
non_member_discount 31
non_member_price 15.06
prop65 NO
ship_rule_desc STD
shipping STD
sku 57724
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.86
ta_dealer_c_price 8.76
ta_price 13.14
text
array
1 57724
2 890032
3 54 in.
timestamp 2015-03-31T17:53:51.579Z
vip_member_price 13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006934
barcode_type UPC
col1 60 in.
col1_sortorder 2149
col2 [empty string]
col3 [empty string]
cost 8.92
deal_of_the_week NO
description 60 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 82496
list_price 24.35
map NO
mfr_num 890035
net_weight 2.36
non_member_discount 31
non_member_price 16.74
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 82496
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.96
ta_dealer_c_price 9.74
ta_price 14.61
text
array
1 82496
2 890035
3 60 in.
timestamp 2015-03-31T17:54:36.258Z
vip_member_price 14.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304044110
barcode_type UPC
col1 66 in.
col1_sortorder 2170
col2 [empty string]
col3 [empty string]
cost 9.15
deal_of_the_week NO
description 66 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 66370
list_price 25
map NO
mfr_num 890062
net_weight 1.68
non_member_discount 31
non_member_price 17.22
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 66370
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.25
ta_dealer_c_price 10
ta_price 15
text
array
1 66370
2 890062
3 66 in.
timestamp 2015-03-31T17:54:10.69Z
vip_member_price 14.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006965
barcode_type UPC
col1 72 in.
col1_sortorder 2237
col2 [empty string]
col3 [empty string]
cost 9.8
deal_of_the_week NO
description 72 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 78718
list_price 26.75
map NO
mfr_num 890038
net_weight 2.04
non_member_discount 31
non_member_price 18.41
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 78718
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.04
ta_dealer_c_price 10.7
ta_price 16.05
text
array
1 78718
2 890038
3 72 in.
timestamp 2015-03-31T17:54:31.641Z
vip_member_price 15.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304043618
barcode_type UPC
col1 78 in.
col1_sortorder 2248
col2 [empty string]
col3 [empty string]
cost 11.13
deal_of_the_week NO
description 78 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 30615
list_price 30.4
map NO
mfr_num 890055
net_weight 2.74
non_member_discount 31
non_member_price 20.93
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 30615
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.68
ta_dealer_c_price 12.16
ta_price 18.24
text
array
1 30615
2 890055
3 78 in.
timestamp 2015-03-31T17:53:08.848Z
vip_member_price 18.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304006996
barcode_type UPC
col1 84 in.
col1_sortorder 2345
col2 [empty string]
col3 [empty string]
cost 12.94
deal_of_the_week NO
description 84 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 79840
list_price 35.35
map NO
mfr_num 890041
net_weight 2.4
non_member_discount 31
non_member_price 24.31
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 79840
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.91
ta_dealer_c_price 14.14
ta_price 21.21
text
array
1 79840
2 890041
3 84 in.
timestamp 2015-03-31T17:54:32.895Z
vip_member_price 20.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


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

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

ItemIDList: 28840
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 717304007023
barcode_type UPC
col1 96 in.
col1_sortorder 2400
col2 [empty string]
col3 [empty string]
cost 19.58
deal_of_the_week NO
description 96 in.
group_id 2774
group_uname best-heavy-duty-pine-super-stretcher-bars
id 61249
list_price 53.5
map NO
mfr_num 890044
net_weight 3.22
non_member_discount 31
non_member_price 36.83
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 61249
sku_pix YES
supplier_id 1
ta_dealer_a_price 24.08
ta_dealer_c_price 21.4
ta_price 32.1
text
array
1 61249
2 890044
3 96 in.
timestamp 2015-03-31T17:54:00.042Z
vip_member_price 31.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 28840
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1989' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e03027c865449748c17f11b5a6f5ed662f7e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-dispensers&CatC=fp~7-160~&gr=3m-scotch-mainline-dispenser-p52.html
urltoken CFID=30597297&CFTOKEN=56835590&jsessionid=e03027c865449748c17f11b5a6f5ed662f7e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:15:31'}
sessionid e030163d887587b8687972504ea413942e26
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=fb~best~fp~21-9999.99~&gr=best-heavy-duty-pine-super-stretcher-bars.html
urltoken CFID=30597298&CFTOKEN=99981207&jsessionid=e030163d887587b8687972504ea413942e26
validationerror [empty string]


Heavy duty pine super stretcher bars are truly that, super bars. The Super Bar is made of pine that has been finger spliced. Finger splicing is a method of bonding pieces of lumber together to form a very long straight bar. The spliced joints are actually stronger than the natural wood. The advantage to this method is that we can now get longer, stronger and straighter bars than ever before. First designed for the construction industry, this high tech method is giving better bars than ever before. Sold individually, not in pairs. 2 1/2 in. high. 7/8 in. thick on flat edge. 1 3/8 in. thick on rolled edge.

Share on Facebook Twitter Pinterest

Ask a question about Heavy Duty Pine Super Stretcher Bars Ask a question about this product

Heavy Duty Pine Super Stretcher Bars

by Best

Average User Rating: Based on (15 Reviews)

5 15

Rod P. from Marble Falls, TX says:

Good solid straight stretcher bars. Corners are not always perfect but can be sanded down to form smooth joints.

[Read All Reviews] [Write a Review]









  Item# Image size
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
60037
Heavy Duty Pine Super Stretcher Bars 16 in.
Zoom Image
16 in. 890005 $6.60 $4.51 32% Off $3.90 41% Off Email When In Stock
Add to Favorites
82679
Heavy Duty Pine Super Stretcher Bars 18 in.
Zoom Image
18 in. 890006 $7.05 $4.84 31% Off $4.18 41% Off Email When In Stock
Add to Favorites
65321
Heavy Duty Pine Super Stretcher Bars 20 in.
Zoom Image
20 in. 890007 $7.90 $5.42 31% Off $4.68 41% Off Email When In Stock
Add to Favorites
35824
Heavy Duty Pine Super Stretcher Bars 24 in.
Zoom Image
24 in. 890009 $9.15 $6.30 31% Off $5.44 41% Off Email When In Stock
Add to Favorites
70280
Heavy Duty Pine Super Stretcher Bars 26 in.
Zoom Image
26 in. 890011 $10.70 $7.37 31% Off $6.36 41% Off Email When In Stock
Add to Favorites
72651
Heavy Duty Pine Super Stretcher Bars 30 in.
Zoom Image
30 in. 890015 $12.20 $8.37 31% Off $7.22 41% Off Email When In Stock
Add to Favorites
37473
Heavy Duty Pine Super Stretcher Bars 36 in.
Zoom Image
36 in. 890021 $14.60 $10.04 31% Off $8.67 41% Off Email When In Stock
Add to Favorites
19518
Heavy Duty Pine Super Stretcher Bars 40 in.
Zoom Image
40 in. 890025 $17.45 $12.01 31% Off $10.37 41% Off Email When In Stock
Add to Favorites
47786
Heavy Duty Pine Super Stretcher Bars 42 in.
Zoom Image
42 in. 890026 $17.70 $12.15 31% Off $10.49 41% Off Email When In Stock
Add to Favorites
52439
Heavy Duty Pine Super Stretcher Bars 48 in.
Zoom Image
48 in. 890029 $20.15 $13.87 31% Off $11.96 41% Off Email When In Stock
Add to Favorites
14200
Heavy Duty Pine Super Stretcher Bars 50 in.
Zoom Image
50 in. 890030 $20.50 $14.09 31% Off $12.15 41% Off Email When In Stock
Add to Favorites
57724
Heavy Duty Pine Super Stretcher Bars 54 in.
Zoom Image
54 in. 890032 $21.90 $15.06 31% Off $13.00 41% Off Email When In Stock
Add to Favorites Heavy Duty Pine Super Stretcher Bars 60 in.
Zoom Image
60 in. 890035 $24.35 $16.74 31% Off $14.44 41% Off Email When In Stock
Add to Favorites Heavy Duty Pine Super Stretcher Bars 66 in.
Zoom Image
66 in. 890062 $25.00 $17.22 31% Off $14.85 41% Off Email When In Stock
Add to Favorites Heavy Duty Pine Super Stretcher Bars 72 in.
Zoom Image
72 in. 890038 $26.75 $18.41 31% Off $15.89 41% Off Email When In Stock
Add to Favorites Heavy Duty Pine Super Stretcher Bars 78 in.
Zoom Image
78 in. 890055 $30.40 $20.93 31% Off $18.06 41% Off Email When In Stock
Add to Favorites Heavy Duty Pine Super Stretcher Bars 84 in.
Zoom Image
84 in. 890041 $35.35 $24.31 31% Off $20.98 41% Off Email When In Stock
Add to Favorites Heavy Duty Pine Super Stretcher Bars 96 in.
Zoom Image
96 in. 890044 $53.50 $36.83 31% Off $31.78 41% Off Email When In Stock

Click the to add item to your Favorites.



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

Canvas Pliers

by Fredrix

Stretch canvas, not your budget

Up to 30% Off

Heavy Body Professional Artist Acrylic...

by Liquitex

Smooth, thick, buttery consistency

At Least 39 % Off

From $2.14

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 Heavy Duty Pine Super Stretcher Bars

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.

Customer Product Reviews
Write a Review
Write a Review
Rated by: Rod P. in Marble Falls, TX
Good solid straight stretcher bars. Corners are not always perfect but can be sanded down to form smooth joints.
Rated by: Jim F. in Yuba City, CA
I was disappointed with this brand. Obviously, I'm the only one here. But, for what's it's worth, the shorter (one piece) bars were great, but the longer ones (multiple pieces spliced together to make one long bar ... why?) bent at the joints and were probably the first ones that "craftsman" did on training day #1. Go Discovery or Fredrix - one piece (no splicing) and better quality.
Rated by: Dan K. in San Diego, CA
Good quality, very strong stretcher bars, real professionsl material. And Misterart have a quick and perfect shipping service. Best deal on the market.
Rated by: Janet E. in Phoenix, AZ
I continue to order from Misterart and have NEVER been disappointed. The prices are terrific and the merchandise arrives quickly. Thank you for this wonderful site.
Rated by: Molly F. in Dallas, TX
These are the best, no kidding, bars you can get. Ease of transaction, the price, and I've never had a company so consistently early in delivery! Cheers!
Rated by: Beverly M. in Malvern, AR
excellent stretcher bars.
Rated by: Janet F. in Highland, MI
The quality is exceptional as well as Misterart.com's service.
Rated by: Aaron W. in Santa Clarita, CA
These are the best bars I've every used, they are extremly sturdy and straight.
Rated by: Ara Lou P. in Naples, FL
The stretcher bars are of excellent quality and arrived in perfect condition. I have completed a painting on one set and am extremely pleased with the superior results.
Rated by: bren c. in gunnison, CO
these stretchers are tight. love them! the groove on the back side helps when your mega large works need corner braces or support bars. highly recommend.
Rated by: bren c. in gunnison, CO
these stretchers are tight. love them! the groove on the back side helps when your mega large works need corner braces or support bars. highly recommend.
Rated by: Monica H. in Fayetteville, NC
These are the first stretchers I have used and they are excellent. They fit perfectly and I was able to stretch a large size canvas with no problem. Highly recommend if you plan on stretching a canvas over 5 ft.
Rated by: Andrew G. in Los Angeles, CA
Easy to assemble and very solid.
Rated by: Kerry B. in Bton Rouge, LA
Best are the absolute best... and the price is nice! Always straight and always square. Excellent support! A+++++
Rated by: Steve von B. in Ft.Lauderdale, FL
As advertised .Perfect fit and size.

Write a Product Review for Heavy Duty Pine Super Stretcher Bars

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