Dinsic > Partituras > Avanzado > Trincameró

0.0 / 5 (0 votes)

Trincameró

Inside Pages

Download

Autor

Joan-Lluís Moraleda Perxachs

Field

Partituras Avanzado

Collection

Materiales per a banda sinfónica Nr. 7

Language

Catalán, Música

Format

Rental Materials

Trincameró es una obra en tres movimientos, original para tres tenoras solistas con acompañamiento de cobla. Fue presentada dentro del ciclo Cobla, Cor i Dansa al Palau gracias al encargo de la Fundació Orfeó Català Palau de la Música con motivo del 150 aniversario de la existencia de la tenora. Así, el 23 de febrero del año 2000 se programó dentro del ciclo el concierto titulado “El gran virtuosisme de tenora”, donde se estrenó esta obra con la participación de los solistas Josep Gispert, Jordi Molina y Jaume Villano, acompañados de la cobla La Principal de la Bisbal bajo la dirección del autor.
El formato del concierto pretendía emular el éxito que habían tenido años antes, en los 90, los conciertos de Los Tres Tenores (Pavarotti, Domingo y Carreras), haciendo el paralelismo entre los tres tenores (cantantes) y las tres tenoras (instrumentistas). Después del estreno oficial, se programaría el mismo formato de concierto en varios festivales de música del país.

Posteriormente, y debido a la buena acogida general de la obra, la Banda Municipal de Barcelona me pidió también una transcripción para esta formación. Transcripción que se estrenó el día 29 de octubre de 2017 en un concierto a la Sala 2 de L’Auditori de Barcelona, con los solistas Jordi Figaró, Enric Ortí y Jordi Molina con acompañamiento de la Banda Municipal y Salvador Brotons a la dirección.

Instrumental and vocal formations

Banda sinfónica

Technical Specifications

Measurements

24 x 34 cm, vertical

Binding

Espiral en la partitura general y grapa en las particelas.

Number of Pages

Number of parts

Number of Pages of Parts

268

ISMN

979-0-69231-839-2

Editor

DINSIC Publicacions Musicals

Notice (8): Undefined variable: five_level_set [APP/views/elements/lateral.ctp, line 145]

Code | Context

$___viewFn	=	"/var/www/test-dinsic/trunk/app/views/elements/lateral.ctp"
$___dataForView	=	array(
	"identify" => null,
	"sesionLang" => "es",
	"categories" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"qui_som" => array(
	"Page" => array()
),
	"que_fem" => array(
	"Page" => array()
),
	"listcolleccions" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"listformacions" => array(
	array(),
	array(),
	array()
),
	"listinstruments" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"paypal" => array(
	"Page" => array()
),
	"perfils_lateral" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"cloud" => " &nbsp; <a href="/searches/index/q:partitura" class="word size8">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size3">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size1">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size6">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size1">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size8">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size1">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size9">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size9">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size8">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size1">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size4">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size6">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size4">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size7">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size9">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size1">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size9">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size7">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size3">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size6">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size6">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size2">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size6">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size1">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size4">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size6">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size5">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size1">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size6">acompañamiento de canciones infantiles</a> &nbsp;",
	"descompte" => 0.05,
	"options_third_level" => array(
	"Todos los tipos",
	"musica_orquestal" => "Música orquestal ",
	"musica_vocal_y_coral" => "Música vocal y coral",
	"musica_instrumental" => "Música instrumental "
),
	"options_instruments_level" => array(
	"Todos los Instrumentos",
	"bisel" => "Bisel",
	"boquilla" => "Boquilla",
	"cana_simple" => "Caña simple",
	"cuerda_frotada" => "Cuerda frotada",
	"cuerda_frotada_violines" => "Cuerda frotada: violines",
	"cuerda_pinzada_guitarras" => "Cuerda pinzada: guitarras",
	"cuerda_pinzada_ukelele" => "Cuerda pinzada: ukelele",
	"cuerda_pinzada_varios" => "Cuerda pinzada: varios",
	"doble_cana" => "Doble caña",
	"instrumentos_de_percussion_orff" => "Instrumentos de percussión Orff",
	"instruments_de_vent_a_determinar" => "Instruments de vent a determinar",
	"percusion_de_so_nido_determinado" => "Percusión de so nido determinado",
	"percusion_de_sonido_indeterminado" => "Percusión de sonido indeterminado",
	"percusion_no_especificada" => "Percusión no especificada",
	"tecla_cuerda_frotada" => "Tecla / Cuerda frotada",
	"tecla_cuerda_percutida" => "Tecla / Cuerda percutida",
	"tecla_cuerda_pinzada" => "Tecla / Cuerda pinzada",
	"tecla_viento" => "Tecla / Viento",
	"teclado_electronico" => "Teclado electrónico"
),
	"pages" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"total_basket" => 0,
	"total_basket_count" => 0,
	"admin" => false,
	"selected_controller" => "publicacions",
	"browser" => array(
	"browsertype" => null,
	"version" => "",
	"platform" => null,
	"AOL" => false
),
	"selectedtab" => false,
	"url_info_descarregable" => "como_bajar_el_material_gratuito_asociado_a_esta_publicacion",
	"vectorUrls" => array(
	"ca_es" => "/publicacions-clasificacio-general/path/card/partitura_de_lloguer-mbs7-trincamero",
	"es_es" => "/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero",
	"en_gb" => "/publications-subject-areas/path/card/partitura_de_lloguer-mbs7-trincamero"
),
	"editor" => array(
	"Editor" => array()
),
	"funcions" => array(
	"dalt" => array(),
	"baix" => array()
),
	"breadcrumb" => array(
	array(),
	array(),
	array()
),
	"description" => "Trincamer&oacute; es una obra en tres movimientos, original para tres tenoras solistas con acompa&ntilde;amiento de cobla. Fue presentada dentro del ciclo Cobla, Cor i Dansa al Palau gracias al encargo de la Fundaci&oacute; Orfe&oacute; Catal&agrave; Palau de la M&uacute;sica con motivo del 150 aniversario de la existencia de la tenora. As&iacute;, el 23 de febrero del a&ntilde;o 2000 se program&oacute; dentro del ciclo el concierto titulado &ldquo;El gran virtuosisme de tenora&rdquo;, donde se estren&oacute; esta obra con la participaci&oacute;n de los solistas Josep Gispert, Jordi Molina y Jaume Villano, acompa&ntilde;ados de la cobla La Principal de la Bisbal bajo la direcci&oacute;n del autor.  	El formato del concierto pretend&iacute;a emular el &eacute;xito que hab&iacute;an tenido a&ntilde;os antes, en los 90, los conciertos de Los Tres Tenores (Pavarotti, Domingo y Carreras), haciendo el paralelismo entre los tres tenores (cantantes) y las tres tenoras (instrumentistas). Despu&eacute;s del estreno oficial, se programar&iacute;a el mismo formato de concierto en varios festivales de m&uacute;sica del pa&iacute;s.  	  	Posteriormente, y debido a la buena acogida general de la obra, la Banda Municipal de Barcelona me pidi&oacute; tambi&eacute;n una transcripci&oacute;n para esta formaci&oacute;n. Transcripci&oacute;n que se estren&oacute; el d&iacute;a 29 de octubre de 2017 en un concierto a la Sala 2 de L&rsquo;Auditori de Barcelona, con los solistas Jordi Figar&oacute;, Enric Ort&iacute; y Jordi Molina con acompa&ntilde;amiento de la Banda Municipal y Salvador Brotons a la direcci&oacute;n.",
	"keywords" => "Trincameró, 979-0-69231-839-2, Trincameró, Symphonic Band Materials, Banda sinfónica, Materiales per a banda sinfónica, Joan-Lluís Moraleda Perxachs",
	"img_src" => "test.dinsic.com/img/cache/23c3b0a2f30043bb689e5fb6677278bb-10213-151.jpg",
	"relacionats" => array(),
	"publicacion" => 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()
),
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"text" => "Joan-Lluís Moraleda Perxachs",
	"search" => SearchHelper
