SELECT n.*, npr.name as parname, npr.small as parsmall, npr.mid as parmid, npr.org as parorg, npr.full as parfull from ins_names_parent as np left join ins_names as n on np.nameid = n.id left join ins_names_prop as npr on n.propid = npr.id WHERE np.parent = 26587 AND type = 'exgood' order by npr.ordering ASC, n.ordering asc
SELECT exgood.id as exgood_id, exgood.name as exgood_name, exgood.sefname as exgood_sefname, exgood.sefnamefullcat as exgood_sefnamefullcat, exgood.sdesc as exgood_sdesc, exgood.fdesc as exgood_fdesc, exgood.small as exgood_small, exgood.mid as exgood_mid, exgood.org as exgood_org, exgood.innerID as exgood_innerID, exgood.expack_select_type as exgood_expack_select_type, exgood.expack_set as exgood_expack_set, expack.id as expack_id, expack.name as expack_name, expack.sku as expack_sku, exprice.val as exprice_val, exprice.cy as exprice_cy FROM ins_exgood as exgood INNER JOIN ins_exrecommended as exrecommended ON ( exrecommended.parent = 26587 AND exrecommended.recommended=exgood.id ) LEFT JOIN ins_expack as expack ON (expack.parent = exgood.id) LEFT JOIN ins_exprice_good as exprice ON ( exprice.parent = 1 AND expack.id = exprice.expack ) GROUP BY(exgood.id)
SELECT a.id, a.name, a.sefname, a.sefnamefullcat, a.mid, a.innerID, b.id as expack_id, b.name as expack_name, c.val as price, d.val as sklad FROM ins_exgood as a inner join ins_expack b ON (b.parent = a.id) inner join ins_exprice_good c ON (c.parent = 1 AND b.id = c.expack) inner join ins_exsklad_good d ON (d.parent = 1 AND b.id = d.expack) WHERE a.parent = 11933 AND a.publish = 1 ORDER BY rand() LIMIT 0, 6
Розничный магазин: Спандаряна 16а | НЕТ |
Оптовый склад: 26 Бакинских Комиссаров 1 ст60/11 | ![]() |
Если выбранного товара нет в розничном магазине, но он есть на оптовом, то закажите товар через сайт.