$lang = "en"
$format = "llibre_amb_dvd_i_cdrom"
$option = "319"
$aux_url = "-en-format-llibre_amb_dvd_i_cdrom"
$aux_url_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$ariadna = array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
$bread_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$tmpformat = "llibre amb dvd i cdrom"
$metadata = array(
"Llibre" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines. Mètodes d'instrument com flauta dolça, violoncel, clarinet, violí, guitarra, piano, percussió, flauta travessera, instruments tradicionals catalans, tenora, tible, flabiol, acordió diatònic, gralla, guitarra acústica, arpa, trompeta, banjo, baix elèctric, bateria, saxo, ukulele. Mètodes de llenguatge musical. Mètodes d'harmonia. Teoria de la música. La música a l'educació infantil, a l'escola primària. Sensibilització musical. Mètodes de cant, tractats antics, educació de l'oïda, pedagogia musical."
),
"CD" => array(
"description" => "CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària."
),
"Audio" => array(
"description" => "Documents àudios en format CD o en MP3. CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària. Documents mp3 d'exemple de publicacions fàcils en pdf."
),
"PDF" => array(
"description" => "description_pdf"
),
"Llibre amb DVD" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD. Mètodes bateria, formació de l'oïda, mètode de trompeta."
),
"Llibre amb DVD i CDRom" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD i un CD-Rom La música contemporània a l'escola."
),
"Partitura" => array(
"description" => "Publicacions de música impresa, tan en paper com en format digital en pdf, per a música instrumental, vocal, coral, orquestra, banda, orquestra de corda, música tradicionsl catalana, cobla. Inclou les col·leccions: Materials per a banda simfònica, Música per a banda, Partitures de butxaca per a banda simfònica. Àlbum de notes, Claudi Arimany, Col·lecció Havaneres de Leonora milà, Obres per a piano de Leonora Milà, Da camera, Dolors Calvet, Dones compositores, Materials per a cobla i altres formacions, Partitures de butxaca per a cobla i altres formacions, Música de cambra, Música de cambra per a instruments de vent, Música instrumental, Músics d'aquí, Obres per a instruments de tecla del s. XVII i XVIII, Obres per a piano d'antoni Besses, Partitures de butxaca per a cobla i altres formacions, Piano Català Contemporani, Repertori per a saxo, Sonatines de carnestoltes, Música per a instruments de cobla, Calaix de solfa, Cançons per al poble, Col·lecció l'Esquitx, Música tradicional catalana, Repertori per a acordió diatònic, Tocatimbal, Sardanes, Obra complerta per a cobla d'Eduard Toldrà, Comencem l'orquestra, Joves orquestres. Col·leccions diverses per a orquestra (materials de lloguer) Grup XXI, Materials d'orquestra, Partitures de butxaca del Grup XXI, partitures de butxaca de música orquestral."
),
"Partitura de lloguer" => array(
"description" => "Publicacions de música impresa que s'ofereix als usuaris en règim de lloguer (no de venda). Per a música d'orquestra, de banda, d'orquestra de corda, cobla."
),
"Publicacio amb arxius descarregables" => array(
"description" => "Publicació amb material gratuït descarregable del web del web de Dinsic, en format pdf o audio (mp3). L'usuari se la pot descarregar de la seva àrea d'usuari."
),
"DVD" => array(
"description" => "DVD amb filmacions didàctiques de com acompanyar en el jazz i amb material gràfic inclòs."
),
"PDF amb audio MP3" => array(
"description" => "Publicacions de partitures senzilles en format pdf per a la venda, amb àudio mp3 gratuÍt d'exemple amb finalitat didàctica. Col·lecció Da camena peces soltes en pdf i exemple àudio."
),
"Llibre amb CD" => array(
"description" => "description_llibre_amb_cd"
),
"Partitura amb CD" => array(
"description" => "description_partitura_amb_cd"
)
)
$metadescription = ""
$description = ""
$originales = "ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ"
$modificadas = "aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr"
$breadcrumb = array(
array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
)
$vectorL = array(
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
"Q",
"R",
"S",
"T",
"U",
"V",
"W",
"X",
"Y",
"Z"
)
$vectorF = array()
$count_tmp = 0
$i = 0
PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5155
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5186]
$lang = "en"
$format = "llibre_amb_dvd_i_cdrom"
$option = "319"
$aux_url = "-en-format-llibre_amb_dvd_i_cdrom"
$aux_url_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$ariadna = array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
$bread_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$tmpformat = "llibre amb dvd i cdrom"
$metadata = array(
"Llibre" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines. Mètodes d'instrument com flauta dolça, violoncel, clarinet, violí, guitarra, piano, percussió, flauta travessera, instruments tradicionals catalans, tenora, tible, flabiol, acordió diatònic, gralla, guitarra acústica, arpa, trompeta, banjo, baix elèctric, bateria, saxo, ukulele. Mètodes de llenguatge musical. Mètodes d'harmonia. Teoria de la música. La música a l'educació infantil, a l'escola primària. Sensibilització musical. Mètodes de cant, tractats antics, educació de l'oïda, pedagogia musical."
),
"CD" => array(
"description" => "CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària."
),
"Audio" => array(
"description" => "Documents àudios en format CD o en MP3. CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària. Documents mp3 d'exemple de publicacions fàcils en pdf."
),
"PDF" => array(
"description" => "description_pdf"
),
"Llibre amb DVD" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD. Mètodes bateria, formació de l'oïda, mètode de trompeta."
),
"Llibre amb DVD i CDRom" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD i un CD-Rom La música contemporània a l'escola."
),
"Partitura" => array(
"description" => "Publicacions de música impresa, tan en paper com en format digital en pdf, per a música instrumental, vocal, coral, orquestra, banda, orquestra de corda, música tradicionsl catalana, cobla. Inclou les col·leccions: Materials per a banda simfònica, Música per a banda, Partitures de butxaca per a banda simfònica. Àlbum de notes, Claudi Arimany, Col·lecció Havaneres de Leonora milà, Obres per a piano de Leonora Milà, Da camera, Dolors Calvet, Dones compositores, Materials per a cobla i altres formacions, Partitures de butxaca per a cobla i altres formacions, Música de cambra, Música de cambra per a instruments de vent, Música instrumental, Músics d'aquí, Obres per a instruments de tecla del s. XVII i XVIII, Obres per a piano d'antoni Besses, Partitures de butxaca per a cobla i altres formacions, Piano Català Contemporani, Repertori per a saxo, Sonatines de carnestoltes, Música per a instruments de cobla, Calaix de solfa, Cançons per al poble, Col·lecció l'Esquitx, Música tradicional catalana, Repertori per a acordió diatònic, Tocatimbal, Sardanes, Obra complerta per a cobla d'Eduard Toldrà, Comencem l'orquestra, Joves orquestres. Col·leccions diverses per a orquestra (materials de lloguer) Grup XXI, Materials d'orquestra, Partitures de butxaca del Grup XXI, partitures de butxaca de música orquestral."
),
"Partitura de lloguer" => array(
"description" => "Publicacions de música impresa que s'ofereix als usuaris en règim de lloguer (no de venda). Per a música d'orquestra, de banda, d'orquestra de corda, cobla."
),
"Publicacio amb arxius descarregables" => array(
"description" => "Publicació amb material gratuït descarregable del web del web de Dinsic, en format pdf o audio (mp3). L'usuari se la pot descarregar de la seva àrea d'usuari."
),
"DVD" => array(
"description" => "DVD amb filmacions didàctiques de com acompanyar en el jazz i amb material gràfic inclòs."
),
"PDF amb audio MP3" => array(
"description" => "Publicacions de partitures senzilles en format pdf per a la venda, amb àudio mp3 gratuÍt d'exemple amb finalitat didàctica. Col·lecció Da camena peces soltes en pdf i exemple àudio."
),
"Llibre amb CD" => array(
"description" => "description_llibre_amb_cd"
),
"Partitura amb CD" => array(
"description" => "description_partitura_amb_cd"
)
)
$metadescription = ""
$description = ""
$originales = "ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ"
$modificadas = "aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr"
$breadcrumb = array(
array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
)
$vectorL = array(
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
"Q",
"R",
"S",
"T",
"U",
"V",
"W",
"X",
"Y",
"Z"
)
$vectorF = array(
"0_9" => 31
)
$count_tmp = 31
$i = 10
$base_conditions = array(
"Publicacion.titol LIKE '9%'"
)
$fields_count = "COUNT(DISTINCT(`Publicacion`.`id`)) AS count"
$joins = array(
array(
"type" => "INNER",
"alias" => "PublicacionI18n",
"table" => "publicacion_translations",
"conditions" => array()
)
)
$joins_coinditions = array(
"Publicacion.id" => stdClass
stdClass::$type = "identifier"
stdClass::$value = "PublicacionI18n.foreign_key",
"PublicacionI18n.model" => "Publicacion",
"PublicacionI18n.locale" => "en_gb",
"PublicacionI18n.field" => "titol",
"PublicacionI18n.content LIKE '9%'"
)
$count = 1
$let = "A"
//letras foreach($vectorL as $let){ $base_conditions=$conditions;
PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5186
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5255]
$lang = "en"
$format = "llibre_amb_dvd_i_cdrom"
$option = "319"
$aux_url = "-en-format-llibre_amb_dvd_i_cdrom"
$aux_url_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$ariadna = array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
$bread_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$tmpformat = "llibre amb dvd i cdrom"
$metadata = array(
"Llibre" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines. Mètodes d'instrument com flauta dolça, violoncel, clarinet, violí, guitarra, piano, percussió, flauta travessera, instruments tradicionals catalans, tenora, tible, flabiol, acordió diatònic, gralla, guitarra acústica, arpa, trompeta, banjo, baix elèctric, bateria, saxo, ukulele. Mètodes de llenguatge musical. Mètodes d'harmonia. Teoria de la música. La música a l'educació infantil, a l'escola primària. Sensibilització musical. Mètodes de cant, tractats antics, educació de l'oïda, pedagogia musical."
),
"CD" => array(
"description" => "CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària."
),
"Audio" => array(
"description" => "Documents àudios en format CD o en MP3. CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària. Documents mp3 d'exemple de publicacions fàcils en pdf."
),
"PDF" => array(
"description" => "description_pdf"
),
"Llibre amb DVD" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD. Mètodes bateria, formació de l'oïda, mètode de trompeta."
),
"Llibre amb DVD i CDRom" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD i un CD-Rom La música contemporània a l'escola."
),
"Partitura" => array(
"description" => "Publicacions de música impresa, tan en paper com en format digital en pdf, per a música instrumental, vocal, coral, orquestra, banda, orquestra de corda, música tradicionsl catalana, cobla. Inclou les col·leccions: Materials per a banda simfònica, Música per a banda, Partitures de butxaca per a banda simfònica. Àlbum de notes, Claudi Arimany, Col·lecció Havaneres de Leonora milà, Obres per a piano de Leonora Milà, Da camera, Dolors Calvet, Dones compositores, Materials per a cobla i altres formacions, Partitures de butxaca per a cobla i altres formacions, Música de cambra, Música de cambra per a instruments de vent, Música instrumental, Músics d'aquí, Obres per a instruments de tecla del s. XVII i XVIII, Obres per a piano d'antoni Besses, Partitures de butxaca per a cobla i altres formacions, Piano Català Contemporani, Repertori per a saxo, Sonatines de carnestoltes, Música per a instruments de cobla, Calaix de solfa, Cançons per al poble, Col·lecció l'Esquitx, Música tradicional catalana, Repertori per a acordió diatònic, Tocatimbal, Sardanes, Obra complerta per a cobla d'Eduard Toldrà, Comencem l'orquestra, Joves orquestres. Col·leccions diverses per a orquestra (materials de lloguer) Grup XXI, Materials d'orquestra, Partitures de butxaca del Grup XXI, partitures de butxaca de música orquestral."
),
"Partitura de lloguer" => array(
"description" => "Publicacions de música impresa que s'ofereix als usuaris en règim de lloguer (no de venda). Per a música d'orquestra, de banda, d'orquestra de corda, cobla."
),
"Publicacio amb arxius descarregables" => array(
"description" => "Publicació amb material gratuït descarregable del web del web de Dinsic, en format pdf o audio (mp3). L'usuari se la pot descarregar de la seva àrea d'usuari."
),
"DVD" => array(
"description" => "DVD amb filmacions didàctiques de com acompanyar en el jazz i amb material gràfic inclòs."
),
"PDF amb audio MP3" => array(
"description" => "Publicacions de partitures senzilles en format pdf per a la venda, amb àudio mp3 gratuÍt d'exemple amb finalitat didàctica. Col·lecció Da camena peces soltes en pdf i exemple àudio."
),
"Llibre amb CD" => array(
"description" => "description_llibre_amb_cd"
),
"Partitura amb CD" => array(
"description" => "description_partitura_amb_cd"
)
)
$metadescription = ""
$description = ""
$originales = "ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ"
$modificadas = "aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr"
$breadcrumb = array(
array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
)
$vectorL = array(
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
"Q",
"R",
"S",
"T",
"U",
"V",
"W",
"X",
"Y",
"Z"
)
$vectorF = array(
"0_9" => 31,
"A" => 99,
"B" => 63,
"C" => 227,
"D" => 164,
"E" => 367,
"F" => 55,
"G" => 10,
"H" => 60,
"I" => 39,
"J" => 31,
"K" => 7,
"L" => 206,
"M" => 164,
"N" => 32,
"O" => 26,
"P" => 137,
"Q" => 53,
"R" => 46,
"S" => 168,
"T" => 140,
"U" => 15,
"V" => 35,
"W" => 3,
"X" => 3,
"Y" => 3,
"Z" => 2
)
$count_tmp = 31
$i = 10
$base_conditions = array(
"Publicacion.titol LIKE 'Z%'"
)
$fields_count = "COUNT(DISTINCT(`Publicacion`.`id`)) AS count"
$joins = array(
array(
"type" => "INNER",
"alias" => "PublicacionI18n",
"table" => "publicacion_translations",
"conditions" => array()
)
)
$joins_coinditions = array(
"Publicacion.id" => stdClass
stdClass::$type = "identifier"
stdClass::$value = "PublicacionI18n.foreign_key",
"PublicacionI18n.model" => "Publicacion",
"PublicacionI18n.locale" => "en_gb",
"PublicacionI18n.field" => "titol",
"PublicacionI18n.content LIKE 'Z%'"
)
$count = 2
$let = "Z"
$letter_selected = ""
PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5255
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5258]
$lang = "en"
$format = "llibre_amb_dvd_i_cdrom"
$option = "319"
$aux_url = "-en-format-llibre_amb_dvd_i_cdrom"
$aux_url_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$ariadna = array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
$bread_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$tmpformat = "llibre amb dvd i cdrom"
$metadata = array(
"Llibre" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines. Mètodes d'instrument com flauta dolça, violoncel, clarinet, violí, guitarra, piano, percussió, flauta travessera, instruments tradicionals catalans, tenora, tible, flabiol, acordió diatònic, gralla, guitarra acústica, arpa, trompeta, banjo, baix elèctric, bateria, saxo, ukulele. Mètodes de llenguatge musical. Mètodes d'harmonia. Teoria de la música. La música a l'educació infantil, a l'escola primària. Sensibilització musical. Mètodes de cant, tractats antics, educació de l'oïda, pedagogia musical."
),
"CD" => array(
"description" => "CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària."
),
"Audio" => array(
"description" => "Documents àudios en format CD o en MP3. CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària. Documents mp3 d'exemple de publicacions fàcils en pdf."
),
"PDF" => array(
"description" => "description_pdf"
),
"Llibre amb DVD" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD. Mètodes bateria, formació de l'oïda, mètode de trompeta."
),
"Llibre amb DVD i CDRom" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD i un CD-Rom La música contemporània a l'escola."
),
"Partitura" => array(
"description" => "Publicacions de música impresa, tan en paper com en format digital en pdf, per a música instrumental, vocal, coral, orquestra, banda, orquestra de corda, música tradicionsl catalana, cobla. Inclou les col·leccions: Materials per a banda simfònica, Música per a banda, Partitures de butxaca per a banda simfònica. Àlbum de notes, Claudi Arimany, Col·lecció Havaneres de Leonora milà, Obres per a piano de Leonora Milà, Da camera, Dolors Calvet, Dones compositores, Materials per a cobla i altres formacions, Partitures de butxaca per a cobla i altres formacions, Música de cambra, Música de cambra per a instruments de vent, Música instrumental, Músics d'aquí, Obres per a instruments de tecla del s. XVII i XVIII, Obres per a piano d'antoni Besses, Partitures de butxaca per a cobla i altres formacions, Piano Català Contemporani, Repertori per a saxo, Sonatines de carnestoltes, Música per a instruments de cobla, Calaix de solfa, Cançons per al poble, Col·lecció l'Esquitx, Música tradicional catalana, Repertori per a acordió diatònic, Tocatimbal, Sardanes, Obra complerta per a cobla d'Eduard Toldrà, Comencem l'orquestra, Joves orquestres. Col·leccions diverses per a orquestra (materials de lloguer) Grup XXI, Materials d'orquestra, Partitures de butxaca del Grup XXI, partitures de butxaca de música orquestral."
),
"Partitura de lloguer" => array(
"description" => "Publicacions de música impresa que s'ofereix als usuaris en règim de lloguer (no de venda). Per a música d'orquestra, de banda, d'orquestra de corda, cobla."
),
"Publicacio amb arxius descarregables" => array(
"description" => "Publicació amb material gratuït descarregable del web del web de Dinsic, en format pdf o audio (mp3). L'usuari se la pot descarregar de la seva àrea d'usuari."
),
"DVD" => array(
"description" => "DVD amb filmacions didàctiques de com acompanyar en el jazz i amb material gràfic inclòs."
),
"PDF amb audio MP3" => array(
"description" => "Publicacions de partitures senzilles en format pdf per a la venda, amb àudio mp3 gratuÍt d'exemple amb finalitat didàctica. Col·lecció Da camena peces soltes en pdf i exemple àudio."
),
"Llibre amb CD" => array(
"description" => "description_llibre_amb_cd"
),
"Partitura amb CD" => array(
"description" => "description_partitura_amb_cd"
)
)
$metadescription = ""
$description = ""
$originales = "ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ"
$modificadas = "aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr"
$breadcrumb = array(
array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
)
$vectorL = array(
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
"Q",
"R",
"S",
"T",
"U",
"V",
"W",
"X",
"Y",
"Z"
)
$vectorF = array(
"0_9" => 31,
"A" => 99,
"B" => 63,
"C" => 227,
"D" => 164,
"E" => 367,
"F" => 55,
"G" => 10,
"H" => 60,
"I" => 39,
"J" => 31,
"K" => 7,
"L" => 206,
"M" => 164,
"N" => 32,
"O" => 26,
"P" => 137,
"Q" => 53,
"R" => 46,
"S" => 168,
"T" => 140,
"U" => 15,
"V" => 35,
"W" => 3,
"X" => 3,
"Y" => 3,
"Z" => 2
)
$count_tmp = 31
$i = 10
$base_conditions = array(
"Publicacion.titol LIKE 'Z%'"
)
$fields_count = "COUNT(DISTINCT(`Publicacion`.`id`)) AS count"
$joins = array(
array(
"type" => "INNER",
"alias" => "PublicacionI18n",
"table" => "publicacion_translations",
"conditions" => array()
)
)
$joins_coinditions = array(
"Publicacion.id" => stdClass
stdClass::$type = "identifier"
stdClass::$value = "PublicacionI18n.foreign_key",
"PublicacionI18n.model" => "Publicacion",
"PublicacionI18n.locale" => "en_gb",
"PublicacionI18n.field" => "titol",
"PublicacionI18n.content LIKE 'Z%'"
)
$count = 2
$let = "Z"
$letter_selected = ""
$result2 = array(
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
)
)
//obtener link ultima pagina $resCount = $this->Publicacion->find('count',array('conditions'=>$conditions));
PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5258
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88
Notice (8): Undefined variable: tmptext [APP/controllers/publicacions_controller.php, line 5347]
$lang = "en"
$format = "llibre_amb_dvd_i_cdrom"
$option = "319"
$aux_url = "-en-format-llibre_amb_dvd_i_cdrom"
$aux_url_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$ariadna = array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
$bread_tmp = array(
"",
"en",
"format",
"llibre_amb_dvd_i_cdrom"
)
$tmpformat = "llibre amb dvd i cdrom"
$metadata = array(
"Llibre" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines. Mètodes d'instrument com flauta dolça, violoncel, clarinet, violí, guitarra, piano, percussió, flauta travessera, instruments tradicionals catalans, tenora, tible, flabiol, acordió diatònic, gralla, guitarra acústica, arpa, trompeta, banjo, baix elèctric, bateria, saxo, ukulele. Mètodes de llenguatge musical. Mètodes d'harmonia. Teoria de la música. La música a l'educació infantil, a l'escola primària. Sensibilització musical. Mètodes de cant, tractats antics, educació de l'oïda, pedagogia musical."
),
"CD" => array(
"description" => "CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària."
),
"Audio" => array(
"description" => "Documents àudios en format CD o en MP3. CD de cançons infantils, complementaris de mètodes d'instrument, de mètodes per a la sensibilització musical, per al treball de la rítmica, o de llibres per a l'educació primària. Documents mp3 d'exemple de publicacions fàcils en pdf."
),
"PDF" => array(
"description" => "description_pdf"
),
"Llibre amb DVD" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD. Mètodes bateria, formació de l'oïda, mètode de trompeta."
),
"Llibre amb DVD i CDRom" => array(
"description" => "Publicació impresa en paper i enquadernada, que parla de música (musicografia) o està destinada l'ensenyament de la música, en qualsevol de les seves disciplines, acompanyada d'un DVD i un CD-Rom La música contemporània a l'escola."
),
"Partitura" => array(
"description" => "Publicacions de música impresa, tan en paper com en format digital en pdf, per a música instrumental, vocal, coral, orquestra, banda, orquestra de corda, música tradicionsl catalana, cobla. Inclou les col·leccions: Materials per a banda simfònica, Música per a banda, Partitures de butxaca per a banda simfònica. Àlbum de notes, Claudi Arimany, Col·lecció Havaneres de Leonora milà, Obres per a piano de Leonora Milà, Da camera, Dolors Calvet, Dones compositores, Materials per a cobla i altres formacions, Partitures de butxaca per a cobla i altres formacions, Música de cambra, Música de cambra per a instruments de vent, Música instrumental, Músics d'aquí, Obres per a instruments de tecla del s. XVII i XVIII, Obres per a piano d'antoni Besses, Partitures de butxaca per a cobla i altres formacions, Piano Català Contemporani, Repertori per a saxo, Sonatines de carnestoltes, Música per a instruments de cobla, Calaix de solfa, Cançons per al poble, Col·lecció l'Esquitx, Música tradicional catalana, Repertori per a acordió diatònic, Tocatimbal, Sardanes, Obra complerta per a cobla d'Eduard Toldrà, Comencem l'orquestra, Joves orquestres. Col·leccions diverses per a orquestra (materials de lloguer) Grup XXI, Materials d'orquestra, Partitures de butxaca del Grup XXI, partitures de butxaca de música orquestral."
),
"Partitura de lloguer" => array(
"description" => "Publicacions de música impresa que s'ofereix als usuaris en règim de lloguer (no de venda). Per a música d'orquestra, de banda, d'orquestra de corda, cobla."
),
"Publicacio amb arxius descarregables" => array(
"description" => "Publicació amb material gratuït descarregable del web del web de Dinsic, en format pdf o audio (mp3). L'usuari se la pot descarregar de la seva àrea d'usuari."
),
"DVD" => array(
"description" => "DVD amb filmacions didàctiques de com acompanyar en el jazz i amb material gràfic inclòs."
),
"PDF amb audio MP3" => array(
"description" => "Publicacions de partitures senzilles en format pdf per a la venda, amb àudio mp3 gratuÍt d'exemple amb finalitat didàctica. Col·lecció Da camena peces soltes en pdf i exemple àudio."
),
"Llibre amb CD" => array(
"description" => "description_llibre_amb_cd"
),
"Partitura amb CD" => array(
"description" => "description_partitura_amb_cd"
)
)
$metadescription = ""
$description = ""
$originales = "ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ"
$modificadas = "aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr"
$breadcrumb = array(
array(
"url" => "/en/format/llibre_amb_dvd_i_cdrom"
)
)
$vectorL = array(
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
"Q",
"R",
"S",
"T",
"U",
"V",
"W",
"X",
"Y",
"Z"
)
$vectorF = array(
"0_9" => 31,
"A" => 99,
"B" => 63,
"C" => 227,
"D" => 164,
"E" => 367,
"F" => 55,
"G" => 10,
"H" => 60,
"I" => 39,
"J" => 31,
"K" => 7,
"L" => 206,
"M" => 164,
"N" => 32,
"O" => 26,
"P" => 137,
"Q" => 53,
"R" => 46,
"S" => 168,
"T" => 140,
"U" => 15,
"V" => 35,
"W" => 3,
"X" => 3,
"Y" => 3,
"Z" => 2
)
$count_tmp = 31
$i = 10
$base_conditions = array(
"Publicacion.titol LIKE 'Z%'"
)
$fields_count = "COUNT(DISTINCT(`Publicacion`.`id`)) AS count"
$joins = array(
array(
"type" => "INNER",
"alias" => "PublicacionI18n",
"table" => "publicacion_translations",
"conditions" => array()
)
)
$joins_coinditions = array(
"Publicacion.id" => stdClass
stdClass::$type = "identifier"
stdClass::$value = "PublicacionI18n.foreign_key",
"PublicacionI18n.model" => "Publicacion",
"PublicacionI18n.locale" => "en_gb",
"PublicacionI18n.field" => "titol",
"PublicacionI18n.content LIKE 'Z%'"
)
$count = 2
$let = "Z"
$letter_selected = ""
$result2 = array(
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
)
)
$resCount = 2258
$lastlink = 323
$new_result = array(
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
)
)
$keywords = array(
"Música 4",
"Educació Primària: Música Segon Cicle",
"Francesca",
"Galofré",
"Jordi-Lluís",
"Rigol",
"Lluís",
"Farré",
"Lluís",
"Farré",
"Música 3-4: Guia del Mestre",
"Educació Primària: Música Segon Cicle",
"Francesca",
"Galofré",
"Jordi-Lluís",
"Rigol",
"Lluís",
"Farré",
"Música 3: CD",
"Educació Primària: Música Segon Cicle",
"Francesca",
"Galofré",
"Jordi-Lluís",
"Rigol",
"Lluís",
"Farré",
"Lluís",
"Farré",
"Escolta i Escriu 1 (without CD)",
"Escolta i Escriu",
"Òscar",
"Boada",
"Francesca",
"Galofré",
"Lluïsa",
"Jover",
"Música 3",
"Educació Primària: Música Segon Cicle",
"Francesca",
"Galofré",
"Jordi-Lluís",
"Rigol",
"Lluís",
"Farré",
"Lluís",
"Farré",
"Música 2",
"Educació Primària: Música Primer Cicle",
"Francesc",
"Salvà",
"Francesc",
"Salvà",
"Francesca",
"Galofré",
"Jordi-Lluís",
"Rigol",
"Música 1-2: Guia del Mestre",
"Educació Primària: Música Primer Cicle",
"Francesc",
"Salvà",
"Francesca",
"Galofré",
"Jordi-Lluís",
"Rigol",
"Llibre"
)
$elem = array(
"Publicacion" => array(
"id" => "1961",
"format" => "Llibre",
"preu" => "8.65",
"created" => "2006-07-12 17:00:00",
"novetat" => "0",
"en_preparacio" => "0",
"recomanat" => "0",
"exhaurit" => "0",
"oferta" => "0",
"locale" => "en_gb",
"titol" => "Música 1-2: Guia del Mestre",
"url" => "score-gm1_2-musica_1_2_guia_del_mestre",
"intro" => ""
),
"Archivesrelation" => array(
array(),
array(),
array()
),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(
array(),
array(),
array()
),
"Category" => array(
array()
),
"Colleccion" => array(
array()
),
"Editor" => array(
array()
),
"Enquadernacion" => array(
array()
),
"Formacion" => array(),
"Idioma" => array(
array()
),
"Instrument" => array(),
"Mida" => array(
array()
),
"Retractilat" => array(),
"Newsletter" => array(
array()
),
"Rsspost" => array()
)
$fields = array(
"Colleccion.id",
"Colleccion.nom",
"Colleccion.url"
)
$vector = array(
array(
"id" => "1779",
"locale" => "en_gb",
"nom" => "Educació Primària: Música Primer Cicle",
"url" => "educacio_primaria_musica_primer_cicle",
"PublicacionsColleccion" => array()
)
)
$elem2 = array(
"id" => "1779",
"nom" => "Educació Primària: Música Primer Cicle",
"catcolleccion_id" => "1733",
"descripcio" => "(Primary Education: First Cycle) The materials listed below for teaching music in the First Cycle of Primary Education are approved by the Department of Education of the Autonomous Government of Catalonia.\n The Students' books include songs, music for listening, dance, rhythm, intonation, melody and qualities of sound, musical instruments, ways of making sound, reading and writing music, etc. The Teacher's Guides provide suggestions for teaching the contents of the Students' books and the CD contains all the complete musical examples for the listening and dance exercises as well as music for work on motor function and the sensorial preparation for the binary and ternary times.",
"order" => "0",
"url" => "educacio_primaria_musica_primer_cicle",
"published" => "1",
"PublicacionsColleccion" => array(
"id" => "180",
"colleccion_id" => "1779",
"publicacion_id" => "1961",
"num_volum" => "0"
)
)
$tmp = array(
"id" => "1779",
"locale" => "en_gb",
"nom" => "Educació Primària: Música Primer Cicle",
"url" => "educacio_primaria_musica_primer_cicle",
"PublicacionsColleccion" => array(
"id" => "180",
"colleccion_id" => "1779",
"publicacion_id" => "1961",
"num_volum" => "0"
)
)
$colection = array(
"id" => "1779",
"locale" => "en_gb",
"nom" => "Educació Primària: Música Primer Cicle",
"url" => "educacio_primaria_musica_primer_cicle",
"PublicacionsColleccion" => array(
"id" => "180",
"colleccion_id" => "1779",
"publicacion_id" => "1961",
"num_volum" => "0"
)
)
$autor = array(
"id" => "1600",
"nom" => "Jordi-Lluís",
"cognom" => "Rigol",
"2cognom" => "Monné",
"curriculum" => "<div>
A composer, pianist and conductor, he was born in Barcelona and undertook his musical studies at the Acadèmia Ars Nova there. He studied singing with Ferran Gimeno and choral conducting with Pierre Cao, Manel Cabero and Gaby Baltes in Barcelona and in Mallorca, and with Simon Johnson in England, where he also worked on orchestral conducting at the Canford Summer School of Music with George Hurst and Michael Rose. He lived in Amsterdam from 1990 to 1993, where he studied orchestral conducting at the Sweelinck Conservatorium with Joop Von Zonn, being awarded his conducting certificate there. His stay at that music school enabled him to pursue further studies in choral conducting, musical analysis and the piano. <br />
Being interested in musical education, he is a teacher at the IPSI (Institució Pedagògica Sant Isidor) in Barcelona and at that centre's Music School, where his activity as a composer has led to the composition of various works suitable for the various levels of the students, such as his children's cantatas El país de la no-memòria (The land of no-memory), On és la música' (Where is music') and El planeta del mar inventat (The planet of the invented sea) for large children's choir and instrumental ensemble, all given their first performances in Barcelona, and also shorter but more complex choral works such as his Missa Brevis, from which the 'Alleluia', the 'Pater Noster' and the 'Magnificat' were given their first performances and subsequent performances by the Cor Vivaldi-Petits Cantors de Catalunya, in Catalonia and in Switzerland as well.<br />
In June 1992 he conducted the first performance of the chamber opera From the Diary of the Hunchback Girl by the composer Shai Lifshitz in the Bachzaal of Amsterdam. He has conducted the Orquestra Simfònica de la Institució Cultural de les Corts and the choir of the Campus Nord of the Polytechnic University of Catalonia, as well as the Chamber Orchestra of the Reial Cercle Artístic. <br />
He has performed as a pianist in various venues in Catalonia and Germany. His creative work involving the piano was recorded on the compact discs Entre miralls (Between mirrors - 1998) and A mínim (At least - 2000). He has also given occasional performances on the organ.<br />
The co-authored the musical No deixeu el meu somni (Don't leave my dream), which was first performed in Barcelona in 1998. He also composed music for the work On eres, Víctor' (Where were you, Victor'), first performed in Barcelona in October 2000, and he has written various choral works for mixed choir.<br />
He is currently the conductor of the Cor-Xera of the Escola IPSI, the Coral Baluern and the Chamber Choir Tempus Musici, he being the founder and director of the latter.</div>
",
"data_desconeguda" => "1",
"data_naixement" => "0000-00-00",
"nomes_any_naixement" => "0",
"nomes_any_defuncio" => "0",
"defuncio" => "0",
"data_defuncio" => "0000-00-00",
"data_defuncio_desconeguda" => "0",
"url" => "jordi_lluis_rigol_monne",
"published" => "1",
"PublicacionsAutor" => array(
"id" => "737",
"autor_id" => "1600",
"publicacion_id" => "1961",
"funcion_id" => "1477"
)
)
$list = array(
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
),
array(
"Publicacion" => array(),
"Archivesrelation" => array(),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(),
"Category" => array(),
"Colleccion" => array(),
"Editor" => array(),
"Enquadernacion" => array(),
"Formacion" => array(),
"Idioma" => array(),
"Instrument" => array(),
"Mida" => array(),
"Retractilat" => array(),
"Newsletter" => array(),
"Rsspost" => array()
)
)
$res = array(
"Publicacion" => array(
"id" => "1961",
"format" => "Llibre",
"preu" => "8.65",
"created" => "2006-07-12 17:00:00",
"novetat" => "0",
"en_preparacio" => "0",
"recomanat" => "0",
"exhaurit" => "0",
"oferta" => "0",
"locale" => "en_gb",
"titol" => "Música 1-2: Guia del Mestre",
"url" => "score-gm1_2-musica_1_2_guia_del_mestre",
"intro" => "",
"path" => "music_in_general_education-primary_school"
),
"Archivesrelation" => array(
array(),
array(),
array()
),
"Rating" => array(),
"Comment" => array(),
"Autor" => array(
array(),
array(),
array()
),
"Category" => array(
array()
),
"Colleccion" => array(
array()
),
"Editor" => array(
array()
),
"Enquadernacion" => array(
array()
),
"Formacion" => array(),
"Idioma" => array(
array()
),
"Instrument" => array(),
"Mida" => array(
array()
),
"Retractilat" => array(),
"Newsletter" => array(
array()
),
"Rsspost" => array()
)
$langs = array(
"Català" => "ca_es",
"Castellà" => "es_es",
"Angles" => "en_gb"
)
$vectorUrls = array()
$baselang = "en_gb"
$trans = "ca_es"
$key = "Català"
PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5347
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88
$i=0; foreach($breadcrumb as $elem){ echo $html->link($elem['text'],$elem['url']);
include - APP/views/layouts/default.ctp, line 408
View::_render() - CORE/cake/libs/view/view.php, line 665
View::renderLayout() - CORE/cake/libs/view/view.php, line 453
View::render() - CORE/cake/libs/view/view.php, line 387
Controller::render() - CORE/cake/libs/controller/controller.php, line 805
PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5355
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88
This portal is designed to work with the latest versions of the principal navigators: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. The use of non-compatible navigators or deactivation of some properties such as Javascript compatibility or blocking cookies may reduce the sites functionality. If you are accessing the site through a firewall or a porxy, make sure cookies are enabled.
(default) 189 queries took 294 ms
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
DESCRIBE `publicacions`
43
43
1
2
DESCRIBE `archivesrelations`
6
6
0
3
DESCRIBE `ratings`
8
8
0
4
DESCRIBE `comments`
9
9
0
5
DESCRIBE `autors`
14
14
0
6
DESCRIBE `publicacions_autors`
4
4
0
7
DESCRIBE `autor_translations`
6
6
0
8
DESCRIBE `categories`
9
9
0
9
DESCRIBE `publicacions_categories`
3
3
0
10
DESCRIBE `categories_translations`
6
6
0
11
DESCRIBE `colleccions`
7
7
0
12
DESCRIBE `catcolleccions`
9
9
0
13
DESCRIBE `catcolleccion_translations`
6
6
0
14
DESCRIBE `publicacions_colleccions`
4
4
0
15
DESCRIBE `colleccion_translations`
6
6
0
16
DESCRIBE `editors`
2
2
0
17
DESCRIBE `publicacions_editors`
9
9
0
18
DESCRIBE `enquadernacions`
3
3
0
19
DESCRIBE `publicacions_enquadernacions`
3
3
0
20
DESCRIBE `enquadernacion_translations`
6
6
0
21
DESCRIBE `formacions`
7
7
0
22
DESCRIBE `catformacions`
9
9
0
23
DESCRIBE `catformacion_translations`
6
6
0
24
DESCRIBE `publicacions_formacions`
3
3
0
25
DESCRIBE `formacion_translations`
6
6
0
26
DESCRIBE `idiomas`
4
4
0
27
DESCRIBE `publicacions_idiomas`
3
3
0
28
DESCRIBE `idioma_translations`
6
6
0
29
DESCRIBE `instruments`
6
6
4
30
DESCRIBE `catinstruments`
9
9
0
31
DESCRIBE `catinstrument_translations`
6
6
0
32
DESCRIBE `publicacions_instruments`
4
4
0
33
DESCRIBE `instrument_translations`
6
6
0
34
DESCRIBE `midas`
4
4
0
35
DESCRIBE `publicacions_midas`
3
3
0
36
DESCRIBE `mida_translations`
6
6
0
37
DESCRIBE `retractilats`
3
3
0
38
DESCRIBE `publicacions_retractilats`
3
3
0
39
DESCRIBE `retractilat_translations`
6
6
0
40
DESCRIBE `newsletters`
7
7
0
41
DESCRIBE `newsletters_publicacions`
3
3
0
42
DESCRIBE `newsletter_translations`
6
6
0
43
DESCRIBE `rssposts`
10
10
0
44
DESCRIBE `rss`
5
5
0
45
DESCRIBE `rssposts_publicacions`
3
3
0
46
DESCRIBE `publicacion_translations`
6
6
0
47
DESCRIBE `relacionats`
4
4
0
48
DESCRIBE `funcions`
4
4
0
49
DESCRIBE `funcion_translations`
6
6
0
50
DESCRIBE `archives`
6
6
0
51
DESCRIBE `codes`
7
7
0
52
DESCRIBE `users`
35
35
1
53
DESCRIBE `roles`
5
5
0
54
DESCRIBE `archivestypes`
5
5
0
55
DESCRIBE `pages`
9
9
0
56
DESCRIBE `pages_translations`
6
6
0
57
DESCRIBE `orders`
18
18
0
58
DESCRIBE `invoices`
22
22
0
59
DESCRIBE `orderproducts`
10
10
0
60
DESCRIBE `latestsearches`
6
6
0
61
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` IS NULL AND `Category`.`published` = 1 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
7
7
0
62
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 78 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
3
3
0
63
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 76 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
3
3
0
64
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 75 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
5
5
0
65
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 77 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
0
0
0
66
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 79 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
2
2
0
67
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 3002 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
0
0
0
68
SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 80 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC
0
0
0
69
SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 4 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1
1
1
0
70
SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 41 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1
1
1
0
71
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` IS NULL AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catcolleccion`.`order` DESC
6
6
0
72
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 95 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
3
3
0
73
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 94 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
6
6
0
74
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1719 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
75
SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 1719 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
4
4
0
76
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 96 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
77
SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 96 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
7
7
0
78
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1720 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
6
6
0
79
SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1721 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
80
SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 1721 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
13
13
0
81
SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` IS NULL AND `Catformacion`.`published` = 1 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC
3
3
0
82
SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 147 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC
0
0
0
83
SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 147 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC
8
8
0
84
SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 145 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC
0
0
0
85
SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 145 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC
18
18
0
86
SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 146 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC
0
0
0
87
SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 146 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC
39
39
0
88
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` IS NULL AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catinstrument`.`order` DESC
6
6
0
89
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 71 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
5
5
0
90
SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 71 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
91
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 70 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
5
5
0
92
SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 70 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
93
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 73 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
4
4
0
94
SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 73 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
95
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 72 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
5
5
0
96
SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 72 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
97
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 74 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
98
SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 74 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
64
64
0
99
SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 1699 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
0
0
0
100
SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 1699 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
32
32
0
101
SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 42 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1
1
1
0
102
SELECT `Page`.`id`, `I18n__name`.`content`, `I18n__url`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') WHERE `Page`.`parent_id` = 43 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `Page`.`order` DESC
5
5
0
103
SELECT `Latestsearch`.`id`, `Latestsearch`.`text`, `Latestsearch`.`q`, `Latestsearch`.`url`, `Latestsearch`.`count`, `Latestsearch`.`lang` FROM `latestsearches` AS `Latestsearch` WHERE 1 = 1 ORDER BY `count` DESC LIMIT 30
30
30
0
104
SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1
1
1
0
105
SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` IS NULL AND `Catformacion`.`published` = '1' AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC
3
3
0
106
SELECT `Catinstrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') WHERE `Catinstrument`.`parent_id` IN (70,71,72,73,74,1699) AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC
19
19
0
107
SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`published` = '1' AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `order` DESC
42
42
0
108
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') WHERE `Publicacion`.`titol` LIKE '0%'
1
1
1
109
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') WHERE `Publicacion`.`titol` LIKE '1%'
1
1
1
110
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') WHERE `Publicacion`.`titol` LIKE '2%'
1
1
1
111
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '3%') WHERE `Publicacion`.`titol` LIKE '3%'
1
1
1
112
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '4%') WHERE `Publicacion`.`titol` LIKE '4%'
1
1
1
113
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '5%') WHERE `Publicacion`.`titol` LIKE '5%'
1
1
1
114
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '6%') WHERE `Publicacion`.`titol` LIKE '6%'
1
1
1
115
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '7%') WHERE `Publicacion`.`titol` LIKE '7%'
1
1
1
116
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '8%') WHERE `Publicacion`.`titol` LIKE '8%'
1
1
1
117
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '9%') WHERE `Publicacion`.`titol` LIKE '9%'
1
1
1
118
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'A%') WHERE `Publicacion`.`titol` LIKE 'A%'
1
1
3
119
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'B%') WHERE `Publicacion`.`titol` LIKE 'B%'
1
1
2
120
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'C%') WHERE `Publicacion`.`titol` LIKE 'C%'
1
1
7
121
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'D%') WHERE `Publicacion`.`titol` LIKE 'D%'
1
1
6
122
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'E%') WHERE `Publicacion`.`titol` LIKE 'E%'
1
1
11
123
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'F%') WHERE `Publicacion`.`titol` LIKE 'F%'
1
1
2
124
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'G%') WHERE `Publicacion`.`titol` LIKE 'G%'
1
1
1
125
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'H%') WHERE `Publicacion`.`titol` LIKE 'H%'
1
1
2
126
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') WHERE `Publicacion`.`titol` LIKE 'I%'
1
1
2
127
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') WHERE `Publicacion`.`titol` LIKE 'J%'
1
1
2
128
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') WHERE `Publicacion`.`titol` LIKE 'K%'
1
1
1
129
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') WHERE `Publicacion`.`titol` LIKE 'L%'
1
1
6
130
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'M%') WHERE `Publicacion`.`titol` LIKE 'M%'
1
1
5
131
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'N%') WHERE `Publicacion`.`titol` LIKE 'N%'
1
1
2
132
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'O%') WHERE `Publicacion`.`titol` LIKE 'O%'
1
1
2
133
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'P%') WHERE `Publicacion`.`titol` LIKE 'P%'
1
1
4
134
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Q%') WHERE `Publicacion`.`titol` LIKE 'Q%'
1
1
2
135
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') WHERE `Publicacion`.`titol` LIKE 'R%'
1
1
2
136
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') WHERE `Publicacion`.`titol` LIKE 'S%'
1
1
5
137
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'T%') WHERE `Publicacion`.`titol` LIKE 'T%'
1
1
4
138
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'U%') WHERE `Publicacion`.`titol` LIKE 'U%'
1
1
1
139
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'V%') WHERE `Publicacion`.`titol` LIKE 'V%'
1
1
2
140
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') WHERE `Publicacion`.`titol` LIKE 'W%'
1
1
1
141
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') WHERE `Publicacion`.`titol` LIKE 'X%'
1
1
1
142
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Y%') WHERE `Publicacion`.`titol` LIKE 'Y%'
1
1
1
143
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Z%') WHERE `Publicacion`.`titol` LIKE 'Z%'
1
1
1
144
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb') WHERE 1 = 1
1
1
50
145
SELECT DISTINCT `Publicacion`.`id`, `Publicacion`.`format`, `Publicacion`.`preu`, `Publicacion`.`created`, `Publicacion`.`novetat`, `Publicacion`.`en_preparacio`, `Publicacion`.`recomanat`, `Publicacion`.`exhaurit`, `Publicacion`.`oferta`, `I18n__titol`.`content`, `I18n__url`.`content`, `I18n__intro`.`content`, `Publicacion`.`id` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__titol` ON (`Publicacion`.`id` = `I18n__titol`.`foreign_key` AND `I18n__titol`.`model` = 'Publicacion' AND `I18n__titol`.`field` = 'titol') LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `publicacion_translations` AS `I18n__intro` ON (`Publicacion`.`id` = `I18n__intro`.`foreign_key` AND `I18n__intro`.`model` = 'Publicacion' AND `I18n__intro`.`field` = 'intro') WHERE `I18n__titol`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__intro`.`locale` = 'en_gb' ORDER BY `Publicacion`.`created` DESC LIMIT 2226, 7
7
7
146
146
SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Publicacion' AND `Archivesrelation`.`foreign_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) ORDER BY `Archivesrelation`.`order` ASC
18
18
2
147
SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`name`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`model` = 'Publicacion' AND `Rating`.`model_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961)
0
0
0
148
SELECT `Comment`.`id`, `Comment`.`publicacion_id`, `Comment`.`replay_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`replay_id`=0 AND `Comment`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) ORDER BY `Comment`.`id` ASC
0
0
0
149
SELECT `Autor`.`id`, `Autor`.`nom`, `Autor`.`cognom`, `Autor`.`2cognom`, `Autor`.`curriculum`, `Autor`.`data_desconeguda`, `Autor`.`data_naixement`, `Autor`.`nomes_any_naixement`, `Autor`.`nomes_any_defuncio`, `Autor`.`defuncio`, `Autor`.`data_defuncio`, `Autor`.`data_defuncio_desconeguda`, `Autor`.`url`, `Autor`.`published`, `PublicacionsAutor`.`id`, `PublicacionsAutor`.`autor_id`, `PublicacionsAutor`.`publicacion_id`, `PublicacionsAutor`.`funcion_id` FROM `autors` AS `Autor` JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC
25
25
1
150
SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`parent_id`, `Category`.`descripcio`, `Category`.`order`, `Category`.`lft`, `Category`.`rght`, `Category`.`published`, `PublicacionsCategory`.`id`, `PublicacionsCategory`.`publicacion_id`, `PublicacionsCategory`.`category_id` FROM `categories` AS `Category` JOIN `publicacions_categories` AS `PublicacionsCategory` ON (`PublicacionsCategory`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsCategory`.`category_id` = `Category`.`id`)
7
7
1
151
SELECT `Colleccion`.`id`, `Colleccion`.`nom`, `Colleccion`.`catcolleccion_id`, `Colleccion`.`descripcio`, `Colleccion`.`order`, `Colleccion`.`url`, `Colleccion`.`published`, `PublicacionsColleccion`.`id`, `PublicacionsColleccion`.`colleccion_id`, `PublicacionsColleccion`.`publicacion_id`, `PublicacionsColleccion`.`num_volum` FROM `colleccions` AS `Colleccion` JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC
7
7
0
152
SELECT `Editor`.`id`, `Editor`.`nom`, `PublicacionsEditor`.`id`, `PublicacionsEditor`.`publicacion_id`, `PublicacionsEditor`.`editor_id`, `PublicacionsEditor`.`data_edicio`, `PublicacionsEditor`.`num_edicio`, `PublicacionsEditor`.`data_reimpresio`, `PublicacionsEditor`.`data_reimpresio_nul`, `PublicacionsEditor`.`num_reimpresio`, `PublicacionsEditor`.`deposito_legal` FROM `editors` AS `Editor` JOIN `publicacions_editors` AS `PublicacionsEditor` ON (`PublicacionsEditor`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`)
7
7
0
153
SELECT `Enquadernacion`.`id`, `Enquadernacion`.`nom`, `Enquadernacion`.`published`, `PublicacionsEnquadernacion`.`id`, `PublicacionsEnquadernacion`.`publicacion_id`, `PublicacionsEnquadernacion`.`enquadernacion_id` FROM `enquadernacions` AS `Enquadernacion` JOIN `publicacions_enquadernacions` AS `PublicacionsEnquadernacion` ON (`PublicacionsEnquadernacion`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`)
7
7
0
154
SELECT `Formacion`.`id`, `Formacion`.`nom`, `Formacion`.`catformacion_id`, `Formacion`.`order`, `Formacion`.`url`, `Formacion`.`published`, `Formacion`.`metadescription`, `PublicacionsFormacion`.`id`, `PublicacionsFormacion`.`publicacion_id`, `PublicacionsFormacion`.`formacion_id` FROM `formacions` AS `Formacion` JOIN `publicacions_formacions` AS `PublicacionsFormacion` ON (`PublicacionsFormacion`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`)
0
0
0
155
SELECT `Idioma`.`id`, `Idioma`.`nom`, `Idioma`.`published`, `Idioma`.`url`, `PublicacionsIdioma`.`id`, `PublicacionsIdioma`.`publicacion_id`, `PublicacionsIdioma`.`idioma_id` FROM `idiomas` AS `Idioma` JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`)
7
7
0
156
SELECT `Instrument`.`id`, `Instrument`.`nom`, `Instrument`.`catinstrument_id`, `Instrument`.`published`, `Instrument`.`url`, `Instrument`.`metadescription`, `PublicacionsInstrument`.`id`, `PublicacionsInstrument`.`publicacion_id`, `PublicacionsInstrument`.`instrument_id`, `PublicacionsInstrument`.`priority` FROM `instruments` AS `Instrument` JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC
0
0
0
157
SELECT `Mida`.`id`, `Mida`.`nom`, `Mida`.`orientacio`, `Mida`.`published`, `PublicacionsMida`.`id`, `PublicacionsMida`.`publicacion_id`, `PublicacionsMida`.`mida_id` FROM `midas` AS `Mida` JOIN `publicacions_midas` AS `PublicacionsMida` ON (`PublicacionsMida`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsMida`.`mida_id` = `Mida`.`id`)
6
6
0
158
SELECT `Retractilat`.`id`, `Retractilat`.`nom`, `Retractilat`.`published`, `PublicacionsRetractilat`.`id`, `PublicacionsRetractilat`.`publicacion_id`, `PublicacionsRetractilat`.`retractilat_id` FROM `retractilats` AS `Retractilat` JOIN `publicacions_retractilats` AS `PublicacionsRetractilat` ON (`PublicacionsRetractilat`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`)
0
0
0
159
SELECT `Newsletter`.`id`, `Newsletter`.`slug`, `Newsletter`.`titol`, `Newsletter`.`assumpte`, `Newsletter`.`intro`, `Newsletter`.`data`, `Newsletter`.`published`, `NewslettersPublicacion`.`id`, `NewslettersPublicacion`.`publicacion_id`, `NewslettersPublicacion`.`newsletter_id` FROM `newsletters` AS `Newsletter` JOIN `newsletters_publicacions` AS `NewslettersPublicacion` ON (`NewslettersPublicacion`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`)
9
9
0
160
SELECT `Rsspost`.`id`, `Rsspost`.`rss_id`, `Rsspost`.`titol`, `Rsspost`.`html`, `Rsspost`.`data_creacio`, `Rsspost`.`data_ordenacio`, `Rsspost`.`data_publica`, `Rsspost`.`slug`, `Rsspost`.`extlink`, `Rsspost`.`published`, `RsspostsPublicacion`.`id`, `RsspostsPublicacion`.`rsspost_id`, `RsspostsPublicacion`.`publicacion_id` FROM `rssposts` AS `Rsspost` JOIN `rssposts_publicacions` AS `RsspostsPublicacion` ON (`RsspostsPublicacion`.`publicacion_id` IN (1968, 1967, 1966, 1965, 1963, 1962, 1961) AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`)
0
0
0
161
SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb') WHERE 1 = 1
1
1
0
162
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1780 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
163
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1780 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
164
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1780 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
165
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1758 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
166
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1780 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
167
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1779 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
168
SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1779 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
169
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 85 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
170
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 76 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
171
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 85 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
172
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 76 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
173
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 85 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
174
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 76 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
175
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
176
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
177
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 85 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
178
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 76 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
179
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 85 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
180
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 76 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
181
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 85 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
182
SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 76 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1
1
1
0
183
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2374 LIMIT 1
1
1
0
184
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2371 LIMIT 1
1
1
0
185
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2370 LIMIT 1
1
1
0
186
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2130 LIMIT 1
1
1
0
187
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2367 LIMIT 1
1
1
0
188
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2364 LIMIT 1
1
1
0
189
SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2361 LIMIT 1
