Porter Agencies

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

  Top » Catalog » TOOLING 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)
NYLON PRODUCTS-> (183)
RECOIL KITS & KEYSERTS-> (253)
TOOL BOXES-> (25)
TOOLING-> (539)
  BURR (5)
  CORE BIT (7)
  DRILL BITS (123)
  DRILL SETS (8)
  HACKSAW BLADES (3)
  HAND TOOLS (57)
  HOLE SAW (14)
  KNIFES (2)
  MISC (3)
  SCREWDRIVER BITS (19)
  TAP & DIES (281)
  TEX BITS (3)
  TUNGSTEN HOLE CUTTERS (14)
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 TOOLING
BURR
BURR
CORE BIT
CORE BIT
DRILL BITS
DRILL BITS
DRILL SETS
DRILL SETS
HACKSAW BLADES
HACKSAW BLADES
HAND TOOLS
HAND TOOLS
HOLE SAW
HOLE SAW
KNIFES
KNIFES
MISC
MISC
SCREWDRIVER BITS
SCREWDRIVER BITS
TAP & DIES
TAP & DIES
TEX BITS
TEX BITS
TUNGSTEN HOLE CUTTERS
TUNGSTEN HOLE CUTTERS
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 = '1' 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]