Porter Agencies

PORTER AGENCIES
Unit 1/6 Industry Street
Malaga Perth, WA 6090
Ph: (08) 9444 9944
Fax : (08) 9444 9767

  Top » Catalog » HEYCO My Account  |  Cart Contents  |  Checkout   
Categories
AUTOMOTIVE-> (69)
CABLE CRIMPERS (3)
CABLE CUTTERS (38)
CABLING & WIRING ACCESSORIES-> (375)
FASTENERS-> (2605)
HEYCO-> (511)
  BRAIDED SLEEVING (16)
  BRASS NICKEL CORD GRIPS (29)
  BUMPERS AND FEET (4)
  CABLE TIES (5)
  CABLE WRAP (10)
  DOME PLUGS (76)
  FLEXIBLE CONDUIT & LIQUID TIGHT (7)
  HOSE CLAMPS (13)
  LIQUID TIGHT CORDGRIP (22)
  LIQUID TIGHT PIGTAILS (2)
  LOUVERED PLUGS (16)
  MISC (53)
  POWER COMPONENTS (17)
  PUSH RIVETS (10)
  RUBBER GROMMETS (30)
  SNAP BUSHINGS (114)
  SPLIT TUBBING (11)
  STRAIN RELIEF BUSHINGS (64)
  VENT PLUGS (12)
HYDRAULIC HOLE PUNCHES-> (275)
KEYSTONE ELECTRONIC HARDWARE-> (139)
LINK CONNECTORS-> (154)
MICROPLASTICS-> (504)
NYLON PRODUCTS-> (183)
RECOIL KITS & KEYSERTS-> (253)
TOOL BOXES-> (25)
TOOLING-> (539)
TOOLS-> (86)
Manufacturers
What's New? more
Baudat BPD16.5mm
Baudat BPD16.5mm
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
About Us
Categories HEYCO
BRAIDED SLEEVING
BRAIDED SLEEVING
BRASS NICKEL CORD GRIPS
BRASS NICKEL CORD GRIPS
BUMPERS AND FEET
BUMPERS AND FEET
CABLE TIES
CABLE TIES
CABLE WRAP
CABLE WRAP
DOME PLUGS
DOME PLUGS
FLEXIBLE CONDUIT & LIQUID TIGHT
FLEXIBLE CONDUIT & LIQUID TIGHT
HOSE CLAMPS
HOSE CLAMPS
LIQUID TIGHT CORDGRIP
LIQUID TIGHT CORDGRIP
LIQUID TIGHT PIGTAILS
LIQUID TIGHT PIGTAILS
LOUVERED PLUGS
LOUVERED PLUGS
MISC
MISC
POWER COMPONENTS
POWER COMPONENTS
PUSH RIVETS
PUSH RIVETS
RUBBER GROMMETS
RUBBER GROMMETS
SNAP BUSHINGS
SNAP BUSHINGS
SPLIT TUBBING
SPLIT TUBBING
STRAIN RELIEF BUSHINGS
STRAIN RELIEF BUSHINGS
VENT PLUGS
VENT PLUGS
New Products For May
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'porterag_db.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '119' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]