SearchHelper::$helpers = array
SearchHelper::$base = ""
SearchHelper::$webroot = "/"
SearchHelper::$themeWeb = NULL
SearchHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
SearchHelper::$params = array
SearchHelper::$action = "display"
SearchHelper::$plugin = NULL
SearchHelper::$data = NULL
SearchHelper::$namedArgs = NULL
SearchHelper::$argSeparator = NULL
SearchHelper::$validationErrors = NULL
SearchHelper::$tags = array
SearchHelper::$__tainted = NULL
SearchHelper::$__cleaned = NULL
SearchHelper::$_log = NULL
SearchHelper::$Html = HtmlHelper object
SearchHelper::$Javascript = JavascriptHelper object,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
JavascriptHelper::$params = array
JavascriptHelper::$action = "display"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"adminmenu" => AdminmenuHelper
AdminmenuHelper::$helpers = array
AdminmenuHelper::$base = ""
AdminmenuHelper::$webroot = "/"
AdminmenuHelper::$themeWeb = NULL
AdminmenuHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
AdminmenuHelper::$params = array
AdminmenuHelper::$action = "display"
AdminmenuHelper::$plugin = NULL
AdminmenuHelper::$data = NULL
AdminmenuHelper::$namedArgs = NULL
AdminmenuHelper::$argSeparator = NULL
AdminmenuHelper::$validationErrors = NULL
AdminmenuHelper::$tags = array
AdminmenuHelper::$__tainted = NULL
AdminmenuHelper::$__cleaned = NULL
AdminmenuHelper::$_log = NULL
AdminmenuHelper::$Html = HtmlHelper object
AdminmenuHelper::$Javascript = JavascriptHelper object,
	"rss" => RssHelper
RssHelper::$helpers = array
RssHelper::$base = ""
RssHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
RssHelper::$params = array
RssHelper::$action = "display"
RssHelper::$data = NULL
RssHelper::$model = NULL
RssHelper::$field = NULL
RssHelper::$version = "2.0"
RssHelper::$encoding = "UTF-8"
RssHelper::$webroot = "/"
RssHelper::$themeWeb = NULL
RssHelper::$plugin = NULL
RssHelper::$namedArgs = NULL
RssHelper::$argSeparator = NULL
RssHelper::$validationErrors = NULL
RssHelper::$tags = array
RssHelper::$__tainted = NULL
RssHelper::$__cleaned = NULL
RssHelper::$_log = NULL
RssHelper::$Xml = Xml object
RssHelper::$Time = TimeHelper object,
	"time" => TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
TimeHelper::$params = array
TimeHelper::$action = "display"
TimeHelper::$plugin = NULL
TimeHelper::$data = NULL
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL,
	"library" => LibraryHelper
