Bezbarvé kameny

kalcit, chalcedon, apofylit
Nasik, Indie
410 Kč, cca 16€
10 x 7 x 3 cm
Vystaveno 13.8.2019
apofylit, stilbit, chalcedon
Nasik, Indie
780 Kč, cca 30€
10 x 7 x 5 cm
Vystaveno 18.7.2019
stilbit, kalcit, chalcedon
Nasik, Indie
430 Kč, cca 17€
8 x 5,5 x 4 cm
Vystaveno 11.7.2019
křišťál
Diamantina, Brazílie
6900 Kč, cca 268€
15 x 14 x 6 cm
Vystaveno 27.6.2019
apofylit
Indie
540 Kč, cca 21€
10 x 6 x 2,5 cm
Vystaveno 24.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

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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) ORDER BY pridano1 DESC, id DESC LIMIT 60

Počet vzorků: 5

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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_1 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_2 LIKE '%sklo') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_1 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') ) UNION SELECT DISTINCT nazev1_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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_2 LIKE '%sklo') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_1 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') ) UNION SELECT DISTINCT nazev1_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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_2 LIKE '%sklo') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_1 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') ) UNION SELECT DISTINCT nazev1_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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_2 LIKE '%sklo') OR (barva_2 LIKE 'sklo%') ) 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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_1 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') ) UNION SELECT DISTINCT nazev1_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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') ) AND ( (barva_2 LIKE '%sklo') OR (barva_2 LIKE 'sklo%') )

Počet druhů: 3

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 >= 1561095554 ) AND (pridano1 <= 1566279554 ) AND ( (barva_1 LIKE '%sklo') OR (barva_2 LIKE '%sklo') OR (barva_1 LIKE 'sklo%') OR (barva_2 LIKE 'sklo%') )