Consumables

You are here: Home / Shop / Consumables

Categories

Staples, Nails & Hoops (28) Oxyacetylene Welding (6) Tapes (27) Oils & Lubricants (37) Shot Blasting (8) Janitorial (9) CVJ Boots (17) Cable Dispenser (2) Chemicals (11) Abrasive Papers (19) Emery Papers (21) Exhaust Mounts (4) Grease Fittings (8) Abrasive Hand Pads (3) Plastic Welding Rods (1) Saw Blades (14) Fuel Filters (4) Spray Gun Filters (2) Tyre & Wheel Maintenance (31) Arc Welding (32) Paint Brushes (9) Spot & Stud Welding (8) Rope (2) Ball Joint Covers (2) Detergents (8) Maintenance (17) Paint (10) Solder (9) Glues, Adhesives & Sealants (33) Compound & Polish (3) Repair Kits (2) Castor Wheels (116) Personal Hygiene (5) Film (3) Hog Rings (1) Steel Wool (4) Trim Clips (104) MIG Welding (62) Split Pins (12) R-Clips (1) O-Rings (4) Roll Pins (2) Grease Nipples (23) Bonded Seals (2) E-Clips (2) Washers (49) Electrical (312) Circlips (1) Clevis Pins (1) Linch Pins (1) Nuts & Bolts (120) Hose Clips (95) Screws & Fixings (77) Brakes (35) Speedfit Pneumatic System (32) Threaded Inserts (19) Rivets (34) Tools & Accessories (15) Parts Cleaning (7) Blades (7)

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '1538'OR PC.CatID = '1540'OR PC.CatID = '1541'OR PC.CatID = '1544'OR PC.CatID = '1568'OR PC.CatID = '1583'OR PC.CatID = '1613'OR PC.CatID = '1635'OR PC.CatID = '1543'OR PC.CatID = '1545'OR PC.CatID = '1547'OR PC.CatID = '1550'OR PC.CatID = '1572'OR PC.CatID = '1573'OR PC.CatID = '1549'OR PC.CatID = '1562'OR PC.CatID = '1563'OR PC.CatID = '1566'OR PC.CatID = '1657'OR PC.CatID = '1565'OR PC.CatID = '1575'OR PC.CatID = '1576'OR PC.CatID = '1574'OR PC.CatID = '1577'OR PC.CatID = '1579'OR PC.CatID = '1580'OR PC.CatID = '1578'OR PC.CatID = '1584'OR PC.CatID = '1585'OR PC.CatID = '1587'OR PC.CatID = '1586'OR PC.CatID = '1594'OR PC.CatID = '1595'OR PC.CatID = '1600'OR PC.CatID = '1611'OR PC.CatID = '1658'OR PC.CatID = '1610'OR PC.CatID = '1616'OR PC.CatID = '1619'OR PC.CatID = '1624'OR PC.CatID = '1625'OR PC.CatID = '1633'OR PC.CatID = '1634'OR PC.CatID = '1636'OR PC.CatID = '1637'OR PC.CatID = '1638'OR PC.CatID = '1639'OR PC.CatID = '1640'OR PC.CatID = '1641'OR PC.CatID = '1642'OR PC.CatID = '1643'OR PC.CatID = '1644'OR PC.CatID = '1650'OR PC.CatID = '1652'OR PC.CatID = '1480'OR PC.CatID = '1567'OR PC.CatID = '1606'OR PC.CatID = '1607'OR PC.CatID = '1608'OR PC.CatID = '1609'OR PC.CatID = '1479'OR PC.CatID = '1481'OR PC.CatID = '1482'OR PC.CatID = '1483'OR PC.CatID = '1484'OR PC.CatID = '1486'OR PC.CatID = '1581'OR PC.CatID = '1485'OR PC.CatID = '1487'OR PC.CatID = '1488'OR PC.CatID = '1490'OR PC.CatID = '1510'OR PC.CatID = '1629'OR PC.CatID = '1651'OR PC.CatID = '1489'OR PC.CatID = '1492'OR PC.CatID = '1496'OR PC.CatID = '1502'OR PC.CatID = '1503'OR PC.CatID = '1504'OR PC.CatID = '1505'OR PC.CatID = '1506'OR PC.CatID = '1525'OR PC.CatID = '1526'OR PC.CatID = '1527'OR PC.CatID = '1528'OR PC.CatID = '1529'OR PC.CatID = '1530'OR PC.CatID = '1531'OR PC.CatID = '1533'OR PC.CatID = '1546'OR PC.CatID = '1552'OR PC.CatID = '1553'OR PC.CatID = '1554'OR PC.CatID = '1555'OR PC.CatID = '1556'OR PC.CatID = '1557'OR PC.CatID = '1559'OR PC.CatID = '1560'OR PC.CatID = '1564'OR PC.CatID = '1569'OR PC.CatID = '1570'OR PC.CatID = '1588'OR PC.CatID = '1589'OR PC.CatID = '1590'OR PC.CatID = '1591'OR PC.CatID = '1592'OR PC.CatID = '1593'OR PC.CatID = '1597'OR PC.CatID = '1598'OR PC.CatID = '1599'OR PC.CatID = '1604'OR PC.CatID = '1617'OR PC.CatID = '1632'OR PC.CatID = '1647'OR PC.CatID = '1648'OR PC.CatID = '1491'OR PC.CatID = '1493'OR PC.CatID = '1494'OR PC.CatID = '1495'OR PC.CatID = '1498'OR PC.CatID = '1499'OR PC.CatID = '1500'OR PC.CatID = '1501'OR PC.CatID = '1509'OR PC.CatID = '1561'OR PC.CatID = '1612'OR PC.CatID = '1646'OR PC.CatID = '1649'OR PC.CatID = '1497'OR PC.CatID = '1508'OR PC.CatID = '1582'OR PC.CatID = '1596'OR PC.CatID = '1605'OR PC.CatID = '1614'OR PC.CatID = '1615'OR PC.CatID = '1507'OR PC.CatID = '1512'OR PC.CatID = '1513'OR PC.CatID = '1514'OR PC.CatID = '1515'OR PC.CatID = '1523'OR PC.CatID = '1542'OR PC.CatID = '1551'OR PC.CatID = '1511'OR PC.CatID = '1516'OR PC.CatID = '1518'OR PC.CatID = '1620'OR PC.CatID = '1517'OR PC.CatID = '1520'OR PC.CatID = '1653'OR PC.CatID = '1654'OR PC.CatID = '1655'OR PC.CatID = '1519'OR PC.CatID = '1522'OR PC.CatID = '1601'OR PC.CatID = '1618'OR PC.CatID = '1622'OR PC.CatID = '1623'OR PC.CatID = '1626'OR PC.CatID = '1627'OR PC.CatID = '1628'OR PC.CatID = '1521'OR PC.CatID = '1524'OR PC.CatID = '1532'OR PC.CatID = '1535'OR PC.CatID = '1539'OR PC.CatID = '1534') LIMIT 0,9;