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_status` DESC
ORDER BY Clauses:
Total ORDER BY clauses: 1 Order #1: stock_status DESC
Stock Distribution (Total: 1 products):
Stock Status "0": 1 products
Product Samples:
| Pos | ID | SKU | Name | Stock |
|---|---|---|---|---|
| 1 | 788 | 246407820002 | LARGE Turtle Stepping Stone Paver Decora | 0 (OUT OF STOCK) |
Shop By
Now Shopping by
Shopping Options
- Upper Material Polyester Remove This Item
- Theme Turtle 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
Assembly Required
Hook Style
Shoe Shaft Style
Manufacturer
Color
Us Shoe Size
Department
Occasion
Lining Material
Style
Heel Height
Toe Shape
Closure
Heel Style
Shoe Width
Insole Material
Fabric Type
Season
My Wish List