ametyst # 14236

  •  
  •  
  •  







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.



ametyst
Las Vigas de Ramírez, Mexiko
8500 Kč, cca 333€
12 x 8 x 6 cm
Vystaveno 9.6.2019
ametyst, křemen
důl Chala, Bulharsko
14200 Kč, cca 556€
9 x 8 x 7 cm
Vystaveno 27.5.2019
ametyst, záhněda
Santa Maria do Jetibá, Brazílie
Prodáno
4 x 6,7 x 3,5 cm
Vystaveno 25.5.2019
ametyst
Adrar Tirecht Bou Oudi, Maroko
450 Kč, cca 18€
2 x 3,3 x 1,7 cm
Vystaveno 10.7.2019
ametyst
Adrar Tirecht Bou Oudi, Maroko
380 Kč, cca 15€
2,6 x 3,8 x 1,8 cm
Vystaveno 30.6.2019
ametyst, záhněda
Santa Maria do Jetibá, Brazílie
370 Kč, cca 14€
4,6 x 6,5 x 3,2 cm
Vystaveno 19.6.2019
ametyst
Adrar Tirecht Bou Oudi, Maroko
260 Kč, cca 10€
2,3 x 2 x 2,5 cm
Vystaveno 1.6.2019
ametyst
Adrar Tirecht Bou Oudi, Maroko
Prodáno
3,5 x 5,5 x 2,4 cm
Vystaveno 1.6.2019
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 ametyst

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

Počet vzorků: 8

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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 ) 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 >= 1558599722 ) AND (pridano1 <= 1563783722 )

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 >= 1558599722 ) AND (pridano1 <= 1563783722 )