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: 1 products):
Stock Status "0": 1 products
Product Samples:
| Pos | ID | SKU | Name | Stock |
|---|---|---|---|---|
| 1 | 320 | 256207820001 | Garden Hose Guide Bird On Daisy Cast Iro | 0 (OUT OF STOCK) |
Shop By
Now Shopping by
Shopping Options
- Item Weight 13 oz Remove This Item
- Heel Style Stiletto Remove This Item
Set Includes
Outsole Material
Accents
Calf Width
Platform Height
Primary Color
Shape
Finish
Product Line
Room
Personalized
Mounting
Indoor Outdoor
Suitable For
Subject
Assembly Required
Hook Style
Shoe Shaft Style
Manufacturer
Color
Us Shoe Size
Department
Occasion
Lining Material
Style
Heel Height
Upper Material
Toe Shape
Closure
Theme
Shoe Width
Insole Material
Fabric Type
My Wish List