×

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.

0 productos, 0 €

Registrarse

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

Dinsic > Autores


Autores

Podéis localizar los autores por la letra inicial de su primer apellido. En su página encontraréis el listado de sus obras, su currículum y quizás su fotografía.

Partituras

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

Profesores

Programa de descuentospara profesores de música y sus alumnos. Afilíate y recupera una parte importante de tus compras.

Directores

Programa de descuentos para directores de coro y orquesta, sean profesionales o amateurs. Afilíate y recupera una parte del importe de tus comrpas.

Autores y compositores

Programa de descuentos para los autores de las obras publicadas por nuestra editorial. Afilíate y recupera una parte del importe de tus compras.

Tiendas

Si eres una tienda ahora ya puedes hacer las compras a través de nuestra web, obteniendo los descuentos comerciales habituales del sector.

Suscripción a los boletines

Recibirás toda la información de novedades de nuestro catálogo y las notícias de la editorial.

Quiénes somos?

Datos del cliente:

Para los usuarios

Información oficial

Búsquedas más recientes

  Quartet de corda núm. 3     Musica     Catala     corda     Da Camera 22     passeport     tot ho podem expressar     Carnestoltes     abesten     acompañamiento de canciones infantiles     orquestra i cada instrument     Sonatina de Nadal     cançó     partitura     nadal     Da Camera 22: Tres danses americanes per a quartet de corda     Literatura e interpretación de la trompeta     El timbaler del Bruc     els músics més petits     cantata nadalenca nit de vetlla     abesten 3     soliloquis     Palau insòlit     abesten 2     abesten 4     flauta     somnis     musica 2     piano     cançoner  

