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` 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'))
    

        ORDER BY Clauses:
        
    
Stock Distribution (Total: 16 products):Stock Status "null": 16 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                3110
                277091711997
                Funko Pop! Pin Star Wars Max Rebo SE Tar
                
                    null                
            

                2
                3111
                277093334750
                SUPER7 RUN DMC Joseph "RUN" Simmons ReAc
                
                    null                
            

                3
                3112
                277093398774
                FUNKO POP! MOVIES: Raiders of the Lost A
                
                    null                
            

                4
                3113
                277093424276
                FUNKO POP! MOVIES: The Last Crusade - He
                
                    null                
            

                5
                3114
                277093437505
                Funko Pop! Pin Star Wars Max Rebo SE Tar
                
                    null                
            

                6
                3115
                286549184208
                Women's Darla Platform Mule Heels Black 
                
                    null                
            

                7
                3117
                286550852026
                Funko Pop! Vinyl: Indiana Jones - Indian
                
                    null                
            

                8
                11956
                277098598300
                The Real Mccoy DVD Action Crime Kim Basi
                
                    null                
            

                9
                11957
                277103109122
                Snake Eyes (DVD, 1999, Sensormatic) Nico
                
                    null                
            

                10
                11958
                277105767269
                Sahara - Universal Mouse Pad with Wirele
                
                    null                
            

    

Pos	ID	SKU	Name	Stock
1	3110	277091711997	Funko Pop! Pin Star Wars Max Rebo SE Tar	null
2	3111	277093334750	SUPER7 RUN DMC Joseph "RUN" Simmons ReAc	null
3	3112	277093398774	FUNKO POP! MOVIES: Raiders of the Lost A	null
4	3113	277093424276	FUNKO POP! MOVIES: The Last Crusade - He	null
5	3114	277093437505	Funko Pop! Pin Star Wars Max Rebo SE Tar	null
6	3115	286549184208	Women's Darla Platform Mule Heels Black	null
7	3117	286550852026	Funko Pop! Vinyl: Indiana Jones - Indian	null
8	11956	277098598300	The Real Mccoy DVD Action Crime Kim Basi	null
9	11957	277103109122	Snake Eyes (DVD, 1999, Sensormatic) Nico	null
10	11958	277105767269	Sahara - Universal Mouse Pad with Wirele	null