Toggle Nav
My Cart
Search
Advanced Search

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`, 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:

stock.stock_status DESC

Stock Distribution (Total: 49 products):

Stock Status "0": 27 products

Stock Status "1": 22 products

Product Samples:

Pos ID SKU Name Stock
1 777 273407820002 Cast Iron Trivet Round Ornate Heart Scro 0 (OUT OF STOCK)
2 776 273407820001 Decorative Cast Iron Trivet Ornate Heart 0 (OUT OF STOCK)
3 326 019707820000 Nautical Black & White Lighthouse Wall H 0 (OUT OF STOCK)
4 328 019707820009 Horse Head Western Wall Hook Rust Brown 0 (OUT OF STOCK)
5 329 019700410014 Mermaid Wall Hook Rust Cast Iron Coat Ha 0 (OUT OF STOCK)
6 330 019707820004 Wall Hook Skeleton Key Coat Rack Antique 0 (OUT OF STOCK)
7 333 019707820003 Seahorse Wall Hook Ocean Decor Rust Brow 0 (OUT OF STOCK)
8 309 820107820008 Welcome Garden Hose Holder Reel Butterfl 0 (OUT OF STOCK)
9 312 820107820006 Garden Water Hose Holder Rose Flower Han 0 (OUT OF STOCK)
10 289 273007820004 Plant Hanger Bird Bath Feeder Cast Iron 0 (OUT OF STOCK)
11 291 255707820021 Pixie Fairy Cast Iron Plant Hanger Verdi 0 (OUT OF STOCK)
12 290 272607820004 Decorative Plant Hanger Cast Iron Flower 0 (OUT OF STOCK)
13 314 820107820014 Garden Hose Holder Hanger - Black Cast I 0 (OUT OF STOCK)
14 292 110102740002 Hummingbird Plant Hanger Cast Iron Flowe 0 (OUT OF STOCK)
15 318 820107820013 Wall Mount Garden Hose Holder Floral & S 0 (OUT OF STOCK)
16 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel 0 (OUT OF STOCK)
17 293 255707820002 Decorative Plant Hanger Ornate Victorian 0 (OUT OF STOCK)
18 295 255707820003 Hummingbird Plant Hanger Flower Hook Dec 0 (OUT OF STOCK)
19 300 272607820001 Rustic Cast Iron Plant Hanger Bracket Fl 0 (OUT OF STOCK)
20 320 256207820001 Garden Hose Guide Bird On Daisy Cast Iro 0 (OUT OF STOCK)
21 322 820107820002 Garden Hose Holder Water Pail Bucket Ver 0 (OUT OF STOCK)
22 301 110100410001 Cast Iron Plant Hanger Basket Hook Pixie 0 (OUT OF STOCK)
23 305 019707820016 Monkey Wall Hook Rack With 4 Cast Iron H 0 (OUT OF STOCK)
24 304 255707820006 Decorative Watering Can Cast Iron Plant 0 (OUT OF STOCK)
25 780 203707820000 Decorative Cast Iron Trivet Chilli Peppe 0 (OUT OF STOCK)
26 324 IWHSH0020 Garden Hose Holder Birds On Branch 9" Wi 0 (OUT OF STOCK)
27 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad 0 (OUT OF STOCK)
28 308 820107820011 Garden Hose Holder Frogs On Lily Pads Ca 1 (IN STOCK)
29 310 820102740000 Cast Iron Garden Hose Holder Floral & Sp 1 (IN STOCK)
30 311 820107820010 Garden Hose Holder Reel Cast Iron Hanger 1 (IN STOCK)
31 2 273707820000 Ornate Heart Shelf Bracket Decorative Ru 1 (IN STOCK)
32 778 203707820002 Decorative Cast Iron Fish Trivet Kitchen 1 (IN STOCK)
33 779 203707820001 Tea Kettle Trivet Ornate Decorative Cast 1 (IN STOCK)
34 781 274207820000 Cast Iron Nautical Anchor Trivet Hot Pla 1 (IN STOCK)
35 313 820107820009 Cast Iron Garden Hose Holder Love Birds 1 (IN STOCK)
36 315 820107820012 Garden Water Hose Holder Birds In Tree C 1 (IN STOCK)
37 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit 1 (IN STOCK)
38 298 255707820016 Love Birds Cast Iron Decorative Plant Ha 1 (IN STOCK)
39 297 272607820010 Plant Hanger Vine Brown Flower Basket Po 1 (IN STOCK)
40 299 255707820017 Birds In Tree Decorative Plant Hanger Ca 1 (IN STOCK)
41 321 256207820002 Decorative Garden Hose Guide Bird On Ros 1 (IN STOCK)
42 334 019707820018 Horse Head Horseshoe Western Double Wall 1 (IN STOCK)
43 303 110100410004 Decorative Chickadee Bird Design Cast Ir 1 (IN STOCK)
44 302 263907820000 Cast Iron S Style Plant Hook Flower Hang 1 (IN STOCK)
45 335 019707820017 Wall Hook Coat Rack Birds On Fence 3 Cas 1 (IN STOCK)
46 325 820100410001 Hose Holder Reel Cast Iron Horse & Horse 1 (IN STOCK)
47 294 255707820000 Plant Hanger Decorative Hummingbird Cast 1 (IN STOCK)
48 773 273407820003 Heart Shaped Trivet Ornate Decorative Ca 1 (IN STOCK)
49 775 273407820005 Square Trivet Black Cast Iron Decorative 1 (IN STOCK)
View as Grid List

Items 1-12 of 49

Set Descending Direction
Page
per page
  1. Shape J Hook Remove This Item
  2. Manufacturer Flag Emotes Remove This Item
Clear All
Shopping Options
Compare Products
You have no items to compare.
My Wish List
Last Added Items
You have no items in your wish list.
Copyright © 2023-present Chillicothe Market All rights reserved.