×

Uso de cookies

Este sitio web utiliza cookies para que usted tenga la mejor experiencia de usuario. Si continúa navegando está dando su consentimiento para la aceptación de las mencionadas cookies y la aceptación de nuestra política de cookies.

Partituras y libros de música: calidad, creatividad y servicio, siempre a tu alcance.


Share
0.0 / 5  (0 votes)

Les set paraules de Nostre Senyor Jesucrist (pdf)

Les set paraules de Nostre Senyor Jesucrist (pdf)-Música coral catalana (publicación en pdf)-Partituras Intermedio

Paginas interiors

Descargar

Autor

Cristòfor Taltabull

Edición crítica

Josep Soler
Teodor Roura

Ámbito

Partituras Intermedio

Colección

Música coral catalana (publicación en pdf) Núm. 8

Idioma

Castellano, Catalán, Inglés, Alemán, Latín

Formato

PDF

8.14 € IVA no incluido

8.47 € IVA incluido

Contenidos generales

Obra dedicada a los cantores de la Coral Santa Cecília de Mataró para dar relieve a la predicación de Las siete Palabras que tradicionalmente se celebraban durante las solemnidades de semana santa, pensada como comentario musical a la prédica.
Escrita para orquesta de cuerda, dos flautas, órgano, tenor solista y coro mixto, está dividida en nueve secciones: preludio, siete palabras y epílogo simfónico. Texto en latín.

Formaciones instrumentales y vocales

Coro mixto, Conjunto instrumental

Instrumentos

Órgano

Estructuración

Partitura para el coro y solista con una reducción de órgano (o piano) del propio maestro Taltabull, revisada y editada por Teo Toure y Josep Soler.
Ver la partitura general en versión de bolsillo: Colección Partituras de bolsillo.
Ver la partitura general y sus particellas correspondientes destinadas a la interpretación (material de alquiler): Colección Materiales para orquesta.

Características técnicas

Medidas

21 x 29,7 cm, vertical

Número de páginas

78

ISMN

M-69210-314-1

Editor

DINSIC Publicacions Musicals

También han participado:

Grabado

Enric Cristòfor Ricart

Poemas

Fèlix Castellà

Otros formatos de esta publicación

Las siete palabras de nuestro señor Jesucristo

Partitura

Las siete palabras de nuestro señor Jesucristo

