BODYJEWELRY
ACCESSORIES
FILTER
Item per page 4080120
SELECT count(product_image_onsale.id) as counts 
FROM products_images_onsales product_image_onsale
INNER JOIN products product on product_image_onsale.product_id = product.id
WHERE product.status='active'

SELECT product.id as 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_onsales product_image_onsale
INNER JOIN products product on product_image_onsale.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_onsales product_image_onsale
INNER JOIN products product on product_image_onsale.product_id = product.id
INNER JOIN categories_products category_product on category_product.product_id = product.id
INNER JOIN categories category on category.id = category_product.category_id
WHERE product.status='active'