select configuration_key as cfgKey, configuration_value as cfgValue from configuration
select languages_id, name, code, image, directory,language_charset from languages order by sort_order
SELECT
*
FROM
customers_status
WHERE
customers_status_id = '1' AND language_id = '1'
SELECT
shipping_status_name,
shipping_status_image,shipping_status_id
FROM shipping_status
where language_id = '1'
SELECT *
FROM
currencies
SELECT *
FROM
customers_status
WHERE
customers_status_id = '1' AND language_id = '1'
SELECT tax_class_id as class FROM tax_class
select * FROM products p,
products_description pd
where p.products_status = '1'
and p.products_id = '16663'
and pd.products_id = p.products_id
and pd.language_id = '1'
select p2c.categories_id from products p, products_to_categories p2c where p.products_id = '16663' and p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id != 0 limit 1
select parent_id from categories where categories_id = '259'
select parent_id from categories where categories_id = '23'
select
cd.categories_name
from categories_description cd,
categories c
where cd.categories_id = '23'
and c.categories_id=cd.categories_id
and cd.language_id='1'
select categories_url from categories where categories_id="23"
select
cd.categories_name
from categories_description cd,
categories c
where cd.categories_id = '259'
and c.categories_id=cd.categories_id
and cd.language_id='1'
select categories_url from categories where categories_id="259"
select categories_url, iszap from categories where categories_id="259"
select products_page_url from products where products_id="16663"
SELECT categories_id FROM products_to_categories WHERE products_id='16663'
select parent_id from categories where categories_id = '259'
select parent_id from categories where categories_id = '259'
update products_description set products_viewed = products_viewed+1 where products_id = '16663' and language_id = '1'
SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id = 16663 and products_parameters.products_parameters_id is not null and products_parameters_order >= 0 and products_parameters2products_order >= 0 order by IF(products_parameters2products_order > 0, products_parameters2products_order, products_parameters_order)
SELECT * FROM products_parameters WHERE products_parameters_type = 'g' order by products_parameters_order
SELECT products_price FROM products WHERE products_id='16663'
select specials_new_products_price from specials where products_id = '16663' and status=1
select products_page_url from products where products_id="16663"
SELECT
cd.categories_name,
c.categories_url
FROM categories_description cd,
categories c
WHERE c.categories_id=cd.categories_id and c.categories_id='259'
and cd.language_id = '1'
select distinct m.manufacturers_id as id, m.manufacturers_name as name, md.manufacturers_url as url from products p, products_to_categories p2c, manufacturers m, manufacturers_info md where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id=md.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id='259' and m.manufacturers_id!=22 order by m.manufacturers_name
select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1'), products p where p.products_id = '16663' and p.manufacturers_id = m.manufacturers_id
select image_id, image_nr, image_name from products_images where products_id = '16663' ORDER BY image_nr
select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='16663' and patrib.options_id = popt.products_options_id and popt.language_id = '1'
select count(*) as total from reviews r, reviews_description rd where r.products_id = '16663' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and rd.reviews_text !=''
SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
FROM products_extra_fields pef
LEFT JOIN products_to_products_extra_fields ptf
ON ptf.products_extra_fields_id=pef.products_extra_fields_id
WHERE ptf.products_id=16663 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1')
ORDER BY products_extra_fields_order
SELECT DISTINCT
products_id
FROM products_content
WHERE languages_id='1'
SELECT products_xsell_grp_name_id FROM products_xsell WHERE products_id = '16663' GROUP BY products_xsell_grp_name_id
SELECT products_xsell_grp_name_id FROM products_xsell WHERE products_id = '16663' GROUP BY products_xsell_grp_name_id
SELECT products_xsell_grp_name_id FROM products_xsell WHERE products_xsell_grp_name_id = '0' GROUP BY products_xsell_grp_name_id
Call-центр
пн-вс: 10:00-19:00
Варианты доставки:
|
Способы оплаты:
|
Бренд | Ariston |
Оригинал | Да |
Зажимное кольцо к посудомоечной машине Ariston (Аристон) C00058776
Оригинальные запчасти (Original) от компании Ariston.
L73XDUO, LSV66BKUK (37216330100), LI700DUO, LV661AIX, LV64ARAN, LV46AWH (37268080000), LSV66, LSE750TAUS, LS62AG (37235160100), LL42AG, AFA400 (37281610000), LSI68D (37225570000), L83WDUO (37235320100), LI485A.C/HA, FDW60G, IDL500EU.2, L62XE/B, LV640ARAN, IDL556FR.2, LI42 (37272440000), BFI680 (37307150200), LV645AWH (37420520000), LV670ROW (37303030100), AS100 (37222130000), LL64AG (37299080000), AS150X (37281510000), LVTI12-66 (37295750000), LSV46ABR (37184770100), LV460AIX (37303770000), LVX9-44AN (37303830000), LV460BK, LI661A (37339440200), LSA2080DSTI (37225800000), LV620BK (37299390100), LV62BRUK (37272510000), IDL76EU.2, LD87XIT, LI67DUONL, GSA602WNEW, FDW75A (37345230100), LV670DUOAN (37299470100), LSV68AIX, LV650AWH (37299240100), LS620AIXAG (37249570000), IDL700UK (37300420000), L52IT, LVTI8-611 (37184760000), LD85IT (37284540200), FDW80P (37331871000), SDW80G, LD90IT (37410560100), LSI64, BFV620X, LD87XIT (37284580200), IDL60EU.2, LV620WH (37299400100), LS248TXEU (37281790000), IDL42SK.C, LVR645AOW/HA, LSI64 (37249890000), LVTI12-42, LI485A.C/HA (64603580000), LVI12-621 (37170480000), L63XAUS (37299130000), LL43XAUS.C (64571150000), LF70IT (37373460000), LF69FR (37478730000), LI700DUO (37295150100), LSI67A, LS2040UK (37168840100), LSV615NEU (37170160000), LV640AIX, LV46AOW (37268100000), LL65XEU (37299100000), L64AUS (37299141000), LSV615NEU/1 (37170140300), FDW80G, IDL557SFR.2, LV650IX115-60 (37360770300), LV62BRUK, LF6070XEU, IDL75SEU.2, LZ700DUOIX (37336630000), LVX12-56IX (37337480000), LSV62WH, LD6090EU (37409210200), LV670DUOIX (37299480000), LV64ABK (37264860100), IDL76EU.2 (37367660000), LVX12-56IX (37337480100), LL64EU, LV46ABK (37268070000), BFT68X (37288470000), IDL50EU.2 (37320060100), LS2005TK/1 (37183810100), L63EX115-60.2, AFA370X (37338270000), LVO67DUOIX (37280730000), LS2430 (37222140000), BFI62, IDL62EU.2 (37322230900), LL6066SK (37422280000), LL6065EU (37409170000), LV640AIX (37299460000), IDL52EU.2 (37342830000), IDL55T49EU.2 (37436680000), IDL550SIT.2, LSV67WHFR (37249670000), LL66XFR (37343800100), LI640BNA, LS620AIXAUS, BFT680X, LSV62BK (37249860000), LZ700IXPLUS, LL6066XSK (37422290000), LI480A.C, LI661A (37339440100), LS630EX50-60 (37235060200), LSI45/50UK (37184840000), LV65AALU (37266240000), LSV67AIX, LV650AWH, LI660A (37303040200), LSI62A (37249710000), LS620TK (37234940000), LV46ABK, L73NDUO, LS2070ESTF.1 (37237720000), LS248TXEU (37281790100)
D42SSP, DI620UK (37303511000), DWN21, DV62BR, DI74EL, D61SUK (37235210100), DVG672AIX (37332320000), DI72SIEU (37249450000), D62IT (37234570100), DV61/1 (37170220000), IDE100EU (37306660000), DV62WHUK (37249920100), DG6145WE, DV650AWH (37306970000), DVG622WH, DG6400WF.1, DV670AWH (37307000000), DV61 (37170220000), DV650AIX (37306960000), D61EX115-60 (37235110100), IDE100SK (37307580000), DWN31 (37184580100), IDE45SEU.C, D41IT, DG6345WSK, DG6EU (37234520100), DI650A, DWF50N, DI74SFR (37251380000), DV620WHUK (37303480100), IDE44UK (37303940000), DHA65SP, DI45A/B (37184830200), DWN31BX (37220120000), DVG622KIXUK, DI653A (37432180000), IDF800EU.2
Call-центр
пн-вс: 10:00-19:00
Введите номер заказа |
Введите номер своего заказа, что бы узнать его текущий статус. Что бы получить доступ к расширенным функциям, пройдите не сложную регистрацию. Зарегистрироваться |