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=2267)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: 20333326
Rear view cam Peiying PY0101 PY0101
12,42 EUR 10.80 EUR
Produkta numurs: 20333327
Rear view cam Peiying PY0101P PY0101P
15,99 EUR 13.90 EUR
Produkta numurs: 20549830
Vakoss  multi-function driving recroder Msonic MV516 FULL HD MV516
17,48 EUR 15.20 EUR
Produkta numurs: 20395386
Sandberg Battery for 430-00 ActionCam 430-01
20,82 EUR 18.10 EUR
Produkta numurs: 20191388
Manta MM310X
21,05 EUR 18.30 EUR
Produkta numurs: 20339994
Kamera samochodowa Girdo 2 (1280x720) TRAKAM43887
21,51 EUR 18.70 EUR
Produkta numurs: 20339989
Rejestrator video BLACKBOX DVR F260 78-517#
28,52 EUR 24.80 EUR
Produkta numurs: 20294078
Prestigio Roadrunner 345 PCDVRR345
32,89 EUR 28.60 EUR
Produkta numurs: 20339988
U-DRIVE ROAD VIEW Kamera samochodowa Full HD MT4063 MT4063
33,35 EUR 29.00 EUR
Produkta numurs: 20100730
Rejestrator video BLACKBOX DVR F460 78-529#
34,04 EUR 29.60 EUR
Produkta numurs: 20339974
Rejestrator video BLACKBOX DVR F450 78-515#
37,61 EUR 32.70 EUR
Produkta numurs: 20457671
Video reģistrātors Prestigio Road Runner 140 PCDVRR140
38,41 EUR 33.40 EUR