"hola"
SELECT p.id_product, pl.name, id_image, t.id_button, IFNULL(pcl.name, "Sin stock con fecha de entrada") as contact, p.id_product as id_od_outofstock FROM ps_product p LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1 LEFT JOIN ps_od_oosbutton t ON t.id_product = p.id_product LEFT JOIN ps_contact_lang pcl ON t.id_button = pcl.id_contact AND pcl.id_lang = 1 LEFT JOIN ps_image_shop i ON p.id_product = i.id_product AND i.cover = 1 WHERE (t.id_button IS NOT NULL) GROUP BY id_product
array:8 [
  0 => array:6 [
    "id_product" => "203"
    "name" => "Power supply 4 Amp. Single channel amplifier serie Tas 001 Triax"
    "id_image" => "2627"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "203"
  ]
  1 => array:6 [
    "id_product" => "204"
    "name" => "Triax TAS 050 Mono Amplifier TDT UHF 50 dB"
    "id_image" => "2632"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "204"
  ]
  2 => array:6 [
    "id_product" => "21818"
    "name" => "Tegui Dual camera B/W TC-70 Europa Series"
    "id_image" => "294910"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "21818"
  ]
  3 => array:6 [
    "id_product" => "28166"
    "name" => "Wisenet WAVE-VW-02 Video Wall License. Management of 2 monitors."
    "id_image" => "297649"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28166"
  ]
  4 => array:6 [
    "id_product" => "28225"
    "name" => "Risco RP512B00000A Polycarbonate box for ProSYS Plus control…"
    "id_image" => "297709"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28225"
  ]
  5 => array:6 [
    "id_product" => "28756"
    "name" => "Bticino 336803. Cable for connection to the installation of internal stations installed on a desktop support"
    "id_image" => "298287"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28756"
  ]
  6 => array:6 [
    "id_product" => "28758"
    "name" => "Hikvision pro DS-2CD3646G2/P-IZS(2.8-12MM) Cámara IP 4MP bullet…"
    "id_image" => "298289"
    "id_button" => "0"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28758"
  ]
  7 => array:6 [
    "id_product" => "28780"
    "name" => "Risco RVIM3A15000A / PFA150 Pole adapter for PFBx PFAx"
    "id_image" => "298428"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28780"
  ]
]
SELECT * FROM ps_od_oosbutton_manufacturer WHERE id_manufacturer = 28SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 20798 AND id_lang = 1 [Refurbished] Receiver Qviart AG2 4K UHD Android 7.0 2GB RAM 16GB Flash Dual Band WIFI (2.4/5.0G) Black
Safire SF-IPD934H-4E - 4 MP IP Camera, 1/3\" Progressive Scan CMOS,…
search
  • Safire SF-IPD934H-4E - 4 MP IP Camera, 1/3\" Progressive Scan CMOS,…

[Refurbished] Receiver Qviart AG2 4K UHD Android 7.0 2GB RAM 16GB Flash Dual Band WIFI (2.4/5.0G) Black

Android 7.0 Operating System with Apps and Web Browser. 2GB DDR3 and 16GB Flash. WIFI. USB 3.0, USB 2.0 and Micro SD. 100M Ethernet. S-PDIF and HDMI 2.0a CEC. 4K UHD HDR10 & HLG VP9 10 Bit 60 FPS H.264 H.265. Dolby Digital Plus.

€82.32

Including €0.04 for ecotax

Tax included
Reference qviart-ag2
Brand Qviart
Quantity
Available Now

Free shipping
Safire SF-IPD934H-4E - 4 MP IP Camera, 1/3\" Progressive Scan CMOS,…

[Refurbished] Receiver Qviart AG2 4K UHD Android 7.0 2GB RAM 16GB Flash Dual Band WIFI (2.4/5.0G) Black

€82.32

Qviart AG2 is a powerful 4K UHD IPTV Android OTT Media streamer/player with a very competitive price. 

The state of the art QTV Online TV Application offers the greatest TV experience in an IPTV set top box; it brings even more functions than your old Satellite or Cable receiver.

