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: 251 products):
Stock Status "0": 242 products
Stock Status "1": 9 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 | 4 | 254107820015 | Decorative Shelf Bracket Ornate Lattice | 0 (OUT OF STOCK) |
4 | 3 | 273654971490 | Wall Shelf Bracket Horse Brace Crafting | 0 (OUT OF STOCK) |
5 | 9 | 254107820013 | Ornate Lattice Shelf Bracket Brown Cast | 0 (OUT OF STOCK) |
6 | 11 | 254000410000 | Wall Shelf Bracket Bird Brace Craft Cast | 0 (OUT OF STOCK) |
7 | 13 | 254407820000 | Western Decorative Wall Shelf Bracket Br | 0 (OUT OF STOCK) |
8 | 2 | 273707820000 | Ornate Heart Shelf Bracket Decorative Ru | 1 (IN STOCK) |
9 | 12 | 254207820000 | Nautical Shelf Bracket Clamshell Beach S | 1 (IN STOCK) |
10 | 166 | 273007820002 | Seed Feeder Bird Bath Cast Iron Wall Mou | 0 (OUT OF STOCK) |
... | ||||
70 | 261 | 273107820000 | Fleur De Lis Plant Hanger Ornate Cast Ir | 0 (OUT OF STOCK) |
71 | 262 | 272607820007 | Blooming Flower S Style Plant Hook Cast | 0 (OUT OF STOCK) |
72 | 263 | 273307820000 | Duck Family Plant Hanger Flower Basket H | 0 (OUT OF STOCK) |
73 | 267 | 255707820013 | Bluejay S Style Plant Hook Cast Iron Flo | 0 (OUT OF STOCK) |
74 | 268 | 255707820011 | Butterfly Plant Hanger Bracket Flower Po | 0 (OUT OF STOCK) |
75 | 272 | 272607820002 | Plant Hanger Hanging Pot Flower Basket H | 0 (OUT OF STOCK) |
76 | 273 | 255707820014 | Chickadee Bird S Style Plant Hook Cast I | 0 (OUT OF STOCK) |
77 | 274 | 272607820006 | Rose Flower Bloom S Style Plant Hook Cas | 0 (OUT OF STOCK) |
78 | 276 | 019707820014 | Cast Iron Wall Hook Rack Ornate Victoria | 0 (OUT OF STOCK) |
79 | 280 | 273007820000 | Decorative Rooster Plant Hanger Flower H | 0 (OUT OF STOCK) |
80 | 282 | 255700410002 | Cast Iron Plant Hanger Ornate Pattern 10 | 0 (OUT OF STOCK) |
... | ||||
161 | 3112 | 277093398774 | FUNKO POP! MOVIES: Raiders of the Lost A | 0 (OUT OF STOCK) |
162 | 3113 | 277093424276 | FUNKO POP! MOVIES: The Last Crusade - He | 0 (OUT OF STOCK) |
163 | 3114 | 277093437505 | Funko Pop! Pin Star Wars Max Rebo SE Tar | 0 (OUT OF STOCK) |
164 | 3115 | 286549184208 | Women's Darla Platform Mule Heels Black | 0 (OUT OF STOCK) |
165 | 3117 | 286550852026 | Funko Pop! Vinyl: Indiana Jones - Indian | 0 (OUT OF STOCK) |
166 | 11956 | 277098598300 | The Real Mccoy DVD Action Crime Kim Basi | 0 (OUT OF STOCK) |
167 | 11957 | 277103109122 | Snake Eyes (DVD, 1999, Sensormatic) Nico | 0 (OUT OF STOCK) |
168 | 11958 | 277105767269 | Sahara - Universal Mouse Pad with Wirele | 0 (OUT OF STOCK) |
169 | 11959 | 277108023030 | Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car | 0 (OUT OF STOCK) |
170 | 11960 | 277108609311 | Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car | 0 (OUT OF STOCK) |
171 | 11961 | 286566328311 | Kenwood KFC 1666R 6.5 Inch Coaxial Car S | 0 (OUT OF STOCK) |
172 | 11962 | 286565954268 | Pioneer A-Series TS-A653FH 6.5" 2-Way 34 | 0 (OUT OF STOCK) |
173 | 11963 | 286563364559 | Pioneer 2-Way Speaker TS-G650 300W Max 6 | 0 (OUT OF STOCK) |
174 | 11969 | 286563505562 | OEM Dyson V15 Detect Laser Slim Fluffy O | 0 (OUT OF STOCK) |
175 | 19191 | 286541448988 | Portable DVD Player Insignia™ 10" NS-P | 0 (OUT OF STOCK) |
176 | 20545 | 277126264408 | CyberPower 950VA / 510W PC Battery Backu | 0 (OUT OF STOCK) |
177 | 21759 | 277128438248 | Metra BY-GM11-SWC Steering Wheel Control | 0 (OUT OF STOCK) |
178 | 21778 | 277128470763 | Metra Steering Wheel Control Interface F | 0 (OUT OF STOCK) |
179 | 23598 | 277131919443 | Funko POP! #1352 Indiana Jones SALLAH Vi | 0 (OUT OF STOCK) |
180 | 953 | 257407650009 | Real Sand Castle Figurine 118 4" Tall Co | 0 (OUT OF STOCK) |
181 | 266 | 110102740003 | Green Hummingbird Large Plant Hanger Cas | 0 (OUT OF STOCK) |
182 | 5 | 254007820003 | Fleur De Lis & Vine Shelf Bracket Cast I | 1 (IN STOCK) |
183 | 265 | 255707820010 | Large Plant Hanger Basket Hook Hummingbi | 0 (OUT OF STOCK) |
184 | 264 | 255707820015 | Decorative Plant Hanger Chickadee Bird B | 0 (OUT OF STOCK) |
185 | 6 | 254107820011 | Decorative Shelf Bracket Flower Leaf Bra | 1 (IN STOCK) |
186 | 7 | 254007820002 | Wall Shelf Bracket Fleur De Lis Cast Iro | 1 (IN STOCK) |
187 | 269 | 255707820009 | Cast Iron S Style Plant Hook Colorful Bi | 0 (OUT OF STOCK) |
188 | 8 | 254107820010 | Decorative Cast Iron Wall Shelf Bracket | 1 (IN STOCK) |
189 | 270 | 255707820019 | Cast Iron Plant Hanger Hook Butterflies | 0 (OUT OF STOCK) |
190 | 271 | 272607820009 | Decorative Plant Hanger Curly Vine Brown | 0 (OUT OF STOCK) |
191 | 1129 | 163807820002 | Firefighting Aluminum Sign Firemans St F | 0 (OUT OF STOCK) |
192 | 1128 | 198507820001 | Double Sided Hanging Welcome Sign Squirr | 0 (OUT OF STOCK) |
193 | 10 | 254107820009 | Cast Iron Wall Shelf Bracket Ornate Brac | 1 (IN STOCK) |
194 | 1130 | 019700410016 | Cast Iron Wall Hook Rack Antique Skeleto | 0 (OUT OF STOCK) |
195 | 326 | 019707820000 | Nautical Black & White Lighthouse Wall H | 0 (OUT OF STOCK) |
196 | 328 | 019707820009 | Horse Head Western Wall Hook Rust Brown | 0 (OUT OF STOCK) |
197 | 330 | 019707820004 | Wall Hook Skeleton Key Coat Rack Antique | 0 (OUT OF STOCK) |
198 | 275 | 019707820011 | Triple Wall Hook For Coat Hat & Scarf Or | 0 (OUT OF STOCK) |
199 | 329 | 019700410014 | Mermaid Wall Hook Rust Cast Iron Coat Ha | 0 (OUT OF STOCK) |
200 | 1138 | 144307820002 | Aluminum Sign You Need A Drink Home Bar | 0 (OUT OF STOCK) |
201 | 333 | 019707820003 | Seahorse Wall Hook Ocean Decor Rust Brow | 0 (OUT OF STOCK) |
202 | 169 | 254007820000 | Wall Shelf Bracket Decorative Cast Iron | 0 (OUT OF STOCK) |
203 | 22 | 254107820005 | Wall Shelf Bracket Cast Iron Shelves Bra | 1 (IN STOCK) |
204 | 277 | 255707820001 | Decorative Horse Head Plant Hanger Cast | 0 (OUT OF STOCK) |
205 | 279 | 255700410004 | Hummingbird Plant Hanger Cast Iron Flowe | 0 (OUT OF STOCK) |
206 | 1164 | 229207820005 | Please Close The Gate Sign Decorative Pl | 0 (OUT OF STOCK) |
207 | 309 | 820107820008 | Welcome Garden Hose Holder Reel Butterfl | 0 (OUT OF STOCK) |
208 | 26 | 254107820027 | Wall Shelf Bracket Distressed White Orna | 1 (IN STOCK) |
209 | 1165 | 274207820001 | Chicken Trivet Decorative Cast Iron Hot | 0 (OUT OF STOCK) |
210 | 281 | 273107820003 | Cast Iron Plant Hanger Basket Hook Ornat | 0 (OUT OF STOCK) |
211 | 1166 | 198507820003 | Double Sided Hanging Welcome Sign Ornate | 0 (OUT OF STOCK) |
212 | 285 | 255707820012 | Hummingbird S Style Plant Hook Cast Iron | 0 (OUT OF STOCK) |
213 | 312 | 820107820006 | Garden Water Hose Holder Rose Flower Han | 0 (OUT OF STOCK) |
214 | 287 | 255707820007 | Cast Iron S Style Plant Hook Hummingbird | 0 (OUT OF STOCK) |
215 | 289 | 273007820004 | Plant Hanger Bird Bath Feeder Cast Iron | 0 (OUT OF STOCK) |
216 | 184 | 254107820026 | Cast Iron Wall Shelf Bracket Brace Colum | 0 (OUT OF STOCK) |
217 | 170 | 012600410004 | Wall Shelf Bracket Leaf Vine Pattern Cas | 0 (OUT OF STOCK) |
218 | 290 | 272607820004 | Decorative Plant Hanger Cast Iron Flower | 0 (OUT OF STOCK) |
219 | 314 | 820107820014 | Garden Hose Holder Hanger - Black Cast I | 0 (OUT OF STOCK) |
220 | 172 | 254107820029 | Wall Shelf Bracket Brace Ornate Vine Bro | 0 (OUT OF STOCK) |
221 | 291 | 255707820021 | Pixie Fairy Cast Iron Plant Hanger Verdi | 0 (OUT OF STOCK) |
222 | 292 | 110102740002 | Hummingbird Plant Hanger Cast Iron Flowe | 0 (OUT OF STOCK) |
223 | 318 | 820107820013 | Wall Mount Garden Hose Holder Floral & S | 0 (OUT OF STOCK) |
224 | 293 | 255707820002 | Decorative Plant Hanger Ornate Victorian | 0 (OUT OF STOCK) |
225 | 295 | 255707820003 | Hummingbird Plant Hanger Flower Hook Dec | 0 (OUT OF STOCK) |
226 | 319 | 820107820000 | Garden Hose Holder Cast Iron Hanger Reel | 0 (OUT OF STOCK) |
227 | 300 | 272607820001 | Rustic Cast Iron Plant Hanger Bracket Fl | 0 (OUT OF STOCK) |
228 | 320 | 256207820001 | Garden Hose Guide Bird On Daisy Cast Iro | 0 (OUT OF STOCK) |
229 | 176 | 254107820004 | Cast Iron Wall Shelf Bracket Brace Vine | 0 (OUT OF STOCK) |
230 | 193 | 019707820013 | Double Wall Hook Decorative Antique Styl | 0 (OUT OF STOCK) |
231 | 301 | 110100410001 | Cast Iron Plant Hanger Basket Hook Pixie | 0 (OUT OF STOCK) |
232 | 192 | 019707820021 | Cast Iron Wall Hook Rack Tropical Fish & | 0 (OUT OF STOCK) |
233 | 1167 | 274811615606 | Harley Quinn Costume Girl M (8-10) DC Su | 0 (OUT OF STOCK) |
234 | 304 | 255707820006 | Decorative Watering Can Cast Iron Plant | 0 (OUT OF STOCK) |
235 | 322 | 820107820002 | Garden Hose Holder Water Pail Bucket Ver | 0 (OUT OF STOCK) |
236 | 305 | 019707820016 | Monkey Wall Hook Rack With 4 Cast Iron H | 0 (OUT OF STOCK) |
237 | 324 | IWHSH0020 | Garden Hose Holder Birds On Branch 9" Wi | 0 (OUT OF STOCK) |
238 | 1269 | 019707820007 | Skeleton Key Style Wall Hook Coat Rack V | 0 (OUT OF STOCK) |
239 | 182 | 254107820018 | Decorative Shelf Bracket - Hexagon Latti | 0 (OUT OF STOCK) |
240 | 181 | 254107820016 | Decorative Shelf Bracket - Ornate Lattic | 0 (OUT OF STOCK) |
241 | 1172 | 275453521123 | Vintage Cracker Jack Gumball prize charm | 0 (OUT OF STOCK) |
242 | 1174 | 275453537797 | Vintage Cracker Jack Gumball prize charm | 0 (OUT OF STOCK) |
243 | 1173 | 275453524384 | Vintage Cracker Jack Gumball prize charm | 0 (OUT OF STOCK) |
244 | 1175 | 275458939770 | vintage Cracker Jack Gumball charm prize | 0 (OUT OF STOCK) |
245 | 1177 | 275458949486 | vintage Cracker Jack charm prize Boy on | 0 (OUT OF STOCK) |
246 | 1179 | 275459221209 | vintage Cracker Jack charm prize Silvery | 0 (OUT OF STOCK) |
247 | 1176 | 275458944602 | vintage Cracker Jack Gumball charm prize | 0 (OUT OF STOCK) |
248 | 1193 | 276301204436 | Baby Proofing American Electrical Outlet | 0 (OUT OF STOCK) |
249 | 1192 | 229207820003 | Cast Iron Plaque Sign - Please Close The | 0 (OUT OF STOCK) |
250 | 1180 | 275459274008 | vintage Cracker Jack charm prize Metalli | 0 (OUT OF STOCK) |
251 | 916 | 276841802932 | Otterbox Elevation 20 Tumbler Thermal Li | 0 (OUT OF STOCK) |