Unwind in Style with Our Lounge Sets, Bralettes, and Slips
Step into a world of comfort with our curated selection of women's loungewear. From cozy lounge sets perfect for a night in, to chic bralettes and slips that make a statement, we at Leto Wholesale are committed to providing quality and style at wholesale prices. Your customers will appreciate the addition of our premium loungewear to your e-commerce store, and you'll love the increased revenue they bring. Join us and elevate your relaxation experience while boosting your business.
Discover Comfort with Our Women's Loungewear
Unwind in Style with Our Lounge Sets, Bralettes, and Slips
Step into a world of comfort with our curated selection of women's loungewear. From cozy lounge sets perfect for a night in, to chic bralettes and slips that make a statement, we at Leto Wholesale are committed to providing quality and style at wholesale prices. Your customers will appreciate the addition of our premium loungewear to your e-commerce store, and you'll love the increased revenue they bring. Join us and elevate your relaxation experience while boosting your business.
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (9771, 9765, 9744, 9634, 9631, 9625, 9413, 9281, 9138, 9137, 9131, 9083)) ORDER BY FIELD(e.entity_id,9771,9765,9744,9634,9631,9625,9413,9281,9138,9137,9131,9083)
Order Column: FIELD(e.entity_id,9771,9765,9744,9634,9631,9625,9413,9281,9138,9137,9131,9083)
Order Direction:
order by: "position" D: "asc"options: "{\"productListToolbarForm\":{\"mode\":\"product_list_mode\",\"direction\":\"product_list_dir\",\"order\":\"product_list_order\",\"limit\":\"product_list_limit\",\"modeDefault\":\"grid\",\"directionDefault\":\"asc\",\"orderDefault\":\"position\",\"limitDefault\":12,\"url\":\"https:\\\/\\\/letowholesale.com\\\/wholesale-loungewear-clothing.html\",\"formKey\":\"E6hkl93UMLdfQgJx\",\"post\":false}}" D: "asc"options: {"type":"Magento\\Catalog\\Block\\Product\\ProductList\\Toolbar\\Interceptor","_current_grid_order":"position","_current_grid_mode":"grid","_current_limit":12,"_current_grid_direction":"asc"} D: "asc"
