BODYJEWELRY
ACCESSORIES
FILTER
Item per page 4080120

SELECT count(product_image_newstyle.id) as counts 
FROM products_images_newstyles product_image_newstyle
INNER JOIN products product on product_image_newstyle.product_id = product.id
WHERE product.status='active'

SELECT product_image_newstyle.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, product.avail_qty
FROM products_images_newstyles product_image_newstyle
INNER JOIN products product on product_image_newstyle.product_id = product.id
WHERE product.status='active' ORDER BY product.added DESC LIMIT 0,40

SELECT distinct category.categoryurl,category.name
FROM products_images_newstyles a
INNER JOIN products b on a.product_id = b.id
INNER JOIN categories_products cat_prod on cat_prod.product_id = a.product_id
INNER JOIN categories category on category.id = cat_prod.category_id