Shipping & Terms  |  Contact Us  |  Create an account  |  Customer Login 
Product search:
 
Welcome - Have Fun Shopping!  
Currencies:
In your shopping cart 0 items
   2
   Accessories
   Cameras & Optics
   Car Audio & Video
   Car/Boat Audio & Video
   CB's & Scanners
   Collectibles
   Computer Accessories
   GPS Navagation
   GPS Navigation
   Health & Beauty
   Home Electronics
   Home Office
   Housewares
   Lawn & Garden
   Miscellaneous
    - ANNIN®
    - BETTER BRUSH™
    - BLISS®
    - CALFORNIA INNOVATIONS™
    - CONSTRUCTION LINE®
    - EXCALIBUR®
    - FLIGHTABLE®
    - GARDEN CREATIONS™
    - HANDY TRENDS™
    - JOBAR®
    - MALIBU®
    - MR. VOICE
    - NORTHWEST COMPANY
    - OUTDOOR DECOR®
    - PACIFIC®
    - PEAK™
    - PREMIER®
    - RYOBI®
    - SEGMA
    - SHARP®
    - SIERRA ELECTRIC®
    - STYLE AUTO™
    - THINKTANK TECHNOLOGY™
    - U.S. PATROL
    - UNISONIC
   Office Products
   Portable Electronics
   Radar Detectors
   Seasonal Items
   Sports/Recreational
   Telephones
   Tools
   Toys & Games
   Two Way Radios / GPS
   Watches/Timepieces
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 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 = '97'

[TEP STOP]