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=3922 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 | |
---|---|---|---|---|---|---|---|---|---|---|
PG103 - 4-1/2" X .045" TIGER AO TYPE 1 CUTTING WHEEL, A60T, 7/8" A.H. | weiler | 78.07 | CAT3922XZ |
C$ 78.07
In Stock
| Yes | No | ||||
1 | PG103 - 4-1/2" X .045" WOLVERINE TYPE 27 THIN CUTTING WHEEL, A60S, 7/8" A.H. | weiler | 52.69 | CAT3922XZ |
C$ 52.69
In Stock
| Yes | No | |||
2 | PG103 - 5" X .045" WOLVERINE TYPE 27 THIN CUTTING WHEEL, A60S, 7/8" A.H. | weiler | 59.71 | CAT3922XZ |
C$ 59.71
In Stock
| Yes | No | |||
3 | PG103 - 4-1/2" X .045" WOLVERINE TYPE 1 CUTTING WHEEL, A60T, 7/8" A.H. | weiler | 52.69 | CAT3922XZ |
C$ 52.69
In Stock
| Yes | No | |||
4 | PG103 - 3" X .035" WOLVERINE TYPE 1 CUTTING WHEEL, A60T, 1/4" A.H. | weiler | 39.11 | CAT3922XZ |
C$ 39.11
In Stock
| Yes | No | |||
5 | PG103 - CUT-OFF WHEELS 3" X 1/16" X 3/8", 54 GRIT (OLD 25-10) - PACK OF 10 | shark | 14.08 | CAT3922XZ |
C$ 14.08
In Stock
| Yes | No | |||
6 | PG103 - CUT-OFF WHEELS 3" X 1/32" X 3/8", 54 GRIT (OLD 26-10) - PACK OF 10 | shark | 14.08 | CAT3922XZ |
C$ 14.08
In Stock
| Yes | No | |||
7 | PG103 - LENOX DIAM CUTOFF WHEEL AG 5" X 7/8" | lenox | 28.67 | CAT3922XZ |
C$ 28.67
In Stock
| Yes | No | |||
8 | PG103 - LENOX DIAM CUTOFF WHEEL AG 4.5" X 7/8" | lenox | 22.19 | CAT3922XZ |
C$ 22.19
In Stock
| Yes | No | |||
9 | PG103 - LENOX DIAM CUTOFF WHEEL DG 3" X 3/8" | lenox | 25.07 | CAT3922XZ |
C$ 25.07
In Stock
| Yes | No |