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=141 and pa.subcategory_id=5026 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 | |
---|---|---|---|---|---|---|---|---|---|---|
0W20; Synth Oil 5Qt. | eneos | 42 | CAT5026XZ |
C$ 42.00
Per Piece | Yes | No | ||||
1 | 5W20; Synth Oil 5Qt. | eneos | 44.4 | CAT5026XZ |
C$ 44.40
Per Piece | Yes | No | |||
2 | 5W30; Synth Oil 5Qt | eneos | 37.2 | CAT5026XZ |
C$ 37.20
Per Piece | Yes | No | |||
3 | 0W20; Synth Oil 5Qt. | eneos | 44.4 | CAT5026XZ |
C$ 44.40
Per Piece | Yes | No | |||
4 | 5W30; Synth Oil 5 Qt. | eneos | 44.4 | CAT5026XZ |
C$ 44.40
Per Piece | Yes | No | |||
5 | 5W20; Synth Oil 5Qt. | idemitsu | 38.4 | CAT5026XZ |
C$ 38.40
Per Piece | Yes | No | |||
6 | 0W20; Synth Oil 5Qt | 38.4 | CAT5026XZ |
C$ 38.40
Per Piece | Yes | No | ||||
7 | 5W30; Synth Oil 5Qt. | idemitsu | 38.4 | CAT5026XZ |
C$ 38.40
Per Piece | Yes | No | |||
8 | QUARTZ INEO DYNAMICS 0W30 5L | total | 51.48 | CAT5026XZ |
C$ 51.48
In Stock
| Yes | No | Full Synthetic | 5L | 0W30 |
9 | QUARTZ INEO LONG LIFE 5W30 5L | total | 49.53 | CAT5026XZ |
C$ 49.53
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
10 | RUBIA WORKS 4000 15W40 5L | total | 30.62 | CAT5026XZ |
C$ 30.62
In Stock
| Yes | No | 5L | 15W40 | |
11 | RUBIA WORKS 4000 FE 10W30 5L | total | 33.54 | CAT5026XZ |
C$ 33.54
In Stock
| Yes | No | 5L | 10W30 | |
12 | QUARTZ 9000 ENERGY 0W30 5L | total | 62.27 | CAT5026XZ |
C$ 62.27
In Stock
| Yes | No | Full Synthetic | 5L | 0W30 |
13 | QUARTZ RACING 10W50 5L | total | 60.39 | CAT5026XZ |
C$ 60.39
In Stock
| Yes | No | Full Synthetic | 5L | 10W50 |
14 | QUARTZ 9000 NFC 5W30 5L | total | 49.34 | CAT5026XZ |
C$ 49.34
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
15 | QUARTZ 9000 ENERGY 0W40 5L | total | 57.33 | CAT5026XZ |
C$ 57.33
In Stock
| Yes | No | Full Synthetic | 5L | 0W40 |
16 | QUARTZ INEO LONG LIFE 0W30 5L | total | 68.84 | CAT5026XZ |
C$ 68.84
In Stock
| Yes | No | Full Synthetic | 5L | 0W30 |
17 | QUARTZ 9000 FUTURE XT 0W16 5L | total | 45.63 | CAT5026XZ |
C$ 45.63
In Stock
| Yes | No | Full Synthetic | 5L | 0W16 |
18 | QUARTZ INEO XTRA V-DRIVE 0W20 5L | total | 49.99 | CAT5026XZ |
C$ 49.99
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
19 | QUARTZ 7000 FUTURE 5W30 5L | total | 35.04 | CAT5026XZ |
C$ 35.04
In Stock
| Yes | No | Semi-Synthetic | 5L | 5W30 |
20 | QUARTZ 7000 FUTURE 0W20 5L | total | 35.04 | CAT5026XZ |
C$ 35.04
In Stock
| Yes | No | Semi-Synthetic | 5L | 0W20 |
21 | QUARTZ 9000 FUTURE XT 5W20 5L | total | 41.15 | CAT5026XZ |
C$ 41.15
In Stock
| Yes | No | Full Synthetic | 5L | 5W20 |
22 | QUARTZ INEO MC3 5W30 5L | total | 52.39 | CAT5026XZ |
C$ 52.39
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
23 | QUARTZ 9000 ENERGY 5W40 | total | 47.45 | CAT5026XZ |
C$ 47.45
In Stock
| Yes | No | Full Synthetic | 5L | 5W40 |
24 | RUBIA OPTIMA 1500 0W40 5L | total | 53.76 | CAT5026XZ |
C$ 53.76
In Stock
| Yes | No | Full Synthetic | 5L | 0W40 |
25 | RUBIA OPTIMA 2100 XFE 10W30 5L | total | 35.3 | CAT5026XZ |
C$ 35.30
In Stock
| Yes | No | Synthetic Blend | 5L | 10W30 |
26 | RUBIA OPTIMA 1100 15W40 5L | total | 30.36 | CAT5026XZ |
C$ 30.36
In Stock
| Yes | No | Conventional | 5L | 15W40 |
27 | DYNATRANS ACX 0W20 5L | total | 53.89 | CAT5026XZ |
C$ 53.89
In Stock
| Yes | No | Conventional | 5L | 0W20 |
28 | RUBIA OPTIMA 1500 FE 5W30 5L | total | 50.05 | CAT5026XZ |
C$ 50.05
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
29 | RUBIA OPTIMA 1500 5W40 | total | 47.78 | CAT5026XZ |
C$ 47.78
In Stock
| Yes | No | Full Synthetic | 5L | 5W40 |
30 | QUARTZ 5000 FUTURE XT 10W30 5L | total | 30.36 | CAT5026XZ |
C$ 30.36
In Stock
| Yes | No | Conventional | 5L | 10W30 |
31 | QUARTZ 5000 FUTURE XT 5W30 5L | total | 28.67 | CAT5026XZ |
C$ 28.67
In Stock
| Yes | No | Conventional | 5L | 5W30 |
32 | QUARTZ 5000 FUTURE XT 5W20 5L | total | 28.67 | CAT5026XZ |
C$ 28.67
In Stock
| Yes | No | Conventional | 5L | 5W20 |
33 | QUARTZ INEO LONG LIFE 5W30 | total | 56.49 | CAT5026XZ |
C$ 56.49
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
34 | QUARTZ 9000 FUTURE FGC 5W30 5L | total | 40.37 | CAT5026XZ |
C$ 40.37
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
35 | QUARTZ 9000 XTRA FUTURE FGC 0W20 5L | total | 40.37 | CAT5026XZ |
C$ 40.37
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
36 | RUBIA WORKS 4000 15W-40 | total | 32.44 | CAT5026XZ |
C$ 32.44
In Stock
| Yes | No | 5L | 15W40 | |
37 | RUBIA WORKS 4000 FE 10W30 5L | total | 29.77 | CAT5026XZ |
C$ 29.77
In Stock
| Yes | No | 5L | 10W30 | |
38 | RUBIA OPTIMA 1300 15W40 5L | total | 32.24 | CAT5026XZ |
C$ 32.24
In Stock
| Yes | No | Synthetic Blend | 5L | 15W40 |
39 | RUBIA OPTIMA 1300 FE 10W30 5L | total | 32.24 | CAT5026XZ |
C$ 32.24
In Stock
| Yes | No | Synthetic Blend | 5L | 10W30 |
40 | QUARTZ 9000 FUTURE XT 0W16 5L | total | 48.3 | CAT5026XZ |
C$ 48.30
In Stock
| Yes | No | Full Synthetic | 5L | 0W16 |
41 | QUARTZ INEO FGO 5W40 5L | total | 64.74 | CAT5026XZ |
C$ 64.74
In Stock
| Yes | No | Full Synthetic | 5L | 5W40 |
42 | RUBIA GAS 9M 15W40 5L | total | 36.34 | CAT5026XZ |
C$ 36.34
In Stock
| Yes | No | 5L | 15W40 | |
43 | RUBIA GAS 9M FE 10W30 | total | 36.34 | CAT5026XZ |
C$ 36.34
In Stock
| Yes | No | 5L | 10W30 | |
44 | TRACTAGRI HDZ 15W40 5L | total | 31.07 | CAT5026XZ |
C$ 31.07
In Stock
| Yes | No | 5L | 15W40 | |
45 | QUARTZ INEO XTRA DYNAMICS 0W20 5L | total | 62.47 | CAT5026XZ |
C$ 62.47
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
46 | QUARTZ INEO XTRA LONG LIFE 0W20 5L | total | 71.44 | CAT5026XZ |
C$ 71.44
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
47 | QUARTZ INEO XTRA V-DRIVE 0W20 5L | total | 49.99 | CAT5026XZ |
C$ 49.99
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
48 | QUARTZ 9000FUTURE FGC 5W30 5L | total | 41.15 | CAT5026XZ |
C$ 41.15
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
49 | QUARTZ 9000 FUTURE FGC 0W20 5L | total | 41.15 | CAT5026XZ |
C$ 41.15
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
50 | QUARTZ INEO MC3 5W30 5L | total | 53.43 | CAT5026XZ |
C$ 53.43
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
51 | HIGH MILEAGE 5W30 5L | quaker-state | 37.52 | CAT5026XZ |
C$ 37.52
In Stock
| Yes | No | Synthetic Blend | 5L | 5W30 |
52 | HIGH MILEAGE 5W20 5L | quaker-state | 37.65 | CAT5026XZ |
C$ 37.65
In Stock
| Yes | No | Synthetic Blend | 5L | 5W20 |
53 | ADVANCED DURABILITY 5W30 5L | quaker-state | 30.93 | CAT5026XZ |
C$ 30.93
In Stock
| Yes | No | Conventional | 5L | 5W30 |
54 | ADVANCED DURABILITY 5W20 5L | quaker-state | 30.6 | CAT5026XZ |
C$ 30.60
In Stock
| Yes | No | Conventional | 5L | 5W20 |
55 | ADVANCED DURABILITY 10W30 5L | quaker-state | 30.6 | CAT5026XZ |
C$ 30.60
In Stock
| Yes | No | Conventional | 5L | 10W30 |
56 | ULTIMATE DURABILITY 0W20 5L | quaker-state | 47.13 | CAT5026XZ |
C$ 47.13
In Stock
| Yes | No | Full Synthetic | 5L | 0W20 |
57 | ULTIMATE DURABILITY 5W20 5L | quaker-state | 47.13 | CAT5026XZ |
C$ 47.13
In Stock
| Yes | No | Full Synthetic | 5L | 5W20 |
58 | ULTIMATE DURABILITY 5W30 5L | quaker-state | 47.13 | CAT5026XZ |
C$ 47.13
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
59 | ULTIMATE DURABILITY 10W30 5L | quaker-state | 47.13 | CAT5026XZ |
C$ 47.13
In Stock
| Yes | No | Full Synthetic | 5L | 10W30 |
60 | ULTIMATE DURABILITY EURO 5W40 5L | quaker-state | 47.78 | CAT5026XZ |
Quaker State
ULTIMATE DURABILITY EURO 5W40 5LPart# 550052728Full Synthetic, Volume: 5L, Grade: 5W40C$ 47.78
In Stock
| Yes | No | Full Synthetic | 5L | 5W40 |
61 | ULTIMATE DURABILITY EURO LX 0W30 5L | quaker-state | 47.78 | CAT5026XZ |
Quaker State
ULTIMATE DURABILITY EURO LX 0W30 5LPart# 550052734Full Synthetic, Volume: 5L, Grade: 0W30C$ 47.78
In Stock
| Yes | No | Full Synthetic | 5L | 0W30 |
62 | ULTIMATE DURABILITY EURO L 5W30 5L | quaker-state | 47.78 | CAT5026XZ |
Quaker State
ULTIMATE DURABILITY EURO L 5W30 5LPart# 550052738Full Synthetic, Volume: 5L, Grade: 5W30C$ 47.78
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
63 | ULTRA PLATINUM 5W20 5L | pennzoil | 65.74 | CAT5026XZ |
C$ 65.74
In Stock
| Yes | No | Full Synthetic | 5L | 5W20 |
64 | ULTRA PLATINUM 0W20 5L | pennzoil | 65.74 | CAT5026XZ |
C$ 65.74
In Stock
| Yes | No | Full Synthetic | 5L | 5W20 |
65 | CONVENTIONAL 5W30 5L | pennzoil | 38.17 | CAT5026XZ |
C$ 38.17
In Stock
| Yes | No | Conventional | 5L | 5W30 |
66 | CONVENTIONAL 5W20 5L | pennzoil | 38.17 | CAT5026XZ |
C$ 38.17
In Stock
| Yes | No | Conventional | 5L | 5W20 |
67 | ULTRA PLATINUM 5W30 5L | pennzoil | 65.74 | CAT5026XZ |
C$ 65.74
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
68 | HIGH MILEAGE CONVENTIONAL 5W20 5L | pennzoil | 41.17 | CAT5026XZ |
C$ 41.17
In Stock
| Yes | No | Conventional | 5L | 5W20 |
69 | HIGH MILEAGE CONVENTIONAL 10W30 5L | pennzoil | 41.17 | CAT5026XZ |
C$ 41.17
In Stock
| Yes | No | Conventional | 5L | 10W30 |
70 | CONVENTIONAL 10W30 5L | pennzoil | 38.17 | CAT5026XZ |
C$ 38.17
In Stock
| Yes | No | Conventional | 5L | 10W30 |
71 | HIGH MILEAGE CONVENTIONAL 5W30 5L | pennzoil | 41.17 | CAT5026XZ |
C$ 41.17
In Stock
| Yes | No | Conventional | 5L | 5W30 |
72 | PLATINUM 5W20 5L | pennzoil | 45.6 | CAT5026XZ |
C$ 45.60
In Stock
| Yes | No | Full Synthetic | 5L | 5W20 |
73 | PLATINUM 10W30 5L | pennzoil | 58.21 | CAT5026XZ |
C$ 58.21
In Stock
| Yes | No | Full Synthetic | 5L | 10W30 |
74 | PLATINUM 5W30 5L | pennzoil | 45.6 | CAT5026XZ |
C$ 45.60
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
75 | PLATINUM 0W20 5L | pennzoil | 45.6 | CAT5026XZ |
C$ 45.60
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
76 | PLATINUM 0W16 5L | pennzoil | 58.21 | CAT5026XZ |
C$ 58.21
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |
77 | PLATINUM EURO LX 0W30 5L | pennzoil | 63.09 | CAT5026XZ |
C$ 63.09
In Stock
| Yes | No | Full Synthetic | 5L | 0W30 |
78 | ROTELLA T5 10W30 5L | shell | 42.16 | CAT5026XZ |
C$ 42.16
In Stock
| Yes | No | Semi-Synthetic | 5L | 10W30 |
79 | ROTELLA T4 TRIPLE PROTECTION 15W40 5L | shell | 34.8 | CAT5026XZ |
C$ 34.80
In Stock
| Yes | No | Conventional | 5L | 15W40 |
80 | ROTELLA T4 TRIPLE PROTECTION 10W30 5L | shell | 34.48 | CAT5026XZ |
C$ 34.48
In Stock
| Yes | No | Conventional | 5L | 10W30 |
81 | ROTELLA T5 15W40 5L | shell | 42.16 | CAT5026XZ |
C$ 42.16
In Stock
| Yes | No | Semi-Synthetic | 5L | 15W40 |
82 | ROTELLA T6 5W40 5L | shell | 51.96 | CAT5026XZ |
C$ 51.96
In Stock
| Yes | No | Full Synthetic | 5L | 5W40 |
83 | ROTELLA T5 ULTRA 10W30 5L | shell | 45.27 | CAT5026XZ |
C$ 45.27
In Stock
| Yes | No | Semi-Synthetic | 5L | 10W30 |
84 | ROTELLA T6 MULTI VEHICLE 5W30 5L | shell | 46.75 | CAT5026XZ |
C$ 46.75
In Stock
| Yes | No | Full Synthetic | 5L | 5W30 |