i-Canoe - Irelands newest online canoe equipment store

Warning: file(includes/spiders.txt) [function.file]: failed to open stream: No such file or directory in /home/icanoe/public_html/catalog/includes/application_top.php on line 181

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/icanoe/public_html/catalog/includes/application_top.php:181) in /home/icanoe/public_html/catalog/includes/functions/sessions.php on line 97

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/icanoe/public_html/catalog/includes/application_top.php:181) in /home/icanoe/public_html/catalog/includes/functions/sessions.php on line 97
i-Canoe - Irelands newest online canoe equipment store

Top » Catalog » Kayaks » Whitewater

My Account | Cart Contents | Checkout

Categories

Gift Vouchers (1)
Map & Video Downloads (9)
Beginner's Bargain Buys (7)
Canoes (8)
Kayaks-> (87)
  Angling (14)
  Surf (1)
  Whitewater-> (51)
    River Running Playboats (9)
    Freestyle Kayaks (14)
    Steep Creekers (14)
    River Runners (14)
  Sit On Top-> (2)
  Touring-> (11)
  Recreational-> (6)
  Inflatable-> (1)
  Polo (1)
Paddles-> (46)
Pedal Boats (2)
Unisex Water-wear-> (53)
Ladies Water-wear (12)
Spraydecks-> (11)
Foot-wear (5)
Helmets-> (18)
Bags & Cases-> (14)
Buoyancy Aids-> (17)
Rescue-> (25)
Accessories-> (15)
Books & DVDs-> (24)
Outfitting (10)
Package Deals (5)
Ex-demo (3)
Special & Clearance Stock (20)
Second Hand

Manufacturers

What's New?

How to Find Us
€0.00EUR

Quick Find

Let's See What We Have Here

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 = '42'

[TEP STOP]