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:
stock.stock_status DESC
Stock Distribution (Total: 239 products):
Stock Status "0": 231 products
Stock Status "1": 8 products
Product Samples:
Pos | ID | SKU | Name | Stock |
---|---|---|---|---|
1 | 911 | 286297875467 | Wireless Meat Thermometer Meater Plus Di | 0 (OUT OF STOCK) |
2 | 3116 | 286550850989 | Funko POP! #1352 Indiana Jones SALLAH Vi | 0 (OUT OF STOCK) |
3 | 11974 | 286568410736 | Kamado Joe JoeTisserie 24 inch Big Joe G | 0 (OUT OF STOCK) |
4 | 20 | 283337722831 | Fleur De Lis Wall Shelf Bracket Cast Iro | 0 (OUT OF STOCK) |
5 | 21 | 283344114097 | Nautical Shelf Bracket Ship Anchor Custo | 0 (OUT OF STOCK) |
6 | 14 | 254107820000 | Wall Shelf Bracket Decorative Cast Iron | 1 (IN STOCK) |
7 | 15 | 254107820020 | Wall Shelf Bracket Brace With Plant Hang | 1 (IN STOCK) |
8 | 18 | 254107820017 | Decorative Cast Iron Wall Shelf Bracket | 1 (IN STOCK) |
9 | 19 | 254107820008 | Wall Shelf Bracket Large Fleur De Lis Ca | 1 (IN STOCK) |
10 | 23 | 254007820009 | Wall Shelf Bracket Ribbon Fleur De Lis V | 1 (IN STOCK) |
... | ||||
70 | 2354 | 286449720137 | Mcfarlane Batman DC Retro 66 Classics TV | 0 (OUT OF STOCK) |
71 | 2356 | 286452062505 | Women's Shannon Heels with Memory Foam I | 0 (OUT OF STOCK) |
72 | 2358 | 255707820018 | Cast Iron Plant Hanger Bracket Hummingbi | 0 (OUT OF STOCK) |
73 | 2359 | 272907820016 | Welcome To Our Home Garden Flag – Seas | 0 (OUT OF STOCK) |
74 | 2360 | 019707820020 | Rustic Cast Iron Antler Wall Hook Rack D | 0 (OUT OF STOCK) |
75 | 2361 | 286459777773 | Peerless AV Peerless-AV ST650P Tilt TV W | 0 (OUT OF STOCK) |
76 | 2363 | 019707820019 | Decorative Double Wall Hook Love Birds R | 0 (OUT OF STOCK) |
77 | 2364 | 148107820000 | Video Gaming Aluminum Sign Gamer Zone Ch | 0 (OUT OF STOCK) |
78 | 2365 | 273207820008 | French Bulldog Beware Of Dog Double Side | 0 (OUT OF STOCK) |
79 | 2366 | 261207820001 | Funny Aluminum Sign No Poop Heads Allowe | 0 (OUT OF STOCK) |
80 | 2367 | 019707820006 | Cast Iron Skeleton Key Wall Hook Rack � | 0 (OUT OF STOCK) |
... | ||||
161 | 1179 | 275459221209 | vintage Cracker Jack charm prize Silvery | 0 (OUT OF STOCK) |
162 | 1176 | 275458944602 | vintage Cracker Jack Gumball charm prize | 0 (OUT OF STOCK) |
163 | 1193 | 276301204436 | Baby Proofing American Electrical Outlet | 0 (OUT OF STOCK) |
164 | 1192 | 229207820003 | Cast Iron Plaque Sign - Please Close The | 0 (OUT OF STOCK) |
165 | 1180 | 275459274008 | vintage Cracker Jack charm prize Metalli | 0 (OUT OF STOCK) |
166 | 1634 | 276860115393 | Women's Diana Buckle Mule Heels Black SZ | 0 (OUT OF STOCK) |
167 | 1573 | 276833228749 | Journee Collection Womens Livvy Back Hee | 0 (OUT OF STOCK) |
168 | 916 | 276841802932 | Otterbox Elevation 20 Tumbler Thermal Li | 0 (OUT OF STOCK) |
169 | 1653 | 276884002210 | JBL Tune 230NC TWS Earbuds Blue Bluetoot | 0 (OUT OF STOCK) |
170 | 1654 | 276889348003 | dearfoams Kids' Good Vibes Slide Slipper | 0 (OUT OF STOCK) |
171 | 1657 | 276912425839 | Apple EarPods with 3.5mm Plug – Wired | 0 (OUT OF STOCK) |
172 | 1661 | 276912562408 | OtterBox Shaker Lid For Elevation 20 1.5 | 0 (OUT OF STOCK) |
173 | 1676 | 276920455864 | Women's Alexa Flare Heel Pumps Black SZ | 0 (OUT OF STOCK) |
174 | 1677 | 820107820015 | Ornate Garden Hose Holder - Heavy Duty M | 0 (OUT OF STOCK) |
175 | 1678 | 930907820002 | Rustic Cast Iron Welcome Bell Vintage Wa | 0 (OUT OF STOCK) |
176 | 1679 | 276928818201 | Allegra K Women's T Strap Open Toe Platf | 0 (OUT OF STOCK) |
177 | 1686 | 276939078249 | Victrola Re-Spin Suitcase Vinyl Record P | 0 (OUT OF STOCK) |
178 | 1690 | 254107820030 | Wall Shelf Bracket Ornate Scroll White C | 0 (OUT OF STOCK) |
179 | 1682 | 276931109905 | Women's Mel Rhinestone Mesh Ballet Flats | 0 (OUT OF STOCK) |
180 | 1699 | 276966958927 | Heyday Silicone Phone Case for iPhone 12 | 0 (OUT OF STOCK) |
181 | 1700 | 276967399530 | Funko Mini Moments: Marvel - Jennifer & | 0 (OUT OF STOCK) |
182 | 1693 | 276955627052 | Women's Marcia Lace up Heels with Memory | 0 (OUT OF STOCK) |
183 | 1703 | 273107820002-1 | Nautical Ship Anchor Cast Iron Shelf Bra | 0 (OUT OF STOCK) |
184 | 1704 | 273107820002 | Nautical Ship Anchor Cast Iron Shelf Bra | 0 (OUT OF STOCK) |
185 | 1701 | 276969248621 | UNOS BY SZ Adult Sneakers - Gray 8-9 | 0 (OUT OF STOCK) |
186 | 1705 | 254107820003-1 | Wall Shelf Bracket Cast Iron Brace Vine | 0 (OUT OF STOCK) |
187 | 1706 | 272607820008 | S-Hook Plant Hanger Flower Basket Decor | 0 (OUT OF STOCK) |
188 | 1708 | 276981428196 | WWE Elite Collection Undertaker Figure - | 0 (OUT OF STOCK) |
189 | 1711 | 276983927536 | Sanus BSA-IWP1-W1 In-Wall Cable Conceale | 0 (OUT OF STOCK) |
190 | 1710 | 276983911682 | Rocketfish - 12' 4K UltraHD/HDR In-Wall | 0 (OUT OF STOCK) |
191 | 1709 | 276983831741 | Rocketfish 8k Ultra High Speed 15ft HDMI | 0 (OUT OF STOCK) |
192 | 1712 | 276983994123 | Sanus - On-Wall Cable Concealer High Cap | 0 (OUT OF STOCK) |
193 | 1714 | 276987123754 | Helios In-Wall Power Outlet Relocation K | 0 (OUT OF STOCK) |
194 | 1716 | 276987506055 | Women's Shannon Heels with Memory Foam I | 0 (OUT OF STOCK) |
195 | 1721 | 276992410457 | Mcfarlane Batman DC Retro 66 Classics TV | 0 (OUT OF STOCK) |
196 | 1720 | 254107820007 | Ornate Cast Iron Shelf Bracket Decorativ | 0 (OUT OF STOCK) |
197 | 1722 | 276992464944 | McFarlane DC Retro 66 Classic TV Series | 0 (OUT OF STOCK) |
198 | 1726 | 272907820017 | Unicorn Garden Flag Rainbow Yard Banner | 0 (OUT OF STOCK) |
199 | 1724 | 246407820001 | 13" Brown Cast Iron Turtle Stepping Ston | 0 (OUT OF STOCK) |
200 | 1723 | 276992467087 | Hasbro Star Wars George Lucas Stormtroop | 0 (OUT OF STOCK) |
201 | 1729 | 261207820000 | Funny Aluminum Sign No Poop Heads Allowe | 0 (OUT OF STOCK) |
202 | 1730 | 273207820013 | Don't Be A Poop Head Emoji Clean Up Afte | 0 (OUT OF STOCK) |
203 | 1727 | 019700410046 | Cast Iron Wall Hook Rack Fish Bone Skele | 0 (OUT OF STOCK) |
204 | 1733 | 272907820015 | Thankful Grateful Blessed Fall Leaves Ga | 0 (OUT OF STOCK) |
205 | 1732 | 000000410068 | Disney Princess Self Stick Removable App | 0 (OUT OF STOCK) |
206 | 1731 | 000007830114 | NASCAR Kasey Kahne Wall Appliques Decal | 0 (OUT OF STOCK) |
207 | 1734 | 163807820003 | Aluminum Sign Firemans Cross White Firef | 0 (OUT OF STOCK) |
208 | 1735 | 273807820002 | Welcome American Garden Flag Emotes Doub | 0 (OUT OF STOCK) |
209 | 1736 | 322207820000 | Fish Pocket Beer Bottle Opener Handheld | 0 (OUT OF STOCK) |
210 | 1738 | 273007820003 | Cast Iron Pedestal Bird Feeder Bath 8" W | 0 (OUT OF STOCK) |
211 | 1739 | 930907820000 | Cast Iron Horse Dinner Bell – Rustic B | 0 (OUT OF STOCK) |
212 | 1737 | 273707820003 | Happy Easter Spring Flowers Birds Garden | 0 (OUT OF STOCK) |
213 | 1740 | 142307820000 | Aluminum Sign Coffee Cappuccino Mocha Es | 0 (OUT OF STOCK) |
214 | 1742 | 277015134596 | CyberPower 1000VA UPS Battery Backup Sur | 0 (OUT OF STOCK) |
215 | 1741 | 277012444440 | New Brielle Home Cotton Jersey Knit (T-S | 0 (OUT OF STOCK) |
216 | 1744 | 261207820002 | Funny Aluminum Sign No Poop Heads Allowe | 0 (OUT OF STOCK) |
217 | 1743 | 322207820002 | Wall Mounted Skull Beer Bottle Opener Ca | 0 (OUT OF STOCK) |
218 | 1752 | 277032581994 | CyberPower 1500VA Battery Back-Up System | 0 (OUT OF STOCK) |
219 | 1751 | 277029661358 | Barbie Toy Wall Stickers Girls Bedroom D | 0 (OUT OF STOCK) |
220 | 1750 | 277025938599 | Yardbird Fire Table Cover CVFTRERB Recta | 0 (OUT OF STOCK) |
221 | 1754 | 277036995257 | Sanus BSA-IWP701-W1 In-Wall Power Kit AV | 0 (OUT OF STOCK) |
222 | 1756 | 277037812053 | Genuine Amazon Alexa Voice Remote (3rd G | 0 (OUT OF STOCK) |
223 | 1755 | 277037180702 | SaharaCase - Office Mouse Pad with Wirel | 0 (OUT OF STOCK) |
224 | 1760 | 277040873020 | Computer Chair Floor Mat 30 x 48 inches | 0 (OUT OF STOCK) |
225 | 1758 | 277039604836 | Nick JR Dora The Explorer Wall Sticker D | 0 (OUT OF STOCK) |
226 | 1763 | 277046740996 | Simpli Home Grafton Round Pouf 20" x 20" | 0 (OUT OF STOCK) |
227 | 1764 | 277047254859 | 10" Twin Intex Standard Dura-Beam Airbed | 0 (OUT OF STOCK) |
228 | 1767 | 277056763782 | The Jimi Hendrix Experience Electric Lad | 0 (OUT OF STOCK) |
229 | 1766 | 163807820000 | Firefighting Firemans Cross Hanging Wall | 0 (OUT OF STOCK) |
230 | 1772 | 277059334344 | TO LIVE AND DIE IN LA New Sealed 4K Ultr | 0 (OUT OF STOCK) |
231 | 1768 | 277056810230 | The Jimi Hendrix Experience Electric Lad | 0 (OUT OF STOCK) |
232 | 1769 | 277056857730 | Ultraman Blu-ray - Ultraman: Complete Se | 0 (OUT OF STOCK) |
233 | 1773 | 277059755739 | 4 LED Reading Light Dimmable Quad Light | 0 (OUT OF STOCK) |
234 | 1775 | 277061995342 | MICHAEL BUBLE' - "Michael Buble' Christm | 0 (OUT OF STOCK) |
235 | 2404 | 277064207987 | Carrie Underwood My Gift First-Ever Chri | 0 (OUT OF STOCK) |
236 | 2405 | 277064611176 | Yogasleep Rohm Portable White Noise Mach | 0 (OUT OF STOCK) |
237 | 2406 | 277066203475 | CASETiFY - Ultra Impact Bounce Case for | 0 (OUT OF STOCK) |
238 | 3071 | 277069846799 | CASETiFY - Mirror Airpods Case for Apple | 0 (OUT OF STOCK) |
239 | 3072 | 277069870238 | Kate Spade New York - Protective Case Ap | 0 (OUT OF STOCK) |