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 '%3971211%' OR t.nazwa1 like '%3971211%' OR t.nazwaBpz like '%3971211%' OR s.pl like '%3971211%' OR s.en like '%3971211%' OR s.de like '%3971211%' OR s.ru like '%3971211%' OR s.ua like '%3971211%' OR s.es like '%3971211%' OR s.cs like '%3971211%' OR s.sk like '%3971211%' OR s2.pl like '%3971211%' OR s2.en like '%3971211%' OR s2.de like '%3971211%' OR s2.ru like '%3971211%' OR s2.ua like '%3971211%' OR s2.es like '%3971211%' OR s2.cs like '%3971211%' OR s2.sk like '%3971211%' OR t.marka like '%3971211%' OR t.typ like '%3971211%' OR t.nrCzesci like '%3971211%' OR pd.nazwaDo like '%3971211%' OR pd.markaDo like '%3971211%' OR pd.typDo like '%3971211%' OR pd.nrCzesciDo like '%3971211%' OR par.wartosc like '%3971211%') ) <<< caused an error: Unknown column 'pd.nazwaDo' in 'where clause'
Plik: /var/www/vhosts/wibako.pl/httpdocs/emag/eModel/Controller/Connection.php
Linia: 37
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 3971211', 24, 1, NULL) #4 /var/www/vhosts/wibako.pl/httpdocs/wibako.pl/controllers/ProductsController.class.php(213): Controller->searchTowary('Cummins 3971211', 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}
Kod: 0