Newsletters are one of the most effective ways to keep your business's name in front of the eyes of your clients, your associates, and others that may be in your target market. A newsletter allows you to indicate to them that you are more than just someone who is looking for projects to work on, you are established and experienced. And a newsletter displays your willingness to pass on information that will help them run their own businesses.
1054 - Unknown column 'p.products_id' in 'on clause'
select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices 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 = '7'