4 Season Greenhouse


	What's New?

Xtrasun 1000W 240v HPS/MH E-Ballast
~~$349.95~~
$314.96

All New Products


	Articles

All Articles
:: Greenhouse Buyer's Guide
:: Composting Guide

4 Season Recommended
Our top 10 Best Selling & Recommended Products! Not only do the products in our best sellers list have to be one of the top selling products on our site but they also feature exceptional feedback from our customers. These are products we would recommend to our families.

1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by rand() DESC limit 3

[TEP STOP]