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