BODYJEWELRY
ACCESSORIES
FILTER
Item per page 4080120

SELECT count(product.id) as counts 
FROM products product
INNER JOIN productsearches search on search.product_id = product.id
INNER JOIN products_images product_image on product_image.product_id = product.id
WHERE (parameters like '%navel%' AND parameters like '%gold%') AND product.status='active'

SELECT count(product.id) as counts
FROM products product
INNER JOIN productsearches search on search.product_id = product.id
INNER JOIN products_images product_image on product_image.product_id = product.id
WHERE (parameters like '%navel%' AND parameters like '%gold%') AND 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 product
INNER JOIN productsearches search on search.product_id = product.id
WHERE (parameters like '%navel%' AND parameters like '%gold%') AND product.status='active' GROUP BY product.image_name ORDER BY product.added DESC LIMIT 0,40

SELECT distinct material.valueurl,material.name
FROM products product
INNER JOIN productsearches search on search.product_id = product.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
WHERE (parameters like '%navel%' AND parameters like '%gold%') AND product.status='active' GROUP BY product.image_name