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`, `stock`.`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 AND stock.website_id = 0 ORDER BY `stock`.`stock_status` DESC

    

        ORDER BY Clauses:
        stock.stock_status DESC

    
Stock Distribution (Total: 31 products):Stock Status "0": 31 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                11974
                286568410736
                Kamado Joe JoeTisserie 24 inch Big Joe G
                
                    0 (OUT OF STOCK)                
            

                2
                3110
                277091711997
                Funko Pop! Pin Star Wars Max Rebo SE Tar
                
                    0 (OUT OF STOCK)                
            

                3
                3111
                277093334750
                SUPER7 RUN DMC Joseph "RUN" Simmons ReAc
                
                    0 (OUT OF STOCK)                
            

                4
                3112
                277093398774
                FUNKO POP! MOVIES: Raiders of the Lost A
                
                    0 (OUT OF STOCK)                
            

                5
                3113
                277093424276
                FUNKO POP! MOVIES: The Last Crusade - He
                
                    0 (OUT OF STOCK)                
            

                6
                3114
                277093437505
                Funko Pop! Pin Star Wars Max Rebo SE Tar
                
                    0 (OUT OF STOCK)                
            

                7
                3117
                286550852026
                Funko Pop! Vinyl: Indiana Jones - Indian
                
                    0 (OUT OF STOCK)                
            

                8
                11956
                277098598300
                The Real Mccoy DVD Action Crime Kim Basi
                
                    0 (OUT OF STOCK)                
            

                9
                11957
                277103109122
                Snake Eyes (DVD, 1999, Sensormatic) Nico
                
                    0 (OUT OF STOCK)                
            

                10
                11958
                277105767269
                Sahara - Universal Mouse Pad with Wirele
                
                    0 (OUT OF STOCK)                
            

    

Pos	ID	SKU	Name	Stock
1	11974	286568410736	Kamado Joe JoeTisserie 24 inch Big Joe G	0 (OUT OF STOCK)
2	3110	277091711997	Funko Pop! Pin Star Wars Max Rebo SE Tar	0 (OUT OF STOCK)
3	3111	277093334750	SUPER7 RUN DMC Joseph "RUN" Simmons ReAc	0 (OUT OF STOCK)
4	3112	277093398774	FUNKO POP! MOVIES: Raiders of the Lost A	0 (OUT OF STOCK)
5	3113	277093424276	FUNKO POP! MOVIES: The Last Crusade - He	0 (OUT OF STOCK)
6	3114	277093437505	Funko Pop! Pin Star Wars Max Rebo SE Tar	0 (OUT OF STOCK)
7	3117	286550852026	Funko Pop! Vinyl: Indiana Jones - Indian	0 (OUT OF STOCK)
8	11956	277098598300	The Real Mccoy DVD Action Crime Kim Basi	0 (OUT OF STOCK)
9	11957	277103109122	Snake Eyes (DVD, 1999, Sensormatic) Nico	0 (OUT OF STOCK)
10	11958	277105767269	Sahara - Universal Mouse Pad with Wirele	0 (OUT OF STOCK)