Search
tel. 02034415298
Shopping Cart
your cart is empty
CycleScheme.co.uk
Logo
Categories
SALE
Bicycles
Batavus
Gazelle Bikes 2012
Classic
City Sport
City lifestyle
Kids -Girls
Kids- Boys
City Specials
Electric bicycles
Leisure
Sport
Koga Miyata
Accessories
Components
Gazelle spare parts and accessories
Price Match Promise
Mini Micro Scooters
SACHS or SRAM Spare Parts
Contact
Contact info@popiel.co.uk
Contact 02034415298
SKYPE : POPIEL.co.uk
Chamonix Excellent T8 (G)
‹ back
HOME  ›  Bicycles  ›  Gazelle Bikes 2012  ›  City Sport  › 

Chamonix Excellent T8 (G)

Gazelle Chamonix Excellent 2012
360
Gazelle Chamonix Excellent 2012
Brand Chamonix Excellent T8 (G)
Delivery week tel. 02034415298 Delivery week Info
Frame Size
Quantity

Compare
Price :
£ 896,58

Advantages
The compact chain case with integrated chain tensioner ensures a smooth ride.
Sporty frame, unique gazelle design, guarantees direct steering behaviour.
Headlight is fully integrated in the mudguard (Bicycle Innovation Award nomination).
Premium gear hub for extra light shifting and smooth cycling.
Rear light is fully integrated into the luggage carrier.

 

 

Gazelle Chamonix Excellent
If you are opting for quality without compromise, the Gazelle Chamonix Excellent is the bicycle for you. Finished with high quality components, such as the 8-speed Premium internal gear hub and the integrated headlight that was nominated for the Dutch Bicycle Innovation Award. It is the top Chamonix model!

 

  
   


 

Category City Sport
Name Gazelle Chamonix Excellent T8
Wheel size 28
Number of gears 8
Frame size men 49, 53, 57, 61, 65
Frame size ladies 49, 53, 57, 61
Frame Material Aluminium
Colour bright alumina / hot chocolate
Brake system front Rollerbrake
Brake system rear Rollerbrake
Groupset Shimano Nexus Premium
Front fork Suspension 50mm
Steam Switch
Seatpost Suspension
Saddle Selle Royal Wave RVL Special
Headlight Gazelle FenderVision
Dynamo Hub Dynamo
Rear light Gazelle Slim Vision
Chain case GoldLine Flowline
Dressguards Yes
Carrier Gazelle Slim Vision
Frame lock Gazelle AXA Defender RL
Chip theft Yes
Weight 19.9kg
Sage Pay
PayPal VISA mastercard
Shop
Brands
About us
Terms and conditions
Contact us
Happy Gazelle Owners
Copyright © 2010 POPIEL
Powered by LEMONPIXEL | Designed by: MDAstudio

