"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 = 33SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 7491 AND id_lang = 1 Digital FTA signals HD Satellite Receiver, SCR I and SCR II support, Televes
Digital FTA signals HD Satellite Receiver, SCR I and SCR II support, Televes
search
  • Digital FTA signals HD Satellite Receiver, SCR I and SCR II support, Televes

Digital FTA signals HD Satellite Receiver, SCR I and SCR II support, Televes

This HDTV receiver allows the reception of TV and radio FTA (Free To Air) satellite services. The receiver stands out for its small and compact design, and its easy and friendly user interface.

€104.06
Tax included
Reference televes-717402
Brand Televes
Quantity
Available in 24/48h

Free shipping
Digital FTA signals HD Satellite Receiver, SCR I and SCR II support, Televes

Digital FTA signals HD Satellite Receiver, SCR I and SCR II support, Televes

€104.06

This HDTV receiver allows the reception of TV and radio FTA (Free To Air) satellite services. The receiver stands out for its small and compact design, and its easy and friendly user interface.

Highlights

  • Plug-and-Play, Astra 19.2° pre-programmed
  • SCR I (EN50494), SCR II (EN50607) and "Legacy" mode support
  • Digital audio coaxial output(S/PDIF)
  • Power consumption lower than 0,5W in Standby mode

Main features

  • Easy, fast and friendly user menu
  • DVB-S / DVB-S2 standard
  • HDMI Output with Full HD resolution
  • Electronic Program Guide (EPG) and teletext
  • Huge channels range
  • Automatically saves the last program
  • 8 “Favorite” lists

Specifications

Input frequency MHz 950...2150
Input signal level dBμV 43 ~ 83
Symbol rate Mbit/s 1 ~ 45
Demodulation DVB-S (QPSK), DVB-S2 (QPSK and 8PSK)
Video format MPEG-2 Video (MP@ML)
MPEG-4 Video (H.264)
Audio format MPEG layer I & II
Aspect ratio 4:3 PS, 4:3 LB, 16:9 and Auto
DiSEqC control 1.0,1.1,1.2, USALS, dCSS (SCR I and SCR II)
LNB Band selection 13V, 18V, 0kHz, 22kHz
FEC 1/2, 2/3, 3/4, 5/6, 7/8, Auto
LNB powering (13/18V) mA 300
Resolution 480i, 480p, 576i, 576p, 720p, 1080i, 1080p
Impedance Ohm 75
GENERAL SPECIFICATIONS
Number of channels 5000
Power consumption (typ.) W 3,8 (working) / 0,5 (Standby)
Mains voltage VAC / Hz 100...240 / 50...60
Operating temperature °C -5 ... +40
SW-Update by USB
Display Green, 4-positions, 7-segments
Color Black
CONNECTORS
Input SAT-Connector F-female
SCART connector SCART Out
HDMI connector HDMI female (Type A)
USB port 2.0
(to SW-Update and save/load channel lists)
Digital audio signal (S/PDIF) Coaxial

Data sheet

Operative System
Standard
Tuners
1
Tuner Type
Single
Satellite Tuner
Satellite DVB-S2
Resolution
Full HD
SCART / CVBS
Yes
Remote control
Standard

Notice: Undefined index: category in /var/www/html/var/cache/prod/smarty/compile/layouts_layout_full_width_tpl/70/4e/f5/704ef5ee69ab552287a67b10a070f4285c0f2b78_2.file.product.tpl.php on line 701

Notice: Trying to get property of non-object in /var/www/html/var/cache/prod/smarty/compile/layouts_layout_full_width_tpl/70/4e/f5/704ef5ee69ab552287a67b10a070f4285c0f2b78_2.file.product.tpl.php on line 701