SVĚTEM ROSTLIN

Třešně

třešeň

Vyberte si třešně pomocí našeho průvodce

Průvodce odrůdami třešní»


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_vyska_od + roz_vyska_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_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((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))) 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
Listnaté stromy

Listnaté stromy

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_vyska_od + roz_vyska_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_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((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))))


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_vyska_od + roz_vyska_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_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))) 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_vyska_od + roz_vyska_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_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))) 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_vyska_od + roz_vyska_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_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))) 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_vyska_od + roz_vyska_do > 0 AND IF' at line 5

SELECT DISTINCT id_ho_barva, naz_barva1_cz, txt_pikto FROM ho_barva WHERE je_zaklad AND (id_ho_barva IN ( SELECT DISTINCT ho_barva.id_ho_barva FROM ho_barva INNER JOIN ro_kvet ON ro_kvet.id_ho_barva = ho_barva.id_ho_barva WHERE je_zaklad AND (1 AND 1 AND (ro_kvet.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))) UNION SELECT DISTINCT id_ho_zaklad1 FROM ho_barva INNER JOIN ro_kvet ON ro_kvet.id_ho_barva = ho_barva.id_ho_barva WHERE 1 AND (1 AND 1 AND (ro_kvet.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))) UNION SELECT DISTINCT id_ho_zaklad2 FROM ho_barva INNER JOIN ro_kvet ON ro_kvet.id_ho_barva = ho_barva.id_ho_barva WHERE 1 AND (1 AND 1 AND (ro_kvet.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))) UNION SELECT DISTINCT id_ho_zaklad3 FROM ho_barva INNER JOIN ro_kvet ON ro_kvet.id_ho_barva = ho_barva.id_ho_barva WHERE 1 AND (1 AND 1 AND (ro_kvet.id_ro_rostl IN (SELECT -1 AS id_ro_rostl UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 1) AND id_ro_rostl IN (SELECT id_ro_rostl FROM ro_vlastnost WHERE id_ho_vlast = 7)))))) ORDER BY je_zaklad DESC, por_barva


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/4835/virtual/www/fce_filtry.php on line 312
Výška rostlinydo 10 cm 10 - 25 cm 50 - 100 cm 1 - 2 m 2 - 5 m 5 - 10 m
10 - 15 m nad 15 m zrušit podmínku
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_vyska_od + roz_vyska_do > 0 AND IF' at line 12

SELECT 1 AS Sirka, SUM(IF(IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) <= 10, 1, 0)) AS Sirka0_10, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 25 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 10, 0, 1)) AS Sirka10_25, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 50 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 25, 0, 1)) AS Sirka25_50, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 100 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 50, 0, 1)) AS Sirka50_100, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 200 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 100, 0, 1)) AS Sirka100_200, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 500 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 200, 0, 1)) AS Sirka200_500, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 1000 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 500, 0, 1)) AS Sirka500_1000, SUM(IF(IF(roz_sirka_od=0, roz_sirka_do/2, roz_sirka_od) > 1500 OR IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) < 1000, 0, 1)) AS Sirka1000_1500, SUM(IF(IF(roz_sirka_do=0, roz_sirka_od*2, roz_sirka_do) >= 1500, 1, 0)) AS Sirka1500 FROM ro_rostlina WHERE roz_sirka_od + roz_sirka_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_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 1500 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 1000UNION SELECT id_ro_rostl FROM ro_rostlina WHERE roz_vyska_od + roz_vyska_do > 0 AND IF(roz_vyska_od=0, roz_vyska_do/2, roz_vyska_od) <= 200 AND IF(roz_vyska_do=0, roz_vyska_od*2, roz_vyska_do) >= 100 )) AND ((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))))


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

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í Jiří Hruška
Firma vznikla v roce 1991. Začínali jsme školkařit na ploše 1 ha, dnes máme produkční školku na rozloze 8 ha. Zabýváme se pěstováním ovocných stromků a keřů a okrasných dřevin v širokém sortimentu. Provádíme návrhy a realizace zahrad.

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

STČ: Velim, Velim
web  telefon
Listnaté stromyJehličnaté stromyJehličnaté keřeSkalničkyTrvalkyPopínavé rostlinyRostliny do nádob
Copyright copy 2010-2018 Světem rostlin, všechna práva vyhrazena.