app/views/publicacions/display.ctp (line 848)
Array
(
    [Relacionat] => Array
        (
            [id] => 172
            [publicacion_id] => 3687
            [publicacion_id1] => 2706
            [type] => altreformat
        )

    [pub] => Array
        (
            [Publicacion] => Array
                (
                    [id] => 2706
                    [titol] => Las siete palabras de nuestro señor Jesucristo
                    [url] => partitura-mc8-las_siete_palabras_de_nuestro_senor_jesucristo
                    [codi] => MCC008
                    [intro] => 
                    [continguts_generals] => Obra dedicada a los cantores de la Coral Santa Cecília de Mataró para dar relieve a la predicación de Las siete Palabras que tradicionalmente se celebraban durante las solemnidades de semana santa, pensada como comentario musical a la prédica.
Escrita para orquesta de cuerda, dos flautas, órgano, tenor solista y coro mixto, está dividida en nueve secciones: preludio, siete palabras y epílogo simfónico. Texto en latín. [estructuracio] => Partitura para el coro y solista con una reducción de órgano (o piano) del propio maestro Taltabull, revisada y editada por Teo Toure y Josep Soler.
Ver la partitura general en versión de bolsillo: Colección Partituras de bolsillo.
Ver la partitura general y sus particellas correspondientes destinadas a la interpretación (material de alquiler): Colección Materiales para orquesta. [material_descarga] => 0 [titol_descarga] => [info_descarga] => [num_pags] => 80 [ismn] => [diposit_legal] => B-5531-99 [codi_barres] => No en té [isbn] => 84-95055-01-5 [preu] => 10.10 [exhaurit] => 0 [oferta] => 0 [en_preparacio] => 0 [recomanat] => 0 [novetat] => 0 [format] => Partitura [ctecnica] => [ilustracion] => [num_pagines_interiors] => 0 [n_pag_annex] => [numero_particelas] => [numero_pagines_particelas] => [durada] => [visible_instrumentacio] => 1 [visible_formacions] => 1 [pdf_car_estructuracio] => 0 [pes] => 0,21 [published] => 1 [created] => 2006-08-29 19:22:00 [modified] => 2025-04-05 01:42:07 [ordenacion] => 2006-08-29 19:22:00 [puntuacio] => 0.00 [visto] => 5038 [rating] => 0.0 [votes] => 0 [parent] => [has_child] => 0 [locale] => es_es ) [Audit] => Array ( ) [Category] => Array ( [0] => Array ( [id] => 89 [url] => intermedio [name] => Intermedio [parent_id] => 78 [descripcio] =>
La clasificación del nivel de una partitura normalmente viene determinado por el grado de dificultad té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én en los listados específicos de cada uno de sus instrumentos o voces que participan en él, pero el nivel que se indica es el de la formación instrumental-vocal.
[order] => 1 [lft] => 4 [rght] => 5 [published] => 1 [PublicacionsCategory] => Array ( [id] => 15470 [publicacion_id] => 2706 [category_id] => 89 ) ) ) [Idioma] => Array ( [0] => Array ( [id] => 103 [nom] => Castellà [published] => 1 [url] => castella [PublicacionsIdioma] => Array ( [id] => 26165 [publicacion_id] => 2706 [idioma_id] => 103 ) ) [1] => Array ( [id] => 116 [nom] => Catalan [published] => 1 [url] => catalan [PublicacionsIdioma] => Array ( [id] => 26166 [publicacion_id] => 2706 [idioma_id] => 116 ) ) [2] => Array ( [id] => 1724 [nom] => English [published] => 1 [url] => english [PublicacionsIdioma] => Array ( [id] => 26167 [publicacion_id] => 2706 [idioma_id] => 1724 ) ) [3] => Array ( [id] => 1879 [nom] => Francés [published] => 1 [url] => frances [PublicacionsIdioma] => Array ( [id] => 26168 [publicacion_id] => 2706 [idioma_id] => 1879 ) ) [4] => Array ( [id] => 1880 [nom] => German [published] => 1 [url] => german [PublicacionsIdioma] => Array ( [id] => 26169 [publicacion_id] => 2706 [idioma_id] => 1880 ) ) [5] => Array ( [id] => 2519 [nom] => Latin [published] => 1 [url] => latin [PublicacionsIdioma] => Array ( [id] => 26170 [publicacion_id] => 2706 [idioma_id] => 2519 ) ) ) [Rsspost] => Array ( ) [Archivesrelation] => Array ( [0] => Array ( [Archivesrelation] => Array ( [id] => 2364 [model] => Publicacion [foreign_id] => 2706 [order] => 0 [file_id] => 2973 [archivestypes_id] => 2 ) ) [1] => Array ( [Archivesrelation] => Array ( [id] => 2365 [model] => Publicacion [foreign_id] => 2706 [order] => 0 [file_id] => 2974 [archivestypes_id] => 3 ) ) [2] => Array ( [Archivesrelation] => Array ( [id] => 7016 [model] => Publicacion [foreign_id] => 2706 [order] => 2 [file_id] => 8398 [archivestypes_id] => 11 ) ) ) [PublicacionsIdioma] => Array ( [Idioma] => Array ( [id] => 103 [nom] => Castellano [published] => 1 [url] => castellano [locale] => es_es ) ) ) [path] => partituras-intermedio )

10.50 €

Las siete palabras de n. s. Jesucristo (PB)

Partitura

