Item per page 4080120

SELECT DISTINCT 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
INNER JOIN products_images product_image 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 material_product ON material_product.product_id = product.id
INNER JOIN materials material ON ( material_product.material_id = material.id )
INNER JOIN productdimensions as productdimension ON productdimension.product_id = product.id
INNER JOIN bodyparts_products bodypart_product ON bodypart_product.product_id = product.id
INNER JOIN bodyparts bodypart ON ( bodypart_product.bodypart_id = bodypart.id )
WHERE product.status='active' and product.brand_id = 7 AND parameters regexp 'punisher' 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 product.status='active' and product.brand_id = 7 AND subcategory.valueurl != "."

SELECT distinct material.valueurl,material.name
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
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 material_product ON material_product.product_id = product.id
INNER JOIN materials material ON ( material_product.material_id = material.id )
INNER JOIN productdimensions as productdimension ON productdimension.product_id = product.id
INNER JOIN bodyparts_products bodypart_product ON bodypart_product.product_id = product.id
INNER JOIN bodyparts bodypart ON ( bodypart_product.bodypart_id = bodypart.id )
WHERE product.status='active' and product.brand_id = 7 AND parameters regexp 'punisher'

SELECT distinct productdimension.gaugeincurl, productdimension.gaugeinch, (REPLACE(productdimension.gaugemm, 'mm', '') * 1) as gaugemm
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
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 material_product ON material_product.product_id = product.id
INNER JOIN materials material ON ( material_product.material_id = material.id )
INNER JOIN productdimensions as productdimension ON productdimension.product_id = product.id
INNER JOIN bodyparts_products bodypart_product ON bodypart_product.product_id = product.id
INNER JOIN bodyparts bodypart ON ( bodypart_product.bodypart_id = bodypart.id )
WHERE product.status='active' and product.brand_id = 7 AND parameters regexp 'punisher' AND productdimension.gaugeinch != '' AND productdimension.gaugeinch LIKE '%"%'ORDER BY gaugemm

SELECT distinct productdimension.lengthinurl, productdimension.lengthinch
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
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 material_product ON material_product.product_id = product.id
INNER JOIN materials material ON ( material_product.material_id = material.id )
INNER JOIN productdimensions as productdimension ON productdimension.product_id = product.id
INNER JOIN bodyparts_products bodypart_product ON bodypart_product.product_id = product.id
INNER JOIN bodyparts bodypart ON ( bodypart_product.bodypart_id = bodypart.id )
WHERE product.status='active' and product.brand_id = 7 AND parameters regexp 'punisher' AND productdimension.lengthinch != ''

SELECT distinct bodypart.valueurl,bodypart.name
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
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 material_product ON material_product.product_id = product.id
INNER JOIN materials material ON ( material_product.material_id = material.id )
INNER JOIN productdimensions as productdimension ON productdimension.product_id = product.id
INNER JOIN bodyparts_products bodypart_product ON bodypart_product.product_id = product.id
INNER JOIN bodyparts bodypart ON ( bodypart_product.bodypart_id = bodypart.id )
WHERE product.status='active' and product.brand_id = 7 AND parameters regexp 'punisher' AND bodypart.valueurl != '.'