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 '%cummins%' OR t.nazwa1 like '%cummins%' OR t.nazwaBpz like '%cummins%' OR  s.pl like '%cummins%' OR  s.en like '%cummins%' OR  s.de like '%cummins%' OR  s.ru like '%cummins%' OR  s.ua like '%cummins%' OR  s.es like '%cummins%' OR  s.cs like '%cummins%' OR  s.sk like '%cummins%' OR  s2.pl like '%cummins%' OR  s2.en like '%cummins%' OR  s2.de like '%cummins%' OR  s2.ru like '%cummins%' OR  s2.ua like '%cummins%' OR  s2.es like '%cummins%' OR  s2.cs like '%cummins%' OR  s2.sk like '%cummins%' OR t.marka like '%cummins%' OR t.typ like '%cummins%' OR t.nrCzesci like '%cummins%' OR pd.nazwaDo like '%cummins%' OR pd.markaDo like '%cummins%' OR pd.typDo like '%cummins%' OR pd.nrCzesciDo like '%cummins%' OR par.wartosc like  '%cummins%')  AND  (t.nazwa like '%isbe3%9%' OR t.nazwa1 like '%isbe3%9%' OR t.nazwaBpz like '%isbe3%9%' OR  s.pl like '%isbe3%9%' OR  s.en like '%isbe3%9%' OR  s.de like '%isbe3%9%' OR  s.ru like '%isbe3%9%' OR  s.ua like '%isbe3%9%' OR  s.es like '%isbe3%9%' OR  s.cs like '%isbe3%9%' OR  s.sk like '%isbe3%9%' OR  s2.pl like '%isbe3%9%' OR  s2.en like '%isbe3%9%' OR  s2.de like '%isbe3%9%' OR  s2.ru like '%isbe3%9%' OR  s2.ua like '%isbe3%9%' OR  s2.es like '%isbe3%9%' OR  s2.cs like '%isbe3%9%' OR  s2.sk like '%isbe3%9%' OR t.marka like '%isbe3%9%' OR t.typ like '%isbe3%9%' OR t.nrCzesci like '%isbe3%9%' OR pd.nazwaDo like '%isbe3%9%' OR pd.markaDo like '%isbe3%9%' OR pd.typDo like '%isbe3%9%' OR pd.nrCzesciDo like '%isbe3%9%' OR par.wartosc like  '%isbe3%9%')  AND  (t.nazwa like '%cpl2953%' OR t.nazwa1 like '%cpl2953%' OR t.nazwaBpz like '%cpl2953%' OR  s.pl like '%cpl2953%' OR  s.en like '%cpl2953%' OR  s.de like '%cpl2953%' OR  s.ru like '%cpl2953%' OR  s.ua like '%cpl2953%' OR  s.es like '%cpl2953%' OR  s.cs like '%cpl2953%' OR  s.sk like '%cpl2953%' OR  s2.pl like '%cpl2953%' OR  s2.en like '%cpl2953%' OR  s2.de like '%cpl2953%' OR  s2.ru like '%cpl2953%' OR  s2.ua like '%cpl2953%' OR  s2.es like '%cpl2953%' OR  s2.cs like '%cpl2953%' OR  s2.sk like '%cpl2953%' OR t.marka like '%cpl2953%' OR t.typ like '%cpl2953%' OR t.nrCzesci like '%cpl2953%' OR pd.nazwaDo like '%cpl2953%' OR pd.markaDo like '%cpl2953%' OR pd.typDo like '%cpl2953%' OR pd.nrCzesciDo like '%cpl2953%' OR par.wartosc like  '%cpl2953%') ) <<< 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('cummins isbe3%9...', 24, 1, NULL)
#4 /var/www/vhosts/wibako.pl/httpdocs/wibako.pl/controllers/ProductsController.class.php(213): Controller->searchTowary('Cummins ISBE3.9...', 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 />