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 = 43 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
El. energijos sąnaudų klasė
Indaplovės tipas
Inverterinis variklis
Trečias stalčius
Džiovinimo technologija
Modernūs purkštukai
Pakeliamas apatinis stalčius (ComfortLift)
Slankiojantys vyriai
Vidaus apšvietimas
Šviesos signalas
Aukštis
Triukšmingumas

Spausdinti
Indaplovės


Rodoma 19 - 36 iš 46

Rodoma 19 - 36 iš 46