Las siete palabras de n. s. Jesucristo (PB)

app/views/publicacions/display.ctp (line 848)
Array
(
    [Relacionat] => Array
        (
            [id] => 173
            [publicacion_id] => 3687
            [publicacion_id1] => 2541
            [type] => altreformat
        )

    [pub] => Array
        (
            [Publicacion] => Array
                (
                    [id] => 2541
                    [titol] => Las siete palabras de n. s. Jesucristo (PB)
                    [url] => partitura-pb1-las_siete_palabras_de_n_s_jesucristo_pb
                    [codi] => PB1
                    [intro] => 
                    [continguts_generals] => Obra dedicada a los cantores de la Coral Santa Cecília de Mataró para dar relieve a la predicación de Las siete Palabras que tradicionalmente se celebraban durante las solemnidades de semana santa, pensada como comentario musical a la prédica.
Escrita para orquesta de cuerda, dos flautas, órgano, tenor solista y coro mixto, está dividida en nueve secciones: preludio, siete palabras y epílogo simfónico. Texto en latín. [estructuracio] => Partitura general en versión de bolsillo.
Ver partitura para el coro y solista con una reducción de piano (o órgano) en el volumen 8 de la Colección Música Coral Catalana.
Ver la partitura general y sus particellas correspondientes destinadas a la interpretación (material de alquiler) en la Colección Materiales para orquesta. [material_descarga] => 0 [titol_descarga] => [info_descarga] => [num_pags] => 92 [ismn] => [diposit_legal] => [codi_barres] => [isbn] => [preu] => 15.38 [exhaurit] => 0 [oferta] => 0 [en_preparacio] => 0 [recomanat] => 0 [novetat] => 0 [format] => Partitura [ctecnica] => [ilustracion] => [num_pagines_interiors] => 0 [n_pag_annex] => [numero_particelas] => [numero_pagines_particelas] => [durada] => [visible_instrumentacio] => 1 [visible_formacions] => 1 [pdf_car_estructuracio] => 0 [pes] => 0,12 [published] => 1 [created] => 2006-08-09 14:50:30 [modified] => 2025-04-04 23:54:56 [ordenacion] => 2006-08-09 14:50:30 [puntuacio] => 0.00 [visto] => 6310 [rating] => 0.0 [votes] => 0 [parent] => [has_child] => 0 [locale] => es_es ) [Audit] => Array ( ) [Category] => Array ( [0] => Array ( [id] => 89 [url] => intermedio [name] => Intermedio [parent_id] => 78 [descripcio] =>
La clasificación del nivel de una partitura normalmente viene determinado por el grado de dificultad té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én en los listados específicos de cada uno de sus instrumentos o voces que participan en él, pero el nivel que se indica es el de la formación instrumental-vocal.
[order] => 1 [lft] => 4 [rght] => 5 [published] => 1 [PublicacionsCategory] => Array ( [id] => 482 [publicacion_id] => 2541 [category_id] => 89 ) ) ) [Idioma] => Array ( [0] => Array ( [id] => 2519 [nom] => Latin [published] => 1 [url] => latin [PublicacionsIdioma] => Array ( [id] => 947 [publicacion_id] => 2541 [idioma_id] => 2519 ) ) ) [Rsspost] => Array ( ) [Archivesrelation] => Array ( [0] => Array ( [Archivesrelation] => Array ( [id] => 2304 [model] => Publicacion [foreign_id] => 2541 [order] => 0 [file_id] => 2913 [archivestypes_id] => 2 ) ) ) [PublicacionsIdioma] => Array ( [Idioma] => Array ( [id] => 2519 [nom] => Latín [published] => 1 [url] => latin [locale] => es_es ) ) ) [path] => partituras-intermedio )

16.00 €

Las siete palabras de n. s. Jesucristo (MO)

Materiales de alquiler

Las siete palabras de n. s. Jesucristo (MO)

