Item Search

Item Number: Search

Price Filter

$ to $ Go


Build Your Body Online

In Stock Bodies

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 Body 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, Body_Model.bm_Name, Body_Options_Properties.bop_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 Body_Model ON Body_Model.bm_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 Body_Options_Properties ON Body_Options_Properties.bop_pkIndex = w_oid5.oid_fk_Option WHERE (w_oid1.oid_Sequnce_ID = 35) AND (w_oid1.oid_fk_Option = 2) AND (w_oid2.oid_Sequnce_ID = 2) AND (w_oid2.oid_fk_Option = 17) AND (w_oid3.oid_Sequnce_ID = 34) AND (w_oid3.oid_fk_Option = 251) AND (w_oid4.oid_Sequnce_ID = 2) AND (w_oid5.oid_Sequnce_ID = 3) 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