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=36)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: 20141303
FUJIFILM QuickSnap MARINE, waterproof (10m), single-use camera 800/135/27
20,01 EUR 17.40 EUR
Produkta numurs: 20193093
Denver KCA-1320 Green
31,40 EUR 27.30 EUR
Produkta numurs: 20166097
Denver KCA-1310 Green
32,20 EUR 28.00 EUR
Produkta numurs: 20307117
Easypix KiddyPix Mystery 10081
46,46 EUR 40.40 EUR
Produkta numurs: 20307118
Easypix KiddyPix Galaxy 10080
46,46 EUR 40.40 EUR
Produkta numurs: 20177274
Rollei Sportsline 65 Compact camera 5 MP CMOS 2592 x 1944 pixels Black,Red 10058
51,75 EUR 45.00 EUR
Produkta numurs: 20177275
Rollei Sportsline 65 Compact camera 5 MP CMOS 2592 x 1944 pixels Black,Yellow 10060
51,75 EUR 45.00 EUR
Produkta numurs: 20177277
Rollei Sportsline 65 Compact camera 5 MP CMOS 2592 x 1944 pixels Black,Orange 10057
51,75 EUR 45.00 EUR
Produkta numurs: 20416743
Rollei Sportsline 64 Compact camera 12 MP CMOS 4000 x 3000 pixels Black 10066
52,10 EUR 45.30 EUR
Produkta numurs: 20313198
Easypix KiddyPix Mystery 10081 10081
52,44 EUR 45.60 EUR
Produkta numurs: 20313199
Easypix Galaxy 5 MP CMOS 2592 x 1944 pixels Blue,Yellow 10080
52,44 EUR 45.60 EUR
Produkta numurs: 20177276
Rollei Sportsline 80 Compact camera 8 MP CMOS 4000 x 3000 pixels Black 10050
2.08 / mēnesī
58,19 EUR 50.60 EUR