app/views/publicacions/display.ctp (line 848)
Array
(
    [Relacionat] => Array
        (
            [id] => 174
            [publicacion_id] => 3687
            [publicacion_id1] => 2518
            [type] => altreformat
        )

    [pub] => Array
        (
            [Publicacion] => Array
                (
                    [id] => 2518
                    [titol] => Las siete palabras de n. s. Jesucristo (MO)
                    [url] => partitura-mo1-las_siete_palabras_de_n_s_jesucristo_mo
                    [codi] => MO01
                    [intro] => 
                    [continguts_generals] => Obra dedicada a los cantores de la Coral Santa Cecília de Mataró para dar relieve a la predicación de Las siete Palabras que tradicionalmente se celebraban durante las solemnidades de semana santa, pensada como comentario musical a la prédica.
Escrita para orquesta de cuerda, dos flautas, órgano, tenor solista y coro mixto, está dividida en nueve secciones: preludio, siete palabras y epílogo simfónico. Texto en latín.

MATERIALES DE ALQUILER [estructuracio] => Partitura general.
Particelas:
Violines 1 (20 págs), Violines 2 (20 págs), Violas (16 págs), Violoncelos (20 págs), Contrabajos (16 págs), Flauta 1 (16 págs), y Flauta 2 (12 págs).
Ver la partitura general en versión de bolsillo (Colección Partituras de bolsillo nº 1).
Ver la partitura del coro y el solista con una reducción de piano (u órgano) en la Colección Música Coral Catalana (nº 8). [material_descarga] => 0 [titol_descarga] => [info_descarga] => [num_pags] => 178 [ismn] => [diposit_legal] => B-6421-2002 [codi_barres] => xxxxxxx [isbn] => xxxxxxx [preu] => 500.00 [exhaurit] => 0 [oferta] => 0 [en_preparacio] => 0 [recomanat] => 0 [novetat] => 0 [format] => Partitura de lloguer [ctecnica] => [ilustracion] => [num_pagines_interiors] => 94 [n_pag_annex] => [numero_particelas] => 7 [numero_pagines_particelas] => 84 [durada] => 30' [visible_instrumentacio] => 1 [visible_formacions] => 1 [pdf_car_estructuracio] => 0 [pes] => 0,46 [published] => 1 [created] => 2006-08-09 12:16:00 [modified] => 2025-04-05 00:44:06 [ordenacion] => 2006-08-09 12:16:00 [puntuacio] => 0.00 [visto] => 5387 [rating] => 0.0 [votes] => 0 [parent] => [has_child] => 0 [locale] => es_es ) [Audit] => Array ( ) [Category] => Array ( [0] => Array ( [id] => 89 [url] => intermedio [name] => Intermedio [parent_id] => 78 [descripcio] =>
La clasificación del nivel de una partitura normalmente viene determinado por el grado de dificultad té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én en los listados específicos de cada uno de sus instrumentos o voces que participan en él, pero el nivel que se indica es el de la formación instrumental-vocal.
[order] => 1 [lft] => 4 [rght] => 5 [published] => 1 [PublicacionsCategory] => Array ( [id] => 14363 [publicacion_id] => 2518 [category_id] => 89 ) ) ) [Idioma] => Array ( [0] => Array ( [id] => 2519 [nom] => Latin [published] => 1 [url] => latin [PublicacionsIdioma] => Array ( [id] => 24004 [publicacion_id] => 2518 [idioma_id] => 2519 ) ) ) [Rsspost] => Array ( ) [Archivesrelation] => Array ( [0] => Array ( [Archivesrelation] => Array ( [id] => 2295 [model] => Publicacion [foreign_id] => 2518 [order] => 0 [file_id] => 2904 [archivestypes_id] => 2 ) ) ) [PublicacionsIdioma] => Array ( [Idioma] => Array ( [id] => 2519 [nom] => Latín [published] => 1 [url] => latin [locale] => es_es ) ) ) [path] => partituras-intermedio )

