SELECT dimension_1feet, dimension_1inch, dimension_2feet, dimension_2inch, Product.product_flat_ship, Product.id, Product.product_name,Product.category_image_name, Product.ebay_title,Product.slug, Product.product_qty, Product.created, Product.product_sku,Product.product_new_sku, Product.price, Product.status, Product.sold_status, Product.sold_to, Product.total_sq_fet, Product.msrp, Product.overstock_othersizes, Product.product_primary_cat,Product.deal_of_day, IFNULL((Select ProductImage.image from product_images AS ProductImage WHERE ProductImage.product_id = Product.id ORDER BY ProductImage.product_id asc limit 1),'') AS image FROM products AS Product WHERE (`Product`.`status` = 1) AND (`Product`.`sold_status` != 2) AND (`Product`.`product_qty` > '0') AND (`Product`.`product_cat` != '88') AND (`Product`.`product_primary_cat` != '88') AND ( (`Product`.`product_publish_to` LIKE '%38%') OR (`Product`.`product_publish_to` LIKE '%,38%') OR (`Product`.`product_publish_to` LIKE '%38,%') OR (`Product`.`product_publish_to` LIKE '%,38,%') ) AND (`Product`.`product_primary_cat` IN ('76') OR `Product`.`product_cat` LIKE '%76%' OR `Product`.`product_cat` LIKE '%,76%' OR `Product`.`product_cat` LIKE '%76,%' OR `Product`.`product_cat` LIKE '%,76,%') GROUP BY Product.id ORDER BY id desc LIMIT 36,9 Wool And Silk Rugs - 1800 Get A Rug
HOLIDAYS RUG SALE EVENT - UP TO 70% OFF
1800getarug.com   |   Handmade Rugs   |   Call now: 201-933-4300   |   40 Universal Place | Carlstadt, N.J., 07072
Copyright © 1990-2020 1800getarug All rights reserved.