SELECT `products_id`, `sku`, `main_image`, `product_name` FROM `kalaty_products` WHERE (`products_id` <> '2769') AND (`weave_name`='Loriloom') AND (`color` LIKE '%RED%') AND (`style`='Transitional')