SELECT T1.*
FROM
(
(SELECT TABLE0.*, BUNDLES.NAME AS FROMBUNDLE
FROM (
(SELECT BUNDLES.ID AS BUNDLEID, BUNDLES.OTT AS BUNDLEOTT, BUNDLES.ORDER AS BUNDLEORDER, BUNDLES.NAME AS BUNDLENAME, BUNDLES.PRICE AS BUNDLEPRICE, BUNDLES.SPEECH AS BUNDLESPEECHONE, BUNDLES.SPEECH_2 AS BUNDLESPEECHTWO, BUNDLES.EN_PACK AS BUNDLEENPACK, BUNDLES.PIC AS BUNDLEPIC, BUNDLES.link_externo AS LINK_EXTERNO, ch_list. * , ch_bundles.IN_BUNDLE
FROM BUNDLES
INNER JOIN ch_list
INNER JOIN ch_bundles ON ch_bundles.IN_BUNDLE = BUNDLES.ID
AND ch_list.ID = ch_bundles.CHANNEL_ID
WHERE ch_list.SHOWCH =1)
UNION
(SELECT BUNDLES.ID AS BUNDLEID, BUNDLES.OTT AS BUNDLEOTT, BUNDLES.ORDER AS BUNDLEORDER, BUNDLES.NAME AS BUNDLENAME, BUNDLES.PRICE AS BUNDLEPRICE, BUNDLES.SPEECH AS BUNDLESPEECHONE, BUNDLES.SPEECH_2 AS BUNDLESPEECHTWO, BUNDLES.EN_PACK AS BUNDLEENPACK, BUNDLES.PIC AS BUNDLEPIC, BUNDLES.link_externo AS LINK_EXTERNO, ch_list. * , ch_bundles.IN_BUNDLE
FROM BUNDLES
INNER JOIN ch_list
INNER JOIN bundles_bundles
INNER JOIN ch_bundles ON ch_bundles.IN_BUNDLE = bundles_bundles.BUNDLE_ID
AND bundles_bundles.IN_BUNDLE = BUNDLES.ID
AND ch_list.ID = ch_bundles.CHANNEL_ID
WHERE ch_list.SHOWCH =1)
ORDER BY BUNDLEORDER
) AS TABLE0
INNER JOIN BUNDLES ON TABLE0.IN_BUNDLE = BUNDLES.ID
INNER JOIN (
SELECT TABLE0.*, BUNDLES.NAME AS FROMBUNDLE
FROM (
(SELECT BUNDLES.ID AS BUNDLEID, BUNDLES.OTT AS BUNDLEOTT, BUNDLES.ORDER AS BUNDLEORDER, BUNDLES.NAME AS BUNDLENAME, BUNDLES.PRICE AS BUNDLEPRICE, BUNDLES.SPEECH AS BUNDLESPEECHONE, BUNDLES.SPEECH_2 AS BUNDLESPEECHTWO, BUNDLES.EN_PACK AS BUNDLEENPACK, BUNDLES.PIC AS BUNDLEPIC, BUNDLES.link_externo AS LINK_EXTERNO, ch_list. * , ch_bundles.IN_BUNDLE
FROM BUNDLES
INNER JOIN ch_list
INNER JOIN ch_bundles ON ch_bundles.IN_BUNDLE = BUNDLES.ID
AND ch_list.ID = ch_bundles.CHANNEL_ID
WHERE ch_list.SHOWCH =1)
UNION
(SELECT BUNDLES.ID AS BUNDLEID, BUNDLES.OTT AS BUNDLEOTT, BUNDLES.ORDER AS BUNDLEORDER, BUNDLES.NAME AS BUNDLENAME, BUNDLES.PRICE AS BUNDLEPRICE, BUNDLES.SPEECH AS BUNDLESPEECHONE, BUNDLES.SPEECH_2 AS BUNDLESPEECHTWO, BUNDLES.EN_PACK AS BUNDLEENPACK, BUNDLES.PIC AS BUNDLEPIC, BUNDLES.link_externo AS LINK_EXTERNO, ch_list. * , ch_bundles.IN_BUNDLE
FROM BUNDLES
INNER JOIN ch_list
INNER JOIN bundles_bundles
INNER JOIN ch_bundles ON ch_bundles.IN_BUNDLE = bundles_bundles.BUNDLE_ID
AND bundles_bundles.IN_BUNDLE = BUNDLES.ID
AND ch_list.ID = ch_bundles.CHANNEL_ID
WHERE ch_list.SHOWCH =1)
ORDER BY BUNDLEORDER
) AS TABLE0
INNER JOIN BUNDLES ON TABLE0.IN_BUNDLE = BUNDLES.ID
GROUP BY TABLE0.BUNDLEID HAVING count(TABLE0.ID) > 1
) dup ON TABLE0.BUNDLEID = dup.BUNDLEID
WHERE TABLE0.BUNDLEENPACK = 4
ORDER BY BUNDLEORDER)
UNION
(SELECT
BUNDLES.ID AS BUNDLEID,
BUNDLES.OTT AS BUNDLEOTT,
BUNDLES.ORDER AS BUNDLEORDER,
BUNDLES.NAME AS BUNDLENAME,
BUNDLES.PRICE AS BUNDLEPRICE,
BUNDLES.SPEECH AS BUNDLESPEECHONE,
BUNDLES.SPEECH_2 AS BUNDLESPEECHTWO,
BUNDLES.EN_PACK AS BUNDLEENPACK,
BUNDLES.PIC AS BUNDLEPIC,
BUNDLES.link_externo AS LINK_EXTERNO,
NULL AS ID,
NULL AS NUM,
NULL AS no_count,
NULL AS shared,
NULL AS nombre,
NULL AS shortname,
NULL AS altername,
NULL AS familygroup,
NULL AS familyhead,
NULL AS PIC,
NULL AS LOGO,
NULL AS PACK,
NULL AS PREMIUM,
NULL AS SHOWCH,
NULL AS dateshow,
NULL AS datedown,
NULL AS CATEGORY,
NULL AS Play,
NULL AS changed,
NULL AS economico,
15 AS IN_BUNDLE
FROM `BUNDLES` WHERE BUNDLES.OTT = 1 AND BUNDLES.EN_PACK = 4)
) T1
Ver señales incluídas
$1215
Para clientes con Pack HD
No válido para clientes Pack Básico
Contratar
Ver señales incluídas
$2050
Para clientes con Pack HD
No válido para clientes Pack Básico
Contratar
