I think I'm getting the hang of this stuff.....however I was wondering if the query below can be deleted from an index.php page without an adverse effect. (I don't have expected products)
[29] => select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 10
-----question 2......where is it being queried from? I have had a quick look at index.php, categories.php and application_top.php
but cannot seem to pin it down.
Cheers,
Michael














