Plant Hangers - 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: 7 products):Stock Status "0": 3 products
Stock Status "1": 4 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                269
                255707820009
                Cast Iron S Style Plant Hook Colorful Bi
                
                    0 (OUT OF STOCK)                
            

                2
                270
                255707820019
                Cast Iron Plant Hanger Hook Butterflies 
                
                    0 (OUT OF STOCK)                
            

                3
                271
                272607820009
                Decorative Plant Hanger Curly Vine Brown
                
                    0 (OUT OF STOCK)                
            

                4
                268
                255707820011
                Butterfly Plant Hanger Bracket Flower Po
                
                    1 (IN STOCK)                
            

                5
                272
                272607820002
                Plant Hanger Hanging Pot Flower Basket H
                
                    1 (IN STOCK)                
            

                6
                273
                255707820014
                Chickadee Bird S Style Plant Hook Cast I
                
                    1 (IN STOCK)                
            

                7
                274
                272607820006
                Rose Flower Bloom S Style Plant Hook Cas
                
                    1 (IN STOCK)                
            

    

Pos	ID	SKU	Name	Stock
1	269	255707820009	Cast Iron S Style Plant Hook Colorful Bi	0 (OUT OF STOCK)
2	270	255707820019	Cast Iron Plant Hanger Hook Butterflies	0 (OUT OF STOCK)
3	271	272607820009	Decorative Plant Hanger Curly Vine Brown	0 (OUT OF STOCK)
4	268	255707820011	Butterfly Plant Hanger Bracket Flower Po	1 (IN STOCK)
5	272	272607820002	Plant Hanger Hanging Pot Flower Basket H	1 (IN STOCK)
6	273	255707820014	Chickadee Bird S Style Plant Hook Cast I	1 (IN STOCK)
7	274	272607820006	Rose Flower Bloom S Style Plant Hook Cas	1 (IN STOCK)