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