SELECT n.*, npr.name as parname, npr.small as parsmall, npr.mid as parmid, npr.org as parorg, npr.full as parfull from ss_names_parent as np
                                                     left join ss_names as n on np.nameid = n.id
                                                     left join ss_names_prop as npr on n.propid = npr.id
                                                     WHERE np.parent = 101393 AND type = 'exgood'
                                                     order by npr.ordering ASC, n.ordering asc

• Главная
• Каталог
• Шины

Каталог шин

Шины Nokian Tyres Hakka Black SUV 295/30 R22 103Y

• 

31 600 руб.

- +

В корзину

под заказ 7-10 дней

• Артикул:
  209863
• Наличие на складе:
  под заказ 7-10 дней
• Производитель:
  Nokian Tyres
• Ширина профиля:
  295
• Высота профиля:
  30
• Индекс скорости:
  Y
• Индекс нагрузки кг:
  103
• Модель:
  Hakka Black SUV
• Посадочный диаметр:
  22

SELECT a.*, b.id as expack_id, c.val as price FROM ss_exgood a
			INNER JOIN ss_expack b ON (b.parent = a.id)
			INNER JOIN ss_exprice_good c ON (c.parent = 1 AND b.id = c.expack)
			WHERE `publish` = 1 AND `spec` = 1 ORDER BY RAND()

/var/www/html/idb.php:496
/var/www/html/i24.php:135
/var/www/html/lib/HTML.php:551
/var/www/html/component/ex/ex_html.php:664
/var/www/html/component/ex/ex_html.php:15
/var/www/html/component/ex/ex.php:332
/var/www/html/component/ex/ex.php:70
/var/www/html/component/ex/ex.php:36
/var/www/html/icore.php:202
/var/www/html/theme/index/index.php:25
/var/www/html/index.php:270