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=208)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: 20141738
MACO kabatiņas 35mm filmām
0,58 EUR 0.50 EUR
Produkta numurs: 20141256
Karstās pēdas aizsargvāciņš HS-01
0,92 EUR 0.80 EUR
Produkta numurs: 20595061
Vakoss CT4337 Somiņa fotokamerai
1,15 EUR 1.00 EUR
Produkta numurs: 20595062
Vakoss CT4531 Universāla somiņa fotokamerai
1,15 EUR 1.00 EUR
Produkta numurs: 20141110
Metz karsta peda Pentax zibspuldzei
795110284.A5
1,27 EUR 1.10 EUR
Produkta numurs: 20141906
Kodak KCR2025 Baterija
1,38 EUR 1.20 EUR
Produkta numurs: 20171020
Green Clean LC-7010 tīrīšanas salvetes optikai
1,38 EUR 1.20 EUR
Produkta numurs: 20141144
Flash Diffuser FC-26B
1,61 EUR 1.40 EUR
Produkta numurs: 20194663
Whitenergy Adapter plate for CRV3 to battery charger 05720 05718
1,96 EUR 1.70 EUR
Produkta numurs: 20141004
Baterija CR2032
2,07 EUR 1.80 EUR
Produkta numurs: 20141012
Baterija KODAK K23A
2,07 EUR 1.80 EUR
Produkta numurs: 20141927
Cell Micro Alkaline Panasonic LR44 EL 6BP (6pcs)
2,07 EUR 1.80 EUR