connect set charset utf8; SELECT `cms_menu`.* FROM `cms_menu` WHERE (active=1) AND (lang='en') ORDER BY `priority` ASC SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `t`.`id`, `t`.`file`, `t`.`template`, `t`.`parent_id`, `t`.`priority`, `t`.`discount`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`meta_title`, `c`.`meta_description`, `c`.`meta_keywords` FROM `cms_products_categories` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='productscategories' and c.lang='en' WHERE (t.active=1) AND (c.active=1) ORDER BY `t`.`priority` ASC SELECT `t`.`id`, `t`.`file`, `t`.`add_date`, `t`.`recommend`, `t`.`template`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_pages` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='pages' and c.lang='en' WHERE (t.id='21') AND (t.active=1) SELECT `t`.`id`, `t`.`producers_id`, `t`.`price`, `t`.`last_price`, `t`.`price_eur`, `t`.`code`, `t`.`weight`, `t`.`featured`, `t`.`quantity`, `t`.`special1`, `t`.`types_id`, `t`.`file`, `t`.`active`, `t`.`add_date`, `t`.`outside_b2b`, `t`.`outside_avaliable`, `t`.`outside_img`, `c`.`title`, `c`.`description`, `c`.`specification`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_products` AS `t` LEFT JOIN `cms_products_desc` AS `c` ON c.products_id=t.id and c.lang='en' WHERE (c.niceurl='gazelle-chamonix-excellent-t8') AND (t.active=1) SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `f`.`id`, `f`.`add_date`, `f`.`file_name`, `f`.`file_size`, `f`.`file_ext`, `f`.`priority`, `f`.`active`, `c`.`title`, `c`.`description` FROM `cms_files_to_controllers` AS `ftc` INNER JOIN `cms_files` AS `f` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=f.id and c.controller='files' and c.lang='en' WHERE (f.id=ftc.id_files) AND (ftc.controller='products') AND (ftc.controller_item_id='470') AND (f.active=1) ORDER BY `f`.`priority` ASC UPDATE `cms_content` SET `visits` = visits+1 WHERE (controller_item_id = '470') AND (controller = 'products') AND (lang = 'en') SELECT `t`.`id`, `t`.`priority`, `t`.`active`, `t`.`file`, `t`.`add_date`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_producers` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='producers' and c.lang='en' WHERE (t.id='1') AND (t.active=1) SELECT `pc`.*, `c`.`niceurl`, `c`.`title` FROM `cms_products_categories` AS `pc` INNER JOIN `cms_products_to_categories` AS `ptc` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=pc.id and c.controller='productscategories' and c.lang='en' WHERE (ptc.products_id='470') AND (pc.id=ptc.products_categories_id) SELECT `pc`.*, `ptc`.`products_id`, `ptc`.`products_categories_id`, `c`.`id`, `c`.`parent_id`, `c`.`discount` FROM `cms_products_categories` AS `pc` LEFT JOIN `cms_products_to_categories` AS `ptc` ON pc.id=ptc.products_categories_id LEFT JOIN `cms_products_categories` AS `c` ON c.id=ptc.products_categories_id WHERE (ptc.products_id='470') SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='24') SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='40') SELECT `t`.`id`, `t`.`file`, `t`.`template`, `t`.`parent_id`, `t`.`priority`, `t`.`discount`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`meta_title`, `c`.`meta_description`, `c`.`meta_keywords` FROM `cms_products_categories` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='productscategories' and c.lang='en' WHERE (t.active=1) AND (c.active=1) ORDER BY `t`.`priority` ASC SELECT `p`.`id`, `p`.`file`, `p`.`price`, `p`.`genre`, `p`.`last_price`, `p`.`price_eur`, `p`.`outside_b2b`, `p`.`outside_img`, `ptc`.`products_categories_id`, `pc`.`discount`, `c`.`title`, `c`.`niceurl` FROM `cms_products` AS `p` INNER JOIN `cms_products_to_categories` AS `ptc` LEFT JOIN `cms_products_categories` AS `pc` ON ptc.id=ptc.products_categories_id=pc.id LEFT JOIN `cms_products_desc` AS `c` ON c.products_id=p.id and c.lang='en' WHERE (ptc.products_categories_id='109') AND (p.id=ptc.products_id) AND (p.active=1) ORDER BY `ptc`.`priority` asc, `p`.`price` desc, `p`.`add_date` desc SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='109') SELECT `t`.*, `ag`.`required`, `c`.`title` AS `attributesTitle`, `cc`.`title` AS `groupsTitle`, `cc`.`id` AS `groupsId` FROM `cms_products_to_attributes` AS `t` INNER JOIN `cms_attributes` AS `a` INNER JOIN `cms_attributes_groups` AS `ag` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=a.id and c.controller='attributes' and c.lang='en' LEFT JOIN `cms_content` AS `cc` ON cc.controller_item_id=ag.id and cc.controller='attributesgroups' and cc.lang='en' WHERE (a.id=t.attributes_id) AND (a.attributes_groups_id=ag.id) AND (a.active=1) AND (ag.active=1) AND (t.products_id='470') ORDER BY `ag`.`priority` asc, `a`.`priority` asc SELECT `di`.`id`, `di`.`file`, `c`.`title` FROM `cms_dict` AS `d` INNER JOIN `cms_dict_items` AS `di` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=di.id and c.controller='dictitems' and c.lang='en' WHERE (di.dict_id=d.id) AND (di.active=1) AND (d.active=1) AND (d.identifier='products-options') ORDER BY `di`.`priority` asc SELECT `cms_products_to_parameters`.* FROM `cms_products_to_parameters` WHERE (products_id=470)