| About Us | Secure Ordering | Shipping & Return | Press | Contact Us |
![]() |
![]() |
|
|
|
select count(*) as total from products p, specials s left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and s.products_id = p.products_id and pd.language_id = '1' [TEP STOP] |