Հետադարձ զանգ
մասնագիտական խորհրդատվություն
16 Gai Ave, Yerevan, Armenia
առանց հանգստյան օրերի երկ-կիր 11: 00-21: 00

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT BrandID, catalog_brands.Parent, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_fast_models INNER JOIN catalog_brands ON catalog_brands.ID = catalog_fast_models.BrandID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('78', catalog_brands.Domains)) AND catalog_brands.Hide = ? GROUP BY BrandID ORDER BY BrandID DESC
Params:
Array
(
    [0] => 
    [1] => 875
    [2] => 
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 190
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_mods_params.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_mods_params INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_mods_params.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_mods_params.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 954
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 181
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 184
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 226
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 227
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 231
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 236
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 237
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 240
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 967
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 1034
    [1] => 
    [2] => 875
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.TopCatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND (TopBrandID IN (9270)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (3)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 1069
    [1] => 
    [2] => 875
)

Ապրանքի ֆիլտր
  • Գինը
  • Խումբ
  • Բրենդ
  • Գույն
  • Չափ
  • Նյութեր
  • Հարկ
  • Սեզոն
  • Սերտիֆիկացման ստանդարտներ
  • Ջրի վանող հատկությունները
  • Կոշիկի տեսք
  • Ձեռնոցներ երկարությունը
  • Պաշտպանության տեսակը
  • Նկարագրություն
  • Մոդելի անվանումը
  • միավորել մեկ քարտի վրա

Кожаные մոտոցիկլ սարքավորումներ 100%

Զեղչ պերվոսեզոննիկներին
Если твоим правам категории А меньше 1 года, приезжай в Партнер-Мото и получи дополнительную скидку 5% на мотоэкипировку.
Պատրաստված է հաստ մաշկի դիմացկուն շփման. Նրանք կարող են բացել սեզոնը ավելի վաղ եւ փակել ավելի ուշ, քանի որ բարձր windproof. Փորձառու motorcyclers սկզբին եւ վերջում սեզոնի օգտագործել կաշվե motoekipirovanie, իսկ շոգին տեքստիլ.
առանց հանգստյան օրերի երկ-կիր 11: 00-21: 00