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

Magnifier Incandescent Lamp

by Studio Designs


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

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

ItemIDList: 17485
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 017342123083
barcode_type UPC
col1 magnifier lamp
col1_sortorder 3649
col2 [empty string]
col3 [empty string]
cost 18.5
deal_of_the_week NO
description magnifier lamp
group_id 2505
group_uname studio-designs-magnifier-incandescent-lamp
id 45195
list_price 43.06
map NO
mfr_num 12308
net_weight 3.08
non_member_discount 35
non_member_price 27.99
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 45195
sku_pix YES
supplier_id 1
ta_dealer_a_price 25.84
ta_dealer_c_price 20.24
ta_price 30.14
text
array
1 45195
2 12308
3 magnifier lamp
timestamp 2015-03-30T16:20:30.422Z
vip_member_price 23.68

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 17485
CACHED false
EXECUTIONTIME 7
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] = '7411' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=furniture&catB=fb~studio-designs~fp~0-54~&gr=studio-designs-magnifier-incandescent-lamp.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:12:43'}
sessionid e0302c40d939577e9fc51973f41377a355e7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~testors~fp~4-14~c1~airbrushing~c2~airbrush-mediums~&gr=testors-model-master-acryl-thinner.html
urltoken CFID=30393978&CFTOKEN=29153234&jsessionid=e0302c40d939577e9fc51973f41377a355e7
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:12:43'}
sessionid e030f8d0d8df4e8680027d4095a1b705554d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=fb~studio-designs~fp~0-54~&gr=studio-designs-magnifier-incandescent-lamp.html
urltoken CFID=30393979&CFTOKEN=33271510&jsessionid=e030f8d0d8df4e8680027d4095a1b705554d
validationerror [empty string]


This lamp boasts a 4 in., three-diopter glass magnification lens with 60-watt capacity and a flexible swing arm that extends up to 36 inches. Also features steel spring and tension control knobs and includes a three-way metal C-clamp.

Share on Facebook Twitter Pinterest

Ask a question about Magnifier Incandescent Lamp Ask a question about this product  |  See all questions & answers (2)

Magnifier Incandescent Lamp

by Studio Designs

Average User Rating: Based on (2 Reviews)

5 2

Carol K. from Philadelphia Area, PA says:

This is a nice little lamp and well worth the small investment. The magnifying glass is much stronger than I imagined for the price.

[Read All Reviews] [Write a Review]









  Item# Image description
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
17485
Magnifier Incandescent Lamp 4 oz. bottle
Zoom Image
4 oz. bottle 50496A $9.18 $7.37 15% Off $6.50 25% Off Email When In Stock

Click the to add item to your Favorites.



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

Up to 50% Off

Transparent Triangles

by C-Thru

Professional grade tools

From $0.81

Multipurpose Cutting Mats

by Pacific Arc

Great for cutting and writing

Up to 40% Off

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 »

Product Questions and Answers

Ask a Question
Ask a Question

What type of light bulbs does it use?

- Asked by Liz on 17-Sep-13
Answer

The Magnifier Incandescent Lamp comes with a 60 watt bulb. We do not sell the replacement bulbs for these lamps. However, you can purchase them from Studio Designs directly if needed.

- Answered by MisterArt on 18-Sep-13

How do you connect the lamp to a desk?

- Asked by Garrett Lange on 18-Nov-12
Answer

The lamp comes with a three-way metal C-clamp. Just slip the clamp on to the edge of your table. Once you have the clamp in position, screw in the metal adjust bar to hold the clamp in place.

- Answered by MisterArt on 21-Nov-12

Ask a Question About Magnifier Incandescent Lamp


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: Carol K. in Philadelphia Area, PA
This is a nice little lamp and well worth the small investment. The magnifying glass is much stronger than I imagined for the price.
Rated by: Susie N. in Birmingham, AL
The lamp was delivered without a problem and packaged well. It also works great!

Write a Product Review for Magnifier Incandescent Lamp

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