SVĚTEM ROSTLIN

Pěstované odrůdy sedmikrásky

sedmikráska

Připravili jsme pro Vás přehled pěstovaných odrůd
sedmikrásky obecné (chudobky)
Bellis perennis

Přehled pěstovaných odrůd»


Kontaktujte nás na adrese:
info@svetemrostlin.cz
SQL příkaz nebyl proveden!!!

Chyba SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF' at line 1

SELECT DISTINCT ro_rostlina.id_ro_rostl, naz_rostl_cz, naz_druh_cz, naz_druh_la, naz_kulti_cz, naz_kulti_la, roz_vyska_od, roz_vyska_do, roz_sirka_od, roz_sirka_do, ro_kvet.je_rez, je_voni, je_hmyz, je_med, HoVlastOpad.naz_vlast_cz AS TxtOpad, HoVlastOpad.txt_pikto AS PiktoOpad, HoVlastOpad.id_ho_vlast AS IdOpad, HoBarvaKvet.naz_barva1_cz AS TxtKvet, HoBarvaKvet.txt_pikto AS PiktoKvet, HoObdobiKvet.cis_mes_od AS KvetOd, HoObdobiKvet.cis_mes_do AS KvetDo, HoStanoSlunce.naz_stano_cz AS TxtSlunce, HoStanoSlunce.txt_pikto AS PiktoSlunce, RoStanoSlunce.typ_vhodne VhodneSlunce, HoStanoPolStin.naz_stano_cz AS TxtPolStin, HoStanoPolStin.txt_pikto AS PiktoPolStin, RoStanoPolStin.typ_vhodne VhodnePolStin, HoStanoStin.naz_stano_cz AS TxtStin, HoStanoStin.txt_pikto AS PiktoStin, RoStanoStin.typ_vhodne VhodneStin, txt_zimovani != "" AS JeZimovani, (SELECT COUNT(id_ro_rez) FROM ro_rez WHERE ro_rez.id_ro_rostl = ro_rostlina.id_ro_rostl AND je_tvarovani GROUP BY ro_rez.id_ro_rostl) IS NOT NULL AS JeTvarovani, (SELECT COUNT(id_ro_jedla) FROM ro_jedla WHERE ro_jedla.id_ro_rostl = ro_rostlina.id_ro_rostl GROUP BY ro_jedla.id_ro_rostl) IS NOT NULL AS JeJedla, (SELECT COUNT(id_ro_leciv) FROM ro_leciva WHERE ro_leciva.id_ro_rostl = ro_rostlina.id_ro_rostl GROUP BY ro_leciva.id_ro_rostl) IS NOT NULL AS JeLeciva, (SELECT COUNT(id_ro_jedov) FROM ro_jedovata WHERE ro_jedovata.id_ro_rostl = ro_rostlina.id_ro_rostl GROUP BY ro_jedovata.id_ro_rostl) IS NOT NULL AS JeJedovata, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)) AS listnate_stromy, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3)) AS jehlicnate_stromy, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)) AS listnate_kere, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3)) AS jehlicnate_kere, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 2) OR ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_uziti WHERE id_ho_uziti = 1 AND typ_vhodne < 3)) AS skalnicky, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 13)) AS okrasne_travy, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (12))) AS trvalky, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (15))) AS letnicky, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (16))) AS dvouletky, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (19, 20))) AS cibuloviny, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (5,9,10,11))) AS popinave_rostliny, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (17))) AS vodni_rostliny, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 18) OR ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_uziti WHERE id_ho_uziti = 21 AND typ_vhodne < 3)) AS do_nadob, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 21)) AS bylinky, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (22))) AS kapradiny, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (27))) AS trava, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (24))) AS ovoce, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (26))) AS zelenina, (ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast IN (25))) AS exoticke FROM ro_rostlina INNER JOIN ta_druh ON ta_druh.id_ta_druh = ro_rostlina.id_ta_druh LEFT JOIN ta_kultivar ON ta_kultivar.id_ta_kulti = ro_rostlina.id_ta_kulti LEFT JOIN ro_vlastnost RoVlastOpad ON RoVlastOpad.id_ro_rostl = ro_rostlina.id_ro_rostl AND RoVlastOpad.id_ho_vlast IN (4, 8, 14) LEFT JOIN ho_vlastnost HoVlastOpad ON HoVlastOpad.id_ho_vlast = RoVlastOpad.id_ho_vlast LEFT JOIN ro_stanoviste RoStanoSlunce ON RoStanoSlunce.id_ro_rostl = ro_rostlina.id_ro_rostl AND RoStanoSlunce.id_ho_stano = 1 LEFT JOIN ho_stanoviste HoStanoSlunce ON HoStanoSlunce.id_ho_stano = RoStanoSlunce.id_ho_stano LEFT JOIN ro_stanoviste RoStanoPolStin ON RoStanoPolStin.id_ro_rostl = ro_rostlina.id_ro_rostl AND RoStanoPolStin.id_ho_stano = 2 LEFT JOIN ho_stanoviste HoStanoPolStin ON HoStanoPolStin.id_ho_stano = RoStanoPolStin.id_ho_stano LEFT JOIN ro_stanoviste RoStanoStin ON RoStanoStin.id_ro_rostl = ro_rostlina.id_ro_rostl AND RoStanoStin.id_ho_stano = 4 LEFT JOIN ho_stanoviste HoStanoStin ON HoStanoStin.id_ho_stano = RoStanoStin.id_ho_stano LEFT JOIN ro_jedla RoJedlaLeciva ON RoJedlaLeciva.id_ro_rostl = ro_rostlina.id_ro_rostl AND RoJedlaLeciva.id_ho_jedov = 5 LEFT JOIN ro_kvet ON ro_kvet.id_ro_rostl = ro_rostlina.id_ro_rostl LEFT JOIN ho_barva HoBarvaKvet ON HoBarvaKvet.id_ho_barva = ro_kvet.id_ho_barva LEFT JOIN ho_obdobi HoObdobiKvet ON HoObdobiKvet.id_ho_obdob = ro_kvet.id_ho_obdob WHERE 1 AND 1 AND (ro_rostlina.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 1500 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 100 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 50 )) AND ((ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3))) ORDER BY naz_druh_cz, naz_kulti_cz


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/srostliny.php on line 368
Jehličnaté keře

