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' 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_category_xref.category_id = 50 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
Gamintojas
Montavimo tipas
Skalbyklės tipas
Skalbimo talpa
Gręžimo greitis
Gylis
Triukšmingumas skalbiant
Triukšmingumas gręžiant
El. energijos sąnaudų klasė
Audinių atšviežinimas (Garai)
Inverterinis variklis
Džiovinimo talpa
Heat Pump technologija
Skalbimo technologija

Spausdinti
SKALBYKLĖS


Rodoma 1 - 18 iš 63

Rodoma 1 - 18 iš 63

Ypatingos prekės

Rezultatai 2 iš 2 Rodyti daugiau