Item Search

Item Number: Search

Price Filter

$ to $ Go

RSS

Build Your Neck Online

In Stock Necks

Screaming Deals

Same Great Warmoth Quality At Even Lower Prices

  • NO Exact Results
  • We would be happy to create the item you desire: How To Order
Build Your Neck Online

Search by Category or use the Search Filters to narrow the results. Save Search


SELECT W_Showcase.ss_Showcase_ID, W_Showcase.ss_Description, W_Showcase.ss_Date_Sold,W_Showcase.ss_Price_Catagory,W_Showcase.ss_Pounds,W_Showcase.ss_Oz, CAST (ss_Price_Catagory as decimal) AS price, W_Showcase.ss_OnHold, W_Showcase.ss_Date_Added, Headstock_Guitar.hg_Name, Construction_Neck.cn_Name, W_Showcase.ss_Spotlight, W_Showcase.ss_Date_Activated FROM W_Showcase INNER JOIN W_OrderItemsDetails AS w_oid1 ON W_Showcase.ss_Showcase_ID = w_oid1.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid2 ON W_Showcase.ss_Showcase_ID = w_oid2.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid3 ON W_Showcase.ss_Showcase_ID = w_oid3.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid4 ON W_Showcase.ss_Showcase_ID = w_oid4.oid_Serial_Number INNER JOIN Headstock_Guitar ON Headstock_Guitar.hg_pkIndex = w_oid4.oid_fk_Option INNER JOIN W_OrderItemsDetails AS w_oid5 ON W_Showcase.ss_Showcase_ID = w_oid5.oid_Serial_Number INNER JOIN Construction_Neck ON Construction_Neck.cn_pkIndex = w_oid5.oid_fk_Option WHERE (w_oid1.oid_Sequnce_ID = 35) AND (w_oid1.oid_fk_Option = 1) AND (w_oid2.oid_Sequnce_ID = 1) AND (w_oid2.oid_fk_Option = 10) AND (w_oid3.oid_Sequnce_ID = 34) AND (w_oid3.oid_fk_Option = 310) AND (w_oid4.oid_Sequnce_ID = 1) AND (w_oid5.oid_Sequnce_ID = 2) AND W_Showcase.ss_Spotlight IN (3,4) AND (W_Showcase.ss_Date_Sold = 1/1/1900) ORDER BY ss_Item_Str desc, ss_Item_Num asc