Porter Agencies

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

  Top » Catalog » MICROPLASTICS » HEX NUTS 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 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
Products Available are... Products Available are...
    Product Name+   Price   Buy Now 
    Hex Nut 3/8 UNC  ---------> Email for a quote!
    Nylon Hex Nut 5/8 - 11 UNC  ---------> Email for a quote!
    Nylon Hex Nut 6-32  ---------> Email for a quote!
    Nylon Hex Nut 8-32  ---------> Email for a quote!
    Nylon Hex Nuts 1/2UNC  ---------> Email for a quote!
    Nylon Hex Nuts 1/4-20  ---------> Email for a quote!
    Nylon Hex Nuts 5/16'  ---------> Email for a quote!
    Nylon Hex Nuts 7/8-9'  ---------> Email for a quote!
    Nylon Hex Nuts M10  ---------> Email for a quote!
    Nylon Hex Nuts M2  ---------> Email for a quote!
    Nylon Hex Nuts M2.5  ---------> Email for a quote!
    Nylon Hex Nuts M3  ---------> Email for a quote!
    Nylon Hex Nuts M3.5  ---------> Email for a quote!
    Nylon Hex Nuts M4  ---------> Email for a quote!
    Nylon Hex Nuts M5  ---------> Email for a quote!
    Nylon Hex Nuts M5  ---------> Email for a quote!
    Nylon Hex Nuts M6  ---------> Email for a quote!
    Nylon Hex Nuts M8  ---------> Email for a quote!
Displaying 1 to 18 (of 18 products) Result Pages:  1 
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'porterag_db.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '37' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

Shopping Cart more
0 items