The Modern Quad Core A53 64 Bit processor with 3D OpenGL high performance Multi Cores GPU and 2GB DDR3 RAM /16GB Flash makes Qviart AG2 fast and powerful to watch TV comfortably and run Android Apps.

4K HEVC HDR10 HLG HDR VP9 10 Bit 60FPS, 6K video, Dolby   ensures that Qviart AG2 is able to play all 4K content in your TV with crystal-clear quality and sound.

USB 3.0 port, HDMI 2.0a, Dual band WIFI (2.4G/5.0G) and Bluetooth 4.1 show extraordinary connectivity features to play and record all kind of content.

Extraordinary modern interface design, very easy to use. You can also customize the Launcher/Menu with your favorite APPs such as Netflix, KODI, DAZN, Amazon prime, Spotify, YouTube 4K, etc.

Features

  • QTV Online TV APP to use Stalker, Xtream and M3U, VOD within the same App. You can PVR, Program Recordings, Timeshift, Catch Up, EPG simple and Multiple, EPG offset, Event reminders, Subtitles, Change Audio language, etc. You can watch your live TV and VOD Movies and shows with all the needed features.
  • Constant OTA Software Updates with improvements and new functions
  • Great comfortable RCU with 57 buttons to offer a real TV experience and also Smart learning function to control your TV.
  • Android 7.0 Operating system with Apps such as Web browser.
  • 2GB DDR3 and 16GB Flash
  • WIFi Dual band for 2.4GHz and 5GHz
  • USB 3.0, USB 2.0, Micro SD
  • Ethernet 100M
  • Bluetooth 4.1, S-PDIF, HDMI 2.0a CEC
  • 4K UHD HDR10&HLG VP9 10 Bit 60 FPS H.264 H.265
  • Dolby Digital Plus
  • Less than 0.5W Standby Power consumption

Inside the Box

  • Qviart AG2
  • RCU and batteries
  • External Power Supply
  • HDMI 2.0 cable
  • User Manual

Dimensions

  • 110 mm long
  • 107 mm wide
  • 23 mm high

Data sheet

Weight
400 g
Power
DC 12 V / 300 mA, PoE IEEE802.3af
Temp. operation
-30º C ~ +60º C
0º C ~ 70º C
Degree of protection
Weatherproof IP67, Anti-vandal IK10
Dimensions
111 (Ø) x 82.4 (h) mm
Transfer Rate
32 Kbps ~ 8 Mbps
Screen
Aluminium polyester with 96% coating+CuSn drainage
Material
Metallic
Length
100 m
Interior conductor
Flexible electrolytic copper AWG25 0,22 mm Class 5
Isolation
Polyethylene
Formation of the wires
Twisted
External cover
Polyolefin FRLSHF 6.7 mm
Number of conductors
8 signal
Conductivity
≤10μS/mm
Resistance
106 Ohm/km signal
Image sensor
1/3\" Progressive Scan CMOS
Minimum illumination
0.028Lux F2.0 (color)
Lens
2.8 mm (H: 100º, V: 55º)
Maximum resolution
4 Megapixel (2560x1440)
Infrared lighting
0 Lux / IR LEDs (30 m)
Image improvements
BLC, 3D-DNR, DWDR, AWB, ROI, Motion detection, Mirror, Privacy mask
Day / Night
Removable mechanical ICR filter
Remote access
Web browser, Safire Control Center Smartphone App and PC Software
Certification
CPR (Cca -1sb, a1, d2), UNE EN 50575, UNE EN 60332-1-2,50399,61034-2, UNE EN 60754-2
Main Stream rate
20 fps (2560 x 1440, 2304 x 1296, 1920 × 1080, 1280 × 960, 1280×720)
Extra Stream rate
25 fps (640 × 480, 640 × 360, 320 × 240)
Compression
H.265+ / H.264+ / H.265 / H.264
Network interface
Ethernet 10/100M BaseT
Interoperability
ONVIF, PSIA, CGI, ISAPI
Lens positioning
2 Axis