0

Jūsų krepšelis yra tuščias

Filtras

No valid database connection Table 'web365db1.fs_vm_product_type_' doesn't exist SQL=SELECT `filter_master_t`.`product_id`,COUNT(DISTINCT child.product_id) AS children_count,filter_master_t.`laikmatis`,GROUP_CONCAT(DISTINCT filter_child_t.`laikmatis`) AS `c_laikmatis`,filter_master_t.`laikmatis` AS value_laikmatis,GROUP_CONCAT(DISTINCT filter_child_t.`laikmatis`) AS `value_c_laikmatis`,filter_master_t.`automatins_programos_receptai`,GROUP_CONCAT(DISTINCT filter_child_t.`automatins_programos_receptai`) AS `c_automatins_programos_receptai`,filter_master_t.`automatins_programos_receptai` AS value_automatins_programos_receptai,GROUP_CONCAT(DISTINCT filter_child_t.`automatins_programos_receptai`) AS `value_c_automatins_programos_receptai`,filter_master_t.`tipas`,GROUP_CONCAT(DISTINCT filter_child_t.`tipas`) AS `c_tipas`,filter_master_t.`tipas` AS value_tipas,GROUP_CONCAT(DISTINCT filter_child_t.`tipas`) AS `value_c_tipas`,filter_master_t.`spalva`,GROUP_CONCAT(DISTINCT filter_child_t.`spalva`) AS `c_spalva`,filter_master_t.`spalva` AS value_spalva,GROUP_CONCAT(DISTINCT filter_child_t.`spalva`) AS `value_c_spalva`,filter_master_t.`teleskopiniai_bgeliai`,GROUP_CONCAT(DISTINCT filter_child_t.`teleskopiniai_bgeliai`) AS `c_teleskopiniai_bgeliai`,filter_master_t.`teleskopiniai_bgeliai` AS value_teleskopiniai_bgeliai,GROUP_CONCAT(DISTINCT filter_child_t.`teleskopiniai_bgeliai`) AS `value_c_teleskopiniai_bgeliai`,filter_master_t.`velnus_udarymas`,GROUP_CONCAT(DISTINCT filter_child_t.`velnus_udarymas`) AS `c_velnus_udarymas`,filter_master_t.`velnus_udarymas` AS value_velnus_udarymas,GROUP_CONCAT(DISTINCT filter_child_t.`velnus_udarymas`) AS `value_c_velnus_udarymas`,filter_master_t.`katalitins_sienels`,GROUP_CONCAT(DISTINCT filter_child_t.`katalitins_sienels`) AS `c_katalitins_sienels`,filter_master_t.`katalitins_sienels` AS value_katalitins_sienels,GROUP_CONCAT(DISTINCT filter_child_t.`katalitins_sienels`) AS `value_c_katalitins_sienels`,filter_master_t.`msos_termometras`,GROUP_CONCAT(DISTINCT filter_child_t.`msos_termometras`) AS `c_msos_termometras`,filter_master_t.`msos_termometras` AS value_msos_termometras,GROUP_CONCAT(DISTINCT filter_child_t.`msos_termometras`) AS `value_c_msos_termometras`,filter_master_t.`piroliz`,GROUP_CONCAT(DISTINCT filter_child_t.`piroliz`) AS `c_piroliz`,filter_master_t.`piroliz` AS value_piroliz,GROUP_CONCAT(DISTINCT filter_child_t.`piroliz`) AS `value_c_piroliz`,filter_master_t.`gar_funkcija`,GROUP_CONCAT(DISTINCT filter_child_t.`gar_funkcija`) AS `c_gar_funkcija`,filter_master_t.`gar_funkcija` AS value_gar_funkcija,GROUP_CONCAT(DISTINCT filter_child_t.`gar_funkcija`) AS `value_c_gar_funkcija`,filter_master_t.`talpa_litrais`,GROUP_CONCAT(DISTINCT filter_child_t.`talpa_litrais`) AS `c_talpa_litrais`,filter_master_t.`talpa_litrais` AS value_talpa_litrais,GROUP_CONCAT(DISTINCT filter_child_t.`talpa_litrais`) AS `value_c_talpa_litrais`,filter_master_t.`garantija`,GROUP_CONCAT(DISTINCT filter_child_t.`garantija`) AS `c_garantija`,filter_master_t.`garantija` AS value_garantija,GROUP_CONCAT(DISTINCT filter_child_t.`garantija`) AS `value_c_garantija`,filter_master_t.`valdymas`,GROUP_CONCAT(DISTINCT filter_child_t.`valdymas`) AS `c_valdymas`,filter_master_t.`valdymas` AS value_valdymas,GROUP_CONCAT(DISTINCT filter_child_t.`valdymas`) AS `value_c_valdymas`,filter_master_t.`plotis_cm`,GROUP_CONCAT(DISTINCT filter_child_t.`plotis_cm`) AS `c_plotis_cm`,filter_master_t.`plotis_cm` AS value_plotis_cm,GROUP_CONCAT(DISTINCT filter_child_t.`plotis_cm`) AS `value_c_plotis_cm`,filter_master_t.`ekranlis`,GROUP_CONCAT(DISTINCT filter_child_t.`ekranlis`) AS `c_ekranlis`,filter_master_t.`ekranlis` AS value_ekranlis,GROUP_CONCAT(DISTINCT filter_child_t.`ekranlis`) AS `value_c_ekranlis`,filter_master_t.`moderns_purktukai`,GROUP_CONCAT(DISTINCT filter_child_t.`moderns_purktukai`) AS `c_moderns_purktukai`,filter_master_t.`moderns_purktukai` AS value_moderns_purktukai,GROUP_CONCAT(DISTINCT filter_child_t.`moderns_purktukai`) AS `value_c_moderns_purktukai`,filter_master_t.`inverterinis_variklis`,GROUP_CONCAT(DISTINCT filter_child_t.`inverterinis_variklis`) AS `c_inverterinis_variklis`,filter_master_t.`inverterinis_variklis` AS value_inverterinis_variklis,GROUP_CONCAT(DISTINCT filter_child_t.`inverterinis_variklis`) AS `value_c_inverterinis_variklis`,filter_master_t.`energijos_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`energijos_klas`) AS `c_energijos_klas`,filter_master_t.`energijos_klas` AS value_energijos_klas,GROUP_CONCAT(DISTINCT filter_child_t.`energijos_klas`) AS `value_c_energijos_klas`,filter_master_t.`galia_w`,GROUP_CONCAT(DISTINCT filter_child_t.`galia_w`) AS `c_galia_w`,filter_master_t.`galia_w` AS value_galia_w,GROUP_CONCAT(DISTINCT filter_child_t.`galia_w`) AS `value_c_galia_w`,filter_master_t.`greii_skaiius`,GROUP_CONCAT(DISTINCT filter_child_t.`greii_skaiius`) AS `c_greii_skaiius`,filter_master_t.`greii_skaiius` AS value_greii_skaiius,GROUP_CONCAT(DISTINCT filter_child_t.`greii_skaiius`) AS `value_c_greii_skaiius`,filter_master_t.`kokteilin`,GROUP_CONCAT(DISTINCT filter_child_t.`kokteilin`) AS `c_kokteilin`,filter_master_t.`kokteilin` AS value_kokteilin,GROUP_CONCAT(DISTINCT filter_child_t.`kokteilin`) AS `value_c_kokteilin`,filter_master_t.`talpa`,GROUP_CONCAT(DISTINCT filter_child_t.`talpa`) AS `c_talpa`,filter_master_t.`talpa` AS value_talpa,GROUP_CONCAT(DISTINCT filter_child_t.`talpa`) AS `value_c_talpa`,filter_master_t.`disk_tipas`,GROUP_CONCAT(DISTINCT filter_child_t.`disk_tipas`) AS `c_disk_tipas`,filter_master_t.`disk_tipas` AS value_disk_tipas,GROUP_CONCAT(DISTINCT filter_child_t.`disk_tipas`) AS `value_c_disk_tipas`,filter_master_t.`msmal`,GROUP_CONCAT(DISTINCT filter_child_t.`msmal`) AS `c_msmal`,filter_master_t.`msmal` AS value_msmal,GROUP_CONCAT(DISTINCT filter_child_t.`msmal`) AS `value_c_msmal`,filter_master_t.`suliaspaud`,GROUP_CONCAT(DISTINCT filter_child_t.`suliaspaud`) AS `c_suliaspaud`,filter_master_t.`suliaspaud` AS value_suliaspaud,GROUP_CONCAT(DISTINCT filter_child_t.`suliaspaud`) AS `value_c_suliaspaud`,filter_master_t.`citrusini_vaisi_suliaspaud`,GROUP_CONCAT(DISTINCT filter_child_t.`citrusini_vaisi_suliaspaud`) AS `c_citrusini_vaisi_suliaspaud`,filter_master_t.`citrusini_vaisi_suliaspaud` AS value_citrusini_vaisi_suliaspaud,GROUP_CONCAT(DISTINCT filter_child_t.`citrusini_vaisi_suliaspaud`) AS `value_c_citrusini_vaisi_suliaspaud`,filter_master_t.`bulvyi_fri_pjaustymo_priedas`,GROUP_CONCAT(DISTINCT filter_child_t.`bulvyi_fri_pjaustymo_priedas`) AS `c_bulvyi_fri_pjaustymo_priedas`,filter_master_t.`bulvyi_fri_pjaustymo_priedas` AS value_bulvyi_fri_pjaustymo_priedas,GROUP_CONCAT(DISTINCT filter_child_t.`bulvyi_fri_pjaustymo_priedas`) AS `value_c_bulvyi_fri_pjaustymo_priedas`,filter_master_t.`pjaustymas_kbeliais`,GROUP_CONCAT(DISTINCT filter_child_t.`pjaustymas_kbeliais`) AS `c_pjaustymas_kbeliais`,filter_master_t.`pjaustymas_kbeliais` AS value_pjaustymas_kbeliais,GROUP_CONCAT(DISTINCT filter_child_t.`pjaustymas_kbeliais`) AS `value_c_pjaustymas_kbeliais`,filter_master_t.`antgalio_tipas`,GROUP_CONCAT(DISTINCT filter_child_t.`antgalio_tipas`) AS `c_antgalio_tipas`,filter_master_t.`antgalio_tipas` AS value_antgalio_tipas,GROUP_CONCAT(DISTINCT filter_child_t.`antgalio_tipas`) AS `value_c_antgalio_tipas`,filter_master_t.`plaktuvas`,GROUP_CONCAT(DISTINCT filter_child_t.`plaktuvas`) AS `c_plaktuvas`,filter_master_t.`plaktuvas` AS value_plaktuvas,GROUP_CONCAT(DISTINCT filter_child_t.`plaktuvas`) AS `value_c_plaktuvas`,filter_master_t.`naumas`,GROUP_CONCAT(DISTINCT filter_child_t.`naumas`) AS `c_naumas`,filter_master_t.`naumas` AS value_naumas,GROUP_CONCAT(DISTINCT filter_child_t.`naumas`) AS `value_c_naumas`,filter_master_t.`priedas_deroms_kimti`,GROUP_CONCAT(DISTINCT filter_child_t.`priedas_deroms_kimti`) AS `c_priedas_deroms_kimti`,filter_master_t.`priedas_deroms_kimti` AS value_priedas_deroms_kimti,GROUP_CONCAT(DISTINCT filter_child_t.`priedas_deroms_kimti`) AS `value_c_priedas_deroms_kimti`,filter_master_t.`priedas_sausainiams_gaminti`,GROUP_CONCAT(DISTINCT filter_child_t.`priedas_sausainiams_gaminti`) AS `c_priedas_sausainiams_gaminti`,filter_master_t.`priedas_sausainiams_gaminti` AS value_priedas_sausainiams_gaminti,GROUP_CONCAT(DISTINCT filter_child_t.`priedas_sausainiams_gaminti`) AS `value_c_priedas_sausainiams_gaminti`,filter_master_t.`disk_skaiius`,GROUP_CONCAT(DISTINCT filter_child_t.`disk_skaiius`) AS `c_disk_skaiius`,filter_master_t.`disk_skaiius` AS value_disk_skaiius,GROUP_CONCAT(DISTINCT filter_child_t.`disk_skaiius`) AS `value_c_disk_skaiius`,filter_master_t.`temperatros_reguliavimas`,GROUP_CONCAT(DISTINCT filter_child_t.`temperatros_reguliavimas`) AS `c_temperatros_reguliavimas`,filter_master_t.`temperatros_reguliavimas` AS value_temperatros_reguliavimas,GROUP_CONCAT(DISTINCT filter_child_t.`temperatros_reguliavimas`) AS `value_c_temperatros_reguliavimas`,filter_master_t.`slgis_barai`,GROUP_CONCAT(DISTINCT filter_child_t.`slgis_barai`) AS `c_slgis_barai`,filter_master_t.`slgis_barai` AS value_slgis_barai,GROUP_CONCAT(DISTINCT filter_child_t.`slgis_barai`) AS `value_c_slgis_barai`,filter_master_t.`lygintuvo_padas`,GROUP_CONCAT(DISTINCT filter_child_t.`lygintuvo_padas`) AS `c_lygintuvo_padas`,filter_master_t.`lygintuvo_padas` AS value_lygintuvo_padas,GROUP_CONCAT(DISTINCT filter_child_t.`lygintuvo_padas`) AS `value_c_lygintuvo_padas`,filter_master_t.`reguliuojamas_garas`,GROUP_CONCAT(DISTINCT filter_child_t.`reguliuojamas_garas`) AS `c_reguliuojamas_garas`,filter_master_t.`reguliuojamas_garas` AS value_reguliuojamas_garas,GROUP_CONCAT(DISTINCT filter_child_t.`reguliuojamas_garas`) AS `value_c_reguliuojamas_garas`,filter_master_t.`garo_vis`,GROUP_CONCAT(DISTINCT filter_child_t.`garo_vis`) AS `c_garo_vis`,filter_master_t.`garo_vis` AS value_garo_vis,GROUP_CONCAT(DISTINCT filter_child_t.`garo_vis`) AS `value_c_garo_vis`,filter_master_t.`automatinis_isijungimas`,GROUP_CONCAT(DISTINCT filter_child_t.`automatinis_isijungimas`) AS `c_automatinis_isijungimas`,filter_master_t.`automatinis_isijungimas` AS value_automatinis_isijungimas,GROUP_CONCAT(DISTINCT filter_child_t.`automatinis_isijungimas`) AS `value_c_automatinis_isijungimas`,filter_master_t.`papildomas_padas_jautriems_audiniams`,GROUP_CONCAT(DISTINCT filter_child_t.`papildomas_padas_jautriems_audiniams`) AS `c_papildomas_padas_jautriems_audiniams`,filter_master_t.`papildomas_padas_jautriems_audiniams` AS value_papildomas_padas_jautriems_audiniams,GROUP_CONCAT(DISTINCT filter_child_t.`papildomas_padas_jautriems_audiniams`) AS `value_c_papildomas_padas_jautriems_audiniams`,filter_master_t.`apsauga_nuo_kalki`,GROUP_CONCAT(DISTINCT filter_child_t.`apsauga_nuo_kalki`) AS `c_apsauga_nuo_kalki`,filter_master_t.`apsauga_nuo_kalki` AS value_apsauga_nuo_kalki,GROUP_CONCAT(DISTINCT filter_child_t.`apsauga_nuo_kalki`) AS `value_c_apsauga_nuo_kalki`,filter_master_t.`apsauga_nuo_lajimo`,GROUP_CONCAT(DISTINCT filter_child_t.`apsauga_nuo_lajimo`) AS `c_apsauga_nuo_lajimo`,filter_master_t.`apsauga_nuo_lajimo` AS value_apsauga_nuo_lajimo,GROUP_CONCAT(DISTINCT filter_child_t.`apsauga_nuo_lajimo`) AS `value_c_apsauga_nuo_lajimo`,filter_master_t.`vandens_rezervuaro_talpa`,GROUP_CONCAT(DISTINCT filter_child_t.`vandens_rezervuaro_talpa`) AS `c_vandens_rezervuaro_talpa`,filter_master_t.`vandens_rezervuaro_talpa` AS value_vandens_rezervuaro_talpa,GROUP_CONCAT(DISTINCT filter_child_t.`vandens_rezervuaro_talpa`) AS `value_c_vandens_rezervuaro_talpa`,filter_master_t.`laido_ilgis`,GROUP_CONCAT(DISTINCT filter_child_t.`laido_ilgis`) AS `c_laido_ilgis`,filter_master_t.`laido_ilgis` AS value_laido_ilgis,GROUP_CONCAT(DISTINCT filter_child_t.`laido_ilgis`) AS `value_c_laido_ilgis`,filter_master_t.`svoris`,GROUP_CONCAT(DISTINCT filter_child_t.`svoris`) AS `c_svoris`,filter_master_t.`svoris` AS value_svoris,GROUP_CONCAT(DISTINCT filter_child_t.`svoris`) AS `value_c_svoris`,filter_master_t.`veikimo_laikas`,GROUP_CONCAT(DISTINCT filter_child_t.`veikimo_laikas`) AS `c_veikimo_laikas`,filter_master_t.`veikimo_laikas` AS value_veikimo_laikas,GROUP_CONCAT(DISTINCT filter_child_t.`veikimo_laikas`) AS `value_c_veikimo_laikas`,filter_master_t.`galingumo_reguliavimas`,GROUP_CONCAT(DISTINCT filter_child_t.`galingumo_reguliavimas`) AS `c_galingumo_reguliavimas`,filter_master_t.`galingumo_reguliavimas` AS value_galingumo_reguliavimas,GROUP_CONCAT(DISTINCT filter_child_t.`galingumo_reguliavimas`) AS `value_c_galingumo_reguliavimas`,filter_master_t.`minkti_ratukai`,GROUP_CONCAT(DISTINCT filter_child_t.`minkti_ratukai`) AS `c_minkti_ratukai`,filter_master_t.`minkti_ratukai` AS value_minkti_ratukai,GROUP_CONCAT(DISTINCT filter_child_t.`minkti_ratukai`) AS `value_c_minkti_ratukai`,filter_master_t.`tampa`,GROUP_CONCAT(DISTINCT filter_child_t.`tampa`) AS `c_tampa`,filter_master_t.`tampa` AS value_tampa,GROUP_CONCAT(DISTINCT filter_child_t.`tampa`) AS `value_c_tampa`,filter_master_t.`baterijos_tipas`,GROUP_CONCAT(DISTINCT filter_child_t.`baterijos_tipas`) AS `c_baterijos_tipas`,filter_master_t.`baterijos_tipas` AS value_baterijos_tipas,GROUP_CONCAT(DISTINCT filter_child_t.`baterijos_tipas`) AS `value_c_baterijos_tipas`,filter_master_t.`energijos_efektyvumo_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`energijos_efektyvumo_klas`) AS `c_energijos_efektyvumo_klas`,filter_master_t.`energijos_efektyvumo_klas` AS value_energijos_efektyvumo_klas,GROUP_CONCAT(DISTINCT filter_child_t.`energijos_efektyvumo_klas`) AS `value_c_energijos_efektyvumo_klas`,filter_master_t.`dulki_pralaidumo_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`dulki_pralaidumo_klas`) AS `c_dulki_pralaidumo_klas`,filter_master_t.`dulki_pralaidumo_klas` AS value_dulki_pralaidumo_klas,GROUP_CONCAT(DISTINCT filter_child_t.`dulki_pralaidumo_klas`) AS `value_c_dulki_pralaidumo_klas`,filter_master_t.`kilim_valymo_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`kilim_valymo_klas`) AS `c_kilim_valymo_klas`,filter_master_t.`kilim_valymo_klas` AS value_kilim_valymo_klas,GROUP_CONCAT(DISTINCT filter_child_t.`kilim_valymo_klas`) AS `value_c_kilim_valymo_klas`,filter_master_t.`kiet_grind_valymo_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`kiet_grind_valymo_klas`) AS `c_kiet_grind_valymo_klas`,filter_master_t.`kiet_grind_valymo_klas` AS value_kiet_grind_valymo_klas,GROUP_CONCAT(DISTINCT filter_child_t.`kiet_grind_valymo_klas`) AS `value_c_kiet_grind_valymo_klas`,filter_master_t.`parketo_antgalis`,GROUP_CONCAT(DISTINCT filter_child_t.`parketo_antgalis`) AS `c_parketo_antgalis`,filter_master_t.`parketo_antgalis` AS value_parketo_antgalis,GROUP_CONCAT(DISTINCT filter_child_t.`parketo_antgalis`) AS `value_c_parketo_antgalis`,filter_master_t.`turbo_antgalis`,GROUP_CONCAT(DISTINCT filter_child_t.`turbo_antgalis`) AS `c_turbo_antgalis`,filter_master_t.`turbo_antgalis` AS value_turbo_antgalis,GROUP_CONCAT(DISTINCT filter_child_t.`turbo_antgalis`) AS `value_c_turbo_antgalis`,filter_master_t.`hepa_filtras`,GROUP_CONCAT(DISTINCT filter_child_t.`hepa_filtras`) AS `c_hepa_filtras`,filter_master_t.`hepa_filtras` AS value_hepa_filtras,GROUP_CONCAT(DISTINCT filter_child_t.`hepa_filtras`) AS `value_c_hepa_filtras`,filter_master_t.`triukmingumas_db`,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_db`) AS `c_triukmingumas_db`,filter_master_t.`triukmingumas_db` AS value_triukmingumas_db,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_db`) AS `value_c_triukmingumas_db`,filter_master_t.`filtras`,GROUP_CONCAT(DISTINCT filter_child_t.`filtras`) AS `c_filtras`,filter_master_t.`filtras` AS value_filtras,GROUP_CONCAT(DISTINCT filter_child_t.`filtras`) AS `value_c_filtras`,filter_master_t.`siurbimo_galia`,GROUP_CONCAT(DISTINCT filter_child_t.`siurbimo_galia`) AS `c_siurbimo_galia`,filter_master_t.`siurbimo_galia` AS value_siurbimo_galia,GROUP_CONCAT(DISTINCT filter_child_t.`siurbimo_galia`) AS `value_c_siurbimo_galia`,filter_master_t.`kavos_pupeli_talpa`,GROUP_CONCAT(DISTINCT filter_child_t.`kavos_pupeli_talpa`) AS `c_kavos_pupeli_talpa`,filter_master_t.`kavos_pupeli_talpa` AS value_kavos_pupeli_talpa,GROUP_CONCAT(DISTINCT filter_child_t.`kavos_pupeli_talpa`) AS `value_c_kavos_pupeli_talpa`,filter_master_t.`programuojamos_vandens_temperatros_lygiai`,GROUP_CONCAT(DISTINCT filter_child_t.`programuojamos_vandens_temperatros_lygiai`) AS `c_programuojamos_vandens_temperatros_lygiai`,filter_master_t.`programuojamos_vandens_temperatros_lygiai` AS value_programuojamos_vandens_temperatros_lygiai,GROUP_CONCAT(DISTINCT filter_child_t.`programuojamos_vandens_temperatros_lygiai`) AS `value_c_programuojamos_vandens_temperatros_lygiai`,filter_master_t.`individualiai_nustatomos_kavos_parinktys`,GROUP_CONCAT(DISTINCT filter_child_t.`individualiai_nustatomos_kavos_parinktys`) AS `c_individualiai_nustatomos_kavos_parinktys`,filter_master_t.`individualiai_nustatomos_kavos_parinktys` AS value_individualiai_nustatomos_kavos_parinktys,GROUP_CONCAT(DISTINCT filter_child_t.`individualiai_nustatomos_kavos_parinktys`) AS `value_c_individualiai_nustatomos_kavos_parinktys`,filter_master_t.`cappuccino_ruoimas`,GROUP_CONCAT(DISTINCT filter_child_t.`cappuccino_ruoimas`) AS `c_cappuccino_ruoimas`,filter_master_t.`cappuccino_ruoimas` AS value_cappuccino_ruoimas,GROUP_CONCAT(DISTINCT filter_child_t.`cappuccino_ruoimas`) AS `value_c_cappuccino_ruoimas`,filter_master_t.`kava_vieno_mygtuko_paspaudimu`,GROUP_CONCAT(DISTINCT filter_child_t.`kava_vieno_mygtuko_paspaudimu`) AS `c_kava_vieno_mygtuko_paspaudimu`,filter_master_t.`kava_vieno_mygtuko_paspaudimu` AS value_kava_vieno_mygtuko_paspaudimu,GROUP_CONCAT(DISTINCT filter_child_t.`kava_vieno_mygtuko_paspaudimu`) AS `value_c_kava_vieno_mygtuko_paspaudimu`,filter_master_t.`reguliuojamas_kavos_malimo_rupumas`,GROUP_CONCAT(DISTINCT filter_child_t.`reguliuojamas_kavos_malimo_rupumas`) AS `c_reguliuojamas_kavos_malimo_rupumas`,filter_master_t.`reguliuojamas_kavos_malimo_rupumas` AS value_reguliuojamas_kavos_malimo_rupumas,GROUP_CONCAT(DISTINCT filter_child_t.`reguliuojamas_kavos_malimo_rupumas`) AS `value_c_reguliuojamas_kavos_malimo_rupumas`,filter_master_t.`kavos_malimo_girn_tipas`,GROUP_CONCAT(DISTINCT filter_child_t.`kavos_malimo_girn_tipas`) AS `c_kavos_malimo_girn_tipas`,filter_master_t.`kavos_malimo_girn_tipas` AS value_kavos_malimo_girn_tipas,GROUP_CONCAT(DISTINCT filter_child_t.`kavos_malimo_girn_tipas`) AS `value_c_kavos_malimo_girn_tipas`,filter_master_t.`grilis`,GROUP_CONCAT(DISTINCT filter_child_t.`grilis`) AS `c_grilis`,filter_master_t.`grilis` AS value_grilis,GROUP_CONCAT(DISTINCT filter_child_t.`grilis`) AS `value_c_grilis`,filter_master_t.`konvekcija`,GROUP_CONCAT(DISTINCT filter_child_t.`konvekcija`) AS `c_konvekcija`,filter_master_t.`konvekcija` AS value_konvekcija,GROUP_CONCAT(DISTINCT filter_child_t.`konvekcija`) AS `value_c_konvekcija`,filter_master_t.`vidaus_danga`,GROUP_CONCAT(DISTINCT filter_child_t.`vidaus_danga`) AS `c_vidaus_danga`,filter_master_t.`vidaus_danga` AS value_vidaus_danga,GROUP_CONCAT(DISTINCT filter_child_t.`vidaus_danga`) AS `value_c_vidaus_danga`,filter_master_t.`nulin_zona`,GROUP_CONCAT(DISTINCT filter_child_t.`nulin_zona`) AS `c_nulin_zona`,filter_master_t.`nulin_zona` AS value_nulin_zona,GROUP_CONCAT(DISTINCT filter_child_t.`nulin_zona`) AS `value_c_nulin_zona`,filter_master_t.`beerkn_sistema`,GROUP_CONCAT(DISTINCT filter_child_t.`beerkn_sistema`) AS `c_beerkn_sistema`,filter_master_t.`beerkn_sistema` AS value_beerkn_sistema,GROUP_CONCAT(DISTINCT filter_child_t.`beerkn_sistema`) AS `value_c_beerkn_sistema`,filter_master_t.`minktas_dureli_udarymas`,GROUP_CONCAT(DISTINCT filter_child_t.`minktas_dureli_udarymas`) AS `c_minktas_dureli_udarymas`,filter_master_t.`minktas_dureli_udarymas` AS value_minktas_dureli_udarymas,GROUP_CONCAT(DISTINCT filter_child_t.`minktas_dureli_udarymas`) AS `value_c_minktas_dureli_udarymas`,filter_master_t.`metaliniai_vyriai`,GROUP_CONCAT(DISTINCT filter_child_t.`metaliniai_vyriai`) AS `c_metaliniai_vyriai`,filter_master_t.`metaliniai_vyriai` AS value_metaliniai_vyriai,GROUP_CONCAT(DISTINCT filter_child_t.`metaliniai_vyriai`) AS `value_c_metaliniai_vyriai`,filter_master_t.`apsauga_nuo_vandens_isiliejimo`,GROUP_CONCAT(DISTINCT filter_child_t.`apsauga_nuo_vandens_isiliejimo`) AS `c_apsauga_nuo_vandens_isiliejimo`,filter_master_t.`apsauga_nuo_vandens_isiliejimo` AS value_apsauga_nuo_vandens_isiliejimo,GROUP_CONCAT(DISTINCT filter_child_t.`apsauga_nuo_vandens_isiliejimo`) AS `value_c_apsauga_nuo_vandens_isiliejimo`,filter_master_t.`laiko_atidjimas`,GROUP_CONCAT(DISTINCT filter_child_t.`laiko_atidjimas`) AS `c_laiko_atidjimas`,filter_master_t.`laiko_atidjimas` AS value_laiko_atidjimas,GROUP_CONCAT(DISTINCT filter_child_t.`laiko_atidjimas`) AS `value_c_laiko_atidjimas`,filter_master_t.`plovimo_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`plovimo_klas`) AS `c_plovimo_klas`,filter_master_t.`plovimo_klas` AS value_plovimo_klas,GROUP_CONCAT(DISTINCT filter_child_t.`plovimo_klas`) AS `value_c_plovimo_klas`,filter_master_t.`diovinimo_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`diovinimo_klas`) AS `c_diovinimo_klas`,filter_master_t.`diovinimo_klas` AS value_diovinimo_klas,GROUP_CONCAT(DISTINCT filter_child_t.`diovinimo_klas`) AS `value_c_diovinimo_klas`,filter_master_t.`temperatr_skaiius`,GROUP_CONCAT(DISTINCT filter_child_t.`temperatr_skaiius`) AS `c_temperatr_skaiius`,filter_master_t.`temperatr_skaiius` AS value_temperatr_skaiius,GROUP_CONCAT(DISTINCT filter_child_t.`temperatr_skaiius`) AS `value_c_temperatr_skaiius`,filter_master_t.`program_skaiius`,GROUP_CONCAT(DISTINCT filter_child_t.`program_skaiius`) AS `c_program_skaiius`,filter_master_t.`program_skaiius` AS value_program_skaiius,GROUP_CONCAT(DISTINCT filter_child_t.`program_skaiius`) AS `value_c_program_skaiius`,filter_master_t.`el_energijos_snaud_klas`,GROUP_CONCAT(DISTINCT filter_child_t.`el_energijos_snaud_klas`) AS `c_el_energijos_snaud_klas`,filter_master_t.`el_energijos_snaud_klas` AS value_el_energijos_snaud_klas,GROUP_CONCAT(DISTINCT filter_child_t.`el_energijos_snaud_klas`) AS `value_c_el_energijos_snaud_klas`,filter_master_t.`treias_stalius`,GROUP_CONCAT(DISTINCT filter_child_t.`treias_stalius`) AS `c_treias_stalius`,filter_master_t.`treias_stalius` AS value_treias_stalius,GROUP_CONCAT(DISTINCT filter_child_t.`treias_stalius`) AS `value_c_treias_stalius`,filter_master_t.`talpa_kg`,GROUP_CONCAT(DISTINCT filter_child_t.`talpa_kg`) AS `c_talpa_kg`,filter_master_t.`talpa_kg` AS value_talpa_kg,GROUP_CONCAT(DISTINCT filter_child_t.`talpa_kg`) AS `value_c_talpa_kg`,filter_master_t.`bat_vilnos_krepys`,GROUP_CONCAT(DISTINCT filter_child_t.`bat_vilnos_krepys`) AS `c_bat_vilnos_krepys`,filter_master_t.`bat_vilnos_krepys` AS value_bat_vilnos_krepys,GROUP_CONCAT(DISTINCT filter_child_t.`bat_vilnos_krepys`) AS `value_c_bat_vilnos_krepys`,filter_master_t.`vidaus_apvietimas`,GROUP_CONCAT(DISTINCT filter_child_t.`vidaus_apvietimas`) AS `c_vidaus_apvietimas`,filter_master_t.`vidaus_apvietimas` AS value_vidaus_apvietimas,GROUP_CONCAT(DISTINCT filter_child_t.`vidaus_apvietimas`) AS `value_c_vidaus_apvietimas`,filter_master_t.`greitas_ualdymas`,GROUP_CONCAT(DISTINCT filter_child_t.`greitas_ualdymas`) AS `c_greitas_ualdymas`,filter_master_t.`greitas_ualdymas` AS value_greitas_ualdymas,GROUP_CONCAT(DISTINCT filter_child_t.`greitas_ualdymas`) AS `value_c_greitas_ualdymas`,filter_master_t.`aldytuvo_talpa`,GROUP_CONCAT(DISTINCT filter_child_t.`aldytuvo_talpa`) AS `c_aldytuvo_talpa`,filter_master_t.`aldytuvo_talpa` AS value_aldytuvo_talpa,GROUP_CONCAT(DISTINCT filter_child_t.`aldytuvo_talpa`) AS `value_c_aldytuvo_talpa`,filter_master_t.`aldiklio_talpa`,GROUP_CONCAT(DISTINCT filter_child_t.`aldiklio_talpa`) AS `c_aldiklio_talpa`,filter_master_t.`aldiklio_talpa` AS value_aldiklio_talpa,GROUP_CONCAT(DISTINCT filter_child_t.`aldiklio_talpa`) AS `value_c_aldiklio_talpa`,filter_master_t.`ualdymo_galingumas`,GROUP_CONCAT(DISTINCT filter_child_t.`ualdymo_galingumas`) AS `c_ualdymo_galingumas`,filter_master_t.`ualdymo_galingumas` AS value_ualdymo_galingumas,GROUP_CONCAT(DISTINCT filter_child_t.`ualdymo_galingumas`) AS `value_c_ualdymo_galingumas`,filter_master_t.`alio_ilaikymo_trukm_nutrkus_elektros_tiekimui`,GROUP_CONCAT(DISTINCT filter_child_t.`alio_ilaikymo_trukm_nutrkus_elektros_tiekimui`) AS `c_alio_ilaikymo_trukm_nutrkus_elektros_tiekimui`,filter_master_t.`alio_ilaikymo_trukm_nutrkus_elektros_tiekimui` AS value_alio_ilaikymo_trukm_nutrkus_elektros_tiekimui,GROUP_CONCAT(DISTINCT filter_child_t.`alio_ilaikymo_trukm_nutrkus_elektros_tiekimui`) AS `value_c_alio_ilaikymo_trukm_nutrkus_elektros_tiekimui`,filter_master_t.`spaudiamos_rankenls`,GROUP_CONCAT(DISTINCT filter_child_t.`spaudiamos_rankenls`) AS `c_spaudiamos_rankenls`,filter_master_t.`spaudiamos_rankenls` AS value_spaudiamos_rankenls,GROUP_CONCAT(DISTINCT filter_child_t.`spaudiamos_rankenls`) AS `value_c_spaudiamos_rankenls`,filter_master_t.`grimo_greitis_aps_min`,GROUP_CONCAT(DISTINCT filter_child_t.`grimo_greitis_aps_min`) AS `c_grimo_greitis_aps_min`,filter_master_t.`grimo_greitis_aps_min` AS value_grimo_greitis_aps_min,GROUP_CONCAT(DISTINCT filter_child_t.`grimo_greitis_aps_min`) AS `value_c_grimo_greitis_aps_min`,filter_master_t.`audinius_tausojantis_bgnas`,GROUP_CONCAT(DISTINCT filter_child_t.`audinius_tausojantis_bgnas`) AS `c_audinius_tausojantis_bgnas`,filter_master_t.`audinius_tausojantis_bgnas` AS value_audinius_tausojantis_bgnas,GROUP_CONCAT(DISTINCT filter_child_t.`audinius_tausojantis_bgnas`) AS `value_c_audinius_tausojantis_bgnas`,filter_master_t.`tiesioginis_purkimas`,GROUP_CONCAT(DISTINCT filter_child_t.`tiesioginis_purkimas`) AS `c_tiesioginis_purkimas`,filter_master_t.`tiesioginis_purkimas` AS value_tiesioginis_purkimas,GROUP_CONCAT(DISTINCT filter_child_t.`tiesioginis_purkimas`) AS `value_c_tiesioginis_purkimas`,filter_master_t.`triukmingumas_skalbiant`,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_skalbiant`) AS `c_triukmingumas_skalbiant`,filter_master_t.`triukmingumas_skalbiant` AS value_triukmingumas_skalbiant,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_skalbiant`) AS `value_c_triukmingumas_skalbiant`,filter_master_t.`triukmingumas_griant`,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_griant`) AS `c_triukmingumas_griant`,filter_master_t.`triukmingumas_griant` AS value_triukmingumas_griant,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_griant`) AS `value_c_triukmingumas_griant`,filter_master_t.`triukmingumas_diovinant`,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_diovinant`) AS `c_triukmingumas_diovinant`,filter_master_t.`triukmingumas_diovinant` AS value_triukmingumas_diovinant,GROUP_CONCAT(DISTINCT filter_child_t.`triukmingumas_diovinant`) AS `value_c_triukmingumas_diovinant`,filter_master_t.`eds3_sistema`,GROUP_CONCAT(DISTINCT filter_child_t.`eds3_sistema`) AS `c_eds3_sistema`,filter_master_t.`eds3_sistema` AS value_eds3_sistema,GROUP_CONCAT(DISTINCT filter_child_t.`eds3_sistema`) AS `value_c_eds3_sistema`,filter_master_t.`galingumas_m3_h`,GROUP_CONCAT(DISTINCT filter_child_t.`galingumas_m3_h`) AS `c_galingumas_m3_h`,filter_master_t.`galingumas_m3_h` AS value_galingumas_m3_h,GROUP_CONCAT(DISTINCT filter_child_t.`galingumas_m3_h`) AS `value_c_galingumas_m3_h`,filter_master_t.`galingumas_m3_h_pagal_iec_61591`,GROUP_CONCAT(DISTINCT filter_child_t.`galingumas_m3_h_pagal_iec_61591`) AS `c_galingumas_m3_h_pagal_iec_61591`,filter_master_t.`galingumas_m3_h_pagal_iec_61591` AS value_galingumas_m3_h_pagal_iec_61591,GROUP_CONCAT(DISTINCT filter_child_t.`galingumas_m3_h_pagal_iec_61591`) AS `value_c_galingumas_m3_h_pagal_iec_61591`,filter_master_t.`rmelis`,GROUP_CONCAT(DISTINCT filter_child_t.`rmelis`) AS `c_rmelis`,filter_master_t.`rmelis` AS value_rmelis,GROUP_CONCAT(DISTINCT filter_child_t.`rmelis`) AS `value_c_rmelis`,filter_master_t.`kaitinimo_zonos`,GROUP_CONCAT(DISTINCT filter_child_t.`kaitinimo_zonos`) AS `c_kaitinimo_zonos`,filter_master_t.`kaitinimo_zonos` AS value_kaitinimo_zonos,GROUP_CONCAT(DISTINCT filter_child_t.`kaitinimo_zonos`) AS `value_c_kaitinimo_zonos`,filter_master_t.`atitirpinimo_kepimo_progr`,GROUP_CONCAT(DISTINCT filter_child_t.`atitirpinimo_kepimo_progr`) AS `c_atitirpinimo_kepimo_progr`,filter_master_t.`atitirpinimo_kepimo_progr` AS value_atitirpinimo_kepimo_progr,GROUP_CONCAT(DISTINCT filter_child_t.`atitirpinimo_kepimo_progr`) AS `value_c_atitirpinimo_kepimo_progr`,filter_master_t.`ketaus_laikikliai`,GROUP_CONCAT(DISTINCT filter_child_t.`ketaus_laikikliai`) AS `c_ketaus_laikikliai`,filter_master_t.`ketaus_laikikliai` AS value_ketaus_laikikliai,GROUP_CONCAT(DISTINCT filter_child_t.`ketaus_laikikliai`) AS `value_c_ketaus_laikikliai`,filter_master_t.`dvigubos_liepsnos_degiklis`,GROUP_CONCAT(DISTINCT filter_child_t.`dvigubos_liepsnos_degiklis`) AS `c_dvigubos_liepsnos_degiklis`,filter_master_t.`dvigubos_liepsnos_degiklis` AS value_dvigubos_liepsnos_degiklis,GROUP_CONCAT(DISTINCT filter_child_t.`dvigubos_liepsnos_degiklis`) AS `value_c_dvigubos_liepsnos_degiklis`,filter_master_t.`trigubos_liepsnos_degiklis`,GROUP_CONCAT(DISTINCT filter_child_t.`trigubos_liepsnos_degiklis`) AS `c_trigubos_liepsnos_degiklis`,filter_master_t.`trigubos_liepsnos_degiklis` AS value_trigubos_liepsnos_degiklis,GROUP_CONCAT(DISTINCT filter_child_t.`trigubos_liepsnos_degiklis`) AS `value_c_trigubos_liepsnos_degiklis` FROM fs_vm_product LEFT JOIN fs_vm_product AS child ON child.product_parent_id != 0 AND child.product_parent_id = fs_vm_product.product_id AND child.product_publish = 'Y' AND (child.product_special = 'Y') LEFT JOIN fs_vm_product_category_xref ON fs_vm_product.product_id = fs_vm_product_category_xref.product_id LEFT JOIN fs_vm_category ON fs_vm_product_category_xref.category_id = fs_vm_category.category_id AND fs_vm_category.category_publish = 'Y' LEFT JOIN fs_vm_product_mf_xref AS master_mf ON master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_manufacturer AS master_m ON master_m.manufacturer_id = master_mf.manufacturer_id LEFT JOIN fs_vm_product_mf_xref AS child_mf ON child.product_id IS NOT NULL AND child_mf.product_id = child.product_id LEFT JOIN fs_vm_manufacturer AS child_m ON child_mf.manufacturer_id IS NOT NULL AND child_m.manufacturer_id = child_mf.manufacturer_id LEFT JOIN fs_vm_product_price AS master_pr ON fs_vm_product.product_id = master_pr.product_id AND master_pr.shopper_group_id IN (5) LEFT JOIN fs_vm_product_price AS child_pr ON child.product_id = child_pr.product_id AND child_pr.shopper_group_id IN (5) LEFT JOIN fs_vm_product_type_ AS filter_master_t ON fs_vm_product.product_id = filter_master_t.product_id LEFT JOIN fs_vm_product_type_ AS filter_child_t ON child.product_id = filter_child_t.product_id WHERE (fs_vm_product.product_special = 'Y' OR child.product_id IS NOT NULL) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y' AND (`filter_master_t`.`product_id` IS NOT NULL OR `filter_child_t`.`product_id` IS NOT NULL) GROUP BY `fs_vm_product`.`product_id` LIMIT 0, 2000
Filtruoti prekes
Kategorija
Gamintojas
Spalva
(Gartraukis)
El. energijos sąnaudų klasė
(Šaldytuvas)
Aukštis, cm
(Šaldytuvas)
Plotis, cm
(Šaldytuvas)
Šaldymo technologija
(Šaldytuvas)
Šaldiklio talpa, l
(Šaldytuvas)
Triukšmingumas, dB
(Šaldytuvas)
Artima 0°C zona
(Šaldytuvas)
Vyrių tipas
(Šaldytuvas)
Montavimo tipas
(Kaitlentė)
Plotis, cm
(Kaitlentė)
Gylis, cm
(Kaitlentė)
Paviršiaus praplėtimo zonos
(Kaitlentė)
Kaitviečių apjungimo funkcija ,,Bridge''
(Kaitlentė)
Skalbimo talpa
(Skalbyklė)
Gręžimo greitis
(Skalbyklė)
Gylis
(Skalbyklė)
Triukšmingumas gręžiant
(Skalbyklė)

Spausdinti
Prekių katalogas feed


Rodoma 1 - 16 iš 18

Gartraukis Allenzi S3 PLUS 60 IX
TOP
-25,00 €
Kaitlentė Starkke THG 618-CF
TOP
-20,00 €

150,00 € 170,00 €
Gartraukis Allenzi GL50 PLUS LED
TOP

Ištraukimo galingumas 700 m3/val. Extra SILENT 240 W turbina - tylus variklis

179,00 €
Kaitlentė Samsung NA64H3010AK
TOP
-20,00 €

179,00 € 199,00 €
Gartraukis Allenzi S5 Massimo 60 WHS
TOP
-19,00 €
Kaitlentė Gorenje IT643BSC
TOP
Kaitlentė AEG IKB64301FB
TOP
Orkaitė Siemens HB634GBS1
TOP
-15,00 €

405,00 € 420,00 €

Rodoma 1 - 16 iš 18