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: 1 products):
Stock Status "0": 1 products
Product Samples:
| Pos | ID | SKU | Name | Stock |
|---|---|---|---|---|
| 1 | 1167 | 274811615606 | Harley Quinn Costume Girl M (8-10) DC Su | 0 (OUT OF STOCK) |
Shop By
Now Shopping by
Shopping Options
- Assembly Required No Remove This Item
- Style Complete Outfit Remove This Item
Set Includes
Outsole Material
Accents
Calf Width
Platform Height
Primary Color
Shape
Item Weight
Finish
Product Line
Room
Personalized
Mounting
Indoor Outdoor
Suitable For
Subject
Hook Style
Shoe Shaft Style
Manufacturer
Color
Us Shoe Size
Department
Occasion
Lining Material
Heel Height
Upper Material
Toe Shape
Closure
Heel Style
Theme
Shoe Width
Insole Material
Fabric Type
My Wish List