Asociaciones o entidades a las que nuestra empresa pertenece

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-2024
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) 146 queries took 250 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `autors`14141
2DESCRIBE `archivesrelations`661
3DESCRIBE `publicacions`43432
4DESCRIBE `ratings`881
5DESCRIBE `comments`991
6DESCRIBE `categories`991
7DESCRIBE `publicacions_categories`331
8DESCRIBE `categories_translations`661
9DESCRIBE `colleccions`771
10DESCRIBE `catcolleccions`991
11DESCRIBE `catcolleccion_translations`661
12DESCRIBE `publicacions_colleccions`441
13DESCRIBE `colleccion_translations`660
14DESCRIBE `editors`220
15DESCRIBE `publicacions_editors`990
16DESCRIBE `enquadernacions`331
17DESCRIBE `publicacions_enquadernacions`330
18DESCRIBE `enquadernacion_translations`661
19DESCRIBE `formacions`771
20DESCRIBE `catformacions`991
21DESCRIBE `catformacion_translations`661
22DESCRIBE `publicacions_formacions`331
23DESCRIBE `formacion_translations`660
24DESCRIBE `idiomas`441
25DESCRIBE `publicacions_idiomas`330
26DESCRIBE `idioma_translations`661
27DESCRIBE `instruments`661
28DESCRIBE `catinstruments`990
29DESCRIBE `catinstrument_translations`660
30DESCRIBE `publicacions_instruments`440
31DESCRIBE `instrument_translations`660
32DESCRIBE `midas`440
33DESCRIBE `publicacions_midas`330
34DESCRIBE `mida_translations`660
35DESCRIBE `retractilats`330
36DESCRIBE `publicacions_retractilats`330
37DESCRIBE `retractilat_translations`660
38DESCRIBE `newsletters`770
39DESCRIBE `newsletters_publicacions`330
40DESCRIBE `newsletter_translations`660
41DESCRIBE `rssposts`10101
42DESCRIBE `rss`550
43DESCRIBE `rssposts_publicacions`330
44DESCRIBE `publicacions_autors`440
45DESCRIBE `publicacion_translations`661
46DESCRIBE `autor_translations`660
47DESCRIBE `archives`660
48DESCRIBE `funcions`440
49DESCRIBE `funcion_translations`660
50DESCRIBE `users`35351
51DESCRIBE `roles`551
52DESCRIBE `archivestypes`551
53DESCRIBE `pages`991
54DESCRIBE `pages_translations`660
55DESCRIBE `orders`18181
56DESCRIBE `invoices`22221
57DESCRIBE `orderproducts`10100
58DESCRIBE `latestsearches`661
59SELECT `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
60SELECT `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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
67SELECT `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
68SELECT `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
69SELECT `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
70SELECT `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
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` = 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
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` = 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
73SELECT `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
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` = 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
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` = 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
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` = 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
77SELECT `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
78SELECT `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
79SELECT `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
80SELECT `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
81SELECT `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
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` = 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
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` = 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
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` = 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
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` = 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
86SELECT `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
87SELECT `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
88SELECT `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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
99SELECT `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
100SELECT `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
101SELECT `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
102SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1110
103SELECT `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
104SELECT `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
105SELECT `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 41410
106SELECT `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
107SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `Page`.`id` 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` = 25 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 1111
108SELECT `Funcion`.`id`, `I18n__nom`.`content` 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') WHERE `Funcion`.`situacio` = 'dalt' AND `I18n__nom`.`locale` = 'es_es' 13130
109SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '0%' 115
110SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '1%' 114
111SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '2%' 114
112SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '3%' 114
113SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '4%' 114
114SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '5%' 114
115SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '6%' 114
116SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '7%' 114
117SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '8%' 115
118SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE '9%' 114
119SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'A%' 117
120SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'B%' 1113
121SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'C%' 118
122SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'D%' 119
123SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'E%' 116
124SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'F%' 115
125SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'G%' 119
126SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'H%' 116
127SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'I%' 115
128SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'J%' 115
129SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'K%' 115
130SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'L%' 116
131SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'M%' 1110
132SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'N%' 115
133SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'O%' 115
134SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'P%' 118
135SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'Q%' 115
136SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'R%' 118
137SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'S%' 116
138SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'T%' 116
139SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'U%' 115
140SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'V%' 117
141SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'W%' 115
142SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'X%' 115
143SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'Y%' 115
144SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND `Autor`.`cognom` LIKE 'Z%' 115
145SELECT COUNT(DISTINCT(`Autor`.`id`)) AS count FROM `autors` AS `Autor` INNER JOIN `autor_translations` AS `AutorI18n` ON (`Autor`.`id` = `AutorI18n`.`foreign_key` AND `AutorI18n`.`model` = 'Autor' AND `AutorI18n`.`locale` = 'es_es') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND (cognom LIKE 'z%') AND `Autor`.`published` = 1 115
146SELECT DISTINCT `Autor`.`id`, `Autor`.`cognom`, `Autor`.`2cognom`, `Autor`.`nom`, convert(cast(convert(Autor.cognom using latin1) as binary) using utf8) AS cognom_esp, convert(cast(convert(Autor.2cognom using latin1) as binary) using utf8) AS cognom2_esp, convert(cast(convert(Autor.nom using latin1) as binary) using utf8) AS nom_esp, `Autor`.`data_naixement`, `Autor`.`data_defuncio`, `Autor`.`data_desconeguda`, `Autor`.`data_defuncio_desconeguda`, `I18n__url`.`content`, `Autor`.`id` FROM `autors` AS `Autor` LEFT JOIN `autor_translations` AS `I18n__url` ON (`Autor`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Autor' AND `I18n__url`.`field` = 'url') INNER JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`autor_id`=`Autor`.`id`) WHERE `PublicacionsAutor`.`funcion_id` IN (1473,1474,1475,1477,1480,1486,1496,1497,1500,3466,5041,5044,5046) AND (cognom LIKE 'z%') AND `Autor`.`published` = 1 AND `I18n__url`.`locale` = 'es_es' ORDER BY `cognom_esp` ASC, `cognom2_esp` ASC, `nom_esp` ASC LIMIT 26112