SELECT
bp.id,
bp.image,
bp.modified,
bp.poster_name as author_name,
bp.posted_date,
bpd.blog_post_id,
bpd.title,
bpd.description,
bpd.short_description,
bc.blog_category_id
FROM
blog_posts bp
LEFT JOIN blog_posts_description bpd ON (bp.id = bpd.blog_post_id)
LEFT JOIN blog_posts_to_blog_categories as bc ON(bc.blog_post_id = bp.id)
LEFT JOIN blog_posts_to_store bp2s ON (bp.id = bp2s.blog_post_id)
WHERE
bpd.language_id = '1'
AND bp2s.store_id = '0'
AND bp.published = '1'
AND bc.blog_category_id='5' ORDER BY bp.modified DESC LIMIT 0,5
SELECT
bp.id,
bp.image,
bp.modified,
bp.poster_name as author_name,
bp.posted_date,
bpd.blog_post_id,
bpd.title,
bpd.description,
bpd.short_description,
bc.blog_category_id
FROM
blog_posts bp
LEFT JOIN blog_posts_description bpd ON (bp.id = bpd.blog_post_id)
LEFT JOIN blog_posts_to_blog_categories as bc ON(bc.blog_post_id = bp.id)
LEFT JOIN blog_posts_to_store bp2s ON (bp.id = bp2s.blog_post_id)
WHERE
bpd.language_id = '1'
AND bp2s.store_id = '0'
AND bp.published = '1'
AND bc.blog_category_id='5' ORDER BY bp.modified DESC LIMIT 0,5
SELECT
bp.id,
bp.image,
bp.modified,
bp.poster_name as author_name,
bp.posted_date,
bpd.blog_post_id,
bpd.title,
bpd.description,
bpd.short_description,
bc.blog_category_id
FROM
blog_posts bp
LEFT JOIN blog_posts_description bpd ON (bp.id = bpd.blog_post_id)
LEFT JOIN blog_posts_to_blog_categories as bc ON(bc.blog_post_id = bp.id)
LEFT JOIN blog_posts_to_store bp2s ON (bp.id = bp2s.blog_post_id)
WHERE
bpd.language_id = '1'
AND bp2s.store_id = '0'
AND bp.published = '1'
AND bc.blog_category_id='5' ORDER BY bp.modified DESC LIMIT 0,5
SELECT
bp.id,
bp.image,
bp.modified,
bp.poster_name as author_name,
bp.posted_date,
bpd.blog_post_id,
bpd.title,
bpd.description,
bpd.short_description,
bc.blog_category_id
FROM
blog_posts bp
LEFT JOIN blog_posts_description bpd ON (bp.id = bpd.blog_post_id)
LEFT JOIN blog_posts_to_blog_categories as bc ON(bc.blog_post_id = bp.id)
LEFT JOIN blog_posts_to_store bp2s ON (bp.id = bp2s.blog_post_id)
WHERE
bpd.language_id = '1'
AND bp2s.store_id = '0'
AND bp.published = '1'
AND bc.blog_category_id='5' ORDER BY rand() ASC LIMIT 0,5
CNC Billet enduro levers
Features:
Machined from high quality T6061 Billet alumin..
Show:
PER PAGE
Showing 1 to 4 of 4 (1 Pages)
Sort By:
Looking for new clutch levers for your bike? Need to make sure your brakes are legal and roadworthy? Motorrad Garage has a range of authentic, easy to install sets at great prices. These sets include both brake and clutch levers, so you can make sure the components match. The other key benefit is the adjustability; you can adjust your levers to fit you perfectly, adding to your control on the road.
We carry complete sets of four to fit BMW, Ducati, Honda, Kawasaki, Suzuki, Triumph, and Yamaha bikes. Each individual kit is compatible with a specific range of models; check the product specifications for further details.