A Canadian Company
filters
Select pa.*,
b.title bnm, b.title_seo bnmseo, b.discount bdiscount,
c.title cnm, c.title_seo cnmseo, c.discount cdiscount,
c1.title scnm, c1.title_seo scnmseo, c1.discount scdiscount
from pa
LEFT JOIN brands b ON pa.brand_id = b.id and b.visible=0
LEFT JOIN categories c ON pa.category_id = c.id and c.visible=0
LEFT JOIN categories c1 ON pa.subcategory_id = c1.id and c1.visible=0
where pa.visible=0 and pa.delflag=0 and pa.category_id=3916 and pa.subcategory_id=3919 order by pa.featured desc,pa.sort_order,FIELD(status,1,3,6,5,1,4,2)
Showing 1 to x of xx results
| # | name | brand | price | category | stock | sale | OilType | OilVol | OilGrade | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG102 - 4-1/2 WOLVERINE AO RFD 120Z GRIT 7/8 ARBOR HOLE | weiler | 15.97 | CAT3919XZ |
C$ 15.97
In Stock
| Yes | No | ||||
| 1 | PG102 - 4-1/2 WOLVERINE AO RFD 80Z GRIT 7/8 ARBOR HOLE | weiler | 15.97 | CAT3919XZ |
C$ 15.97
In Stock
| Yes | No | |||
| 2 | PG102 - 4-1/2 WOLVERINE AO RFD 60Z GRIT 7/8 ARBOR HOLE | weiler | 16.97 | CAT3919XZ |
C$ 16.97
In Stock
| Yes | No | |||
| 3 | PG102 - 5 WOLVERINE AO RFD 120AO GRIT 7/8 ARBOR HOLE | weiler | 18.85 | CAT3919XZ |
C$ 18.85
In Stock
| Yes | No | |||
| 4 | PG102 - 5 WOLVERINE AO RFD 80AO GRIT 7/8 ARBOR HOLE | weiler | 18.85 | CAT3919XZ |
C$ 18.85
In Stock
| Yes | No | |||
| 5 | PG102 - 5 WOLVERINE AO RFD 60AO GRIT 7/8 ARBOR HOLE | weiler | 19.39 | CAT3919XZ |
C$ 19.39
In Stock
| Yes | No | |||
| 6 | PG101 - 5" WOLVERINE ABRASIVE FLAP DISC, ANGLED, PHENOLIC BACKING, 80Z, 7/8" HOLE | weiler | 46.31 | CAT3919XZ |
Weiler
PG101 - 5" WOLVERINE ABRASIVE FLAP DISC, ANGLED, PHENOLIC BACKING, 80Z, 7/8" HOLEPart# WEI-31358C$ 46.31
In Stock
| Yes | No |