FROM inventory, inventory_by_location
 SHOW days_in_stock, days_in_stock_at_location, days_out_of_stock
WHERE product_tags NOT IN ['24X7 Men', '24x7 Woman', '3 by 4 Sleeved Vest', '3/4th Sleeve Top Leggings Set', 'Accessories', 'Active Bras', 'Ankle Length Socks', 'Ankle Socks', 'Apparel Bottoms', 'Apparel Bottoms Joggers', 'Apparel Tops', 'Apparel Tops Colors_To_Explore', 'Apparel Tops Hoodie', 'Apparel Tops Jacket', 'Apparel Tops Jackets', 'Apparel Tops Men', 'Athleisure', 'Athleisure Full Sleeve T Shirts For Men', 'Athleisure Hoodie', 'Bath Towel', 'Beginners Bras', 'Bermudas', 'Bestseller', 'Bikinis', 'Bloomers', 'Blue Polo T Shirts', 'Bonded', 'Bottom Thermals', 'Bottoms for Teens', 'Boxer Briefs', 'Boxer Shorts', 'Boy Leg', 'boy shorts', 'Boyleg', 'Boys Apparel Bottoms', 'Boys Apparel Tops', 'Boys Innerwear', 'Boys Sets', 'bra', 'Bras', 'Briefs', 'Calf Length', 'Calf Length Socks', 'Camisole', 'Camisoles', 'Cap', 'Capris', 'Cargo Jogger', 'Cargo Pants', 'Casual Socks', 'Checkered', 'Colors_To_Explore', 'Comfies', 'Cotton_Panties', 'Crew Length Socks', 'Crop Tops', 'Culotte Pants', 'Elance', 'Essence', 'Essentials', 'Everyday Basics', 'Everyday Bras', 'Face Towel', 'Fashion Essentials', 'Final_2_Colors_to_Explore', 'Final_Colors_To_Explore', 'Flared Pant', 'Formal Socks', 'Front Opening Bra', 'Full Briefs', 'Full Sleeve', 'Full Sleeve T Shirts For Men', 'Gilet', 'Girls Apparel Bottoms', 'Girls Apparel Tops', 'Girls Innerwear', 'groove', 'Groove_Winter', 'Gym Towel', 'Gym-Vests', 'Hand Towel', 'Handkerchief', 'Henleys', 'Heritage', 'Hipsters', 'Home', 'Home_Bra', 'Home_Brief', 'Home_Briefs', 'Home_Colors_To_Explore', 'Home_Pants', 'Home_Radiate', 'Home_Shorts', 'Home_T-Shirt', 'Home_Trackpant', 'Home_Trunk', 'Hooded Neck', 'Hoodie', 'Hoodie Sweatshirts', 'ignore-plc', 'Inner Boxers', 'Inner Tank Tops', 'Innerwear', 'Innerwear Tops', 'International Collection', 'Jacket', 'Jackets', 'Jackets Hoodies', 'Jeggings', 'Jeggings Leggings', 'JKY Studio', 'Jockey life', 'Joggers', 'Joggers Track Pants', 'Junior Socks', 'Juniors', 'Juniorsshow_on_collection', 'Kids Face Mask', 'Kids Thermals', 'Knee Length Socks', 'Knit Shirts', 'Kurta Slips', 'Kurti Slips', 'Lace Panty', 'Leggings', 'Long John', 'Long Pant', 'Long Sleeve T-Shirt', 'Long Sleeve Vest', 'Lounge Bras', 'Lounge Dress', 'Low Show Socks', 'Masks', 'Max', 'Men', 'Men Gym T-shirt', 'Men_Vneck_T-Shirt', 'Mid-waist', 'Minimizer Bra', 'Miss Jockey', 'Modern Classic', 'Move', 'multipack_combo', 'Multiway Backless Bra', 'New', 'New Arrivals', 'NEW ONE', 'New Style', 'New York City', 'New York Cityshow_on_collection', 'No Show Socks', 'No-show Socks', 'Non Padded Bras', 'non-returnable', 'NONE', 'Nursing Bras', 'Outer Crop Top', 'Oversized T-Shirt Men', 'Oversized T-Shirt Women', 'Oversized Tank Top', 'Pack of 2', 'Pack of 3', 'Pack of 5', 'Pack of 6', 'Padded', 'Pak of 5', 'Panties', 'Pants', 'Period Panty', 'Plunge Bra', 'Plus Size Bra', 'Plus Size Bras', 'Polo T-Shirts', 'Polos', 'POP', 'POPshow_on_collection', 'Print', 'printed', 'Push Up Bra', 'Pyjama Sets', 'Pyjamas', 'Relax', 'Round Neck', 'Round Neck Crew T Shirt', 'Sagging Bra', 'Seamless Bra', 'Seamless Panty', 'Seamless Shapewear', 'Sets', 'Shacket', 'Shapewear', 'Shapewear Bottoms', 'Shirt', 'Shorties', 'Shorts', 'Shorts Sets', 'show_all_colors', 'show_all_colorsSimple Comfort', 'show_all_colorsTowel', 'show_all_colorsWomen', 'show_on_collection', 'show_on_collection_1', 'show_uat', 'Shrug', 'Simple Comfort', 'Sleep Bras', 'Sleep Dress', 'Sleep dress', 'Sleeved Vest', 'Sleeved Vests', 'Sleeveless Vests', 'Slip On', 'Socks', 'Socksshow_on_collection', 'Soft Wonder', 'Sport', 'Strapless Bras', 'Sweatshirts', 'T-shirt', 'T-Shirt Bras', 'T-Shirts', 'T-Shirtsshow_on_collection', 'Tank Top', 'Tank Tops', 'Thermal', 'Thermal Socks', 'Thermals', 'Toe Socks', 'Top Thermals', 'Tops for Teens', 'Towel', 'Track Pants', 'Track Pantsshow_on_collection', 'Trackpants', 'Transparent Straps', 'Trunks', 'Tube Bra', 'Undershirt Long John Set', 'Underwire Bras', 'Uniform Bras', 'Unisex Face Mask', 'USA Originals', 'USA Originalsshow_on_collection', 'Utility Pants', 'Vests', 'Winter 2025', 'Women', 'Women gym T-shirt', 'Women Skirt', 'Womenshow_on_collection', 'Young Casuals', 'Young Casualsshow_on_collection', 'Zone', 'Zoneshow_on_collection']
 GROUP BY ONLY TOP 5 product_variant_sku, ONLY TOP 5 product_tag, ONLY TOP 5
 product_variant_title WITH GROUP_TOTALS, TOTALS
SINCE startOfDay(-30d) UNTIL today
ORDER BY days_in_stock__product_variant_sku_totals DESC,
days_in_stock__product_variant_sku_product_tag_totals DESC, days_in_stock DESC,
product_variant_sku ASC, product_tag ASC, product_variant_title ASC
VISUALIZE days_in_stock

Disclaimer: This product comes in a variety of pattern & design. Image shown here is for representation only. Actual pattern & design may vary.