"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 = 21875 AND id_lang = 1 [Refurbished] Qviart AG3 4K UHD OTT IPTV Receiver Android 9.0 2GB RAM 16GB Flash Dual Band WIFI (2.4 / 5.0G) Black
Airspace SAM-2704 Industrial unmanaged switch 8-port 10 / 100TX…
search
  • Airspace SAM-2704 Industrial unmanaged switch 8-port 10 / 100TX…

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

Android 9.0 Operating System with Apps and Web Browser. 2GB DDR3 and 16GB Flash. WIFI. Bluetooth 4.2. HDMI 2.1 4Kx2K @ 60fps HDCP2.2, CVBS (HDMI-CEC) USB 3.0, USB 2.0 and Micro SD. S / PDIF Optical Digital Audio. IR

€507.51
Tax included
Reference qviart-ag3
Brand Qviart
Quantity
Available Now

Free shipping
Airspace SAM-2704 Industrial unmanaged switch 8-port 10 / 100TX…

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

€507.51

Qviart AG3 is the ultra-powerful receiver of the Qviart AG family: one of the best and fastest multimedia streaming receivers in the world, with Android 9.0 4K UHD OTT IPTV to enjoy content over the internet live or on demand (VOD).

Features

  • Android 9.0 with Android APPs
  • QTV Online TV for Video on Demand (VOD) and Live TV: PVR, Schedule recordings, Reminders, Time shift, Catch Up, EPG, Subtitles, Change Audio, Favorite Group, Edit channels, etc.
  • QUAD-CORE ARM CORTEX A55 CPU 64-Bit@1.91GHz 19700 DMIPS
  • 2GB DDR4-3200 super fast RAM
  • Mali-G31 MP2 GPU with OpenGL ES 3.2, Vulkan 1.0, and OpenCL 2.0
  • 16GB Flash
  • Gigabit LAN 10/100/1000
  • WIFI: Dual band 2.4 / 5.0 with external antenna
  • BLUETOOTH: 4.2
  • HDMI 2.1 4Kx2K @ 60fps HDCP2.2, CVBS (HDMI-CEC)
  • 1x USB 3.0
  • 1x USB 2.0
  • Micro SD
  • S / PDIF Optical Digital Audio
  • TO GO
  • Power LED light
  • Main APPs
  • Qviart Online TV (QTV)
  • Youtube
  • Netflix
  • Prime Video
  • DAZN
  • Web Browser
  • Games
  • ...

Technical specifications

Dimensions

  • Length: 114mm
  • Width: 100mm (120mm with antenna)
  • Height: 20mm (120mm with antenna)
  • Weight: 150gr

Hardware

  • Chipset: AMLOGIC S905X3
  • Processor: QUAD CORE ARM CORTEX-A55
  • Memory: 2GB DDR4 (3200Mhz)
  • Flash Memory: 16GB
  • Video RAM: MALI-G31 MP2

software

  • Operating System: Android 9.0

Interfaces:

  • 1 x USB 3.0
  • 1x USB 2.0
  • HDMI 2.1 (4Kx2K @ 60fps)
  • Ethernet RJ45 10/100/1000 Mbps port
  • S / PDIF Optical Digital Audio port
  • IR Port
  • Micro SD
  • LED display
  • DC 12V / 1A

Multimedia content sources

  • PC and NAS in local network, USB devices

Video decoder

  • HDR, Dolby Vision, Advanced HDR10, HDR10 +, HLG, TCH PRIME HDR, BT709 / BT2020 / BT2100
  • 10-Bit H.265, VP9 P2, AVS2 up to 4Kp75, H.264 4Kp30
  • VP9 Profile-2 up to 8Kx4K @ 24fps & H.265 HEVC MP-10 up to 8Kx4K @ 24fps
  • AVI, MKV, etc.

Audio decoder

  • Dolby Digital, Stereo DACs, S / PDIF In and Out, 8-ch PDM, 12-ch PDM in, 12-ch PDM out
  • MPEG I Layer 1/2/3 (2-CH) and MPEG II ½ (Multi-channel)
  • FLAC, AAC, WAV, etc.

Box contents

  • QVIART AG3 receiver
  • HDMI cable
  • IR cable
  • Quick Start Guide
  • Remote control and batteries
  • External power supply
2021-10-19