Query: >>>SELECT count(distinct t.id, t.idKarta) count FROM Towar t LEFT JOIN Slownik s ON t.nazwa = s.id AND s.tabela='Karta' LEFT JOIN Slownik s2 ON t.nazwa1 = s2.id AND s2.tabela='nazwaDo'  LEFT JOIN Parametr p ON t.id = p.id  WHERE ( (t.nazwa like '%deutz%' OR t.nazwa1 like '%deutz%' OR t.nazwaBpz like '%deutz%' OR  s.pl like '%deutz%' OR  s.en like '%deutz%' OR  s.de like '%deutz%' OR  s.ru like '%deutz%' OR  s.ua like '%deutz%' OR  s.es like '%deutz%' OR  s.cs like '%deutz%' OR  s.sk like '%deutz%' OR  s2.pl like '%deutz%' OR  s2.en like '%deutz%' OR  s2.de like '%deutz%' OR  s2.ru like '%deutz%' OR  s2.ua like '%deutz%' OR  s2.es like '%deutz%' OR  s2.cs like '%deutz%' OR  s2.sk like '%deutz%' OR t.marka like '%deutz%' OR t.typ like '%deutz%' OR t.nrCzesci like '%deutz%' OR pd.nazwaDo like '%deutz%' OR pd.markaDo like '%deutz%' OR pd.typDo like '%deutz%' OR pd.nrCzesciDo like '%deutz%' OR par.wartosc like  '%deutz%')  AND  (t.nazwa like '%bf4m1012%' OR t.nazwa1 like '%bf4m1012%' OR t.nazwaBpz like '%bf4m1012%' OR  s.pl like '%bf4m1012%' OR  s.en like '%bf4m1012%' OR  s.de like '%bf4m1012%' OR  s.ru like '%bf4m1012%' OR  s.ua like '%bf4m1012%' OR  s.es like '%bf4m1012%' OR  s.cs like '%bf4m1012%' OR  s.sk like '%bf4m1012%' OR  s2.pl like '%bf4m1012%' OR  s2.en like '%bf4m1012%' OR  s2.de like '%bf4m1012%' OR  s2.ru like '%bf4m1012%' OR  s2.ua like '%bf4m1012%' OR  s2.es like '%bf4m1012%' OR  s2.cs like '%bf4m1012%' OR  s2.sk like '%bf4m1012%' OR t.marka like '%bf4m1012%' OR t.typ like '%bf4m1012%' OR t.nrCzesci like '%bf4m1012%' OR pd.nazwaDo like '%bf4m1012%' OR pd.markaDo like '%bf4m1012%' OR pd.typDo like '%bf4m1012%' OR pd.nrCzesciDo like '%bf4m1012%' OR par.wartosc like  '%bf4m1012%')  AND  (t.nazwa like '%4198361r%' OR t.nazwa1 like '%4198361r%' OR t.nazwaBpz like '%4198361r%' OR  s.pl like '%4198361r%' OR  s.en like '%4198361r%' OR  s.de like '%4198361r%' OR  s.ru like '%4198361r%' OR  s.ua like '%4198361r%' OR  s.es like '%4198361r%' OR  s.cs like '%4198361r%' OR  s.sk like '%4198361r%' OR  s2.pl like '%4198361r%' OR  s2.en like '%4198361r%' OR  s2.de like '%4198361r%' OR  s2.ru like '%4198361r%' OR  s2.ua like '%4198361r%' OR  s2.es like '%4198361r%' OR  s2.cs like '%4198361r%' OR  s2.sk like '%4198361r%' OR t.marka like '%4198361r%' OR t.typ like '%4198361r%' OR t.nrCzesci like '%4198361r%' OR pd.nazwaDo like '%4198361r%' OR pd.markaDo like '%4198361r%' OR pd.typDo like '%4198361r%' OR pd.nrCzesciDo like '%4198361r%' OR par.wartosc like  '%4198361r%') ) <<< caused an error: Unknown column 'pd.nazwaDo' in 'where clause'<br />Plik: /var/www/vhosts/wibako.pl/httpdocs/emag/eModel/Controller/Connection.php<br />Linia: 37<br />Trace: #0 /var/www/vhosts/wibako.pl/httpdocs/emag/eModel/Controller/Connection.php(47): Connection->throw_exception('Query: >>>SELEC...')
#1 /var/www/vhosts/wibako.pl/httpdocs/emag/eModel/Controller/TowarController.php(359): Connection->query('SELECT count(di...')
#2 /var/www/vhosts/wibako.pl/httpdocs/emag/eModel/Controller/TowarController.php(341): TowarController->getTowary2('SELECT DISTINCT...', 'SELECT count(di...', 24, 1, Array)
#3 /var/www/vhosts/wibako.pl/httpdocs/emag/eModel/Controller.php(196): TowarController->searchTowary('deutz bf4m1012 ...', 24, 1, NULL)
#4 /var/www/vhosts/wibako.pl/httpdocs/wibako.pl/controllers/ProductsController.class.php(213): Controller->searchTowary('Deutz BF4M1012 ...', 24, 1)
#5 /var/www/vhosts/wibako.pl/httpdocs/wibako.pl/controllers/ProductsController.class.php(23): ProductsController->search()
#6 /var/www/vhosts/wibako.pl/httpdocs/wibako.pl/controllers/PageController.class.php(211): ProductsController->products()
#7 /var/www/vhosts/wibako.pl/httpdocs/wibako.pl/index.php(156): PageController->showPage(Array)
#8 {main}<br />Kod: 0<br />