Home & Garden

InstockProductsFirst Debug

SQL Query:

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`, MAX(stock.stock_status) AS `stock_status` 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` ON e.entity_id = stock.product_id GROUP BY `e`.`entity_id` ORDER BY `stock`.`stock_status` DESC

ORDER BY Clauses:

Total ORDER BY clauses: 1

Order #1: stock.stock_status DESC

Stock Distribution (Total: 120 products):

Stock Status "0": 78 products

Stock Status "1": 42 products

Product Samples:

Pos ID SKU Name Stock
1 911 286297875467 Wireless Meat Thermometer Meater Plus Di 0 (OUT OF STOCK)
2 20 283337722831 Fleur De Lis Wall Shelf Bracket Cast Iro 0 (OUT OF STOCK)
3 21 283344114097 Nautical Shelf Bracket Ship Anchor Custo 0 (OUT OF STOCK)
4 953 257407650009 Real Sand Castle Figurine 118 4" Tall Co 0 (OUT OF STOCK)
5 410 276793574596 Women's Marsha Ankle Boots Zip Up Pointe 0 (OUT OF STOCK)
6 729 276821288981 Women's Pippa Stretch Ankle Boots Taupe 0 (OUT OF STOCK)
7 415 276793633196 Women's Chunky Heel Boots - Dolly Black 0 (OUT OF STOCK)
8 752 276822613745 Joybees Men's Chance Clogs Gray Sz 7 Sli 0 (OUT OF STOCK)
9 1573 276833228749 Journee Collection Womens Livvy Back Hee 0 (OUT OF STOCK)
10 1653 276884002210 JBL Tune 230NC TWS Earbuds Blue Bluetoot 0 (OUT OF STOCK)
11 1634 276860115393 Women's Diana Buckle Mule Heels Black SZ 0 (OUT OF STOCK)
12 916 276841802932 Otterbox Elevation 20 Tumbler Thermal Li 0 (OUT OF STOCK)
13 1654 276889348003 dearfoams Kids' Good Vibes Slide Slipper 0 (OUT OF STOCK)
14 1657 276912425839 Apple EarPods with 3.5mm Plug – Wired 0 (OUT OF STOCK)
15 1677 820107820015 Ornate Garden Hose Holder - Heavy Duty M 0 (OUT OF STOCK)
16 1661 276912562408 OtterBox Shaker Lid For Elevation 20 1.5 0 (OUT OF STOCK)
17 1676 276920455864 Women's Alexa Flare Heel Pumps Black SZ 0 (OUT OF STOCK)
18 1682 276931109905 Women's Mel Rhinestone Mesh Ballet Flats 0 (OUT OF STOCK)
19 1678 930907820002 Rustic Cast Iron Welcome Bell Vintage Wa 0 (OUT OF STOCK)
20 1679 276928818201 Allegra K Women's T Strap Open Toe Platf 0 (OUT OF STOCK)
21 1686 276939078249 Victrola Re-Spin Suitcase Vinyl Record P 0 (OUT OF STOCK)
22 1690 254107820030 Wall Shelf Bracket Ornate Scroll White C 0 (OUT OF STOCK)
23 1699 276966958927 Heyday Silicone Phone Case for iPhone 12 0 (OUT OF STOCK)
24 1700 276967399530 Funko Mini Moments: Marvel - Jennifer & 0 (OUT OF STOCK)
25 1701 276969248621 UNOS BY SZ Adult Sneakers - Gray 8-9 0 (OUT OF STOCK)
26 1705 254107820003-1 Wall Shelf Bracket Cast Iron Brace Vine 0 (OUT OF STOCK)
27 1703 273107820002-1 Nautical Ship Anchor Cast Iron Shelf Bra 0 (OUT OF STOCK)
28 1704 273107820002 Nautical Ship Anchor Cast Iron Shelf Bra 0 (OUT OF STOCK)
29 1706 272607820008 S-Hook Plant Hanger Flower Basket Decor 0 (OUT OF STOCK)
30 1709 276983831741 Rocketfish 8k Ultra High Speed 15ft HDMI 0 (OUT OF STOCK)
31 1708 276981428196 WWE Elite Collection Undertaker Figure - 0 (OUT OF STOCK)
32 1711 276983927536 Sanus BSA-IWP1-W1 In-Wall Cable Conceale 0 (OUT OF STOCK)
33 1712 276983994123 Sanus - On-Wall Cable Concealer High Cap 0 (OUT OF STOCK)
34 1710 276983911682 Rocketfish - 12' 4K UltraHD/HDR In-Wall 0 (OUT OF STOCK)
35 1714 276987123754 Helios In-Wall Power Outlet Relocation K 0 (OUT OF STOCK)
36 1720 254107820007 Ornate Cast Iron Shelf Bracket Decorativ 0 (OUT OF STOCK)
37 1716 276987506055 Women's Shannon Heels with Memory Foam I 0 (OUT OF STOCK)
38 1721 276992410457 Mcfarlane Batman DC Retro 66 Classics TV 0 (OUT OF STOCK)
39 1722 276992464944 McFarlane DC Retro 66 Classic TV Series 0 (OUT OF STOCK)
40 1723 276992467087 Hasbro Star Wars George Lucas Stormtroop 0 (OUT OF STOCK)
41 1726 272907820017 Unicorn Garden Flag Rainbow Yard Banner 0 (OUT OF STOCK)
42 1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skele 0 (OUT OF STOCK)
43 1724 246407820001 13" Brown Cast Iron Turtle Stepping Ston 0 (OUT OF STOCK)
44 1729 261207820000 Funny Aluminum Sign No Poop Heads Allowe 0 (OUT OF STOCK)
45 1730 273207820013 Don't Be A Poop Head Emoji Clean Up Afte 0 (OUT OF STOCK)
46 1731 000007830114 NASCAR Kasey Kahne Wall Appliques Decal 0 (OUT OF STOCK)
47 1733 272907820015 Thankful Grateful Blessed Fall Leaves Ga 0 (OUT OF STOCK)
48 1732 000000410068 Disney Princess Self Stick Removable App 0 (OUT OF STOCK)
49 1734 163807820003 Aluminum Sign Firemans Cross White Firef 0 (OUT OF STOCK)
50 1735 273807820002 Welcome American Garden Flag Emotes Doub 0 (OUT OF STOCK)
51 1737 273707820003 Happy Easter Spring Flowers Birds Garden 0 (OUT OF STOCK)
52 1736 322207820000 Fish Pocket Beer Bottle Opener Handheld 0 (OUT OF STOCK)
53 1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Es 0 (OUT OF STOCK)
54 1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" W 0 (OUT OF STOCK)
55 1739 930907820000 Cast Iron Horse Dinner Bell – Rustic B 0 (OUT OF STOCK)
56 1742 277015134596 CyberPower 1000VA UPS Battery Backup Sur 0 (OUT OF STOCK)
57 1741 277012444440 New Brielle Home Cotton Jersey Knit (T-S 0 (OUT OF STOCK)
58 1743 322207820002 Wall Mounted Skull Beer Bottle Opener Ca 0 (OUT OF STOCK)
59 1744 261207820002 Funny Aluminum Sign No Poop Heads Allowe 0 (OUT OF STOCK)
60 1750 277025938599 Yardbird Fire Table Cover CVFTRERB Recta 0 (OUT OF STOCK)
61 1752 277032581994 CyberPower 1500VA Battery Back-Up System 0 (OUT OF STOCK)
62 1754 277036995257 Sanus BSA-IWP701-W1 In-Wall Power Kit AV 0 (OUT OF STOCK)
63 1751 277029661358 Barbie Toy Wall Stickers Girls Bedroom D 0 (OUT OF STOCK)
64 1756 277037812053 Genuine Amazon Alexa Voice Remote (3rd G 0 (OUT OF STOCK)
65 1758 277039604836 Nick JR Dora The Explorer Wall Sticker D 0 (OUT OF STOCK)
66 1755 277037180702 SaharaCase - Office Mouse Pad with Wirel 0 (OUT OF STOCK)
67 1764 277047254859 10" Twin Intex Standard Dura-Beam Airbed 0 (OUT OF STOCK)
68 1760 277040873020 Computer Chair Floor Mat 30 x 48 inches 0 (OUT OF STOCK)
69 1763 277046740996 Simpli Home Grafton Round Pouf 20" x 20" 0 (OUT OF STOCK)
70 1768 277056810230 The Jimi Hendrix Experience Electric Lad 0 (OUT OF STOCK)
71 1767 277056763782 The Jimi Hendrix Experience Electric Lad 0 (OUT OF STOCK)
72 1766 163807820000 Firefighting Firemans Cross Hanging Wall 0 (OUT OF STOCK)
73 1772 277059334344 TO LIVE AND DIE IN LA New Sealed 4K Ultr 0 (OUT OF STOCK)
74 1773 277059755739 4 LED Reading Light Dimmable Quad Light 0 (OUT OF STOCK)
75 1769 277056857730 Ultraman Blu-ray - Ultraman: Complete Se 0 (OUT OF STOCK)
76 1775 277061995342 MICHAEL BUBLE' - "Michael Buble' Christm 0 (OUT OF STOCK)
77 1822 266107820001 Funny Dachshund Sign Don't Trip Over My 1 (IN STOCK)
78 1819 144307820001 Personalized Man Cave Aluminum Sign Cust 1 (IN STOCK)
79 951 273407820004 Decorative Trivet Square Cast Iron Hot P 1 (IN STOCK)
80 1824 273907820000 Cast Iron Skillet Wall Hanging Holstein 1 (IN STOCK)
81 1681 276928972258 Fitbit Versa 4 Fitness Smartwatch FB523B 1 (IN STOCK)
82 19191 286541448988 Portable DVD Player Insignia™ 10" NS-P 0 (OUT OF STOCK)
83 20545 277126264408 CyberPower 950VA / 510W PC Battery Backu 1 (IN STOCK)
84 23598 277131919443 Funko POP! #1352 Indiana Jones SALLAH Vi 1 (IN STOCK)
85 21778 277128470763 Metra Steering Wheel Control Interface F 1 (IN STOCK)
86 21759 277128438248 Metra BY-GM11-SWC Steering Wheel Control 1 (IN STOCK)
87 1823 829800250004 Longaberger Traditions Handle Tie Collec 1 (IN STOCK)
88 1833 218107280003 Holiday Home Snowman Pattern Mug China T 1 (IN STOCK)
89 14 254107820000 Wall Shelf Bracket Decorative Cast Iron 1 (IN STOCK)
90 15 254107820020 Wall Shelf Bracket Brace With Plant Hang 1 (IN STOCK)
91 1834 268507820000 Lady Bug Hide A Key Box Distressed Brown 1 (IN STOCK)
92 19 254107820008 Wall Shelf Bracket Large Fleur De Lis Ca 1 (IN STOCK)
93 18 254107820017 Decorative Cast Iron Wall Shelf Bracket 1 (IN STOCK)
94 1835 198507820000 Welcome Garden Sign Pink Flowers Black C 1 (IN STOCK)
95 1842 137607820000 Aluminum Sign You Need A Beer Home Bar M 1 (IN STOCK)
96 23 254007820009 Wall Shelf Bracket Ribbon Fleur De Lis V 1 (IN STOCK)
97 1861 144907820000 Aluminum Sign Kitchen Rules Wall Hanging 1 (IN STOCK)
98 25 254007820010 Wall Shelf Bracket Cast Iron Brace Fleur 1 (IN STOCK)
99 27 254107820028 Wall Shelf Bracket Distressed Brown Orna 1 (IN STOCK)
100 1868 198507820002 Flamingo Welcome Plaque Brown Cast Iron 1 (IN STOCK)
101 1872 272207820000 Large Rolling Plant Caddy Fleur De Lis 1 (IN STOCK)
102 1873 273607820000 Decorative Cast Iron Rooster Trivet Kitc 1 (IN STOCK)
103 1874 197107820000 Turtle Hide A Key Box Distressed Brown C 1 (IN STOCK)
104 1876 229207820004 Cast Iron Plaque Sign - Beware Of The Do 1 (IN STOCK)
105 1875 284109859464 Disney’s Baby Mickey Mouse Wall Border 1 (IN STOCK)
106 1877 284292040564 Baby Einstein Four Fundamentals 5 Develo 1 (IN STOCK)
107 1882 TGLSPG0001 Electric Salt & Pepper Grinder Set - Adj 1 (IN STOCK)
108 1880 285024495455 Please Close The Gate Cast Iron Plaque S 1 (IN STOCK)
109 1879 284965973493 vintage Cracker Jack prize charm Seagram 1 (IN STOCK)
110 416 286234217652 Women's Boots with Memory Foam Insole - 1 (IN STOCK)
111 554 286254844708 Dr. Scholl's Laurel Womens Ankle Bootie 1 (IN STOCK)
112 1941 286287688602 Allegra K Women's Back to College Faux S 1 (IN STOCK)
113 1989 286292297452 Men's Joshua Slide Sandals Tan 8 Unworn 1 (IN STOCK)
114 1969 286290556641 Dr. Scholl's Women's Janette Slip Resist 1 (IN STOCK)
115 1942 286287784729 Women's Devin Two Band Footbed Sandals B 1 (IN STOCK)
116 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth 1 (IN STOCK)
117 901 286294130286 Traeger Timberline Outdoor Kitchen Trim 1 (IN STOCK)
118 1693 276955627052 Women's Marcia Lace up Heels with Memory 0 (OUT OF STOCK)
119 1791 273907820002 Frog Hide A Key Box Distressed Brown Cas 1 (IN STOCK)
120 1728 274007820000 Slow Down Garden Flag Caution Children A 1 (IN STOCK)
View as Grid List

Items 1-12 of 120

Set Descending Direction
Page
per page
Copyright © 2023-present Chillicothe Market All rights reserved.