Gioco Digitale ha il più alto livello di sicurezza e di integrità di gioco. Tutte le informazioni sono protette dalla più avanzata tecnologia di criptatura, dei sistemi automatici monitorizzano il gioco e assicurano che il gioco sia condotto nell'interesse dei nostri utenti.
Dopo esserti registrato potrai versare sul tuo Conto Gioco col metodo che preferisci!
© Gioco Digitale Italia - P.I. 05522130961 - Tutti i diritti riservati
| # | type | message |
|---|---|---|
| 1 | Context | initialization |
| 2 | Controller | initialization |
| 3 | Routing | match route [default] "/:module/:action/*" |
| 4 | Request | request parameters array ( 'module' => 'archive', 'action' => 'list',) |
| 5 | Creole | connect(): DSN: array ( 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'username' => '****', ), FLAGS: 1 |
| 6 | Other | GiocoAuth: cookie INVALID |
| 7 | User | user is not authenticated |
| 8 | Controller | dispatch request |
| 9 | Filter | executing filter "sfRenderingFilter" |
| 10 | Filter | executing filter "sfWebDebugFilter" |
| 11 | Filter | executing filter "sfCommonFilter" |
| 12 | Filter | executing filter "sfFlashFilter" |
| 13 | Filter | executing filter "sfExecutionFilter" |
| 14 | Action | call "archiveActions->executeList()" |
| 15 | Creole | prepareStatement(): SELECT webserver.ID, webserver.SERVER_NAME, webserver.SERVER_DNS_NAME, webserver.SERVER_PORT, webserver.THEME_ALL_LANGS, webserver.ACTIVE, webserver.DEFAULT_LANGUAGE, webserver.OWNER_ID, webserver.USERNAME, webserver.PASSWORD, webserver.GOOGLE_ANALYTICS_CODE, webserver.SERVER_DNS_ALIAS1, webserver.SERVER_DNS_ALIAS2, webserver.SERVER_DNS_ALIAS3, webserver.SERVER_DNS_ALIAS4, webserver.SERVER_DNS_ALIAS5 FROM webserver WHERE webserver.ID=? |
| 16 | Creole | applyLimit(): SELECT webserver.ID, webserver.SERVER_NAME, webserver.SERVER_DNS_NAME, webserver.SERVER_PORT, webserver.THEME_ALL_LANGS, webserver.ACTIVE, webserver.DEFAULT_LANGUAGE, webserver.OWNER_ID, webserver.USERNAME, webserver.PASSWORD, webserver.GOOGLE_ANALYTICS_CODE, webserver.SERVER_DNS_ALIAS1, webserver.SERVER_DNS_ALIAS2, webserver.SERVER_DNS_ALIAS3, webserver.SERVER_DNS_ALIAS4, webserver.SERVER_DNS_ALIAS5 FROM webserver WHERE webserver.ID=1, offset: 0, limit: 1 |
| 17 | Creole | executeQuery(): [0.18 ms] SELECT webserver.ID, webserver.SERVER_NAME, webserver.SERVER_DNS_NAME, webserver.SERVER_PORT, webserver.THEME_ALL_LANGS, webserver.ACTIVE, webserver.DEFAULT_LANGUAGE, webserver.OWNER_ID, webserver.USERNAME, webserver.PASSWORD, webserver.GOOGLE_ANALYTICS_CODE, webserver.SERVER_DNS_ALIAS1, webserver.SERVER_DNS_ALIAS2, webserver.SERVER_DNS_ALIAS3, webserver.SERVER_DNS_ALIAS4, webserver.SERVER_DNS_ALIAS5 FROM webserver WHERE webserver.ID=1 LIMIT 1 |
| 18 | Creole | prepareStatement(): SELECT syndication_client.ID, syndication_client.NAME FROM syndication_client WHERE syndication_client.ID=? |
| 19 | Creole | executeQuery(): [0.12 ms] SELECT syndication_client.ID, syndication_client.NAME FROM syndication_client WHERE syndication_client.ID=-1 |
| 20 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM (contentcategory, contentcategory_sort_by_webserver, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 21 | Creole | applyLimit(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM (contentcategory, contentcategory_sort_by_webserver, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC, offset: 0, limit: 1 |
| 22 | Creole | executeQuery(): [0.19 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM (contentcategory, contentcategory_sort_by_webserver, contentcategory_i18n) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC LIMIT 1 |
| 23 | View | initialize view for "archive/list" |
| 24 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/listSuccess.php" |
| 25 | PartialHelper | call "archive->executeCategories()" |
| 26 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 27 | Creole | executeQuery(): [0.25 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 28 | View | initialize view for "archive/_categories" |
| 29 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_categories.php" |
| 30 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 31 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=19, offset: 0, limit: 1 |
| 32 | Creole | executeQuery(): [0.17 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=19 LIMIT 1 |
| 33 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 34 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=11, offset: 0, limit: 1 |
| 35 | Creole | executeQuery(): [0.17 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=11 LIMIT 1 |
| 36 | PartialHelper | call "archive->executeSubcategories()" |
| 37 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 38 | Creole | executeQuery(): [0.23 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=11 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 39 | View | initialize view for "archive/_subcategories" |
| 40 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_subcategories.php" |
| 41 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 42 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=34, offset: 0, limit: 1 |
| 43 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=34 LIMIT 1 |
| 44 | PartialHelper | call "archive->executeSubcategories()" |
| 45 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 46 | Creole | executeQuery(): [0.22 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=34 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 47 | View | initialize view for "archive/_subcategories" |
| 48 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_subcategories.php" |
| 49 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 50 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=42, offset: 0, limit: 1 |
| 51 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=42 LIMIT 1 |
| 52 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 53 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=32, offset: 0, limit: 1 |
| 54 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=32 LIMIT 1 |
| 55 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 56 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=31, offset: 0, limit: 1 |
| 57 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=31 LIMIT 1 |
| 58 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 59 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=30, offset: 0, limit: 1 |
| 60 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=30 LIMIT 1 |
| 61 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 62 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=33, offset: 0, limit: 1 |
| 63 | Creole | executeQuery(): [0.17 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=33 LIMIT 1 |
| 64 | PartialHelper | call "archive->executeSubcategories()" |
| 65 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 66 | Creole | executeQuery(): [0.23 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=33 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 67 | View | initialize view for "archive/_subcategories" |
| 68 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_subcategories.php" |
| 69 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 70 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=23, offset: 0, limit: 1 |
| 71 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=23 LIMIT 1 |
| 72 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 73 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=21, offset: 0, limit: 1 |
| 74 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=21 LIMIT 1 |
| 75 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 76 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=14, offset: 0, limit: 1 |
| 77 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=14 LIMIT 1 |
| 78 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 79 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=12, offset: 0, limit: 1 |
| 80 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=12 LIMIT 1 |
| 81 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 82 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=13, offset: 0, limit: 1 |
| 83 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=13 LIMIT 1 |
| 84 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 85 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=43, offset: 0, limit: 1 |
| 86 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=43 LIMIT 1 |
| 87 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 88 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=5, offset: 0, limit: 1 |
| 89 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=5 LIMIT 1 |
| 90 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 91 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=36, offset: 0, limit: 1 |
| 92 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=36 LIMIT 1 |
| 93 | PartialHelper | call "archive->executeSubcategories()" |
| 94 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 95 | Creole | executeQuery(): [0.22 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=36 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 96 | View | initialize view for "archive/_subcategories" |
| 97 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_subcategories.php" |
| 98 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 99 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=6, offset: 0, limit: 1 |
| 100 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=6 LIMIT 1 |
| 101 | PartialHelper | call "archive->executeSubcategories()" |
| 102 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 103 | Creole | executeQuery(): [0.22 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=6 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 104 | View | initialize view for "archive/_subcategories" |
| 105 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_subcategories.php" |
| 106 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 107 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=28, offset: 0, limit: 1 |
| 108 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=28 LIMIT 1 |
| 109 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 110 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=27, offset: 0, limit: 1 |
| 111 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=27 LIMIT 1 |
| 112 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 113 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=4, offset: 0, limit: 1 |
| 114 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=4 LIMIT 1 |
| 115 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 116 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=8, offset: 0, limit: 1 |
| 117 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=8 LIMIT 1 |
| 118 | PartialHelper | call "archive->executeSubcategories()" |
| 119 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 120 | Creole | executeQuery(): [0.22 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=8 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 121 | View | initialize view for "archive/_subcategories" |
| 122 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/archive/_subcategories.php" |
| 123 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 124 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=18, offset: 0, limit: 1 |
| 125 | Creole | executeQuery(): [0.17 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=18 LIMIT 1 |
| 126 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 127 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=40, offset: 0, limit: 1 |
| 128 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=40 LIMIT 1 |
| 129 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 130 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=41, offset: 0, limit: 1 |
| 131 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=41 LIMIT 1 |
| 132 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=? |
| 133 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=9, offset: 0, limit: 1 |
| 134 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.PID=9 LIMIT 1 |
| 135 | View | decorate content with "sf_root_dir/web/theme/giocco_digitale_3/templates/layout.php" |
| 136 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/layout.php" |
| 137 | Creole | prepareStatement(): SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT FROM videoformat |
| 138 | Creole | executeQuery(): [0.13 ms] SELECT videoformat.ID, videoformat.NAME, videoformat.FORMAT, videoformat.WIDTH, videoformat.HEIGHT FROM videoformat |
| 139 | Creole | prepareStatement(): SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=? |
| 140 | Creole | applyLimit(): SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=1, offset: 0, limit: 1 |
| 141 | Creole | executeQuery(): [0.16 ms] SELECT frontpage.ID, frontpage.WEBSERVER_ID, frontpage.PPV_CONTENT_ID, frontpage.THUMBNAIL_NORMAL_QUALITY_SIZE, frontpage.THUMBNAIL_VIDEO_QUALITY_SIZE, frontpage.THUMBNAIL_HIGH_QUALITY_SIZE, frontpage.SHOW_CONTROLS, frontpage.SHOW_RATING, frontpage.SHOW_COMMENTS, frontpage.SHOW_BOOKMARKS, frontpage.SHOW_INDEX, frontpage.SHOW_EXTERN_LINKS, frontpage.SHOW_TELL_A_FRIEND, frontpage.SHOW_FILES, frontpage.SHOW_IMAGES, frontpage.SHOW_CREDITS, frontpage.SHOW_EMBED, frontpage.SHOW_LINK, frontpage.SHOW_CHAPTERS, frontpage.PLAYER_LOGO_ID FROM frontpage WHERE frontpage.WEBSERVER_ID=1 LIMIT 1 |
| 142 | Creole | prepareStatement(): SELECT frontpage_i18n.ID, frontpage_i18n.CULTURE, frontpage_i18n.NAME, frontpage_i18n.DESCRIPTION, frontpage_i18n.VALID, frontpage_i18n.LIVECHANNEL_ID, frontpage_i18n.FRONT_CONTENT_ID, frontpage_i18n.LIVEPLAYLIST_ID, frontpage_i18n.WIDGET_FRONT_CONTENT_ID, frontpage_i18n.VISUAL_IDENTITY_PACKAGE_ID FROM frontpage_i18n WHERE frontpage_i18n.ID=? AND frontpage_i18n.CULTURE=? |
| 143 | Creole | executeQuery(): [0.17 ms] SELECT frontpage_i18n.ID, frontpage_i18n.CULTURE, frontpage_i18n.NAME, frontpage_i18n.DESCRIPTION, frontpage_i18n.VALID, frontpage_i18n.LIVECHANNEL_ID, frontpage_i18n.FRONT_CONTENT_ID, frontpage_i18n.LIVEPLAYLIST_ID, frontpage_i18n.WIDGET_FRONT_CONTENT_ID, frontpage_i18n.VISUAL_IDENTITY_PACKAGE_ID FROM frontpage_i18n WHERE frontpage_i18n.ID=1 AND frontpage_i18n.CULTURE='it_IT' |
| 144 | Creole | prepareStatement(): SELECT live_playlist.ID, live_playlist.START_TIME, live_playlist.GENERATED_CONTENT_TIME, live_playlist.PPV_CONTENT_ID, live_playlist.SHOW_EMBED, live_playlist.SHOW_LINK, live_playlist.REPEAT_IN_SCHEDULE, live_playlist.LAST_UPDATE_TIME FROM live_playlist WHERE live_playlist.ID=? |
| 145 | Creole | executeQuery(): [0.13 ms] SELECT live_playlist.ID, live_playlist.START_TIME, live_playlist.GENERATED_CONTENT_TIME, live_playlist.PPV_CONTENT_ID, live_playlist.SHOW_EMBED, live_playlist.SHOW_LINK, live_playlist.REPEAT_IN_SCHEDULE, live_playlist.LAST_UPDATE_TIME FROM live_playlist WHERE live_playlist.ID=1 |
| 146 | PartialHelper | call "contentcategory->executeInlineList()" |
| 147 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND contentcategory_sort_by_webserver.WEBSERVER_ID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 148 | Creole | applyLimit(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC, offset: 0, limit: 30 |
| 149 | Creole | executeQuery(): [0.24 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=-2 AND contentcategory_sort_by_webserver.WEBSERVER_ID=1 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory_sort_by_webserver.CONTENTCATEGORY_ID=contentcategory.ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC LIMIT 30 |
| 150 | View | initialize view for "contentcategory/_inlineList" |
| 151 | View | render "sf_root_dir/web/theme/giocco_digitale_3/templates/contentcategory/_inlineList.php" |
| 152 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 153 | Creole | executeQuery(): [0.21 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=19 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 154 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 155 | Creole | executeQuery(): [0.24 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=11 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 156 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 157 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=34 |
| 158 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 159 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=42 |
| 160 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 161 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=42 |
| 162 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 163 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=23 |
| 164 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 165 | Creole | executeQuery(): [0.21 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=5 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 166 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 167 | Creole | executeQuery(): [0.22 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=36 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 168 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 169 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=6 |
| 170 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 171 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=28 |
| 172 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 173 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=28 |
| 174 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 175 | Creole | executeQuery(): [0.21 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=8 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 176 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=? |
| 177 | Creole | executeQuery(): [0.15 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID=18 |
| 178 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 179 | Creole | executeQuery(): [0.21 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=41 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 180 | Creole | prepareStatement(): SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=? AND webserver_has_contentcategory.WEBSERVER_ID=? AND contentcategory_i18n.VALID=? AND contentcategory_i18n.IS_AVAILABLE=? AND (contentcategory.CATEGORY_OWNER_ID=? OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE=? AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 181 | Creole | executeQuery(): [0.20 ms] SELECT DISTINCT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID, contentcategory_i18n.ID, contentcategory_i18n.CULTURE, contentcategory_i18n.VALID, contentcategory_i18n.NAME, contentcategory_i18n.COLOR, contentcategory_i18n.CCTHEME_ID, contentcategory_i18n.THUMBNAIL_ID, contentcategory_i18n.IS_AVAILABLE, contentcategory_i18n.IS_PUBLIC, contentcategory_i18n.HTML, contentcategory_i18n.DESCRIPTION, contentcategory_i18n.AUTHOR_ID FROM (contentcategory, contentcategory_i18n, contentcategory_sort_by_webserver) INNER JOIN webserver_has_contentcategory ON (contentcategory.ID=webserver_has_contentcategory.CONTENTCATEGORY_ID) WHERE contentcategory.PID=9 AND webserver_has_contentcategory.WEBSERVER_ID=1 AND contentcategory_i18n.VALID=1 AND contentcategory_i18n.IS_AVAILABLE=1 AND (contentcategory.CATEGORY_OWNER_ID=-1 OR EXISTS (SELECT * FROM contentcategory_syndicated_to_client JOIN contentcategory_syndicated_to_client_to_webserver ON contentcategory_syndicated_to_client.id = contentcategory_syndicated_to_client_to_webserver.contentcategory_syndicated_to_client_id WHERE contentcategory_syndicated_to_client.copy_contentcategory_id = contentcategory.id AND contentcategory_syndicated_to_client.syndication_client_id =-1 AND contentcategory_syndicated_to_client_to_webserver.webserver_id = 1 AND (contentcategory_syndicated_to_client.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.start_time)) AND (contentcategory_syndicated_to_client.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client.expiration_time)) AND (contentcategory_syndicated_to_client_to_webserver.start_time <= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.start_time)) AND (contentcategory_syndicated_to_client_to_webserver.expiration_time >= '2010-09-06' OR ISNULL(contentcategory_syndicated_to_client_to_webserver.expiration_time)) )) AND contentcategory_i18n.CULTURE='it_IT' AND contentcategory.ID=contentcategory_sort_by_webserver.CONTENTCATEGORY_ID AND contentcategory.ID=contentcategory_i18n.ID ORDER BY contentcategory_sort_by_webserver.RANK ASC |
| 182 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID IS NULL |
| 183 | Creole | executeQuery(): [0.19 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID IS NULL |
| 184 | Creole | prepareStatement(): SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID IS NULL |
| 185 | Creole | executeQuery(): [0.16 ms] SELECT contentcategory.ID, contentcategory.PID, contentcategory.RANK, contentcategory.SORT_BY, contentcategory.PAGER_LIMIT, contentcategory.SHOW_PAGER, contentcategory.SORT_ORDER, contentcategory.STRING_ID, contentcategory.FRONT_CONTENT_ID, contentcategory.CATEGORY_OWNER_ID, contentcategory.PPV_CONTENT_ID, contentcategory.UPDATE_TIME, contentcategory.VIDEO_PLAYER_ID, contentcategory.LIVE_PLAYLIST_ID, contentcategory.DEFAULT_SUBCATEGORY_ID, contentcategory.ENABLE_GEOLOCK, contentcategory.OVERLAY_AD_ZONE_ID, contentcategory.INLINE_AD_ZONE_ID, contentcategory.PLAYER_LOGO_ID FROM contentcategory WHERE contentcategory.ID IS NULL |
vars & config
logs & msgs
57
6429.2 KB
424 ms
---
parameterHolder:
symfony/default:
action: list
module: archive
attributeHolder:
symfony/default:
---
cookies:
httpHeaders:
Content-Type: text/html; charset=utf-8
parameterHolder:
helper/asset/auto/httpmeta:
Content-Type: text/html; charset=utf-8
helper/asset/auto/javascript:
/sf/prototype/js/prototype: /sf/prototype/js/prototype
/sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
helper/asset/auto/meta:
description: K.iTV, Internet Television
dottv: Softing (http://www.eu-softing.com)
keywords: K.iTV, Internet, Television
robots: index, follow
title: K.iTV 2.0
helper/asset/auto/stylesheet:
/sf/sf_web_debug/css/main:
symfony/response/http/headers:
Content-Type: text/html; charset=utf-8
symfony/view/asset:
javascripts_included:
stylesheets_included:
---
app_sfCaptchaGDPlugin_routes_register:
dottv2_common_cookie_domain:
dottv2_hash_key_iv: abc123+=
dottv2_hash_key_secret: >
Softing d.o.o. secret key for hashkey
algo
dottv_adserver_config_dir: >
http://static004.ksoft.tv/production.giocodigitale/openx/ads-config/
dottv_designer_css_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/css/
dottv_designer_flash_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/flash/
dottv_designer_image_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/images/
dottv_designer_js_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/js/
dottv_designer_min_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/min/
dottv_designer_silverlight_dir: /theme/giocco_digitale_3/silverlight/
dottv_designer_template_dir: >
/var/www/vcms/giocodigitale/web/theme/giocco_digitale_3/templates
dottv_designer_theme: giocco_digitale_3
dottv_designer_xml_dir: >
http://static004.ksoft.tv/production.giocodigitale/theme/giocco_digitale_3/xml/
dottv_openx_dir: >
http://static004.ksoft.tv/production.giocodigitale/openx/
dottv_sponsors_upload_dir: >
http://static004.ksoft.tv/production.giocodigitale/uploads/sponsors/
enable_multiple_login: 1
enable_packages:
error_404_url: http://www.pokerdigitale.it/blog/error
i_am_live_report_frequency: 86400
kitv_external_autentication_class: GiocoAuth
kitv_search_on_whole_words: 1
kitv_static_webroot: >
http://static004.ksoft.tv/production.giocodigitale
mobile_dns_names:
tv.pokerdigitale.it: iphone.gdpoker.ksoft.tv
tv.gdpoker.it: iphone.gdpoker.ksoft.tv
tv.giocodigitale.it: iphone.gdpoker.ksoft.tv
staging.giocodigitale.ksoft.tv: iphone.giocodigitale.ksoft.tv
mod_archive_enabled: 1
mod_archive_is_internal:
mod_archive_view_class: my
mod_contentcategory_enabled: 1
mod_contentcategory_is_internal:
mod_contentcategory_view_class: my
openx_conf:
server_url: http://openx.ksoft.tv/
affiliate_id: 3
manager_username:
manager_password:
default_vod_overlay_zone: 8
default_live_overlay_zone: 6
default_vod_inline_zone: 0
default_live_inline_zone: 0
paypal_ipn_notify_email: mujo.kodro@eu-softing.com
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: >
/var/www/vcms/giocodigitale/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
/var/www/vcms/giocodigitale/apps/frontend
sf_app_i18n_dir: >
/var/www/vcms/giocodigitale/web/theme/giocco_digitale_3/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
/var/www/vcms/giocodigitale/apps/frontend/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: >
/var/www/vcms/giocodigitale/apps/frontend/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: >
/var/www/vcms/giocodigitale/apps/frontend/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_asx_dir: >
/var/www/vcms/giocodigitale/web/uploads/asx
sf_asx_dir_name: asx
sf_autoloading_functions:
sf_available: 1
sf_backend_dns_name: tv.gdpoker.it
sf_backend_menu:
-
group_title: Home
group_items:
-
title: Frontpage
module: frontpage
action: list
-
group_title: Content Statistics
group_items:
-
title: Content library
module: content_library_stats
action: list
-
title: Most viewed contents
module: content_library_stats
action: mostview
-
group_title: Vod
group_items:
-
title: Media Contents
module: content
action: list
-
title: VOD Channels
module: contentcategory
action: list
-
title: Playlists
module: playlist
action: list
-
title: Authors
module: author
action: list
-
title: Thumbnails
module: thumbnail
action: list
-
title: Artists
module: writer
action: list
-
title: Tags
module: tag
action: list
-
title: Players
module: videoplayer
action: list
-
title: Player Logos
module: player_logo
action: list
-
group_title: Playout
group_items:
-
title: Live Channel WM
module: livechannel
action: list
-
title: Live Playlist FLV
module: live_playlist
action: list
-
title: Live Broadcast Messages
module: livemessage
action: list
-
group_title: Advertising
group_items:
-
title: Video Ads
module: comercial
action: list
-
title: Banners
module: sponsor
action: list
-
group_title: Interactivity
group_items:
-
title: Comments
module: comment
action: list
-
title: Polls
module: poll
action: list
-
title: RSS Ticker
module: scroll
action: list
-
title: Static Pages
module: staticpage
action: list
-
title: Bookmark and Share
module: bookmark_and_share
action: list
-
title: Press Release
module: pressrelease
action: list
-
group_title: Subscribers
group_items:
-
title: Registred Users
module: frontend_user
action: list
-
title: User Groups Administration
module: frontendusergroup
action: list
-
title: Subscritpion Packages
module: package
action: list
-
title: Subscritpion Packages PPV content
module: package_contentcategory_has_content
action: list
-
title: Mailing List
module: maillist
action: list
-
group_title: Podcast
group_items:
-
title: Podcast
module: podcast
action: list
-
group_title: Ugc
group_items:
-
title: User Generated Content
module: usergeneratedcontent
action: list
-
group_title: Syndication
group_items:
-
title: Content Syndication Center
module: contentsyndicationcenter
action: list
-
title: Syndacation Clients
module: syndication_client
action: list
-
title: Syndication Messages
module: syndication_messages
action: list
-
group_title: K.iTV SETUP MENU
group_items:
-
group_title: Administrators
group_items:
-
title: Users
module: user
action: list
-
title: Roles
module: role
action: list
-
group_title: Cdn
group_items:
-
title: Webservers
module: webserver
action: list
-
title: Streamingservers
module: streamingserver
action: list
-
title: Countries
module: country
action: list
-
title: Streaming Server Type
module: streamingservertype
action: list
-
title: Storage Servers
module: dataserver
action: list
-
title: Podcast Storage
module: podcast_storage
action: list
-
group_title: Transcoding
group_items:
-
title: Transcoder Server
module: transcoderserver
action: list
-
title: Transcoder Profile
module: transcoderprofile
action: list
-
title: Transcoder Tasks
module: transcodertask
action: list
-
title: Watch Folders
module: watchfolder
action: list
-
title: Watch Folder Transcoding Task
module: watchfoldertranscodingtask
action: list
-
title: UGC Generate Config
module: usergenerateconfig
action: list
-
group_title: Interactivity Modules Setup
group_items:
-
title: Extern Link Type
module: externlink_type
action: list
-
group_title: K.iTV Layout
group_items:
-
title: Template Engine
module: cctheme
action: list
-
group_title: Multilanguage Configuration
group_items:
-
title: Language
module: language
action: list
-
title: Backend Languages
module: languagebackend
action: list
-
group_title: VOD Configuration
group_items:
-
title: Media Edition
module: mediaedition
action: list
-
title: Media Type
module: mediafiletype
action: list
-
title: Media Aspect Ratio
module: videoformats
action: list
-
group_title: Debug
group_items:
-
title: Error Logs
module: sfErrorLog
action: list
-
title: FFmpeg Logs
module: ffmpeglog
action: list
-
group_title: Affiliate
group_items:
-
title: Affilate users
module: affiliate_user
action: list
-
title: Payment invoices
module: affiliate_invoice
action: list
-
title: Statistics
module: affiliate_statistics
action: >
index?filters[day]=&filters[mounth]=&filters[year]=0&filters[show_visits]=1&filters[show_registered]=1&filters[show_transactions]=1&filters[show_percentage_profit]=1&filter=filter
-
title: Configurator
module: affiliate_config
action: list
sf_backend_script_name: /backend.php
sf_backend_webroot: http://tv.gdpoker.it
sf_base_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend
sf_bibliographies_dir_name: bibliographies
sf_bin_dir: /var/www/vcms/giocodigitale/batch
sf_bin_dir_name: batch
sf_cache:
sf_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock:
sf_check_symfony_version:
sf_compressed:
sf_config_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/config
sf_config_dir: /var/www/vcms/giocodigitale/config
sf_config_dir_name: config
sf_content_images_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/content_images/
sf_credits_dir_name: credits
sf_data_dir: /var/www/vcms/giocodigitale/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_cache_lifetime: 31536000
sf_default_module: default
sf_doc_dir: /var/www/vcms/giocodigitale/data/doc
sf_doc_dir_name: doc
sf_enabled_modules:
- default
- sfCaptchaGD
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: frontpage
sf_error_log_mail: production@eu-softing.com
sf_error_reporting: 4095
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag:
sf_feed_no_download_link: true
sf_files_dir: >
/var/www/vcms/giocodigitale/web/uploads/files
sf_files_dir_name: files
sf_i18n: 1
sf_i18n_cache: 1
sf_i18n_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/i18n/web/theme/giocco_digitale_3
sf_i18n_debug:
sf_i18n_default_culture: it_IT
sf_i18n_source: XLIFF
sf_i18n_untranslated_prefix: [T]
sf_i18n_untranslated_suffix: [/T]
sf_interactivity_modules:
poll: Polls
podcast: Podcasts
search: Search
videogallery: Video gallery
sf_lib_dir: /var/www/vcms/giocodigitale/lib
sf_lib_dir_name: lib
sf_log_dir: /var/www/vcms/giocodigitale/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate:
sf_login_action: login
sf_login_module: frontend_user
sf_max_forwards: 5
sf_menu:
- Content Modules
- Syndication
- Addin Modules
- CDN Modules
- Setup Modules
sf_model_dir: /var/www/vcms/giocodigitale/lib/model
sf_model_dir_name: model
sf_model_lib_dir: /var/www/vcms/giocodigitale/lib/model
sf_module_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/modules
sf_module_dirs:
/var/www/vcms/giocodigitale/cache/frontend/dev/modules: 1
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name:
sf_orm: propel
sf_password_recovery_mail: info@tv.gdpoker.it
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_player_logo_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/player_logo/
sf_plugins_dir: /var/www/vcms/giocodigitale/plugins
sf_plugins_dir_name: plugins
sf_podcast_files: /uploads/podcast_files/
sf_poll_images_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/poll_images/
sf_pool_upload_dir: >
/var/www/vcms/giocodigitale/web/uploads/poll_images
sf_pool_upload_dir_name: uploads/poll_images
sf_preloader_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/preloader_files/
sf_preloaders_dir: >
/var/www/vcms/giocodigitale/web/uploads/preloader_files
sf_preloaders_dir_name: preloader_files
sf_pressrelease_dir_webroot: /uploads/press_release
sf_prototype_web_dir: /sf/prototype
sf_reg_noti_mail: users@tv.gdpoker.it
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /var/www/vcms/giocodigitale/cache
sf_root_dir: /var/www/vcms/giocodigitale
sf_routing_defaults:
sf_culture: it_IT
sf_saleitem_dir_name: saleitems_files
sf_secure_action: secure
sf_secure_module: default
sf_sponsor_dir_name: sponsors
sf_standard_helpers:
- Partial
- Cache
- Form
sf_stats:
sf_strip_comments: 1
sf_subtitles_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/subtitles/
sf_suffix: .
sf_symfony_data_dir: /var/www/vcms/giocodigitale/data/symfony
sf_symfony_lib_dir: /var/www/vcms/giocodigitale/lib/symfony
sf_temp_dir: /var/www/vcms/giocodigitale/web/temp/
sf_temp_gen_thumbs: temp/gen_thumbs/
sf_temp_web_root: http://tv.gdpoker.it/temp/
sf_template_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/template
sf_test:
sf_test_cache_dir: >
/var/www/vcms/giocodigitale/cache/frontend/dev/test
sf_test_dir: /var/www/vcms/giocodigitale/test
sf_test_dir_name: test
sf_theme_dir: /var/www/vcms/giocodigitale/web/theme
sf_thumbnails_dir: >
/var/www/vcms/giocodigitale/web/uploads/thumbnails
sf_thumbnails_dir_name: thumbnails
sf_thumbnails_webroot: >
http://static004.ksoft.tv/production.giocodigitale/uploads/thumbnails/
sf_timeout: 86400
sf_timer_start: 1283792996.58
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /var/www/vcms/giocodigitale/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:
sf_validation_error_suffix:
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/vcms/giocodigitale/web
sf_web_dir_name: web
sf_wsx_dir: /var/www/vcms/giocodigitale/data/wsx
supervisor_syndicate_contents:
tv_use_wmv:
---
cookie:
dottv2frontend: 325112a3db0491d6ab096e6d1bc3a8aa
env:
LANG: C
PATH: /usr/local/bin:/usr/bin:/bin
PWD: /root
SHLVL: 1
_: /usr/sbin/apache2
files:
get:
post:
server:
DOCUMENT_ROOT: /var/www/vcms/giocodigitale/web
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: >
text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING: gzip
HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
HTTP_CACHE_CONTROL: no-cache
HTTP_CONNECTION: close
HTTP_COOKIE: >
dottv2frontend=325112a3db0491d6ab096e6d1bc3a8aa
HTTP_HOST: tv.gdpoker.it
HTTP_PRAGMA: no-cache
HTTP_USER_AGENT: >
CCBot/1.0
(+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID: ccc02-01
PATH: /usr/local/bin:/usr/bin:/bin
PATH_INFO: /archive/list
PATH_TRANSLATED: redirect:/index.php/list
PHP_SELF: /frontend_dev.php/archive/list
QUERY_STRING:
REMOTE_ADDR: 38.107.191.94
REMOTE_PORT: 22947
REQUEST_METHOD: GET
REQUEST_TIME: 1283792996
REQUEST_URI: /frontend_dev.php/archive/list
SCRIPT_FILENAME: >
/var/www/vcms/giocodigitale/web/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 94.75.214.154
SERVER_ADMIN: m.panc@ksoft.tv
SERVER_NAME: tv.gdpoker.it
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: |
<address>Apache/2.2.3 (Debian) PHP/5.2.0-8+etch15 Server at tv.gdpoker.it Port 80</address>
SERVER_SOFTWARE: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch15
UNIQUE_ID: WYawyF5L1poAAAh3kyoAAAAE
argc: 0
argv:
session:
symfony/user/sfUser/attributes:
tv.gdpoker.it:
webserver_id: 1
default_culture: it_IT
it_IT:
theme: giocco_digitale_3
symfony/user/sfUser/attributes:
frontend_culture: it_IT
category_id: 14
category_selected_id: 14
content_show: 1
symfony/user/sfUser/authenticated:
symfony/user/sfUser/credentials:
symfony/user/sfUser/culture: it_IT
symfony/user/sfUser/lastRequest: 1283792962
--- php: 5.2.0-8+etch15 os: > Linux DIN004 2.6.18-6-686 #1 SMP Fri Dec 12 16:48:28 UTC 2008 i686 extensions: - zip - xmlwriter - libxml - xml - wddx - tokenizer - sysvshm - sysvsem - sysvmsg - session - SimpleXML - sockets - soap - SPL - shmop - standard - Reflection - posix - mime_magic - mbstring - json - iconv - hash - gettext - ftp - filter - exif - dom - dba - date - ctype - calendar - bz2 - bcmath - zlib - pcre - openssl - xmlreader - apache2handler - uploadprogress - curl - eAccelerator - gd - mysql - mysqli - PDO - pdo_mysql
| type | calls | time (ms) |
|---|---|---|
| Configuration | 21 | 113.51 |
| Action "archive/list" | 1 | 11.13 |
| Database | 57 | 9.97 |
| View "Success" for "archive/list" | 1 | 193.56 |
| Component "archive/categories" | 1 | 5.18 |
| Partial "archive/_categories" | 1 | 74.52 |
| Component "archive/subcategories" | 6 | 23.94 |
| Partial "archive/_subcategories" | 6 | 38.25 |
| Component "contentcategory/inlineList" | 1 | 5.60 |
| Partial "contentcategory/_inlineList" | 1 | 46.43 |