LibraryHelper::$helpers = array
LibraryHelper::$base = ""
LibraryHelper::$webroot = "/"
LibraryHelper::$themeWeb = NULL
LibraryHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
LibraryHelper::$params = array
LibraryHelper::$action = "display"
LibraryHelper::$plugin = NULL
LibraryHelper::$data = NULL
LibraryHelper::$namedArgs = NULL
LibraryHelper::$argSeparator = NULL
LibraryHelper::$validationErrors = NULL
LibraryHelper::$tags = array
LibraryHelper::$__tainted = NULL
LibraryHelper::$__cleaned = NULL
LibraryHelper::$_log = NULL
LibraryHelper::$Html = HtmlHelper object
LibraryHelper::$Javascript = JavascriptHelper object,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "337eccbd43ced36b81f70fcab2883ac8"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1743830064
SessionHelper::$sessionTime = 1743852064
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$identify	=	null
$sesionLang	=	"es"
$categories	=	array(
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
)
)
$qui_som	=	array(
	"Page" => array(
	"id" => "4",
	"order" => "36",
	"parent_id" => null,
	"name" => "¿Quiénes somos?",
	"html" => "<div>
	Situada en pleno coraz&oacute;n de la Barcelona antigua, DINSIC Publicacions Musicals, S.L. fue fundada en 1988 por Francesca Galofr&eacute; Mora con una fuerte vocaci&oacute;n educativa y con la intenci&oacute;n de difundir el conocimiento y la producci&oacute;n musical.<br />
	<br />
	Hoy, tras m&aacute;s de veinte a&ntilde;os de tarea continuada, la editorial se dedica a impulsar la redacci&oacute;n de libros y materiales diversos para la ense&ntilde;anza de la m&uacute;sica en todos sus &aacute;mbitos: escuelas y conservatorios de m&uacute;sica, escuelas de ense&ntilde;anza general en sus diferentes niveles, y tambi&eacute;n la universidad.<br />
	<br />
	Dispone de colecciones de partituras de obras que van desde el instrumento solista, pasando por los grupos y orquestas de c&aacute;mara, hasta la gran orquesta sinf&oacute;nica, as&iacute; como el coro, en sus diversas formaciones. Algunas de estas colecciones disponen de estudios cr&iacute;ticos, publicados en diversos idiomas.</div>
<div>
	&nbsp;</div>
<ul>
	<li>
		<a href="/es/p/presentacion">Presentaci&oacute;n</a></li>
	<li>
		<a href="/es/p/objetivos_de_la_empresa">Objetivos de la empresa</a></li>
	<li>
		<a href="/es/p/los_autores">Los autores</a></li>
	<li>
		<a href="/es/p/cooperaciones">Cooperaciones</a></li>
	<li>
		<a href="/es/p/distribucion_comercial">Distribuci&oacute;n comercial</a></li>
	<li>
		<a href="/es/p/catalogo_de_publicaciones">Cat&aacute;logo de publicaciones</a></li>
</ul>
",
	"url" => "quienes_somos",
	"published" => "1",
	"lft" => "5",
	"rght" => "26",
	"locale" => "es_es"
)
)
$que_fem	=	array(
	"Page" => array(
	"id" => "41",
	"order" => "8",
	"parent_id" => null,
	"name" => "¿A qué nos dedicamos?",
	"html" => "<div>
	En DINSIC, nos dedicamos principalmente a redactar y publicar libros y materiales diversos para la ense&ntilde;anza de la m&uacute;sica, as&iacute; como a editar partituras de m&uacute;sica vocal, instrumental y orquestal destinadas a corales, grupos de c&aacute;mara y orquestas.<br />
	<br />
	Tenemos especial inter&eacute;s en la publicaci&oacute;n de obras musicales acompa&ntilde;adas de comentarios en diversos idiomas (catal&aacute;n, castellano, vasco, franc&eacute;s, occitano, portugu&eacute;s, ingl&eacute;s, alem&aacute;n etc.), y de libros que hablan de la m&uacute;sica y su mundo.<br />
	<br />
	Contamos con una secci&oacute;n de m&uacute;sica tradicional y popular catalana y occitana que, muy pronto, se ver&aacute; ampliada con m&uacute;sica de otras regiones.<br />
	<br />
	En nuestra editorial, trabajamos intensamente para aprovechar las posibilidades de las aplicaciones tecnol&oacute;gicas que las TIC (nuevas tecnolog&iacute;as de la informaci&oacute;n y comunicaci&oacute;n) ofrecen a nuestro campo.<br />
	<br />
	Nuestra p&aacute;gina Web expone el cat&aacute;logo de publicaciones, disponibles en todo tipo de soportes (papel, CD etc.), o bien sin soporte, directamente en l&iacute;nea.<br />
	<br />
	Hemos incorporado a nuestra Web una tienda y un entorno virtual para usuarios registrados, a quienes ofrecemos servicios complementarios de informaci&oacute;n y soporte.</div>
",
	"url" => "a_que_nos_dedicamos",
	"published" => "1",
	"lft" => "71",
	"rght" => "72",
	"locale" => "es_es"
)
)
$listcolleccions	=	array(
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
)
)
$listformacions	=	array(
	array(
	"Catformacion" => array(),
	"children" => array()
),
	array(
	"Catformacion" => array(),
	"children" => array()
),
	array(
	"Catformacion" => array(),
	"children" => array()
)
)
$listinstruments	=	array(
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
)
)
$paypal	=	array(
	"Page" => array(
	"id" => "42",
	"order" => "9",
	"parent_id" => null,
	"name" => "También con PayPal",
	"html" => "<div>
	DINSIC Publicacions Musicals se complace en anunciar que ya se acepta PayPal como forma de pago on-line de sus compras, adem&aacute;s de Visa, Mastercard y otras tarjetas de cr&eacute;dito, u otros sistemas tradicionales de pago como el reembolso postal o de agencia de transportes.<br />
	<br />
	Si no conoces PayPal, este sistema es una de las maneras m&aacute;s eficaces de hacer cobros y pagos internacionales as&iacute; como dentro del pa&iacute;s.<br />
	<br />
	De la misma forma que con el pago on-line con tarjeta de cr&eacute;dito, es un sistema totalmente seguro en el que el comercio vendedor en ning&uacute;n caso tiene acceso a tus datos bancarios.<br />
	<br />
	Vincula tu tarjeta de cr&eacute;dito o d&eacute;bito a PayPal y decide con ellos tu forma preferida de pago.&nbsp;</div>
",
	"url" => "tambien_con_paypal",
	"published" => "1",
	"lft" => "73",
	"rght" => "74",
	"locale" => "es_es"
)
)
$perfils_lateral	=	array(
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
)
)
$cloud	=	" &nbsp; <a href="/searches/index/q:partitura" class="word size8">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size3">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size1">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size6">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size1">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size8">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size1">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size9">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size9">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size8">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size1">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size4">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size6">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size4">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size7">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size9">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size1">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size9">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size7">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size3">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size6">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size6">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size2">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size6">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size1">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size4">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size6">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size5">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size1">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size6">acompañamiento de canciones infantiles</a> &nbsp;"
$descompte	=	0.05
$options_third_level	=	array(
	"Todos los tipos",
	"musica_orquestal" => "Música orquestal ",
	"musica_vocal_y_coral" => "Música vocal y coral",
	"musica_instrumental" => "Música instrumental "
)
$options_instruments_level	=	array(
	"Todos los Instrumentos",
	"bisel" => "Bisel",
	"boquilla" => "Boquilla",
	"cana_simple" => "Caña simple",
	"cuerda_frotada" => "Cuerda frotada",
	"cuerda_frotada_violines" => "Cuerda frotada: violines",
	"cuerda_pinzada_guitarras" => "Cuerda pinzada: guitarras",
	"cuerda_pinzada_ukelele" => "Cuerda pinzada: ukelele",
	"cuerda_pinzada_varios" => "Cuerda pinzada: varios",
	"doble_cana" => "Doble caña",
	"instrumentos_de_percussion_orff" => "Instrumentos de percussión Orff",
	"instruments_de_vent_a_determinar" => "Instruments de vent a determinar",
	"percusion_de_so_nido_determinado" => "Percusión de so nido determinado",
	"percusion_de_sonido_indeterminado" => "Percusión de sonido indeterminado",
	"percusion_no_especificada" => "Percusión no especificada",
	"tecla_cuerda_frotada" => "Tecla / Cuerda frotada",
	"tecla_cuerda_percutida" => "Tecla / Cuerda percutida",
	"tecla_cuerda_pinzada" => "Tecla / Cuerda pinzada",
	"tecla_viento" => "Tecla / Viento",
	"teclado_electronico" => "Teclado electrónico"
)
$pages	=	array(
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
)
)
$total_basket	=	0
$total_basket_count	=	0
$admin	=	false
$selected_controller	=	"publicacions"
$browser	=	array(
	"browsertype" => null,
	"version" => "",
	"platform" => null,
	"AOL" => false
)
$selectedtab	=	false
$url_info_descarregable	=	"como_bajar_el_material_gratuito_asociado_a_esta_publicacion"
$vectorUrls	=	array(
	"ca_es" => "/publicacions-clasificacio-general/path/card/partitura_de_lloguer-mbs7-trincamero",
	"es_es" => "/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero",
	"en_gb" => "/publications-subject-areas/path/card/partitura_de_lloguer-mbs7-trincamero"
)
$editor	=	array(
	"Editor" => array(
	"id" => "102",
	"nom" => "DINSIC Publicacions Musicals"
)
)
$funcions	=	array(
	"dalt" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"baix" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
)
)
$breadcrumb	=	array(
	array(
	"url" => "/es/publicaciones-clasificacion-general/partituras",
	"text" => "Partituras"
),
	array(
	"url" => "/es/publicaciones-clasificacion-general/partituras-avanzado",
	"text" => "Avanzado"
),
	array(
	"url" => "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero",
	"text" => "Trincameró"
)
)
$description	=	"Trincamer&oacute; es una obra en tres movimientos, original para tres tenoras solistas con acompa&ntilde;amiento de cobla. Fue presentada dentro del ciclo Cobla, Cor i Dansa al Palau gracias al encargo de la Fundaci&oacute; Orfe&oacute; Catal&agrave; Palau de la M&uacute;sica con motivo del 150 aniversario de la existencia de la tenora. As&iacute;, el 23 de febrero del a&ntilde;o 2000 se program&oacute; dentro del ciclo el concierto titulado &ldquo;El gran virtuosisme de tenora&rdquo;, donde se estren&oacute; esta obra con la participaci&oacute;n de los solistas Josep Gispert, Jordi Molina y Jaume Villano, acompa&ntilde;ados de la cobla La Principal de la Bisbal bajo la direcci&oacute;n del autor.  	El formato del concierto pretend&iacute;a emular el &eacute;xito que hab&iacute;an tenido a&ntilde;os antes, en los 90, los conciertos de Los Tres Tenores (Pavarotti, Domingo y Carreras), haciendo el paralelismo entre los tres tenores (cantantes) y las tres tenoras (instrumentistas). Despu&eacute;s del estreno oficial, se programar&iacute;a el mismo formato de concierto en varios festivales de m&uacute;sica del pa&iacute;s.  	  	Posteriormente, y debido a la buena acogida general de la obra, la Banda Municipal de Barcelona me pidi&oacute; tambi&eacute;n una transcripci&oacute;n para esta formaci&oacute;n. Transcripci&oacute;n que se estren&oacute; el d&iacute;a 29 de octubre de 2017 en un concierto a la Sala 2 de L&rsquo;Auditori de Barcelona, con los solistas Jordi Figar&oacute;, Enric Ort&iacute; y Jordi Molina con acompa&ntilde;amiento de la Banda Municipal y Salvador Brotons a la direcci&oacute;n."
$keywords	=	"Trincameró, 979-0-69231-839-2, Trincameró, Symphonic Band Materials, Banda sinfónica, Materiales per a banda sinfónica, Joan-Lluís Moraleda Perxachs"
$img_src	=	"test.dinsic.com/img/cache/23c3b0a2f30043bb689e5fb6677278bb-10213-151.jpg"
$relacionats	=	array()
$publicacion	=	array(
	"Publicacion" => array(
	"id" => "12983",
	"oferta" => "0",
	"exhaurit" => "0",
	"material_descarga" => "0",
	"titol_descarga" => "",
	"num_pags" => "76",
	"ismn" => "979-0-69231-839-2",
	"isbn" => "",
	"diposit_legal" => "B 22326-2017",
	"preu" => "380.00",
	"durada" => "",
	"format" => "Partitura de lloguer",
	"n_pag_annex" => null,
	"num_pagines_interiors" => null,
	"numero_particelas" => "31",
	"numero_pagines_particelas" => "268",
	"visible_instrumentacio" => "0",
	"visible_formacions" => "1",
	"novetat" => "1",
	"recomanat" => "0",
	"en_preparacio" => "0",
	"visto" => "2048",
	"rating" => "0.0",
	"locale" => "es_es",
	"titol" => "Trincameró",
	"url" => "partitura_de_lloguer-mbs7-trincamero",
	"published" => "1",
	"continguts_generals" => "<div>
	<strong>Trincamer&oacute;</strong> es una obra en tres movimientos, original para tres tenoras solistas con acompa&ntilde;amiento de cobla. Fue presentada dentro del ciclo Cobla, Cor i Dansa al Palau gracias al encargo de la Fundaci&oacute; Orfe&oacute; Catal&agrave; Palau de la M&uacute;sica con motivo del 150 aniversario de la existencia de la tenora. As&iacute;, el 23 de febrero del a&ntilde;o 2000 se program&oacute; dentro del ciclo el concierto titulado &ldquo;El gran virtuosisme de tenora&rdquo;, donde se estren&oacute; esta obra con la participaci&oacute;n de los solistas Josep Gispert, Jordi Molina y Jaume Villano, acompa&ntilde;ados de la cobla La Principal de la Bisbal bajo la direcci&oacute;n del autor.<br />
	El formato del concierto pretend&iacute;a emular el &eacute;xito que hab&iacute;an tenido a&ntilde;os antes, en los 90, los conciertos de Los Tres Tenores (Pavarotti, Domingo y Carreras), haciendo el paralelismo entre los tres tenores (cantantes) y las tres tenoras (instrumentistas). Despu&eacute;s del estreno oficial, se programar&iacute;a el mismo formato de concierto en varios festivales de m&uacute;sica del pa&iacute;s.<br />
	<br />
	Posteriormente, y debido a la buena acogida general de la obra, la Banda Municipal de Barcelona me pidi&oacute; tambi&eacute;n una transcripci&oacute;n para esta formaci&oacute;n. Transcripci&oacute;n que se estren&oacute; el d&iacute;a 29 de octubre de 2017 en un concierto a la Sala 2 de L&rsquo;Auditori de Barcelona, con los solistas Jordi Figar&oacute;, Enric Ort&iacute; y Jordi Molina con acompa&ntilde;amiento de la Banda Municipal y Salvador Brotons a la direcci&oacute;n.</div>
",
	"estructuracio" => "",
	"ctecnica" => "",
	"ilustracion" => "",
	"info_descarga" => ""
),
	"Archivesrelation" => array(
	array(),
	array(),
	array()
),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(
	array()
),
	"Category" => array(
	array()
),
	"Colleccion" => array(
	array()
),
	"Editor" => array(
	array()
),
	"Enquadernacion" => array(
	array()
),
	"Formacion" => array(
	array()
),
	"Idioma" => array(
	array(),
	array()
),
	"Instrument" => array(),
	"Mida" => array(
	array()
),
	"Retractilat" => array(),
	"Newsletter" => array(
	array()
),
	"Rsspost" => array()
)
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$text	=	"Joan-Lluís Moraleda Perxachs"
$search	=	SearchHelper
SearchHelper::$helpers = array
SearchHelper::$base = ""
SearchHelper::$webroot = "/"
SearchHelper::$themeWeb = NULL
SearchHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
SearchHelper::$params = array
SearchHelper::$action = "display"
SearchHelper::$plugin = NULL
SearchHelper::$data = NULL
SearchHelper::$namedArgs = NULL
SearchHelper::$argSeparator = NULL
SearchHelper::$validationErrors = NULL
SearchHelper::$tags = array
SearchHelper::$__tainted = NULL
SearchHelper::$__cleaned = NULL
SearchHelper::$_log = NULL
SearchHelper::$Html = HtmlHelper object
SearchHelper::$Javascript = JavascriptHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
JavascriptHelper::$params = array
JavascriptHelper::$action = "display"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$adminmenu	=	AdminmenuHelper
AdminmenuHelper::$helpers = array
AdminmenuHelper::$base = ""
AdminmenuHelper::$webroot = "/"
AdminmenuHelper::$themeWeb = NULL
AdminmenuHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
AdminmenuHelper::$params = array
AdminmenuHelper::$action = "display"
AdminmenuHelper::$plugin = NULL
AdminmenuHelper::$data = NULL
AdminmenuHelper::$namedArgs = NULL
AdminmenuHelper::$argSeparator = NULL
AdminmenuHelper::$validationErrors = NULL
AdminmenuHelper::$tags = array
AdminmenuHelper::$__tainted = NULL
AdminmenuHelper::$__cleaned = NULL
AdminmenuHelper::$_log = NULL
AdminmenuHelper::$Html = HtmlHelper object
AdminmenuHelper::$Javascript = JavascriptHelper object
$rss	=	RssHelper
RssHelper::$helpers = array
RssHelper::$base = ""
RssHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
RssHelper::$params = array
RssHelper::$action = "display"
RssHelper::$data = NULL
RssHelper::$model = NULL
RssHelper::$field = NULL
RssHelper::$version = "2.0"
RssHelper::$encoding = "UTF-8"
RssHelper::$webroot = "/"
RssHelper::$themeWeb = NULL
RssHelper::$plugin = NULL
RssHelper::$namedArgs = NULL
RssHelper::$argSeparator = NULL
RssHelper::$validationErrors = NULL
RssHelper::$tags = array
RssHelper::$__tainted = NULL
RssHelper::$__cleaned = NULL
RssHelper::$_log = NULL
RssHelper::$Xml = Xml object
RssHelper::$Time = TimeHelper object
$time	=	TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
TimeHelper::$params = array
TimeHelper::$action = "display"
TimeHelper::$plugin = NULL
TimeHelper::$data = NULL
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL
$library	=	LibraryHelper
LibraryHelper::$helpers = array
LibraryHelper::$base = ""
LibraryHelper::$webroot = "/"
LibraryHelper::$themeWeb = NULL
LibraryHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
LibraryHelper::$params = array
LibraryHelper::$action = "display"
LibraryHelper::$plugin = NULL
LibraryHelper::$data = NULL
LibraryHelper::$namedArgs = NULL
LibraryHelper::$argSeparator = NULL
LibraryHelper::$validationErrors = NULL
LibraryHelper::$tags = array
LibraryHelper::$__tainted = NULL
LibraryHelper::$__cleaned = NULL
LibraryHelper::$_log = NULL
LibraryHelper::$Html = HtmlHelper object
LibraryHelper::$Javascript = JavascriptHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "337eccbd43ced36b81f70fcab2883ac8"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1743830064
SessionHelper::$sessionTime = 1743852064
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/es/publicaciones-clasificacion-general/path/card/partitura_de_lloguer-mbs7-trincamero"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$i	=	0
$cat	=	array(
	"Category" => array(
	"id" => "78",
	"url" => "partituras",
	"name" => "Partituras",
	"parent_id" => null,
	"descripcio" => "<div>
	M&uacute;sica para interpretar: vocal y coral, instrumental (peque&ntilde;os conjuntos, grupos de c&aacute;mara, cobla, etc.) y m&uacute;sica orquestal para diversas formaciones y estilos.</div>
",
	"order" => "7",
	"lft" => "1",
	"rght" => "8",
	"published" => "1",
	"locale" => "es_es"
),
	"Categories" => array(
	array(),
	array(),
	array()
)
)
$subcat	=	array(
	"Category" => array(
	"id" => "89",
	"url" => "intermedio",
	"name" => "Intermedio",
	"parent_id" => "78",
	"descripcio" => "<div>
	La clasificaci&oacute;n del nivel de una partitura normalmente viene determinado por el grado de dificultad t&eacute;cnica del instrumento o voz. En los casos de obras para formaciones instrumentales diversas, orquestales, vocales, etc. el nivel se determina atendiendo a la complejidad general de la obra, no a la de sus instrumentos en particular. Es muy importante conocer este criterio porque las obras de conjunto aparecen tambi&eacute;n en los listados espec&iacute;ficos de cada uno de sus instrumentos o voces que participan en &eacute;l, pero el nivel que se indica es el de la formaci&oacute;n instrumental-vocal.</div>
",
	"order" => "1",
	"lft" => "4",
	"rght" => "5",
	"published" => "1",
	"locale" => "es_es"
)
)

                                    <?php echo $form->input('five_level',array('id'=>'instruments_level2','div'=>false,'label'=>false,'type'=>'select','options'=>$five_level_set,'selected'=>$instrument_level_set_selected)); ?>

                                <?php else: ?>

                                    <?php echo $form->input('five_level',array('id'=>'instruments_level2','div'=>false,'label'=>false,'type'=>'select','options'=>$five_level_set)); ?>

