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=2842)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: 20163729
HP LJ Pro P1102/M1132/M1212 CE285A uzpilde un atjaunošana (CE285A_ATJ)
14,15 EUR 12.30 EUR
Produkta numurs: 20192442
HP LJ Pro P1102/M1132/M1212 CE285A DEMO uzpilde un atjaonošana (CE285A_DEMO_ATJ)
14,15 EUR 12.30 EUR
Produkta numurs: 20163733
Tonera HP Q5949A uzpilde un atjaunošana (Q5949A_ATJ)
18,98 EUR 16.50 EUR
Produkta numurs: 20197567
Tonera HP Q2612A uzpilde un atjaunošana (Q2612A_ATJ)
18,98 EUR 16.50 EUR
Produkta numurs: 20197569
Tonera HP CE278A uzpilde un atjaunošana (CE278A_ATJ)
18,98 EUR 16.50 EUR
Produkta numurs: 20197568
HP LJ 1300 Q2613X BK uzpilde un atjaunošana (Q2613X_ATJ)
20,70 EUR 18.00 EUR
Produkta numurs: 20198799
HP 79A (CF279A) black uzpilde un atjaunošana (CF279A_ATJ)
28,06 EUR 24.40 EUR
Produkta numurs: 20163730
Tonera HP CE320A uzpilde un atjaunošana (CE320A_ATJ)
36,46 EUR 31.70 EUR
Produkta numurs: 20163731
Tonera HP CE322A uzpilde un atjaunošana (CE322A_ATJ)
36,46 EUR 31.70 EUR
Produkta numurs: 20163734
Tonera HP CE321A uzpilde un atjaunošana (CE321A_ATJ)
36,46 EUR 31.70 EUR