

Detail položky
SELECT DISTINCT(Z.vyrobce),V.nazev, V.rok_narozeni, V.rok_umrti FROM hokej_zbozi AS Z LEFT JOIN hokej_vyrobci AS V ON Z.vyrobce = V.id WHERE (Z.aktivni="1" OR Z.aktivni="1") AND Z.planovane_ukonceni > 1575765760 and (Z.nazevproduktu like '%G_2020⊂=%' or Z.text like '%G_2020⊂=%' or Z.i_kod like '%G_2020⊂=%' or Z.i_jmeno like '%G_2020⊂=%' or Z.i_primeni like '%G_2020⊂=%' or Z.i_technika like '%G_2020⊂=%' or Z.i_rok like '%G_2020⊂=%' or Z.i_rozmer like '%G_2020⊂=%' or Z.i_signatura like '%G_2020⊂=%' or Z.i_ram like '%G_2020⊂=%' or Z.i_ostatni like '%G_2020⊂=%') AND V.aktivni = "1" ORDER BY trim(V.nazev)MySQL error: Illegal mix of collations (cp1250_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'