morganit
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ů
hledám morganit
SQL: SELECT *, 'zbozi_nerosty_rs_v_3' AS tabule FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='morganit')OR(nazev1_cz='morganit')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1570529225 ) AND (pridano1 <= 1575713225 ) UNION SELECT *, 'zbozi_rockshop_rs_v_3' AS tabule FROM zbozi_rockshop_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='morganit')OR(nazev1_cz='morganit')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1570529225 ) AND (pridano1 <= 1575713225 ) UNION SELECT *, 'zbozi_levne_rs_v_3' AS tabule FROM zbozi_levne_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='morganit')OR(nazev1_cz='morganit')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1570529225 ) AND (pridano1 <= 1575713225 ) UNION SELECT *, 'zbozi_balkan_rs_v_3' AS tabule FROM zbozi_balkan_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='morganit')OR(nazev1_cz='morganit')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1570529225 ) AND (pridano1 <= 1575713225 ) UNION SELECT *, 'zbozi_turmaliny_rs_v_3' AS tabule FROM zbozi_turmaliny_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND ((nazev_cz='morganit')OR(nazev1_cz='morganit')) AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1570529225 ) AND (pridano1 <= 1575713225 ) ORDER BY id DESC
Počet vzorků: 0
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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 ) 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 >= 1570529225 ) AND (pridano1 <= 1575713225 )
Počet druhů: 4
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 >= 1570529225 ) AND (pridano1 <= 1575713225 )