Novinky přidané během posledních 60 dnů

Seznam minerálů

výběr podle barev


Kompletní nabídku najdete na těchto stránkách
www.nerosty.cz
skoryl
skoryl, albit, záhněda
Davib Ost, Namibie
1410 Kč, cca 54€
4,5 x 4,3 x 4 cm
Vystaveno 4.9.2019
fluorit
fluorit
důl Okorusu, Namibie
9400 Kč, cca 363€
12 x 8 x 7 cm
Vystaveno 1.9.2019
dravit
dravit, turmalín
Pomba pit, Brazílie
950 Kč, cca 37€
1,8 x 2,2 x 1,5 cm
Vystaveno 30.8.2019
stilbit
stilbit, apofylit
Nasik, Indie
560 Kč, cca 22€
9 x 5 x 3 cm
Vystaveno 29.8.2019
ametyst
ametyst
Adrar Tirecht Bou Oudi, Maroko
440 Kč, cca 17€
3,2 x 2 x 3,5 cm
Vystaveno 22.8.2019
fluorit
fluorit, fluorit, pyrit
Maroko
2350 Kč, cca 91€
16 x 10,5 x 5 cm
Vystaveno 15.8.2019
kalcit
kalcit, chalcedon, apofylit
Nasik, Indie
410 Kč, cca 16€
10 x 7 x 3 cm
Vystaveno 13.8.2019
ametyst
ametyst
Adrar Tirecht Bou Oudi, Maroko
880 Kč, cca 34€
3,2 x 4,2 x 1,9 cm
Vystaveno 31.7.2019
skoryl
skoryl, křišťál, albit
Davib Ost, Namibie
1890 Kč, cca 73€
3,5 x 4,5 x 3,9 cm
Vystaveno 25.7.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

SQL: SELECT *, 'zbozi_nerosty_rs_v_3' AS tabule 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1563654355 ) AND (pridano1 <= 1568838355 ) UNION SELECT *, 'zbozi_rockshop_rs_v_3' AS tabule 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1563654355 ) AND (pridano1 <= 1568838355 ) UNION SELECT *, 'zbozi_levne_rs_v_3' AS tabule 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1563654355 ) AND (pridano1 <= 1568838355 ) UNION SELECT *, 'zbozi_balkan_rs_v_3' AS tabule 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1563654355 ) AND (pridano1 <= 1568838355 ) UNION SELECT *, 'zbozi_turmaliny_rs_v_3' AS tabule 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1563654355 ) AND (pridano1 <= 1568838355 ) ORDER BY pridano1 DESC, id DESC LIMIT 60

Počet vzorků: 9

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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 ) 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 >= 1563654355 ) AND (pridano1 <= 1568838355 )

Počet druhů: 8

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 >= 1563654355 ) AND (pridano1 <= 1568838355 )