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

Luzern Excellent T8 (L)

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

Compare
Price :
£ 768,38

Advantages
Modern, sporty bicycle with a unique look, lightweight and low-maintenance.
50 mm tyres ensure optimum vibration absorption and a very low rolling resistance.
The Lucerne Excellent has been nominated Bicycle of the Year 2011!
Premium gear hub for extra light shifting and smooth cycling.


Gazelle Luzern Excellent 2011


The Gazelle Luzern Excellent is an unique, sporty Gazelle frame guarantees direct steering performance.
The maintenance-free Gazelle Luzern Excellent offers everything that you might expect from a sporty city bicycle. 50 millimetre tyres with extremely low rolling resistance, an 8-speed Premium internal gear hub for extra light gear changing... For good reasons nominated for the 2011 Dutch Bicycle of the Year Award!
 

Category City Sport
Name Gazelle Luzern 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 Sienna/black, matt
Brake system front Roller brake
Brake system rear Roller brake
Groupset Shimano Nexus Premium
Front fork Solid
Steam Switch
Saddle Selle Royal Nuvola RVL
Headlight Gazelle LightVision Compact LED
Dynamo Hub Dynamo
Rear light Axa Riff LED
Chain case Hesling Agudo
Dressguards No
Carrier Racktime Tourit
Frame lock Gazelle Axa Defender RL
Weight 19 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-luzern-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='461') AND (f.active=1) ORDER BY `f`.`priority` ASC UPDATE `cms_content` SET `visits` = visits+1 WHERE (controller_item_id = '461') 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='461') 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='461') 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='461') 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=461)