SELECT * FROM ( SELECT DISTINCT item.pid, item.cid, item.typ, item.pzs, item.wm, item.h, item.q, item.s, item.wmk, item.wmd, item.uszczelnienie, item.sterowanie, item.w_opcji, item.funkcja, item.wyjscie_sygnalu, item.zakres, item.inne, item.kolejnosc, kategoria.kolejnosc as kategoria_kolejnosc, item.informacje_dodatkowe, COALESCE(lang.title, lang_def.title) AS title, COALESCE(lang.introtext, lang_def.introtext) AS introtext, COALESCE(lang.text, lang_def.text) AS text, COALESCE(lang.keywords, lang_def.keywords) AS keywords, COALESCE(kat_lang.title, kat_lang_def.title) AS kategoria FROM oferta_produkt as item LEFT JOIN oferta_produkt_lang as lang ON(item.pid = lang.pid AND lang.lang = 'pl') LEFT JOIN oferta_produkt_lang as lang_def ON(item.pid = lang_def.pid AND lang_def.lang = 'pl') LEFT JOIN oferta_kategoria as kategoria ON(item.cid = kategoria.cid) LEFT JOIN oferta_kategoria_lang as kat_lang ON(item.cid = kat_lang.cid AND kat_lang.lang = 'pl') LEFT JOIN oferta_kategoria_lang as kat_lang_def ON(item.cid = kat_lang_def.cid AND kat_lang_def.lang = 'pl') WHERE item.publikacja = '1' AND item.cid IN() ) as produkty ORDER BY kategoria_kolejnosc ASC, kolejnosc ASC, title ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /components/oferta/component.data.php on line 175
Armatura w wykonaniu morskim - PVG