PHP kód:
SELECT t.trter__kod, t.trter__seo_url, coalesce(t.trter__jmp_hrefstr, i.trtip__jmp_hrefstr) AS jmp_hrefstr, coalesce(t.trter__jmp_oldal, i.trtip__jmp_oldal) AS jmp_oldal, coalesce(t.trter__jmp_paramnr_ek, i.trtip__jmp_paramnr_ek) AS jmp_paramnr_ek FROM term_termek AS t LEFT JOIN term_tip AS i ON i.trtip__kod=t.trter__tip WHERE trter__seo_url='konyv' UNION ALL SELECT t.trter__kod, t.trter__seo_url, coalesce(t.trter__jmp_hrefstr, i.trtip__jmp_hrefstr) AS jmp_hrefstr, coalesce(t.trter__jmp_oldal, i.trtip__jmp_oldal) AS jmp_oldal, coalesce(t.trter__jmp_paramnr_ek, i.trtip__jmp_paramnr_ek) AS jmp_paramnr_ek FROM term_termek AS t LEFT JOIN term_tip AS i ON i.trtip__kod=t.trter__tip WHERE coalesce(t.trter__jmp_hrefstr, i.trtip__jmp_hrefstr)='konyv' AND trter__seo_url='a-felakasztott-indian-szigeten''You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''a-felakasztott-indian-szigeten'' at line 7
Könyvjelzők