skoryl # 4466

Seznam minerálů

výběr podle barev


Kompletní nabídku najdete na těchto stránkách
www.nerosty.cz

  •  
  •  
  •  







Vystaveno

! !

Cena:


 

Objednáváte konkrétní vyfotografovaný kus. Při objednání obdržíte přesně to, co vidíte na obrázku. Vzorek si můžete osobně prohlédnout v naší prodejní galerii.



skoryl
skoryl, turmalín
Davib Ost, Namibie
2450 Kč, cca 96€
4,3 x 4,4 x 4 cm
Vystaveno 8.7.2019
skoryl
skoryl, turmalín
Davib Ost, Namibie
1990 Kč, cca 78€
4 x 4,9 x 4,5 cm
Vystaveno 28.5.2019
skoryl
skoryl, turmalín
Davib Ost, Namibie
1540 Kč, cca 60€
4 x 3,1 x 3,5 cm
Vystaveno 28.5.2019
skoryl
skoryl, hyalit, albit
Davib Ost, Namibie
9300 Kč, cca 364€
17 x 8 x 10 cm
Vystaveno 17.6.2019
skoryl
skoryl, turmalín
Davib Ost, Namibie
1380 Kč, cca 54€
3,9 x 4,3 x 4,5 cm
Vystaveno 3.6.2019
skoryl
skoryl, turmalín
Davib Ost, Namibie
2850 Kč, cca 112€
5 x 4 x 4,5 cm
Vystaveno 23.5.2019
skoryl
skoryl, turmalín
Davib Ost, Namibie
3780 Kč, cca 148€
4 x 5 x 2,5 cm
Vystaveno 23.5.2019
 NEROSTY.CZ - NOVINKY
 Přihlášení  O nás  S tradicí od roku 1996  Jak nakupovat
Podle zákona o evidenci tržeb je prodávající povinen vystavit kupujícímu účtenku. Zároveň je povinen zaevidovat přijatou tržbu u správce daně online; v případě technického výpadku pak nejpozději do 48 hodin. ::: GDPR - Informace o zpracování osobních údajů
© 2005 - 2019 NEROSTY.CZ

hledám skoryl

SQL: SELECT *, 'zbozi_nerosty_rs_v_3' AS tabule FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='skoryl')OR(nazev1_cz='skoryl')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT *, 'zbozi_rockshop_rs_v_3' AS tabule FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='skoryl')OR(nazev1_cz='skoryl')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT *, 'zbozi_levne_rs_v_3' AS tabule FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='skoryl')OR(nazev1_cz='skoryl')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT *, 'zbozi_balkan_rs_v_3' AS tabule FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='skoryl')OR(nazev1_cz='skoryl')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT *, 'zbozi_turmaliny_rs_v_3' AS tabule FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='skoryl')OR(nazev1_cz='skoryl')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) ORDER BY id DESC

Počet vzorků: 7

skládám menu

SQL: SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev1_cz FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 ) UNION SELECT DISTINCT nazev_cz FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 )

Počet druhů: 34

Omezení dostupnosti: ((status='skladem') OR (status='rezervovano'))

Omezení oddělením:

Omezení státy:

Omezení jinak: AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1558597017 ) AND (pridano1 <= 1563781017 )