42S22:SELECT SQL_CALC_FOUND_ROWS  A.id, A.nazwa, A.adres, A.foto1, A.sid, A.status, A.outlet, A.bestseller, A.wyprzedaz, A.producent, A.promo, A.nowosc, A.shfree, A.cena, A.rabat, A.cena_max, A.cenaold, A.avg_grade ,R.logo,www as R_logo,www , M.path0, GROUP_CONCAT(F.photo) as photos, MAX(Z.rabat_bf) as rabat_bf, MIN(Z.cena_promo) as cena_promo,( A.nazwa LIKE '%zoggs zestaw rurka %2B wiose%C5%82ka%') as __search_priority FROM act_base_produkty as A   LEFT JOIN act_base_prod as R ON R.id = A.producent  INNER JOIN act_menu M ON M.id = A.menu_id
LEFT JOIN act_base_photos F ON F.f_produkt = A.id AND F.main = 1
LEFT JOIN act_base_towar Z ON Z.pid = A.id AND Z.status = 1 WHERE ((A.pstatus OR Z.stan) AND A.status = 1 ) AND (0  OR A.nazwa LIKE '%zoggs%' OR A.nazwag LIKE '%zoggs%' OR A.pstatus LIKE '%zoggs%' OR A.adres LIKE '%zoggs%' OR A.f_grupa_rozmiarow LIKE '%zoggs%' OR A.tabroz LIKE '%zoggs%' OR A.sid LIKE '%zoggs%' OR A.opis LIKE '%zoggs%' OR A.status LIKE '%zoggs%' OR A.porownywarka LIKE '%zoggs%' OR A.gfeed LIKE '%zoggs%' OR A.baselinker LIKE '%zoggs%' OR A.outlet LIKE '%zoggs%' OR A.bestseller LIKE '%zoggs%' OR A.wyprzedaz LIKE '%zoggs%' OR A.char LIKE '%zoggs%' OR A.opishurt LIKE '%zoggs%' OR A.rabat LIKE '%zoggs%' OR A.data_ack LIKE '%zoggs%' OR A.keywords LIKE '%zoggs%' OR A.rodzaj LIKE '%zoggs%' OR A.avg_grade LIKE '%zoggs%' OR A.reviews_cnt LIKE '%zoggs%')  AND (0  OR A.nazwa LIKE '%zestaw%' OR A.nazwag LIKE '%zestaw%' OR A.pstatus LIKE '%zestaw%' OR A.adres LIKE '%zestaw%' OR A.f_grupa_rozmiarow LIKE '%zestaw%' OR A.tabroz LIKE '%zestaw%' OR A.sid LIKE '%zestaw%' OR A.opis LIKE '%zestaw%' OR A.status LIKE '%zestaw%' OR A.porownywarka LIKE '%zestaw%' OR A.gfeed LIKE '%zestaw%' OR A.baselinker LIKE '%zestaw%' OR A.outlet LIKE '%zestaw%' OR A.bestseller LIKE '%zestaw%' OR A.wyprzedaz LIKE '%zestaw%' OR A.char LIKE '%zestaw%' OR A.opishurt LIKE '%zestaw%' OR A.rabat LIKE '%zestaw%' OR A.data_ack LIKE '%zestaw%' OR A.keywords LIKE '%zestaw%' OR A.rodzaj LIKE '%zestaw%' OR A.avg_grade LIKE '%zestaw%' OR A.reviews_cnt LIKE '%zestaw%')  AND (0  OR A.nazwa LIKE '%rurka%' OR A.nazwag LIKE '%rurka%' OR A.pstatus LIKE '%rurka%' OR A.adres LIKE '%rurka%' OR A.f_grupa_rozmiarow LIKE '%rurka%' OR A.tabroz LIKE '%rurka%' OR A.sid LIKE '%rurka%' OR A.opis LIKE '%rurka%' OR A.status LIKE '%rurka%' OR A.porownywarka LIKE '%rurka%' OR A.gfeed LIKE '%rurka%' OR A.baselinker LIKE '%rurka%' OR A.outlet LIKE '%rurka%' OR A.bestseller LIKE '%rurka%' OR A.wyprzedaz LIKE '%rurka%' OR A.char LIKE '%rurka%' OR A.opishurt LIKE '%rurka%' OR A.rabat LIKE '%rurka%' OR A.data_ack LIKE '%rurka%' OR A.keywords LIKE '%rurka%' OR A.rodzaj LIKE '%rurka%' OR A.avg_grade LIKE '%rurka%' OR A.reviews_cnt LIKE '%rurka%')  AND (0  OR A.nazwa LIKE '%%2B%' OR A.nazwag LIKE '%%2B%' OR A.pstatus LIKE '%%2B%' OR A.adres LIKE '%%2B%' OR A.f_grupa_rozmiarow LIKE '%%2B%' OR A.tabroz LIKE '%%2B%' OR A.sid LIKE '%%2B%' OR A.opis LIKE '%%2B%' OR A.status LIKE '%%2B%' OR A.porownywarka LIKE '%%2B%' OR A.gfeed LIKE '%%2B%' OR A.baselinker LIKE '%%2B%' OR A.outlet LIKE '%%2B%' OR A.bestseller LIKE '%%2B%' OR A.wyprzedaz LIKE '%%2B%' OR A.char LIKE '%%2B%' OR A.opishurt LIKE '%%2B%' OR A.rabat LIKE '%%2B%' OR A.data_ack LIKE '%%2B%' OR A.keywords LIKE '%%2B%' OR A.rodzaj LIKE '%%2B%' OR A.avg_grade LIKE '%%2B%' OR A.reviews_cnt LIKE '%%2B%')  AND (0  OR A.nazwa LIKE '%wiose%C5%82ka%' OR A.nazwag LIKE '%wiose%C5%82ka%' OR A.pstatus LIKE '%wiose%C5%82ka%' OR A.adres LIKE '%wiose%C5%82ka%' OR A.f_grupa_rozmiarow LIKE '%wiose%C5%82ka%' OR A.tabroz LIKE '%wiose%C5%82ka%' OR A.sid LIKE '%wiose%C5%82ka%' OR A.opis LIKE '%wiose%C5%82ka%' OR A.status LIKE '%wiose%C5%82ka%' OR A.porownywarka LIKE '%wiose%C5%82ka%' OR A.gfeed LIKE '%wiose%C5%82ka%' OR A.baselinker LIKE '%wiose%C5%82ka%' OR A.outlet LIKE '%wiose%C5%82ka%' OR A.bestseller LIKE '%wiose%C5%82ka%' OR A.wyprzedaz LIKE '%wiose%C5%82ka%' OR A.char LIKE '%wiose%C5%82ka%' OR A.opishurt LIKE '%wiose%C5%82ka%' OR A.rabat LIKE '%wiose%C5%82ka%' OR A.data_ack LIKE '%wiose%C5%82ka%' OR A.keywords LIKE '%wiose%C5%82ka%' OR A.rodzaj LIKE '%wiose%C5%82ka%' OR A.avg_grade LIKE '%wiose%C5%82ka%' OR A.reviews_cnt LIKE '%wiose%C5%82ka%')  AND (A.perms & 1)   AND A.lang IN (0,-1) AND A.date_end >= NOW() AND A.date_start <= NOW() GROUP BY A.id ORDER BY `results%7Cdesc`  LIMIT 0, 21