Porter Agencies

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

  Top » Catalog » MICROPLASTICS My Account  |  Cart Contents  |  Checkout   
Categories
AUTOMOTIVE-> (69)
CABLE CRIMPERS (3)
CABLE CUTTERS (38)
CABLING & WIRING ACCESSORIES-> (375)
FASTENERS-> (2605)
HEYCO-> (511)
HYDRAULIC HOLE PUNCHES-> (275)
KEYSTONE ELECTRONIC HARDWARE-> (139)
LINK CONNECTORS-> (154)
MICROPLASTICS-> (504)
  ACETAL RIVETS (3)
  ARROW CLIPS (12)
  BUSHINGS (1)
  CHEESE HEAD (37)
  CSK METAL THREAD (28)
  CUP WASHER (3)
  DOME NUTS (4)
  DOME PLUGS (2)
  FLAT WASHERS (81)
  FLEXIBLE GROMMETTING (4)
  GRUB SCREW (1)
  HEX HEAD (38)
  HEX NUTS (18)
  HOSE CLAMPS (2)
  JAM NUTS (5)
  LOCK NUTS (1)
  MISC (40)
  NYLON FASTENER KNOBS (16)
  P CLIPS (1)
  PAN METAL THREAD (28)
  PAN SLOT SCREWS (2)
  PUSH IN FASTENERS (8)
  RETAINING WASHERS (4)
  SCREW INSULATOR (9)
  SHOULDER WASHERS (32)
  SNAP RIVETS (5)
  SOCKET CAP HEAD (1)
  SPACERS (90)
  THREADED ROD (4)
  THUMB SCREWS (17)
  WING NUTS (7)
NYLON PRODUCTS-> (183)
RECOIL KITS & KEYSERTS-> (253)
TOOL BOXES-> (25)
TOOLING-> (539)
TOOLS-> (86)
Manufacturers
What's New? more
Baudat BPD20.5mm
Baudat BPD20.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 MICROPLASTICS
ACETAL RIVETS
ACETAL RIVETS
ARROW CLIPS
ARROW CLIPS
BUSHINGS
BUSHINGS
CHEESE HEAD
CHEESE HEAD
CSK METAL THREAD
CSK METAL THREAD
CUP WASHER
CUP WASHER
DOME NUTS
DOME NUTS
DOME PLUGS
DOME PLUGS
FLAT WASHERS
FLAT WASHERS
FLEXIBLE GROMMETTING
FLEXIBLE GROMMETTING
GRUB SCREW
GRUB SCREW
HEX HEAD
HEX HEAD
HEX NUTS
HEX NUTS
HOSE CLAMPS
HOSE CLAMPS
JAM NUTS
JAM NUTS
LOCK NUTS
LOCK NUTS
MISC
MISC
NYLON FASTENER KNOBS
NYLON FASTENER KNOBS
P CLIPS
P CLIPS
PAN METAL THREAD
PAN METAL THREAD
PAN SLOT SCREWS
PAN SLOT SCREWS
PUSH IN FASTENERS
PUSH IN FASTENERS
RETAINING WASHERS
RETAINING WASHERS
SCREW INSULATOR
SCREW INSULATOR
SHOULDER WASHERS
SHOULDER WASHERS
SNAP RIVETS
SNAP RIVETS
SOCKET CAP HEAD
SOCKET CAP HEAD
SPACERS
SPACERS
THREADED ROD
THREADED ROD
THUMB SCREWS
THUMB SCREWS
WING NUTS
WING NUTS
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 = '32' 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]