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=60)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: 20351393
Beper CA.010
4,83 EUR 4.20 EUR
Produkta numurs: 20351392
Beper CA.011
6,33 EUR 5.50 EUR
Produkta numurs: 20429059
ESPERANZA EKC007K CAPPUCCINO - coffee grinder EKC007K - 5901299932155
7,48 EUR 6.50 EUR
Produkta numurs: 20429060
ESPERANZA EKC007W CAPPUCCINO - coffee grinder EKC007W - 5901299932131
7,48 EUR 6.50 EUR
Produkta numurs: 20379841
PHILIPS Atkaļķošanas škidrums Saeco kafijas automātiem CA6700/10
7,94 EUR 6.90 EUR
Produkta numurs: 20407090
ESPERANZA EKC002K LUNGO - coffee grinder EKC002K - 5901299915172
8,74 EUR 7.60 EUR
Produkta numurs: 20351394
Beper CA.003
8,97 EUR 7.80 EUR
Produkta numurs: 20407091
ESPERANZA EKC001W ESPERSSO - coffee grinder EKC001W - 5901299915158
9,20 EUR 8.00 EUR
Produkta numurs: 20346459
PHILIPS piena sistēmas tīrīšanas līdzeklis Saeco CA6705/10
10,01 EUR 8.70 EUR
Produkta numurs: 20351396
Beper CA.001
10,81 EUR 9.40 EUR
Produkta numurs: 20525105
KRUPS tīrīšanas tabletes, 10 gab XS300010
12,65 EUR 11.00 EUR
Produkta numurs: 20379844
PHILIPS Brita ūdens filtrs Saeco kafijas automātiem CA6702/10
13,92 EUR 12.10 EUR