SELECT p.id, p.name_lat as name, p.present_lat as present, p.price, p.price2, p.on_stock, p.amount_onplace, p.amount_onwarehouse, p.manufacturer_link, p.added_time, GROUP_CONCAT(i.id ORDER BY i.ord ASC) as image_names FROM products p LEFT JOIN categories c ON (p._categ = c.id) LEFT JOIN suppliers as s ON s.id=p.supplier_id LEFT JOIN xmllink_images_2 as i ON i.XML_ID = p.XML_ID WHERE (p._categ=194)AND (((p.amount_onplace>0) OR (p.amount_onwarehouse>0)) AND disable<>1 )AND s.disabled=0 GROUP BY p.id ORDER BY p.price
Produkta numurs: 20373741
Izpārdošanas cena! Juguetronica BASIC FIDGET SPINNER pirkstu virpinātājs (no 3 gadiem) JUG0253
5,06 EUR 4.40 EUR
Produkta numurs: 20095881
Juguetronica MEGA BUBBLES komplekts lielo ziepju burbuļu izgatavošanai JUG0284
5,87 EUR 5.10 EUR
Produkta numurs: 20373747
Juguetronica MAGIC BOOMERANG - maģiskais bumerangs (EVA putas) JUG0131
6,44 EUR 5.60 EUR
Produkta numurs: 20342981
Denver Rec-34 White
8,51 EUR 7.40 EUR
Produkta numurs: 20342982
Denver Rec-34 Black
8,51 EUR 7.40 EUR
Produkta numurs: 20323774
Denver CR-419 MK2
10,01 EUR 8.70 EUR
Produkta numurs: 20342944
Denver CR-420
10,01 EUR 8.70 EUR
Produkta numurs: 20187731
Alarm clock with thermometer SENCOR SDC 2800 W SDC 2800 W
12,77 EUR 11.10 EUR
Produkta numurs: 20200051
SENCOR Modinātājpulkstenis SDC 2800 W
13,11 EUR 11.40 EUR
Produkta numurs: 20200052
SENCOR Modinātājpulkstenis SDC 2800 B
13,11 EUR 11.40 EUR
Produkta numurs: 20342976
Denver CR-918 White
14,26 EUR 12.40 EUR
Produkta numurs: 20342977
Denver CR-918 Black
14,26 EUR 12.40 EUR