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=2900)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: 20295806
Camry Hepa and outlet filter set CR 7037.2 for CR7037 CR 7037.2
1,50 EUR 1.30 EUR
Produkta numurs: 20534298
Aromatizēti gaisa atsvaidz. 41646
1,73 EUR 1.50 EUR
Produkta numurs: 20534324
Trauks tabletēm, sadalīts pa dienām 17384
2,07 EUR 1.80 EUR
Produkta numurs: 20534291
Varde ar sirdi I Love you, 7,5x5,5cm 47370
2,42 EUR 2.10 EUR
Produkta numurs: 20534323
Trauks eļļas aromātam, lodveida zieds, 8x8cm 17913
2,53 EUR 2.20 EUR
Produkta numurs: 20534292
Caurspīdīgs dāvanu rullis, 5mx70cm, bez apdrukas 45000
3,11 EUR 2.70 EUR
Produkta numurs: 20534299
Celofāna dāvanu maisiņi, 180x300mm 41631
3,34 EUR 2.90 EUR
Produkta numurs: 20502589
ESPERANZA EBG004B SPIKE -Trimmer for clipping nose and ear hair - BLUE EBG004B - 5901299918791
3,57 EUR 3.10 EUR
Produkta numurs: 20541169
Fabric Shaver Vakoss PE-6011E | green PE-6011E
3,68 EUR 3.20 EUR
Produkta numurs: 20533320
BRABANTIA atkritumu tvertņu maisiņi, 3 l, (A) (20 gab) 311727
3,80 EUR 3.30 EUR
Produkta numurs: 20533811
BRABANTIA atkritumu tvertņu maisiņi, 5 l, (B) (20maisi rullītī) White 311741
3,80 EUR 3.30 EUR
Produkta numurs: 20534304
Iepirkumu soma XXL 40174
3,80 EUR 3.30 EUR