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
Orange Excellent T8 (L)
‹ back
HOME  ›  Bicycles  ›  Gazelle Bikes 2012  ›  City Sport  › 

Orange Excellent T8 (L)

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

Compare
Price :
£ 853,85

Advantages
Headlight is fully integrated in the luggage carrier.
Low, spacious entry on the ladies' model
Premium gear hub for extra light shifting and smooth cycling.
Headlamp is fully integrated in the front fork and mudguard (nominated for Bike Innovation Award)


Gazelle Orange Excellent

The Gazelle Excellent is the most luxurious option in the Orange line. The Premium internal gear hub with 8 speeds changes absolutely smoothly. The headlight and rearlight are beautifully concealed. The ladies’ model is equipped with an extra low entry. Cycling in truly royal style
 

Category City Sport
Name Gazelle Orange Excellent T8
Wheel size 28
Number of gears 8
Frame size men 53, 57, 61, 65
Frame size ladies 49, 53, 57, 61
Frame Material Aluminium
Colour shadow blue / shadow silver
Brake system front Roller brake
Brake system rear Roller brake
Groupset Shimano Nexus Premium
Front fork Suspension 50mm with adjustable tension
Steam Gazelle Switch
Seatpost Suspension
Saddle Selle Royal Herz RVL
Headlight Gazelle FenderVision
Dynamo Hub Dynamo
Rear light Gazelle Slim Vision
Chain case Gazelle Mildly Geometric
Dressguards Yes
Carrier Gazelle Slim Vision
Frame lock Gazelle AXA Defender RL
Chip theft Yes
Weight 20.1 kg
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-orange-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='467') AND (f.active=1) ORDER BY `f`.`priority` ASC UPDATE `cms_content` SET `visits` = visits+1 WHERE (controller_item_id = '467') 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='467') 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='467') 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='467') 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=467)