hledám

SQL: SELECT * FROM zbozi_nerosty_rs_v_3 WHERE ((status='skladem') OR (status='rezervovano')) AND LOWER(stat_cz) LIKE LOWER('%brazílie%') AND ((oddeleni_id='1') OR (oddeleni_id='13')) AND (unikatni='unikátní') AND (pridano1 >= 1561095529 ) AND (pridano1 <= 1566279529 ) ORDER BY id DESC

Počet vzorků: 2

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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 ) 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 >= 1561095529 ) AND (pridano1 <= 1566279529 )

Počet druhů: 11

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 >= 1561095529 ) AND (pridano1 <= 1566279529 )