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 = '16528'
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 = '16528' 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 = '258'
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 = '258'
and c.categories_id=cd.categories_id
and cd.language_id='1'
select categories_url from categories where categories_id="258"
select categories_url, iszap from categories where categories_id="258"
select products_page_url from products where products_id="16528"
SELECT categories_id FROM products_to_categories WHERE products_id='16528'
select parent_id from categories where categories_id = '258'
select parent_id from categories where categories_id = '258'
update products_description set products_viewed = products_viewed+1 where products_id = '16528' and language_id = '1'
SELECT * FROM products_parameters2products LEFT JOIN products_parameters using(products_parameters_id) WHERE products_id = 16528 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='16528'
select specials_new_products_price from specials where products_id = '16528' and status=1
select products_page_url from products where products_id="16528"
SELECT
cd.categories_name,
c.categories_url
FROM categories_description cd,
categories c
WHERE c.categories_id=cd.categories_id and c.categories_id='258'
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='258' and m.manufacturers_id!=74 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 = '16528' and p.manufacturers_id = m.manufacturers_id
select image_id, image_nr, image_name from products_images where products_id = '16528' ORDER BY image_nr
select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='16528' 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 = '16528' 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=16528 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 = '16528' GROUP BY products_xsell_grp_name_id
SELECT products_xsell_grp_name_id FROM products_xsell WHERE products_id = '16528' 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
Варианты доставки:
|
Способы оплаты:
|
Бренд | Zanussi |
Цвет | серый |
Комплект колес (роликов) к посудомоечной машине Zanussi 50286967000 (не оригинал)
F34030IM0 (911529039 02), F35400IMO, F40742 (911515012 01), F54750 (911615221 01), F35020IM (911529065 02), F34030IM0, F54760 (911615253 04), F50777S, F34032VI0 (911539062 01), F54000IM0, F35410IM (911629233 05), FFIESTAAA, F35400IM0 (911669001 01)
ESF6526 (911949205 02), ESL43020 (911639233 06), ESL45015 (911635230 01), ESF64014, ESF4200LOW (911089004 03), ESI4121X (911625228 01), ESI4112X, ESL6142, ESL7310RO (911436308 01), ESF63021X (911519078 05), ESI44032B (911625284 02), ESI6550ROW (911426031 03), ESF63029, ESF63020 (911519017 00), ESL43010 (911639215 00), ESL4120, ESF63021 (911519018 03), ESL7310RO (911436308 10), ESI44032X, ESF63020 (911519019 05), ESI63010X (911529060 02), ESF4110 (911645208 00), ESI6112X, ESL4200LA (911679017 03), ESL6375RO (911436039 01), ESI63010W (911529057 04), ESF4200LOW, ESL94200LO (911079012 00), ESF63029 (911549017 00), ESF63030 (911549013 04), ESI6110W, ESF6145, ESL64602R (911439004 01), ESL4142 (911635210 01), ESF64011 (911515008 00), ESL7311RA (911436321 03), ELU ESL4200LA D, ESI6550ROX (911426033 04), ESF63021 (911519018 00)
LDW60 (911529071 03)
VW812 (911519066 00), VW1013 (911513047 01), VW912, VW1013, VW812, VW912 (911519093 03), VW912 (911519093 00), VW912 (911519093 04)
336305_11117 (911925323 00), 00809481_11128 (911926278 01), 00524238_11352, 872840_11123 (911916316 01), 883379_11126 (911926276 00), 00526450_11370 (911926334 00), 214036_11016 (911615228 01), 673708_10925 (911615207 01), 568450_11040 (911629225 01), 684929_11066 (911925290 01), 142484_10856, 126911_11140, 583295_11076 (911925315 01), 316066_10990, 00493752_11198 (911619259 00), 00524337_11353, 276664_11131 (911626263 00), 860988_10826, 198989_11014 (911619231 00), 00526694_11371, 886047_10898 (911915218 00), 775810_11154, 832248_11095, 030535_10554 (911625029 00), 00526694_11371 (911926335 00), 00107226_11190, 473413_11063 (911915276 00), 706627_11152 (911615250 00), 205402_11138
TT40E, TT590 (911939242 01), TT590 (911939242 02), TT590, TT40E (911939234 00), TT590 (911939242 03)
GE66005S, KDT10022FK (911435022 01), GE66003 (911519116 00), ZKS5653S (911929251 00), GS44005S (911619251 00), ZKI1410X (911529063 06), GE64016S (911915257 00), ZKS5642X (911929248 00)
ZDF301, ZDI112W (911529049 01), ZDF2030 (911519097 01), ZDT311 (911535011 05), ZDS2010 (911619267 10), ZDS3010 (911615258 07), ZDF3011, ZDS101 (911619236 00), ZDI110X (911529009 04), ZDF3010X (911543022 01), ZDF303 (911515005 02), ZDIS102X (911629238 13), ZSF6128 (911919219 04), ZDF257, ZDS12001WA (911059010 02), ZDF2015 (911549036 00), ZDF305 (911515022 01), ZDI101X (911529034 05), ZDF257X, ZDTS102 (911639224 08), ZDT200 (911539009 01), ZDI200X (911925253 01), ZDI101X (911529034 01), ZDI6556W (911925216 01), ZDF230 (911919241 00), ZDV12001FA (911679005 00), ZDF219, ZDU112X (911959201 02), ZDI6556X (911925218 01), ZDT6454 (911935207 00), ZDF324X (911515035 00), ZDT40 (911539010 02), ZDV91200FA, DE6540 (911945204 00), DE2554, ZDF2015X (911519092 01), ZDN11002XA (911069002 00), ZDI6053X (911929218 02), ZDS91500SA (911053005 02), ZDS050 (911619224 00), ZDF212 (911519074 00), ZDI110X (911929208 00), ZDTS102 (911639224 06)
Call-центр
пн-вс: 10:00-19:00
Введите номер заказа |
Введите номер своего заказа, что бы узнать его текущий статус. Что бы получить доступ к расширенным функциям, пройдите не сложную регистрацию. Зарегистрироваться |