Horticulture Source » Gardening & Hydroponics Store » Meters, Timers & Instruments » Instruments, Thermometers, Hygrometers & Light Meters   Mobile   Secure |  My Account | Cart Contents | Checkout )
Horticulture Source
Quick Find
Help [?]   Search Descriptions Phrase   Advanced
Secure   My Account   Cart Contents   Checkout  
You have JavaScript disabled or are using a browser which does not support it. Please turn on JavaScript or consider upgrading or switching your web browser, e.g. FireFox or Opera.
Celebrating our 12th Year of Service to Gardeners! Thank you for your business!

What do we have here?
Meters, Timers & Instruments: Instruments, Thermometers, Hygrometers & Light Meters

What do we have here?
Displaying 1 to 20 (of 24 products) Result Pages:  1  2  [Next >>] 
1317 - Query execution was interrupted

select p.products_image, p.products_image2, m.manufacturers_name, pd.products_name, pd.products_description, p.products_model, p.products_ltl_only, p.products_ship_sep, p.products_id, p.manufacturers_id, p.products_price, p.products_date_available, p.products_tax_class_id, 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 from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '119' order by p.products_ordered desc, pd.products_name limit 0, 20