include - APP/views/elements/lateral.ctp, line 145
View::_render() - CORE/cake/libs/view/view.php, line 665
View::element() - CORE/cake/libs/view/view.php, line 342
include - APP/views/layouts/default.ctp, line 493
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
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 228
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88

DIFFICULTY LEVEL:

Subscribe to our Newletter!

You'll receive all the information on our new releases and latest news.

Associations of which we are part

DINSIC Publicacions Musicals, S.L.
Warehouse: Sepúlveda, 84 - 08015 Barcelona (Calàbria / Metro L1 Rocafort)
From Monday to Friday 9:30 - 13:30
Tels. +34 93 832 69 46
[email protected]
Copyright © 1998-2025

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) 224 queries took 248 ms
Nr	Query	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	0
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	0
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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__html`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__html`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__plural`.`locale` = 'es_es' AND `I18n__abreviacio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__plural`.`locale` = 'es_es' AND `I18n__abreviacio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__plural`.`locale` = 'es_es' AND `I18n__abreviacio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__plural`.`locale` = 'es_es' AND `I18n__abreviacio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__plural`.`locale` = 'es_es' AND `I18n__abreviacio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	19	19	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__plural`.`locale` = 'es_es' AND `I18n__abreviacio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	8	8	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` = 'es_es' AND `I18n__html`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' 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` = 'es_es' AND `I18n__html`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `order` DESC	42	42	0
108	SELECT `I18n__url`.`content` FROM `pages` AS `Page` 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`.`id` = 55 AND `I18n__url`.`locale` = 'es_es' LIMIT 1	1	1	0
109	SELECT `Publicacion`.`id`, `Publicacion`.`oferta`, `Publicacion`.`exhaurit`, `Publicacion`.`material_descarga`, `Publicacion`.`titol_descarga`, `Publicacion`.`num_pags`, `Publicacion`.`ismn`, `Publicacion`.`isbn`, `Publicacion`.`diposit_legal`, `Publicacion`.`preu`, `Publicacion`.`durada`, `Publicacion`.`format`, `Publicacion`.`n_pag_annex`, `Publicacion`.`num_pagines_interiors`, `Publicacion`.`numero_particelas`, `Publicacion`.`numero_pagines_particelas`, `Publicacion`.`visible_instrumentacio`, `Publicacion`.`visible_formacions`, `Publicacion`.`novetat`, `Publicacion`.`recomanat`, `Publicacion`.`en_preparacio`, `Publicacion`.`visto`, `Publicacion`.`rating`, `I18n__titol`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__continguts_generals`.`content`, `I18n__estructuracio`.`content`, `I18n__ctecnica`.`content`, `I18n__ilustracion`.`content`, `I18n__info_descarga`.`content` 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__published` ON (`Publicacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Publicacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `publicacion_translations` AS `I18n__continguts_generals` ON (`Publicacion`.`id` = `I18n__continguts_generals`.`foreign_key` AND `I18n__continguts_generals`.`model` = 'Publicacion' AND `I18n__continguts_generals`.`field` = 'continguts_generals') LEFT JOIN `publicacion_translations` AS `I18n__estructuracio` ON (`Publicacion`.`id` = `I18n__estructuracio`.`foreign_key` AND `I18n__estructuracio`.`model` = 'Publicacion' AND `I18n__estructuracio`.`field` = 'estructuracio') LEFT JOIN `publicacion_translations` AS `I18n__ctecnica` ON (`Publicacion`.`id` = `I18n__ctecnica`.`foreign_key` AND `I18n__ctecnica`.`model` = 'Publicacion' AND `I18n__ctecnica`.`field` = 'ctecnica') LEFT JOIN `publicacion_translations` AS `I18n__ilustracion` ON (`Publicacion`.`id` = `I18n__ilustracion`.`foreign_key` AND `I18n__ilustracion`.`model` = 'Publicacion' AND `I18n__ilustracion`.`field` = 'ilustracion') LEFT JOIN `publicacion_translations` AS `I18n__info_descarga` ON (`Publicacion`.`id` = `I18n__info_descarga`.`foreign_key` AND `I18n__info_descarga`.`model` = 'Publicacion' AND `I18n__info_descarga`.`field` = 'info_descarga') WHERE `I18n__url`.`content` = 'partitura_de_lloguer-mbs7-trincamero' AND `I18n__titol`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__continguts_generals`.`locale` = 'es_es' AND `I18n__estructuracio`.`locale` = 'es_es' AND `I18n__ctecnica`.`locale` = 'es_es' AND `I18n__ilustracion`.`locale` = 'es_es' AND `I18n__info_descarga`.`locale` = 'es_es' LIMIT 1	1	1	232
110	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` = (12983) ORDER BY `Archivesrelation`.`order` ASC	3	3	2
111	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` = (12983)	0	0	0
112	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` = (12983) ORDER BY `Comment`.`id` ASC	0	0	0
113	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` = 12983 AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC	1	1	1
114	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` = 12983 AND `PublicacionsCategory`.`category_id` = `Category`.`id`)	1	1	0
115	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` = 12983 AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC	1	1	5
116	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` = 12983 AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`)	1	1	0
117	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` = 12983 AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`)	1	1	0
118	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` = 12983 AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`)	1	1	0
119	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` = 12983 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`)	2	2	0
120	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` = 12983 AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC	0	0	0
121	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` = 12983 AND `PublicacionsMida`.`mida_id` = `Mida`.`id`)	1	1	0
122	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` = 12983 AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`)	0	0	0
123	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` = 12983 AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`)	1	1	0
124	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` = 12983 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`)	0	0	0
125	SELECT `I18n__url`.`content` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') WHERE `Publicacion`.`id` = 12983 AND `I18n__url`.`locale` = 'ca_es' LIMIT 1	1	1	0
126	SELECT COUNT(*) AS `count` FROM `publicacions` AS `Publicacion` WHERE `Publicacion`.`id` = 12983	1	1	0
127	SELECT `Publicacion`.*, `I18n__titol`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__intro`.`content`, `I18n__continguts_generals`.`content`, `I18n__estructuracio`.`content`, `I18n__ctecnica`.`content`, `I18n__ilustracion`.`content`, `I18n__info_descarga`.`content` 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__published` ON (`Publicacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Publicacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `publicacion_translations` AS `I18n__intro` ON (`Publicacion`.`id` = `I18n__intro`.`foreign_key` AND `I18n__intro`.`model` = 'Publicacion' AND `I18n__intro`.`field` = 'intro') LEFT JOIN `publicacion_translations` AS `I18n__continguts_generals` ON (`Publicacion`.`id` = `I18n__continguts_generals`.`foreign_key` AND `I18n__continguts_generals`.`model` = 'Publicacion' AND `I18n__continguts_generals`.`field` = 'continguts_generals') LEFT JOIN `publicacion_translations` AS `I18n__estructuracio` ON (`Publicacion`.`id` = `I18n__estructuracio`.`foreign_key` AND `I18n__estructuracio`.`model` = 'Publicacion' AND `I18n__estructuracio`.`field` = 'estructuracio') LEFT JOIN `publicacion_translations` AS `I18n__ctecnica` ON (`Publicacion`.`id` = `I18n__ctecnica`.`foreign_key` AND `I18n__ctecnica`.`model` = 'Publicacion' AND `I18n__ctecnica`.`field` = 'ctecnica') LEFT JOIN `publicacion_translations` AS `I18n__ilustracion` ON (`Publicacion`.`id` = `I18n__ilustracion`.`foreign_key` AND `I18n__ilustracion`.`model` = 'Publicacion' AND `I18n__ilustracion`.`field` = 'ilustracion') LEFT JOIN `publicacion_translations` AS `I18n__info_descarga` ON (`Publicacion`.`id` = `I18n__info_descarga`.`foreign_key` AND `I18n__info_descarga`.`model` = 'Publicacion' AND `I18n__info_descarga`.`field` = 'info_descarga') WHERE `Publicacion`.`id` = 12983 AND `I18n__titol`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__intro`.`locale` = 'ca_es' AND `I18n__continguts_generals`.`locale` = 'ca_es' AND `I18n__estructuracio`.`locale` = 'ca_es' AND `I18n__ctecnica`.`locale` = 'ca_es' AND `I18n__ilustracion`.`locale` = 'ca_es' AND `I18n__info_descarga`.`locale` = 'ca_es' LIMIT 1	1	1	1
128	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` = 12983 AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC	1	1	0
129	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` = 12983 AND `PublicacionsCategory`.`category_id` = `Category`.`id`)	1	1	0
130	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` = 12983 AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC	1	1	0
131	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` = 12983 AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`)	1	1	0
132	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` = 12983 AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`)	1	1	0
133	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` = 12983 AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`)	1	1	0
134	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` = 12983 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`)	2	2	0
135	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` = 12983 AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC	0	0	0
136	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` = 12983 AND `PublicacionsMida`.`mida_id` = `Mida`.`id`)	1	1	0
137	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` = 12983 AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`)	0	0	0
138	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` = 12983 AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`)	1	1	0
139	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` = 12983 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`)	0	0	0
140	UPDATE `publicacions` SET `visto` = 2049, `modified` = '2025-04-05 07:14:24' WHERE `publicacions`.`id` = 12983	1		1
141	SELECT `Publicacion`.*, `I18n__titol`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__intro`.`content`, `I18n__continguts_generals`.`content`, `I18n__estructuracio`.`content`, `I18n__ctecnica`.`content`, `I18n__ilustracion`.`content`, `I18n__info_descarga`.`content` 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__published` ON (`Publicacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Publicacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `publicacion_translations` AS `I18n__intro` ON (`Publicacion`.`id` = `I18n__intro`.`foreign_key` AND `I18n__intro`.`model` = 'Publicacion' AND `I18n__intro`.`field` = 'intro') LEFT JOIN `publicacion_translations` AS `I18n__continguts_generals` ON (`Publicacion`.`id` = `I18n__continguts_generals`.`foreign_key` AND `I18n__continguts_generals`.`model` = 'Publicacion' AND `I18n__continguts_generals`.`field` = 'continguts_generals') LEFT JOIN `publicacion_translations` AS `I18n__estructuracio` ON (`Publicacion`.`id` = `I18n__estructuracio`.`foreign_key` AND `I18n__estructuracio`.`model` = 'Publicacion' AND `I18n__estructuracio`.`field` = 'estructuracio') LEFT JOIN `publicacion_translations` AS `I18n__ctecnica` ON (`Publicacion`.`id` = `I18n__ctecnica`.`foreign_key` AND `I18n__ctecnica`.`model` = 'Publicacion' AND `I18n__ctecnica`.`field` = 'ctecnica') LEFT JOIN `publicacion_translations` AS `I18n__ilustracion` ON (`Publicacion`.`id` = `I18n__ilustracion`.`foreign_key` AND `I18n__ilustracion`.`model` = 'Publicacion' AND `I18n__ilustracion`.`field` = 'ilustracion') LEFT JOIN `publicacion_translations` AS `I18n__info_descarga` ON (`Publicacion`.`id` = `I18n__info_descarga`.`foreign_key` AND `I18n__info_descarga`.`model` = 'Publicacion' AND `I18n__info_descarga`.`field` = 'info_descarga') WHERE `Publicacion`.`id` = 12983 AND `I18n__titol`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__intro`.`locale` = 'ca_es' AND `I18n__continguts_generals`.`locale` = 'ca_es' AND `I18n__estructuracio`.`locale` = 'ca_es' AND `I18n__ctecnica`.`locale` = 'ca_es' AND `I18n__ilustracion`.`locale` = 'ca_es' AND `I18n__info_descarga`.`locale` = 'ca_es' LIMIT 1	1	1	1
142	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` = 12983 AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC	1	1	0
143	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` = 12983 AND `PublicacionsCategory`.`category_id` = `Category`.`id`)	1	1	0
144	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` = 12983 AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC	1	1	0
145	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` = 12983 AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`)	1	1	0
146	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` = 12983 AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`)	1	1	0
147	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` = 12983 AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`)	1	1	0
148	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` = 12983 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`)	2	2	0
149	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` = 12983 AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC	0	0	0
150	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` = 12983 AND `PublicacionsMida`.`mida_id` = `Mida`.`id`)	1	1	0
151	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` = 12983 AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`)	0	0	0
152	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` = 12983 AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`)	1	1	0
153	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` = 12983 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`)	0	0	0
154	DESCRIBE `audits`	8	8	0
155	DESCRIBE `audit_deltas`	5	5	0
156	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` = 'ca_es') WHERE `Publicacion`.`novetat` = 1 AND `Publicacion`.`published` = 1	1	1	2
157	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` = 'ca_es') WHERE `Publicacion`.`recomanat` = 1 AND `Publicacion`.`published` = 1	1	1	2
158	SELECT `I18n__url`.`content` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') WHERE `Publicacion`.`id` = 12983 AND `I18n__url`.`locale` = 'ca_es' LIMIT 1	1	1	0
159	SELECT `I18n__url`.`content` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') WHERE `Publicacion`.`id` = 12983 AND `I18n__url`.`locale` = 'es_es' LIMIT 1	1	1	0
160	SELECT `I18n__url`.`content` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') WHERE `Publicacion`.`id` = 12983 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
161	SELECT `Editor`.`id`, `Editor`.`nom` FROM `editors` AS `Editor` WHERE `Editor`.`id` = 102 LIMIT 1	1	1	0
162	SELECT `Idioma`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `idiomas` AS `Idioma` LEFT JOIN `idioma_translations` AS `I18n__nom` ON (`Idioma`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Idioma' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `idioma_translations` AS `I18n__url` ON (`Idioma`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Idioma' AND `I18n__url`.`field` = 'url') LEFT JOIN `idioma_translations` AS `I18n__published` ON (`Idioma`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Idioma' AND `I18n__published`.`field` = 'published') WHERE `Idioma`.`id` = 116 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	0
163	SELECT `Idioma`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `idiomas` AS `Idioma` LEFT JOIN `idioma_translations` AS `I18n__nom` ON (`Idioma`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Idioma' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `idioma_translations` AS `I18n__url` ON (`Idioma`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Idioma' AND `I18n__url`.`field` = 'url') LEFT JOIN `idioma_translations` AS `I18n__published` ON (`Idioma`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Idioma' AND `I18n__published`.`field` = 'published') WHERE `Idioma`.`id` = 142 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	0
164	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`.`id` = 537 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' LIMIT 1	1	1	0
165	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`.`id` = 5558 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	0
166	SELECT `Enquadernacion`.*, `I18n__nom`.`content`, `I18n__published`.`content` FROM `enquadernacions` AS `Enquadernacion` LEFT JOIN `enquadernacion_translations` AS `I18n__nom` ON (`Enquadernacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Enquadernacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `enquadernacion_translations` AS `I18n__published` ON (`Enquadernacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Enquadernacion' AND `I18n__published`.`field` = 'published') WHERE `Enquadernacion`.`id` = 487 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	0
167	SELECT `Funcion`.*, `I18n__nom`.`content`, `I18n__published`.`content`, `Funcion`.`id` FROM `funcions` AS `Funcion` LEFT JOIN `funcion_translations` AS `I18n__nom` ON (`Funcion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Funcion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `funcion_translations` AS `I18n__published` ON (`Funcion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Funcion' AND `I18n__published`.`field` = 'published') WHERE `Funcion`.`situacio` = 'dalt' AND `I18n__nom`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es'	13	13	0
168	SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Funcion' AND `Archivesrelation`.`foreign_id` IN (1473, 1474, 1475, 1477, 1480, 1486, 1496, 1497, 1500, 3466, 5041, 5044, 5046) ORDER BY `Archivesrelation`.`order` ASC	0	0	0
169	SELECT `Funcion`.*, `I18n__nom`.`content`, `I18n__published`.`content`, `Funcion`.`id` FROM `funcions` AS `Funcion` LEFT JOIN `funcion_translations` AS `I18n__nom` ON (`Funcion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Funcion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `funcion_translations` AS `I18n__published` ON (`Funcion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Funcion' AND `I18n__published`.`field` = 'published') WHERE `Funcion`.`situacio` = 'baix' AND `I18n__nom`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es'	27	27	0
170	SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Funcion' AND `Archivesrelation`.`foreign_id` IN (1476, 1478, 1479, 1481, 1482, 1483, 1484, 1485, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1498, 1499, 1501, 3553, 3658, 3662, 4770, 5042, 5043, 5047) ORDER BY `Archivesrelation`.`order` ASC	0	0	0
171	SELECT `Category`.`id`, `Category`.`parent_id`, `I18n__name`.`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__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 90 AND `I18n__name`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1	1	1	0
172	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`.`id` = 78 AND `I18n__name`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1	1	1	0
173	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`.`id` = 78 AND `I18n__name`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1	1	1	0
174	SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 10213 LIMIT 1	1	1	0
175	SELECT `Relacionat`.`id`, `Relacionat`.`publicacion_id`, `Relacionat`.`publicacion_id1`, `Relacionat`.`type` FROM `relacionats` AS `Relacionat` LEFT JOIN `publicacions` AS `Publicacion` ON (`Relacionat`.`publicacion_id` = `Publicacion`.`id`) LEFT JOIN `publicacions` AS `Publicacion1` ON (`Relacionat`.`publicacion_id1` = `Publicacion1`.`id`) WHERE `Relacionat`.`publicacion_id`=12983 OR `Relacionat`.`publicacion_id1`=12983	0	0	0
176	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	7	7	0
177	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	3	3	0
178	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	3	3	0
179	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	5	5	0
180	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	0	0	0
181	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	2	2	0
182	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	0	0	0
183	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` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' ORDER BY `order` DESC	0	0	0
184	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` = 'es_es' AND `I18n__html`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	0
185	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` = 'es_es' AND `I18n__html`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	0
186	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `Catcolleccion`.`order` DESC	6	6	0
187	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	3	3	0
188	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	6	6	0
189	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	0	0	0
190	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	4	4	0
191	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	0	0	0
192	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	7	7	0
193	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	6	6	0
194	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	0	0	0
195	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` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `I18n__nom`.`content` ASC	13	13	0
196	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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `Catformacion`.`order` DESC	3	3	0
197	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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `Catformacion`.`order` DESC	0	0	0
198	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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' ORDER BY `Formacion`.`nom` ASC	8	8	0
199	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` = 'es_es' AND `I18n__descripcion`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' ORDER BY `Catformacion`.`order` DESC	0	0	0
200	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` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__metadescription`.`locale` = 'es_es' ORDER BY `Formacion`.`nom` ASC	18	18	0

Trincameró

Inside Pages

Autor

Field

Collection

Language

Format

Contents

Instrumental and vocal formations

Technical Specifications

Measurements

Binding

Number of Pages

Number of parts

Number of Pages of Parts

ISMN

Editor

Partituras

Profesores

Directores

Autores y compositores

Tiendas

Subscribe to our Newletter!

About Us

Customer info:

For users

Official information

Latests searches

Associations of which we are part