BODYJEWELRY
ACCESSORIES
FILTERS
Item per page 4080120
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 = 32
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 = 32
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 = 32
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 = 32
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 = 32
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 = 32
and category.status='active')