MODE DEBUG
PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="emissions"
SELECT COUNT(1) count FROM ga_page WHERE page_url="emissions" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="70" AND page_url="les-oreilles-de-jankev-27-10-2012"
Page::getPageDynamic
Page::getModels
SELECT model_name FROM ga_model WHERE model_type="page"
SELECT id_utilisateur, page_name, page_title, page_description, page_keywords FROM ma_utilisateur WHERE page_url="les-oreilles-de-jankev-27-10-2012"
SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="les-oreilles-de-jankev-27-10-2012"
SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="les-oreilles-de-jankev-27-10-2012"
SELECT id_emission, page_name, page_title, page_description, page_keywords FROM ma_emission WHERE page_url="les-oreilles-de-jankev-27-10-2012"
SELECT id_page,page_link FROM ga_page WHERE page_url="emission"
SELECT page_url FROM ga_page WHERE id_page="70"
SELECT page_url FROM ga_page WHERE id_page="8"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="emission" AND page_type="1"
Page::getCssPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="8" AND file_extension="css" ORDER BY ga_file_page.id_file_page
Page::getJsPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="8" AND file_extension="js" ORDER BY ga_file_page.id_file_page
Page::getRSSPage
SELECT rss_url,rss_description FROM ga_rss,ga_page_rss WHERE ga_page_rss.id_page='8' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Site::getConfig
SELECT * FROM ga_config
PageBuilderPublic::buildPage
dataflow::__construct
dataflow::getDataflowQueries
Récupération des requêtes supplémentaires.
SELECT ga_query.id_query, ga_query_asso.query_asso_order, ga_query.query_column, ga_query.query_table, ga_query.query_where, ga_query.query_group, ga_query.query_order, ga_query.query_left, ga_query.query_on, ga_query.query_list, ga_query.query_limit, ga_query.query_type, ga_query.query_log, ga_query.query_output_name, ga_fileprocess.fileprocess_name FROM ( ga_dataflow, ga_query, ga_query_asso) LEFT JOIN ga_fileprocess ON ga_dataflow.id_fileprocess=ga_fileprocess.id_fileprocess WHERE ga_dataflow.dataflow_name="emission" AND ga_dataflow.id_dataflow=ga_query_asso.id_dataflow AND ga_query.id_query=ga_query_asso.id_query ORDER BY ga_query_asso.query_asso_order, ga_query.query_list
SELECT ma_emission.id_emission, ma_emission.page_name, ma_emission.page_url, ma_emission.page_title, ma_emission.page_description, ma_emission.page_keywords, ma_emission.emission_datetime, ma_emission.emission_datetime_fin, ma_emission.emission_duree, ma_emission.emission_sujet, ma_emission.emission_entete, ma_emission.emission_description, ma_emission.emission_audio, ma_emission.id_playlist_emission, ma_programme.programme_nom, ma_programme.programme_description, ma_media.media_name, ma_media.media_description, ma_programme.page_url media_repertoire, ma_programme.id_programme FROM ( ma_emission) LEFT JOIN ma_programme ON ma_programme.id_programme=ma_emission.id_programme LEFT JOIN ma_media ON ma_media.id_programme=ma_emission.id_programme WHERE ma_emission.page_url="les-oreilles-de-jankev-27-10-2012"
SELECT ma_media.media_name emission_media_name, ma_media.media_description emission_media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="les-oreilles-de-jankev-27-10-2012" AND media_type='une'
SELECT ma_evenement.page_url, ma_evenement.evenement_nom, ma_evenement.evenement_type, ma_evenement.evenement_debut, ma_evenement.evenement_entete, ma_evenement.evenement_etat, ma_media.media_name FROM ( ma_evenement) LEFT JOIN ma_media ON ma_media.id_evenement=ma_evenement.id_evenement WHERE ma_evenement.evenement_debut>=NOW() AND ma_evenement.evenement_etat='2' ORDER BY ma_evenement.evenement_debut ASC LIMIT 5
SELECT ma_tag.tag_name FROM ( ma_emission) LEFT JOIN ma_tag ON ma_tag.id_programme=ma_emission.id_programme WHERE ma_emission.page_url="les-oreilles-de-jankev-27-10-2012"
SELECT ma_emission.page_url, ma_emission.emission_datetime, ma_emission.emission_entete, ma_programme.programme_nom, programme_entete, ma_media.media_name FROM ( ma_emission) LEFT JOIN ma_programme ON ma_programme.id_programme=ma_emission.id_programme LEFT JOIN ma_media ON ma_media.id_programme=ma_emission.id_programme WHERE ma_emission.emission_datetime>=CURDATE() AND ma_emission.emission_datetime<=CURDATE()+1 ORDER BY ma_emission.emission_datetime ASC
SELECT ma_media.media_name, ma_media.media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="les-oreilles-de-jankev-27-10-2012" AND ma_media.media_type='son'
SELECT ma_commentaire.id_commentaire, ma_commentaire.commentaire_name, ma_commentaire.commentaire_contenu, ma_commentaire.commentaire_date, ma_commentaire.commentaire_auteur, ma_commentaire.id_article, ma_commentaire.id_emission, ma_commentaire.commentaire_email FROM ( ma_commentaire) LEFT JOIN ma_emission ON ma_commentaire.id_emission=ma_emission.id_emission WHERE ma_emission.page_url="les-oreilles-de-jankev-27-10-2012" AND ma_commentaire.commentaire_status=1 ORDER BY ma_commentaire.commentaire_date ASC
Appel d'un fichier de post-traitement : /action/process/dataflow/emissions_programme.php
SELECT ma_emission.emission_datetime,ma_emission.page_url,ma_emission.emission_sujet
FROM ma_emission
WHERE id_programme='32' AND
emission_datetime<=CURRENT_DATE()
ORDER BY emission_datetime DESC
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='32' AND
emission_datetime>=NOW()
ORDER BY emission_datetime ASC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='32' AND
emission_datetime<'2012-10-27 20:00:00'
ORDER BY emission_datetime DESC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='32' AND
emission_datetime>'2012-10-27 20:00:00'
ORDER BY emission_datetime ASC
LIMIT 1
SELECT id_em_titre, em_titre_name, em_titre_artiste,
id_emission, em_titre_label, em_titre_annee,
em_titre_album, em_titre_site, em_titre_facebook,
em_titre_twitter, em_titre_bandcamp, em_titre_myspace,
em_titre_soundcloud, em_titre_mixcloud, em_titre_ra,
em_titre_youtube, em_titre_vimeo, em_titre_discogs,
em_titre_cover
FROM ma_em_titre
WHERE id_emission='1158'
Données envoyés au template :
Array
(
[id_emission] => 1158
[page_name] => Les oreilles de Jankev - 27/10/2012
[page_url] => les-oreilles-de-jankev-27-10-2012
[page_title] => Les oreilles de Jankev - 27/10/2012
[page_description] =>
[page_keywords] =>
[emission_datetime] => 2012-10-27 20:00:00
[emission_datetime_fin] => 2012-10-27 20:59:00
[emission_duree] => 59
[emission_sujet] => Saison 3 - Emission 3 | Gaïo
[emission_entete] =>
[emission_description] => La playlist :
01 // Bufi - Will Be
02 // Matt & Kim - Let’s Go
03 // Of Montreal – Our Love is Senile
04 // Exotica - Conte d’été (Afrofunk Version)
05 // Stealing Sheep – Genevieve
06 // La rencontre – Gaïo
07 // Gaïo - Hello
08 // David Dallas - Don’t Want The World
09 // Illy – Where Ya Been Ft. Pez
10 // Kylie Auldist - Changes
11 // Le morceau mystère : Don Johnson Big Band - Rip It Up
12 // Larry Graham - Raise Up (feat. Prince)
[emission_audio] =>
[id_playlist_emission] => 0
[programme_nom] => Les oreilles de Jankev
[programme_description] =>
Retrouvez dans Les oreilles de Jankev, toute l'actu musique, les meilleurs disques du moment passés sous les oreilles aiguisées de Jankev. De la pop à la soul, en passant par le hip hop et le rock puis l'afro beat et la funk actuelle, les oreilles ratissent large pour vous dénicher les meilleurs titres du moment. Et de surcroît, retrouvez en interview les artistes qui font l'actu !
Retrouvez les playlist détaillées des émissions, des mix et autres friandises sur le site des Oreilles de Jankev : www.lesoreillesdejankev.com
Ils sont passés dans les 2 saisons dernières :
Saison 1 : Féfé / Ursus Minor / Arther / Quadricolor / Lisa Portelli / Manceau / Elephanz / Smooth / Success / Neonbirds / Fortune / Nasser / The Souljazz Orchestra / Discodeine / Hervé Salters aka General Elektriks / Örsten / Misteur Valaire / Stupeflip / Dilemn / Emilie Chick / Blundetto.
Saison 2 : Backpack Jax / La Femme / Chinese Man / Housse de Racket / Maya Barsony / Hushpuppies / Stuck In The Sound / Juveniles / Rover / Elephanz (bis) / Badume's Band / Hyphen Hyphen / Papier Tigre / Chairlift / Oh Tiger Mountain / Applause / Wankin' Noodles / Malted Milk / Revolver / Of Montreal / François and The Atlas Mountain / C2C.
[media_name] => 2012-09-27-68cf8f7fdb5278e310c41aadbb1ac382.jpg
[media_description] => Oreilles de Jankev
[media_repertoire] => les-oreilles-de-jankev
[id_programme] => 32
[evenements_liste] => Array
(
[0] => Array
(
[page_url] => ozma-raha-22-05-2013
[evenement_nom] => Ozma + Raha
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 20:30:00
[evenement_entete] => Concert - Jazz
[evenement_etat] => 2
[media_name] => 2013-05-14-75a6e5c1f7dc2d800e8c228ba9768e8f.jpg
)
[1] => Array
(
[page_url] => dillinger-22-05-2013
[evenement_nom] => Dillinger
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 20:30:00
[evenement_entete] => Film - Braqueurs de banque
[evenement_etat] => 2
[media_name] => 2013-05-13-c801c7683d7efe59efa8373d62149f49.jpg
)
[2] => Array
(
[page_url] => takataka-poesie-22-05-2013
[evenement_nom] => Takataka Poésie
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 21:00:00
[evenement_entete] => Soirée slam avec Nina Kibuanda
[evenement_etat] => 2
[media_name] => 2013-05-17-24763fdc84b941c3c251fa6a6d41d345.jpg
)
[3] => Array
(
[page_url] => tac-taking-haart-23-05-2013
[evenement_nom] => TAC, Taking Haart
[evenement_type] => partenaire
[evenement_debut] => 2013-05-23 18:30:00
[evenement_entete] => Projection / débat
[evenement_etat] => 2
[media_name] => 2013-05-13-a0580099e27fff995789d451f223e1b5.jpg
)
[4] => Array
(
[page_url] => nautilis-23-05-2013
[evenement_nom] => Nautilis
[evenement_type] => partenaire
[evenement_debut] => 2013-05-23 20:30:00
[evenement_entete] => Concert - Jazz
[evenement_etat] => 2
[media_name] => 2013-05-14-957ac5356248a1d87300ed1800154dbe.jpg
)
)
[tags_liste] => Array
(
[0] => Array
(
[tag_name] => hip hop
)
[1] => Array
(
[tag_name] => pop
)
[2] => Array
(
[tag_name] => soul
)
[3] => Array
(
[tag_name] => rock
)
[4] => Array
(
[tag_name] => afro
)
[5] => Array
(
[tag_name] => funk
)
[6] => Array
(
[tag_name] => actualité musique
)
[7] => Array
(
[tag_name] => sorties
)
[8] => Array
(
[tag_name] => rencontres
)
)
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => jay-deemension-22-05-2013
[emission_datetime] => 2013-05-22 00:00:00
[emission_entete] => Du BeatMaking t'en entends pas partout alors écoutes Jay Deemension !
[programme_nom] => Jay Deemension
[programme_entete] => Immersion dans l'univers de la musique alternative et expérimentale
[media_name] => 2012-09-24-0529e7108d5c613b911e34afdf93d6de.jpg
)
[1] => Array
(
[page_url] => la-matinale-22052013
[emission_datetime] => 2013-05-22 07:00:00
[emission_entete] =>
[programme_nom] => La Matinale
[programme_entete] => Réveillez-vous avec l'actualité locale, nationale et internationale
[media_name] => 2012-12-17-e774b6059eeabd80af2b2e794bbf3b51.jpg
)
[2] => Array
(
[page_url] => ghetto-blaster-22-05-2013
[emission_datetime] => 2013-05-22 17:00:00
[emission_entete] => Diderot - Les Ephémères - Go to Togo
[programme_nom] => Ghetto Blaster
[programme_entete] => Magazine quotidien de 2h dédiées à l'actualité culturelle locale
[media_name] => 2013-04-15-24e3d517441a03b1abb0ab0ba4e2c3a4.jpg
)
[3] => Array
(
[page_url] => le-labo-des-savoirs-22052013
[emission_datetime] => 2013-05-22 19:00:00
[emission_entete] => Le Labo des savoirs explore le Big Bang
[programme_nom] => Le Labo des Savoirs
[programme_entete] => L'émission scientifique de Prun'
[media_name] => 2012-09-26-22d3fdd9d93a84f28ba40ff129059ae2.jpg
)
[4] => Array
(
[page_url] => un-diner-sur-lherbe-22-05-2013
[emission_datetime] => 2013-05-22 20:00:00
[emission_entete] =>
[programme_nom] => Un dîner sur l'herbe
[programme_entete] => Sélection éclectique avec de l'actualité et des découvertes musicales
[media_name] => 2012-10-10-8af495c66a69b4640eaec2ea96c1fe36.jpg
)
[5] => Array
(
[page_url] => gimme-some-more-22-05-2013
[emission_datetime] => 2013-05-22 21:00:00
[emission_entete] =>
[programme_nom] => Gimme Some More
[programme_entete] => Une émission soul funk afro latino hip hop rock.... and more !
[media_name] => 2012-09-26-5293800dec8459ae270380626d067731.jpg
)
[6] => Array
(
[page_url] => house-2-couette-22-05-2013
[emission_datetime] => 2013-05-22 22:00:00
[emission_entete] =>
[programme_nom] => House 2 Couette
[programme_entete] => Découverte des musiques électroniques
[media_name] => 2012-10-02-62e935733dfe49c8bce669af6e10ef00.jpg
)
[7] => Array
(
[page_url] => abstrackgram-22-05-2013
[emission_datetime] => 2013-05-22 23:00:00
[emission_entete] =>
[programme_nom] => Abstrack'Gram
[programme_entete] => Musiques underground électroniques et éclectiques !
[media_name] => 2012-09-25-1e790e2c56bbbf073ce09f234381c343.jpg
)
[8] => Array
(
[page_url] => evan-dream-on-the-mix-23-05-2013
[emission_datetime] => 2013-05-23 00:00:00
[emission_entete] =>
[programme_nom] => Evan Dream On the Mix
[programme_entete] => 2H de Mix autour des musiques électroniques
[media_name] => 2012-09-25-d7fd483399938bb8a372bb07e4a160a4.jpg
)
)
[podcast_liste] => Array
(
[0] => Array
(
[media_name] => les-oreilles-de-jankev-20121027-1.mp3
[media_description] => Les oreilles de Jankev 27/10/2012 Partie 1
)
)
[emissions_passees_liste] => Array
(
[0] => Array
(
[emission_datetime] => 2013-05-18 20:00:00
[page_url] => les-oreilles-de-jankev-18-05-2013
[emission_sujet] => Saison 2 - Episode 24
)
[1] => Array
(
[emission_datetime] => 2013-05-11 20:00:00
[page_url] => les-oreilles-de-jankev-11-05-2013
[emission_sujet] =>
)
[2] => Array
(
[emission_datetime] => 2013-05-04 20:00:00
[page_url] => les-oreilles-de-jankev-04-05-2013
[emission_sujet] =>
)
[3] => Array
(
[emission_datetime] => 2013-04-27 20:00:00
[page_url] => les-oreilles-de-jankev-27-04-2013
[emission_sujet] => Saison 2 - Episode 23
)
[4] => Array
(
[emission_datetime] => 2013-04-20 20:00:00
[page_url] => les-oreilles-de-jankev-20-04-2013
[emission_sujet] => Saison 3 - Episode 22 | Cody Chesnutt
)
[5] => Array
(
[emission_datetime] => 2013-04-13 20:00:00
[page_url] => les-oreilles-de-jankev-13-04-2013
[emission_sujet] => Saison 3 - Episode 21
)
[6] => Array
(
[emission_datetime] => 2013-04-06 20:00:00
[page_url] => les-oreilles-de-jankev-06-04-2013
[emission_sujet] => Saison 3 - Episode 20 | Wax Taylor
)
[7] => Array
(
[emission_datetime] => 2013-03-30 20:00:00
[page_url] => les-oreilles-de-jankev-30-03-2013
[emission_sujet] => Saison 3 - Episode 19 | Rémi Kolpa Kopoul & Sebastien Vidal
)
[8] => Array
(
[emission_datetime] => 2013-03-23 20:00:00
[page_url] => les-oreilles-de-jankev-23-03-2013
[emission_sujet] => Saison 3 - Episode 18 | Balthazar
)
[9] => Array
(
[emission_datetime] => 2013-03-16 20:00:00
[page_url] => les-oreilles-de-jankev-16-03-2013
[emission_sujet] =>
)
[10] => Array
(
[emission_datetime] => 2013-03-09 20:00:00
[page_url] => les-oreilles-de-jankev-09-03-2013
[emission_sujet] => Saison 3 - Episode 17
)
[11] => Array
(
[emission_datetime] => 2013-03-02 20:00:00
[page_url] => les-oreilles-de-jankev-02-03-2013
[emission_sujet] => Saison 3 - Episode 16 | Lilly Wood & The Prick
)
[12] => Array
(
[emission_datetime] => 2013-02-23 20:00:00
[page_url] => les-oreilles-de-jankev-23-02-2013
[emission_sujet] => Saison 3 - Emission 15
)
[13] => Array
(
[emission_datetime] => 2013-02-16 20:00:00
[page_url] => les-oreilles-de-jankev-16-02-2013
[emission_sujet] => Saison 3 - Emission 14 | Concrete Knives
)
[14] => Array
(
[emission_datetime] => 2013-02-09 20:00:00
[page_url] => les-oreilles-de-jankev-09-02-2013
[emission_sujet] => Saison 3 - Emission 13 | Soul Square
)
[15] => Array
(
[emission_datetime] => 2013-02-02 20:00:00
[page_url] => les-oreilles-de-jankev-02-02-2013
[emission_sujet] =>
)
[16] => Array
(
[emission_datetime] => 2013-01-26 20:00:00
[page_url] => les-oreilles-de-jankev-26-01-2013
[emission_sujet] => Saison 3 - Emission 12 | La Gale
)
[17] => Array
(
[emission_datetime] => 2013-01-19 20:00:00
[page_url] => les-oreilles-de-jankev-19-01-2013
[emission_sujet] => Saison 3 - Emission 11 | Hugh Coltman
)
[18] => Array
(
[emission_datetime] => 2013-01-12 20:00:00
[page_url] => les-oreilles-de-jankev-12-01-2013
[emission_sujet] => Saison 3 - Emission 10 | Rétrospective 2012
)
[19] => Array
(
[emission_datetime] => 2013-01-05 20:00:00
[page_url] => les-oreilles-de-jankev-05-01-2013
[emission_sujet] => Rediffusion
)
[20] => Array
(
[emission_datetime] => 2012-12-22 20:00:00
[page_url] => les-oreilles-de-jankev-22-12-2012
[emission_sujet] => Saison 3 - Emission 9 | Naive New Beaters
)
[21] => Array
(
[emission_datetime] => 2012-12-08 20:00:00
[page_url] => les-oreilles-de-jankev-08-12-2012
[emission_sujet] => Saison 3 - Emission 8 | Chlorine Free
)
[22] => Array
(
[emission_datetime] => 2012-12-01 20:00:00
[page_url] => les-oreilles-de-jankev-01-12-2012
[emission_sujet] => Saison 3 - Rediffusion de l'émission spéciale Transmusicales de Rennes 2012
)
[23] => Array
(
[emission_datetime] => 2012-11-24 20:00:00
[page_url] => les-oreilles-de-jankev-24-11-2012
[emission_sujet] => Saison 3 - Emission 7
)
[24] => Array
(
[emission_datetime] => 2012-11-17 20:00:00
[page_url] => les-oreilles-de-jankev-17-11-2012
[emission_sujet] => Saison 3 - Emission 6 | Spéciale 34ème Transmusicales de Rennes
)
[25] => Array
(
[emission_datetime] => 2012-11-10 20:00:00
[page_url] => les-oreilles-de-jankev-10-11-2012
[emission_sujet] => Saison 3 - Emission 5 | Framix
)
[26] => Array
(
[emission_datetime] => 2012-11-03 20:00:00
[page_url] => les-oreilles-de-jankev-03-11-2012
[emission_sujet] => Saison 3 - Emission 4
)
[27] => Array
(
[emission_datetime] => 2012-10-27 20:00:00
[page_url] => les-oreilles-de-jankev-27-10-2012
[emission_sujet] => Saison 3 - Emission 3 | Gaïo
)
[28] => Array
(
[emission_datetime] => 2012-10-13 20:00:00
[page_url] => les-oreilles-de-jankev-13-10-2012
[emission_sujet] => Saison 3 - Emission 2 | Electric Guest
)
[29] => Array
(
[emission_datetime] => 2012-10-06 20:00:00
[page_url] => les-oreilles-de-jankev-06-10-2012
[emission_sujet] => Saison 3 - Emission 1 : Jupiter
)
)
[prochaine_emission_programme] => Array
(
[emission_datetime] => 2013-05-25 20:00:00
[emission_sujet] =>
[page_url] => les-oreilles-de-jankev-25-05-2013
)
[precedente_emission_programme] => Array
(
[emission_datetime] => 2012-10-13 20:00:00
[emission_sujet] => Saison 3 - Emission 2 | Electric Guest
[page_url] => les-oreilles-de-jankev-13-10-2012
)
[suivante_emission_programme] => Array
(
[emission_datetime] => 2012-11-03 20:00:00
[emission_sujet] => Saison 3 - Emission 4
[page_url] => les-oreilles-de-jankev-03-11-2012
)
[playlist] => Array
(
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"