DINSIC Publicacions Musicals, S.L.
Almacén: Sepúlveda, 84 - 08015 Barcelona (Calàbria / Metro L1 Rocafort)
De lunes a viernes 9:30 - 13:30
Tels. +34 93 832 69 46
[email protected]
Copyright © 1998-2025
Este portal está optimizado principalmente para las últimas versiones de los principales navegadores: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. La utilización de un navegador no compatible o la desactivación de algunas propiedades como la compatibilidad con Javascript o la desactivación de cookies puede reducir la funcionalidad del sitio. Si se accede al lugar gracias a un Firewall (cortafuegos) o servidor proxy, asegúrese que se permite la recepción de cookies.
(default) 259 queries took 129 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `publicacions`43431
2DESCRIBE `archivesrelations`660
3DESCRIBE `ratings`880
4DESCRIBE `comments`990
5DESCRIBE `autors`14140
6DESCRIBE `publicacions_autors`440
7DESCRIBE `autor_translations`660
8DESCRIBE `categories`990
9DESCRIBE `publicacions_categories`330
10DESCRIBE `categories_translations`660
11DESCRIBE `colleccions`770
12DESCRIBE `catcolleccions`990
13DESCRIBE `catcolleccion_translations`660
14DESCRIBE `publicacions_colleccions`440
15DESCRIBE `colleccion_translations`660
16DESCRIBE `editors`220
17DESCRIBE `publicacions_editors`990
18DESCRIBE `enquadernacions`330
19DESCRIBE `publicacions_enquadernacions`330
20DESCRIBE `enquadernacion_translations`660
21DESCRIBE `formacions`770
22DESCRIBE `catformacions`990
23DESCRIBE `catformacion_translations`660
24DESCRIBE `publicacions_formacions`330
25DESCRIBE `formacion_translations`660
26DESCRIBE `idiomas`440
27DESCRIBE `publicacions_idiomas`330
28DESCRIBE `idioma_translations`660
29DESCRIBE `instruments`660
30DESCRIBE `catinstruments`990
31DESCRIBE `catinstrument_translations`660
32DESCRIBE `publicacions_instruments`440
33DESCRIBE `instrument_translations`660
34DESCRIBE `midas`440
35DESCRIBE `publicacions_midas`330
36DESCRIBE `mida_translations`660
37DESCRIBE `retractilats`330
38DESCRIBE `publicacions_retractilats`330
39DESCRIBE `retractilat_translations`660
40DESCRIBE `newsletters`770
41DESCRIBE `newsletters_publicacions`330
42DESCRIBE `newsletter_translations`660
43DESCRIBE `rssposts`10100
44DESCRIBE `rss`550
45DESCRIBE `rssposts_publicacions`330
46DESCRIBE `publicacion_translations`660
47DESCRIBE `relacionats`440
48DESCRIBE `funcions`440
49DESCRIBE `funcion_translations`660
50DESCRIBE `archives`660
51DESCRIBE `codes`770
52DESCRIBE `users`35350
53DESCRIBE `roles`550
54DESCRIBE `archivestypes`550
55DESCRIBE `pages`990
56DESCRIBE `pages_translations`660
57DESCRIBE `orders`18180
58DESCRIBE `invoices`22220
59DESCRIBE `orderproducts`10100
60DESCRIBE `latestsearches`660
61SELECT `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 770
62SELECT `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 330
63SELECT `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 330
64SELECT `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 550
65SELECT `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 000
66SELECT `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 220
67SELECT `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 000
68SELECT `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 000
69SELECT `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 1110
70SELECT `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 1110
71SELECT `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 660
72SELECT `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 330
73SELECT `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 660
74SELECT `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 000
75SELECT `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 440
76SELECT `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 000
77SELECT `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 770
78SELECT `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 660
79SELECT `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 000
80SELECT `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 13130
81SELECT `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 330
82SELECT `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 000
83SELECT `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 880
84SELECT `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 000
85SELECT `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 18180
86SELECT `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 000
87SELECT `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 39390
88SELECT `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 660
89SELECT `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 550
90SELECT `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 000
91SELECT `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 550
92SELECT `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 000
93SELECT `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 440
94SELECT `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 000
95SELECT `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 550
96SELECT `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 000
97SELECT `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 000
98SELECT `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 19190
99SELECT `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 000
100SELECT `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 880
101SELECT `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 1110
102SELECT `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 550
103SELECT `Latestsearch`.`id`, `Latestsearch`.`text`, `Latestsearch`.`q`, `Latestsearch`.`url`, `Latestsearch`.`count`, `Latestsearch`.`lang` FROM `latestsearches` AS `Latestsearch` WHERE 1 = 1 ORDER BY `count` DESC LIMIT 3030300
104SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1110
105SELECT `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 330
106SELECT `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 19190
107SELECT `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 42420
108SELECT `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`.`id` = 56 AND `I18n__name`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
109SELECT `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 1110
110SELECT `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` = 'pdf-mc8cs-les_set_paraules_de_nostre_senyor_jesucrist_pdf' 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 11197
111SELECT `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` = (3687) ORDER BY `Archivesrelation`.`order` ASC 332
112SELECT `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` = (3687) 000
113SELECT `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` = (3687) ORDER BY `Comment`.`id` ASC 000
114SELECT `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` = 3687 AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC 551
115SELECT `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` = 3687 AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 110
116SELECT `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` = 3687 AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC 110
117SELECT `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` = 3687 AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`) 110
118SELECT `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` = 3687 AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`) 000
119SELECT `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` = 3687 AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 220
120SELECT `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` = 3687 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 550
121SELECT `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` = 3687 AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC 110
122SELECT `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` = 3687 AND `PublicacionsMida`.`mida_id` = `Mida`.`id`) 110
123SELECT `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` = 3687 AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 000
124SELECT `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` = 3687 AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`) 000
125SELECT `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` = 3687 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 000
126SELECT `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` = 3687 AND `I18n__url`.`locale` = 'ca_es' LIMIT 1110
127SELECT COUNT(*) AS `count` FROM `publicacions` AS `Publicacion` WHERE `Publicacion`.`id` = 3687 110
128SELECT `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` = 3687 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 1111
129SELECT `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` = 3687 AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC 550
130SELECT `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` = 3687 AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 110
131SELECT `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` = 3687 AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC 110
132SELECT `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` = 3687 AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`) 110
133SELECT `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` = 3687 AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`) 000
134SELECT `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` = 3687 AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 220
135SELECT `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` = 3687 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 550
136SELECT `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` = 3687 AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC 110
137SELECT `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` = 3687 AND `PublicacionsMida`.`mida_id` = `Mida`.`id`) 110
138SELECT `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` = 3687 AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 000
139SELECT `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` = 3687 AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`) 000
140SELECT `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` = 3687 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 000
141UPDATE `publicacions` SET `visto` = 4745, `modified` = '2025-04-05 06:45:38' WHERE `publicacions`.`id` = 368712
142SELECT `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` = 3687 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 1111
143SELECT `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` = 3687 AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC 550
144SELECT `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` = 3687 AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 110
145SELECT `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` = 3687 AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC 110
146SELECT `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` = 3687 AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`) 110
147SELECT `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` = 3687 AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`) 000
148SELECT `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` = 3687 AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 220
149SELECT `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` = 3687 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 550
150SELECT `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` = 3687 AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC 110
151SELECT `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` = 3687 AND `PublicacionsMida`.`mida_id` = `Mida`.`id`) 110
152SELECT `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` = 3687 AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 000
153SELECT `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` = 3687 AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`) 000
154SELECT `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` = 3687 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 000
155DESCRIBE `audits`880
156DESCRIBE `audit_deltas`550
157SELECT 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 112
158SELECT 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 112
159SELECT `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` = 3687 AND `I18n__url`.`locale` = 'ca_es' LIMIT 1110
160SELECT `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` = 3687 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
161SELECT `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` = 3687 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
162SELECT `Editor`.`id`, `Editor`.`nom` FROM `editors` AS `Editor` WHERE `Editor`.`id` = 102 LIMIT 1110
163SELECT `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` = 103 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
164SELECT `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 1110
165SELECT `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` = 1724 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
166SELECT `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` = 1880 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
167SELECT `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` = 2519 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
168SELECT `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` = 544 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 1110
169SELECT `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` = 550 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 1110
170SELECT `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` = 5598 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 1110
171SELECT `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`.`id` = 834 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' LIMIT 1110
172SELECT `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' 13130
173SELECT `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 000
174SELECT `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' 27270
175SELECT `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 000
176SELECT `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` = 89 AND `I18n__name`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
177SELECT `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 1110
178SELECT `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 1110
179SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 3174 LIMIT 1110
180SELECT `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`=3687 OR `Relacionat`.`publicacion_id1`=3687 330
181SELECT `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`, `Publicacion`.`id` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__titol` ON (`Publicacion`.`id` = `I18n__titol`.`foreign_key` AND `I18n__titol`.`model` = 'Publicacion' AND `I18n__titol`.`field` = 'titol') LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `publicacion_translations` AS `I18n__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` = 2706 AND `I18n__titol`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__intro`.`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 1111
182SELECT `Audit`.`id`, `Audit`.`event`, `Audit`.`model`, `Audit`.`entity_id`, `Audit`.`json_object`, `Audit`.`description`, `Audit`.`source_id`, `Audit`.`created` FROM `audits` AS `Audit` WHERE `Audit`.`entity_id` = (2706) 000
183SELECT `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` = 2706 AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 110
184SELECT `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` = 2706 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 660
185SELECT `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` = 2706 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 000
186SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 89 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
187SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
188SELECT `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` = 2706 ORDER BY `order` ASC 331
189SELECT `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` = 103 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
190SELECT `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`, `Publicacion`.`id` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__titol` ON (`Publicacion`.`id` = `I18n__titol`.`foreign_key` AND `I18n__titol`.`model` = 'Publicacion' AND `I18n__titol`.`field` = 'titol') LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `publicacion_translations` AS `I18n__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` = 2541 AND `I18n__titol`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__intro`.`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 1111
191SELECT `Audit`.`id`, `Audit`.`event`, `Audit`.`model`, `Audit`.`entity_id`, `Audit`.`json_object`, `Audit`.`description`, `Audit`.`source_id`, `Audit`.`created` FROM `audits` AS `Audit` WHERE `Audit`.`entity_id` = (2541) 000
192SELECT `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` = 2541 AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 110
193SELECT `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` = 2541 AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 110
194SELECT `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` = 2541 AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 000
195SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 89 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
196SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
197SELECT `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` = 2541 ORDER BY `order` ASC 112
198SELECT `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` = 2519 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
199SELECT `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`, `Publicacion`.`id` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__titol` ON (`Publicacion`.`id` = `I18n__titol`.`foreign_key` AND `I18n__titol`.`model` = 'Publicacion' AND `I18n__titol`.`field` = 'titol') LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `publicacion_translations` AS `I18n__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` = 2518 AND `I18n__titol`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' AND `I18n__intro`.`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 1111
200SELECT `Audit`.`id`, `Audit`.`event`, `Audit`.`model`, `Audit`.`entity_id`, `Audit`.`json_object`, `Audit`.`description`, `Audit`.`source_id`, `Audit`.`created` FROM `audits` AS `Audit` WHERE `Audit`.`entity_id` = (2518) 000