Camera supraveghere exterior HikVision TurboHD DS-2CE16H0T-ITFS 2.8 mm, 5 MP, IR 30 m, microfon, audio prin coaxial

2006
Interogarea nu a fost rulata: SELECT produs_id, p.nume, p.producator, p.link_produs,p.website, p.validare, p.afisare, p.data_afisare, p.pret_lista, p.pret,url_poza,descriere_scurta,p.url, categorie, subcategorie, aff_code ,MATCH( nume, descriere_scurta, index_cautare ) AGAINST('camera supraveghere exterior hikvision turbohd ds2ce16h0titfs 28 mm mp microfon audio coaxial ' ) as relevance FROM produs as p where p.activ_on_my_site =1 and p.afisare= 1 and p.validare = 1 and p.tip = 0 and MATCH( cuvinte_soundex ) AGAINST('C560 S161 E236 H212 T613 D233 0000 M000 M100 M261 A300 C240' IN BOOLEAN MODE )>5.99 order by relevance desc, nr_clickuri desc , produs_id desc limit 0, 40