Odzież reklamowa
Znaleziono:
103
produktów
sale
Notice: Trying to access array offset on value of type null in
/home/texet_pl/site/library/Doctrine/ORM/Query/Parser.php on line
2829
Ilość kolorów: 9
FilterFacade - FilterState
Array
(
[outlet] => 1
[grupa] => 1
[sortowanie] => cena_asc
[strona] => 1
[na_stronie] => 24
)
FilterFacade - Dozwolone marki
Array
(
[0] => 1
[1] => 2
[2] => 3
[3] => 4
[4] => 5
[5] => 6
[6] => 7
[7] => 9
[8] => 10
[9] => 11
[10] => 12
[11] => 13
[12] => 15
[13] => 17
[14] => 18
[15] => 19
[16] => 23
[17] => 24
[18] => 25
[19] => 26
[20] => 27
[21] => 28
[22] => 29
[23] => 30
[24] => 31
)
FilterFacade - SQL Query
SELECT p.*, pi.nazwa, pi.opis, pi.tagi FROM produkty p LEFT JOIN produkty_i18n pi ON p.id = pi.produkty_id AND pi.jezyk = 'pl' INNER JOIN produkty_detale pd ON p.id = pd.produkty_id AND pd.usuniety = 0
INNER JOIN produkty_has_kategorie phk_grupa ON p.id = phk_grupa.produkty_id
INNER JOIN kategorie kat_grupa ON phk_grupa.kategorie_id = kat_grupa.id AND kat_grupa.widoczna = 1
WHERE p.widoczny_netstore = 1 AND p.producenci_id IN (1,2,3,4,5,6,7,9,10,11,12,13,15,17,18,19,23,24,25,26,27,28,29,30,31) AND kat_grupa.grupa = 1 AND p.outlet = 1 AND pd.detal_outlet = 1 GROUP BY p.id ORDER BY MIN(pd.cena) ASC, p.nr_katalogowy ASC LIMIT 0, 24
Zaloguj się
