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: 16 products):Stock Status "0": 7 products
Stock Status "1": 9 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                169
                254007820000
                Wall Shelf Bracket Decorative Cast Iron 
                
                    0 (OUT OF STOCK)                
            

                2
                184
                254107820026
                Cast Iron Wall Shelf Bracket Brace Colum
                
                    0 (OUT OF STOCK)                
            

                3
                170
                012600410004
                Wall Shelf Bracket Leaf Vine Pattern Cas
                
                    0 (OUT OF STOCK)                
            

                4
                172
                254107820029
                Wall Shelf Bracket Brace Ornate Vine Bro
                
                    0 (OUT OF STOCK)                
            

                5
                176
                254107820004
                Cast Iron Wall Shelf Bracket Brace Vine 
                
                    0 (OUT OF STOCK)                
            

                6
                181
                254107820016
                Decorative Shelf Bracket - Ornate Lattic
                
                    0 (OUT OF STOCK)                
            

                7
                182
                254107820018
                Decorative Shelf Bracket - Hexagon Latti
                
                    0 (OUT OF STOCK)                
            

                8
                186
                019700410031
                Cast Iron Wall Hook Verdigris Seahorse 5
                
                    1 (IN STOCK)                
            

                9
                166
                273007820002
                Seed Feeder Bird Bath Cast Iron Wall Mou
                
                    1 (IN STOCK)                
            

                10
                167
                273007820005
                Hanging Heart Shaped Love Bird Feeder Or
                
                    1 (IN STOCK)                
            

                11
                174
                254107820031
                Wall Shelf Bracket Ornate Vine Distresse
                
                    1 (IN STOCK)                
            

                12
                178
                254107820025
                Decorative Wall Shelf Bracket Simple Vin
                
                    1 (IN STOCK)                
            

                13
                179
                197100410004
                Wall Shelf Bracket - Ornate Pattern - Bl
                
                    1 (IN STOCK)                
            

                14
                183
                254107820019
                Shelf Bracket Brace For Custom Shelving 
                
                    1 (IN STOCK)                
            

                15
                2359
                272907820016
                Welcome To Our Home Garden Flag – Seas
                
                    1 (IN STOCK)                
            

                16
                2358
                255707820018
                Cast Iron Plant Hanger Bracket Hummingbi
                
                    1 (IN STOCK)                
            

    

Pos	ID	SKU	Name	Stock
1	169	254007820000	Wall Shelf Bracket Decorative Cast Iron	0 (OUT OF STOCK)
2	184	254107820026	Cast Iron Wall Shelf Bracket Brace Colum	0 (OUT OF STOCK)
3	170	012600410004	Wall Shelf Bracket Leaf Vine Pattern Cas	0 (OUT OF STOCK)
4	172	254107820029	Wall Shelf Bracket Brace Ornate Vine Bro	0 (OUT OF STOCK)
5	176	254107820004	Cast Iron Wall Shelf Bracket Brace Vine	0 (OUT OF STOCK)
6	181	254107820016	Decorative Shelf Bracket - Ornate Lattic	0 (OUT OF STOCK)
7	182	254107820018	Decorative Shelf Bracket - Hexagon Latti	0 (OUT OF STOCK)
8	186	019700410031	Cast Iron Wall Hook Verdigris Seahorse 5	1 (IN STOCK)
9	166	273007820002	Seed Feeder Bird Bath Cast Iron Wall Mou	1 (IN STOCK)
10	167	273007820005	Hanging Heart Shaped Love Bird Feeder Or	1 (IN STOCK)
11	174	254107820031	Wall Shelf Bracket Ornate Vine Distresse	1 (IN STOCK)
12	178	254107820025	Decorative Wall Shelf Bracket Simple Vin	1 (IN STOCK)
13	179	197100410004	Wall Shelf Bracket - Ornate Pattern - Bl	1 (IN STOCK)
14	183	254107820019	Shelf Bracket Brace For Custom Shelving	1 (IN STOCK)
15	2359	272907820016	Welcome To Our Home Garden Flag – Seas	1 (IN STOCK)
16	2358	255707820018	Cast Iron Plant Hanger Bracket Hummingbi	1 (IN STOCK)