"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 = 10SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 19316 AND id_lang = 1 [Refurbished] GigaBlue UHD Trio 4K Receiver Combo DVB-S/S2x/T2
  • -8%
Receiver GigaBlue UHD Trio 4K
search
  • Receiver GigaBlue UHD Trio 4K

[Refurbished] GigaBlue UHD Trio 4K Receiver Combo DVB-S/S2x/T2

The new of the Gigablue UHD Trio 4K has 1 x DVB-S/S2x and 1 x Hybrid tuner DVB-T2/C. And thus as a combo usable version. The UHD Trio 4K model provides all the necessary features for a smooth TV and multimedia enjoyment with a stronger CPU power now.

€107.64 €116.99 Save 8%
Tax included
Reference gb-uhd-trio-4k
Brand Gigablue
Quantity
Last items in stock

Free shipping
Receiver GigaBlue UHD Trio 4K

[Refurbished] GigaBlue UHD Trio 4K Receiver Combo DVB-S/S2x/T2

€107.64 €116.99 Save 8%

The new of the Gigablue UHD Trio 4K has 1 x DVB-S/S2x and 1 x Hybrid tuner . And thus as a combo usable version. The UHD Trio 4K model provides all the necessary features for a smooth TV and multimedia enjoyment with a stronger CPU power now.

New standards will set the new GigabBlue receiver. Equipped with the necessary and advanced features users should have for a fair price a receiver at home that you want to meet their wishes in all matters. During the period of high definition television the Gigablue stands with high quality image resolution in HD format in the eye. Rapid switching It is a further feature. Smooth recordings on an external hard drive enable archiving desired series or movies easily.

Features 

  • Fast CPU: ARM Cortex A53, Quad core 64bit, 15.000 dmips
  • 8 GB eMMC Flash / 1 GB Ram DDR3 SDRAM
  • 4 digit / 7 segment
  • 2 x USB (1 front + 2 back)
  • 1 x HDMI
  • 1 x S/C slot
  • 1 x DVB-S2X Tuner MIS (Multtistream)
  • 1 x DVB-T/T2 /DVB-C Tuner
  • 1 x RS-232
  • Optical
  • Blindscan, SW Update via Internet, Ota Update
  • SAT>IP Client, Multiroom, Multiboot
  • Time Shift, Timer-Funktion
  • Ethernet (RJ-45/100/1000Mbps)

Specifications

System Linux
CPU  Hisilicon 3798MV200 Chip
CPU: ARM Cortex A53, Quad core 64bit, 15.000 dmips
ROM 8 GB eMMC Flash
RAM 1 GB Ram DDR3 SDRAM
Dimensions 280mm x 230mm x 55mm
Front  
IR Receiver 1 x IR
Button 8 x Button
Indecater LED 2 x LED
Front Display 4 digit / 7 segment
USB 2.0 1 x USB Host
CI-Modul -
SmardCard 1 x S/C Slot
Rear  
DVB -S2x IN 1 x Input
DVB -S2x OUT 1 x loopthrough
Tuner 2 DVB-C/T/T2
PnP Tuner 2 not used
Scart not used
HDMI 1 x HDMI Output
USB 2.0 1 x USB Host
USB 3.0 1 x USB Host
SD Cardreader 1 x SD Cadreader
S/PDIF 1 x Optical
RS-232 1 x RS-232
Ethernet 1 x RJ45:100/1000Mbps
Power Switch 1 x I/O Switch
DC Input Jack 1 x Jack
Power  
E-PSU 12V/2A

Data sheet

Operative System
Linux / E2
Tuners
2
Tuner Type
Combo (Sat + TDT)
Satellite Tuner
Satellite DVB-S2X
Terrestrial Tuner
Terrestrial / Cable DVB-T2/C
Resolution
4K UHD
CPU
Quad Core
Hard Disk Drive PVR
External HDD (USB)
Card / PCMCIA
Card
Ethernet Connection
Gigabit
RAM
1 GB
Flash Storage
8 GB
Wi-Fi Antenna
External
Remote control
Standard