{"product_id":"test-product","title":"Test product","description":"\u003cp\u003eFROM inventory, inventory_by_location\u003cbr\u003e SHOW days_in_stock, days_in_stock_at_location, days_out_of_stock\u003cbr\u003eWHERE 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']\u003cbr\u003e GROUP BY ONLY TOP 5 product_variant_sku, ONLY TOP 5 product_tag, ONLY TOP 5\u003cbr\u003e product_variant_title WITH GROUP_TOTALS, TOTALS\u003cbr\u003eSINCE startOfDay(-30d) UNTIL today\u003cbr\u003eORDER BY days_in_stock__product_variant_sku_totals DESC,\u003cbr\u003edays_in_stock__product_variant_sku_product_tag_totals DESC, days_in_stock DESC,\u003cbr\u003eproduct_variant_sku ASC, product_tag ASC, product_variant_title ASC\u003cbr\u003eVISUALIZE days_in_stock\u003c\/p\u003e","brand":"Jockey","offers":[{"title":"S","offer_id":54135357473067,"sku":"11345006","price":1099.0,"currency_code":"INR","in_stock":true},{"title":"M","offer_id":54135357505835,"sku":"11345003","price":1099.0,"currency_code":"INR","in_stock":true},{"title":"L","offer_id":54135357538603,"sku":"11345002","price":1099.0,"currency_code":"INR","in_stock":true},{"title":"XL","offer_id":54135357571371,"sku":"11345005","price":1129.0,"currency_code":"INR","in_stock":true},{"title":"XXL","offer_id":54135357604139,"sku":"11345004","price":1149.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0753\/1056\/3627\/files\/US88_SD-BR_0103_S126_Jky_1_1a354393-a83e-48ce-a1d6-e8d73d653802.webp?v=1783659173","url":"https:\/\/www.jockey.in\/products\/test-product","provider":"Jockey India","version":"1.0","type":"link"}