Jehličnaté keře

Počet rostlin:

SQL příkaz nebyl proveden!!!

Chyba SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF' at line 3

SELECT DISTINCT fi_firma.id_fi_firma, fi_firma.txt_nazev, fi_firma.txt_logo FROM fi_firma INNER JOIN ro_odkaz ON ro_odkaz.id_fi_firma = fi_firma.id_fi_firma INNER JOIN ro_rostlina ON ro_rostlina.id_ro_rostl = ro_odkaz.id_ro_rostl WHERE fi_firma.dat_odkazy >= NOW() AND (1 AND 1 AND (ro_odkaz.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 1500 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 100 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 50 )) AND ((ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3))))


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_filtry.php on line 104
SQL příkaz nebyl proveden!!!

Chyba SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF' at line 4

SELECT DISTINCT ho_stanoviste.id_ho_stano, naz_stano_cz, txt_pikto FROM ho_stanoviste INNER JOIN ro_stanoviste ON ro_stanoviste.id_ho_stano = ho_stanoviste.id_ho_stano WHERE typ_vhodne IN (1,2) AND (1 AND 1 AND (ro_stanoviste.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 1500 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 100 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 50 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3)))) AND ho_stanoviste.id_ho_stano IN (1, 2, 4) ORDER BY por_stano


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_filtry.php on line 156
SQL příkaz nebyl proveden!!!

Chyba SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF' at line 4

SELECT DISTINCT ho_uziti.id_ho_uziti, naz_uziti_cz, txt_pikto FROM ho_uziti INNER JOIN ro_uziti ON ro_uziti.id_ho_uziti = ho_uziti.id_ho_uziti WHERE typ_vhodne IN (1,2) AND (1 AND 1 AND (ro_uziti.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 1500 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 100 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 50 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3)))) AND (ho_uziti.id_ho_uziti < 53 OR ho_uziti.id_ho_uziti > 78) AND ho_uziti.id_ho_uziti IN (1, 20, 21, 37, 14, 22, 31, 35, 2, 3, 16, 11, 43, 46, 45, 4, 33, 8, 9) ORDER BY por_uziti


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_filtry.php on line 256
SQL příkaz nebyl proveden!!!

Chyba SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF' at line 4

SELECT DISTINCT ho_vlastnost.id_ho_vlast, naz_vlast_cz, txt_pikto FROM ho_vlastnost INNER JOIN ro_vlastnost ON ro_vlastnost.id_ho_vlast = ho_vlastnost.id_ho_vlast WHERE ho_vlastnost.id_ho_vlast IN (4, 8, 14) AND (1 AND 1 AND (ro_vlastnost.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 1500 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 100 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 50 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3)))) ORDER BY por_vlast


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_filtry.php on line 201
SQL příkaz nebyl proveden!!!

Chyba SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF' at line 12

SELECT 1 AS Vyska, SUM(IF(IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) <= 10, 1, 0)) AS Vyska0_10, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 25 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 10, 0, 1)) AS Vyska10_25, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 50 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 25, 0, 1)) AS Vyska25_50, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 100 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 50, 0, 1)) AS Vyska50_100, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 200 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 100, 0, 1)) AS Vyska100_200, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 500 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 200, 0, 1)) AS Vyska200_500, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 1000 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 500, 0, 1)) AS Vyska500_1000, SUM(IF(IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) > 1500 OR IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) < 1000, 0, 1)) AS Vyska1000_1500, SUM(IF(IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1500, 1, 0)) AS Vyska1500 FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND (1 AND 1 AND (ro_rostlina.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 1500 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_do > 0 AND IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) <= 100 AND IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 50 )) AND ((ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 6) AND ro_rostlina.id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 3))))


Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_filtry.php on line 368
Šířka rostliny10 - 25 cm 25 - 50 cm 50 - 100 cm 1 - 2 m 2 - 5 m 5 - 10 m
10 - 15 m nad 15 m zrušit podmínku

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_zobrazeni.php on line 625

V našem adresáři zahradnických firem naleznete například toto zahradnictví:

Zahradnictví Petro
Srdečně Vás zveme k nákupu v samoobslužném skleníku, kde si krom uvedeného sortimentu můžete zakoupit pokojové rostliny, keramiku, substráty, hnojiva, květináče, vzrostlé rostliny, osázené závěsné nádoby, multiplata a řadu jiného zboží. Zveme Vás k nákupu v našem obnoveném zásilkovém obchodu- e-shopu, který jsme nyní znovu otevřeli a obohatili o akční nabídku „Zvýhodněná cena za 3 ks“.

Seznam rostlin prodávaných v tomto zahradnictví »

STČ: Mělník–Mlazice, Mělník–Mlazice
web  telefon
Jehličnaté stromyListnaté keřeJehličnaté keřeOkrasné trávyTrvalkyLetničkyDvouletkyRostliny do nádobBylinky
Copyright copy 2010-2018 Světem rostlin, všechna práva vyhrazena.