SELECT product.id, product.image_name, product.brand_id, product.description, product.number, product.price, product.s_price, product.reg_price, product.discount_value, product.discount_chart, product.package_deal, product.new_styles, product.producturlid 
FROM products_images product_image
INNER JOIN products product on product_image.product_id = product.id
INNER JOIN categories_products category_product ON category_product.product_id = product.id
INNER JOIN categories as category on category.id = category_product.category_id
WHERE (category_product.category_id = 13
and category.status='active') ORDER BY product.added DESC LIMIT 0, 40

SELECT distinct subcategory.id, subcategory.name, subcategory.valueurl
FROM products_images product_image
INNER JOIN products product ON product.id = product_image.product_id
INNER JOIN categories_products category_product ON category_product.product_id = product_image.product_id
INNER JOIN categories category ON category.id = category_product.category_id
INNER JOIN subcategories_products subcategory_product ON subcategory_product.product_id = category_product.product_id
INNER JOIN subcategories subcategory ON ( subcategory.id = subcategory_product.subcategory_id AND subcategory.status='active' )
WHERE (category_product.category_id = 13
and category.status='active')

SELECT distinct material.valueurl,material.name
FROM products_images product_image
INNER JOIN products product ON product_image.product_id = product.id
INNER JOIN categories_products category_product ON category_product.product_id = product.id
INNER JOIN categories as category on category.id = category_product.category_id
INNER JOIN materials_products as material_product on material_product.product_id = product.id
INNER JOIN materials as material on ( material.id = material_product.material_id AND material.status='active' )
WHERE (category_product.category_id = 13
and category.status='active')

SELECT distinct productdimension.gaugeincurl, productdimension.gaugeinch
FROM products_images product_image
INNER JOIN products product ON product_image.product_id = product.id
INNER JOIN categories_products category_product ON category_product.product_id = product.id
INNER JOIN categories as category on category.id = category_product.category_id
INNER JOIN productdimensions AS productdimension ON productdimension.product_id = product.id
WHERE (category_product.category_id = 13
and category.status='active') AND productdimension.gaugeinch != ''

SELECT distinct productdimension.lengthinurl, productdimension.lengthinch
FROM products_images product_image
INNER JOIN products product ON product_image.product_id = product.id
INNER JOIN categories_products category_product ON category_product.product_id = product.id
INNER JOIN categories as category on category.id = category_product.category_id
INNER JOIN productdimensions AS productdimension ON productdimension.product_id = product.id
WHERE (category_product.category_id = 13
and category.status='active') AND productdimension.lengthinch != ''

SELECT distinct bodypart.valueurl,bodypart.name
FROM products_images product_image
INNER JOIN products product ON product_image.product_id = product.id
INNER JOIN categories_products category_product ON category_product.product_id = product.id
INNER JOIN categories as category on category.id = category_product.category_id
INNER JOIN bodyparts_products bodypart_product on bodypart_product.product_id = category_product.product_id
INNER JOIN bodyparts bodypart on bodypart.id = bodypart_product.bodypart_id
WHERE (category_product.category_id = 13
and category.status='active')
					
					
				

Distributor of Wholesale Body Jewelry and Professional Body Piercing Jewelry, Ear Plugs, Nose Studs, Labrets, and Belly Rings Supply.

We are proud to supply a full line of professional wholesale body jewelry products and unique body piercing jewelry, ear plugs, nose studs, labrets, and belly rings supply. Unique Body Jewelry can help any retailers boost sales. We offer the newest and freshest style.

Bodyvibe insures customers to find superb newest wholesale body jewelry in our web and always at the very best quality and prices in the industry. Quantity and volume discounts offered to our beloved customers.

Be part of the best and experience the most popular wide selection styles of body piercing jewelry today. Take time exploring our site. What you receive is more than what you see and expected.