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: 15 products):Stock Status "0": 3 products
Stock Status "1": 12 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                1682
                276931109905
                Women's Mel Rhinestone Mesh Ballet Flats
                
                    0 (OUT OF STOCK)                
            

                2
                1686
                276939078249
                Victrola Re-Spin Suitcase Vinyl Record P
                
                    0 (OUT OF STOCK)                
            

                3
                1690
                254107820030
                Wall Shelf Bracket Ornate Scroll White C
                
                    0 (OUT OF STOCK)                
            

                4
                2076
                286416196718
                Fitbit Inspire 3 | Heart Rate Monitor | 
                
                    1 (IN STOCK)                
            

                5
                2066
                286393686543
                Victrola Eastwood Signature Record Playe
                
                    1 (IN STOCK)                
            

                6
                2065
                286393541437
                Women's Mel Rhinestone Mesh Ballet Flats
                
                    1 (IN STOCK)                
            

                7
                2074
                254007820011
                Cast Iron Shelf Bracket Fleur De Lis Dis
                
                    1 (IN STOCK)                
            

                8
                2073
                286401640996
                Folding Front Shelf Traeger Pro Series 3
                
                    1 (IN STOCK)                
            

                9
                2080
                237107820000
                Human Footprint Stepping Stone Pair Feet
                
                    1 (IN STOCK)                
            

                10
                2078
                286416733183
                Genuine Apple - EarPods with Lightning C
                
                    1 (IN STOCK)                
            

                11
                2081
                272607820003
                13.75" Cast Iron Plant Hanger Bracket �
                
                    1 (IN STOCK)                
            

                12
                2082
                286427434485
                HEYDAY Phone Case for iPhone 12 Mini 5.4
                
                    1 (IN STOCK)                
            

                13
                2084
                254107820003
                Wall Shelf Bracket Decorative Cast Iron 
                
                    1 (IN STOCK)                
            

                14
                2085
                286430295408
                Google Pixel Watch 41mm Matte Black Stai
                
                    1 (IN STOCK)                
            

                15
                2088
                273207820012
                Funny Garden Flag Roses Are Red So Is My
                
                    1 (IN STOCK)                
            

    

Pos	ID	SKU	Name	Stock
1	1682	276931109905	Women's Mel Rhinestone Mesh Ballet Flats	0 (OUT OF STOCK)
2	1686	276939078249	Victrola Re-Spin Suitcase Vinyl Record P	0 (OUT OF STOCK)
3	1690	254107820030	Wall Shelf Bracket Ornate Scroll White C	0 (OUT OF STOCK)
4	2076	286416196718	Fitbit Inspire 3 \| Heart Rate Monitor \|	1 (IN STOCK)
5	2066	286393686543	Victrola Eastwood Signature Record Playe	1 (IN STOCK)
6	2065	286393541437	Women's Mel Rhinestone Mesh Ballet Flats	1 (IN STOCK)
7	2074	254007820011	Cast Iron Shelf Bracket Fleur De Lis Dis	1 (IN STOCK)
8	2073	286401640996	Folding Front Shelf Traeger Pro Series 3	1 (IN STOCK)
9	2080	237107820000	Human Footprint Stepping Stone Pair Feet	1 (IN STOCK)
10	2078	286416733183	Genuine Apple - EarPods with Lightning C	1 (IN STOCK)
11	2081	272607820003	13.75" Cast Iron Plant Hanger Bracket �	1 (IN STOCK)
12	2082	286427434485	HEYDAY Phone Case for iPhone 12 Mini 5.4	1 (IN STOCK)
13	2084	254107820003	Wall Shelf Bracket Decorative Cast Iron	1 (IN STOCK)
14	2085	286430295408	Google Pixel Watch 41mm Matte Black Stai	1 (IN STOCK)
15	2088	273207820012	Funny Garden Flag Roses Are Red So Is My	1 (IN STOCK)