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