Wyposażenie sklepów JAMP
Rzetelna firma
... jest pusty
Koszyk 0
Strona główna Rejestracja Logowanie Moje konto Strona firmowa Kontakt
Boksy kasowe

Linia ACX
Linia COP
Nowości
Boks kasowy ACX 03
Chwilowy brak ceny
 
 
Boks kasowy ACX 01
Chwilowy brak ceny
 
 
Boks kasowy COP.2.2
Cena:
5.395,00 zł (netto)
6.635,85 zł (brutto)

 
Boks kasowy COP.4.2
Cena:
5.955,00 zł (netto)
7.324,65 zł (brutto)

 
1054 - Unknown column 'f.products_id' in 'on clause'

select distinct p.products_id, pd.products_short_description AS products_description1, products_quantity, p.products_image, p.products_tax_class_id, products_retail_price, s.status as specstat, s.specials_new_products_price, p.products_price from ((products p) left join products_description pd on pd.products_id = f.products_id left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c) left join featured f on p.products_id = f.products_id where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_id in (13, 125, 124) and p.products_status = '1' and f.status = '1' GROUP BY p.products_id order by rand() DESC limit 4

[TEP STOP]