×

Ús de cookies

Aquest lloc web utilitza cookies per què vostè tingui la millor experiència d'usuari. Si continua navegant, està donant el seu consentiment per a l'acceptació de les mencionades cookies i l'acceptacció de la nostra política de cookies..

0 productes, 0 €

Registrar-se

Partitures i llibres de música: qualitat, creativitat i servei, sempre al teu abast

Dinsic > Notícies del sector

Notícies del sector

L'Auditori celebra la 6a Mostra de Cors de Clavé

Tot a punt per a la 6a Mostra de Cors de Clavé. Set corals d’arreu del país se citaran el 17 de setembre a l’Auditori de Barcelona (17:30h) per oferir un repertori molt eclèctic. El conseller de Cultura Llu&iacu...

La Banda Simfònica Manyanet de Sant Andreu, a l'Associa't a la Festa

La Banda Simfònica Manyanet Sant Andreu dilluns 25 de setembre, festiu a Barcelona, oferirà un concert dins del marc de l'Associa't a la Festa, a l'escenari verd de Plaça Catalunya a les 19.15h...

Inscripcions obertes dels Tallers del C.A.T.

Obertes les inscripcions dels Tallers de música i danses del CAT Del 4 al 22 de setembre   ALLERS DEL CAT Períodes de matriculació curs 2017-2018:...

Els cors de l’Orfeó Català protagonitzaran l’estrena europea de ‘Considering Matthew Shepard’ de Craig Hella Johnson, al Palau de la Música

Dirigits per Simon Halsey, el concert compta amb la col·laboració especial d’Els Amics de les Arts, Big Mama Montse, La Brutal i l’artista visual David Espinosa...

L’Orquestra Simfònica del Vallès celebra 30 anys i presenta una nova temporada del cicle Simfònics al Palau amb els signes d’identitat: innovació, proximitat i qualitat

El dissabte 23 de setembre (18.30 h) comença la 22a temporada del cicle Simfònics al Palau que protagonitza l’Orquestra Simfònica del Vallès al Palau de la Música Catalana. Enguany és un any molt ...

L´EMM d’Olesa de Montserrat busca professor/a de baix elèctric.

15-09-2017 | http://www.acem.cat/
L´Escola Municipal de Música d’Olesa de Montserrat ha obert una convocatòria per la selecció d’un professor/a de baix elèctric. Podeu consultar tota la informació en aquest enllaç.&nbs...

L’EMM Julià Canals de Molins de Rei busca professor/a de llenguatge musical

15-09-2017 | http://www.acem.cat/
L´Escola Municipal de Música Julià Canals ha obert una convocatòria urgent per la selecció d’un professor/a de llenguatge musica. Podeu consultar tota la informació en aquest enllaç.  S...

Néstor Giménez RAW Trio: ‘‘La nostra manera de tocar és sense additius, sense complexos, sense casar-nos amb cap estil’’

Néstor Giménez RAW Trio reuneix tres dels joves músics de jazz més sòlids de la nostra escena. El grup proposa un acostament en clau jazzística a coneguts temes de bandes de pop-rock de les darreres d&e...

Presentació de la Xarxa de Músiques a Catalunya 17-18

Aquest divendres 15 de setembre a les 16:30h al pati cobert de L'Altlàntida de Vic tindrà lloc l'acte de presentació de la temporada 17-18 de la Xarxa de Músiques a Catalunya, en el marc del Mercat de M&uacut...

L’Escola de Música Municipal de Linyola busca professor/a de llenguatge musical

08-09-2017 | http://www.acem.cat/
L’Escola de Música Municipal de Linyola busca professor/a de llenguatge musical per als dijous a la tarda. Es valorarà si també pot impartir classes de violoncel. Interessats podeu enviar el ...

Partitures

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

Professors

Programa de descomptes per a professors de música i els seus alumnes. Afilia't i recupera una part de l’import de les teves compres.

Directors

Programa de descomptes per a directors de corals i d’orquestra, siguin professionals o amateurs. Afilía't i recupera una part de l’import de les teves compres.

Autors i compositors

Programa de descomptes per als autors de les obres publicades per la nostra editorial. Afilía't i recupera una part de l’import de les teves compres.

Botigues

Si ets una botiga ara ja pots fer compres a través de la nostra web, aconseguint els descomptes comercials habituals del sector.

Subscripció als butlletins

Rebràs tota la informació de novetats del nostre catàleg i les notícies de l’editorial.

Qui som?

Dades del client:

Per als usuaris

Informació oficial

Cerques més recents

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

Associacions o entitats a les que la nostra empresa pertany

DINSIC Publicacions Musicals, S.L.
Magatzem: Sepúlveda, 84 - 08015 Barcelona (Calàbria / Metro L1 Rocafort)
De dilluns a divendres 9:30 - 13:30
Tels. +34 93 832 69 46
[email protected]
Copyright © 1998-2025
Aquest Portal esta optimitzat principalment per a les últimes versions dels principals navegadors: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. La utilització d'un navegador no compatible o la desactivació d'algunes propietats, com la compatibilitat amb Javascript o la desactivació de les cookies, pot reduir la funcionalitat del lloc. Si s'accedeix al lloc gràcies a un firewall (tallafocs) o servidor proxy, asseguri's que es permet la recepció de cookies.
(default) 149 queries took 46 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `rss`550
2DESCRIBE `archivesrelations`660
3DESCRIBE `rssposts`10100
4DESCRIBE `publicacions`43430
5DESCRIBE `ratings`880
6DESCRIBE `comments`990
7DESCRIBE `autors`14140
8DESCRIBE `publicacions_autors`440
9DESCRIBE `autor_translations`660
10DESCRIBE `categories`990
11DESCRIBE `publicacions_categories`330
12DESCRIBE `categories_translations`660
13DESCRIBE `colleccions`770
14DESCRIBE `catcolleccions`990
15DESCRIBE `catcolleccion_translations`660
16DESCRIBE `publicacions_colleccions`440
17DESCRIBE `colleccion_translations`660
18DESCRIBE `editors`220
19DESCRIBE `publicacions_editors`990
20DESCRIBE `enquadernacions`330
21DESCRIBE `publicacions_enquadernacions`330
22DESCRIBE `enquadernacion_translations`660
23DESCRIBE `formacions`770
24DESCRIBE `catformacions`990
25DESCRIBE `catformacion_translations`660
26DESCRIBE `publicacions_formacions`330
27DESCRIBE `formacion_translations`660
28DESCRIBE `idiomas`440
29DESCRIBE `publicacions_idiomas`330
30DESCRIBE `idioma_translations`660
31DESCRIBE `instruments`660
32DESCRIBE `catinstruments`990
33DESCRIBE `catinstrument_translations`660
34DESCRIBE `publicacions_instruments`440
35DESCRIBE `instrument_translations`660
36DESCRIBE `midas`440
37DESCRIBE `publicacions_midas`330
38DESCRIBE `mida_translations`660
39DESCRIBE `retractilats`330
40DESCRIBE `publicacions_retractilats`330
41DESCRIBE `retractilat_translations`660
42DESCRIBE `newsletters`770
43DESCRIBE `newsletters_publicacions`330
44DESCRIBE `newsletter_translations`660
45DESCRIBE `rssposts_publicacions`330
46DESCRIBE `publicacion_translations`660
47DESCRIBE `users`35350
48DESCRIBE `roles`550
49DESCRIBE `archives`660
50DESCRIBE `archivestypes`550
51DESCRIBE `pages`990
52DESCRIBE `pages_translations`660
53DESCRIBE `orders`18180
54DESCRIBE `invoices`22220
55DESCRIBE `orderproducts`10100
56DESCRIBE `latestsearches`660
57SELECT `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` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 770
58SELECT `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` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 330
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` = 76 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 330
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` = 75 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 550
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` = 77 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 000
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` = 79 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 220
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` = 3002 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_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` = 80 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC 000
65SELECT `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` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1110
66SELECT `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` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1110
67SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catcolleccion`.`order` DESC 660
68SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 330
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` = 94 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 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` = 1719 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 000
71SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 440
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` = 96 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_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` = 96 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 770
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` = 1720 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 660
75SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 000
76SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 13130
77SELECT `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` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC 330
78SELECT `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` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC 000
79SELECT `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` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Formacion`.`nom` ASC 880
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` = 145 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_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` = 145 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Formacion`.`nom` ASC 18180
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` = 146 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_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` = 146 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Formacion`.`nom` ASC 39390
84SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catinstrument`.`order` DESC 660
85SELECT `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` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 660
86SELECT `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` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 000
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` = 70 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_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` = 70 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_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` = 73 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 440
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` = 73 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_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` = 72 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_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` = 72 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_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` = 74 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 000
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` = 74 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 19190
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` = 1699 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_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` = 1699 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 880
97SELECT `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` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1110
98SELECT `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` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `Page`.`order` DESC 550
99SELECT `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
100SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1110
101SELECT `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` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC 330
102SELECT `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` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC 20200
103SELECT `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` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `order` DESC 44440
104SELECT `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` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' LIMIT 1110
105SELECT `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` = 54 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1110
106SELECT COUNT(*) AS `count` FROM `rssposts` AS `Rsspost` LEFT JOIN `rss` AS `Rss` ON (`Rsspost`.`rss_id` = `Rss`.`id`) WHERE `Rsspost`.`published` = 1 AND `Rsspost`.`rss_id` != 16 110
107SELECT `Rsspost`.`id`, `Rsspost`.`rss_id`, `Rsspost`.`titol`, `Rsspost`.`html`, `Rsspost`.`data_creacio`, `Rsspost`.`data_ordenacio`, `Rsspost`.`data_publica`, `Rsspost`.`slug`, `Rsspost`.`extlink`, `Rsspost`.`published`, `Rss`.`id`, `Rss`.`url`, `Rss`.`web`, `Rss`.`nom`, `Rss`.`active` FROM `rssposts` AS `Rsspost` LEFT JOIN `rss` AS `Rss` ON (`Rsspost`.`rss_id` = `Rss`.`id`) WHERE `Rsspost`.`published` = 1 AND `Rsspost`.`rss_id` != 16 ORDER BY `Rsspost`.`data_ordenacio` DESC LIMIT 130, 10101023
108SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` IN (23583, 23584, 23585, 23586, 23587, 23539, 23540, 23529, 23530, 23425) ORDER BY `Archivesrelation`.`order` ASC 002
109SELECT `Publicacion`.`id`, `Publicacion`.`titol`, `Publicacion`.`url`, `Publicacion`.`codi`, `Publicacion`.`intro`, `Publicacion`.`continguts_generals`, `Publicacion`.`estructuracio`, `Publicacion`.`material_descarga`, `Publicacion`.`titol_descarga`, `Publicacion`.`info_descarga`, `Publicacion`.`num_pags`, `Publicacion`.`ismn`, `Publicacion`.`diposit_legal`, `Publicacion`.`codi_barres`, `Publicacion`.`isbn`, `Publicacion`.`preu`, `Publicacion`.`exhaurit`, `Publicacion`.`oferta`, `Publicacion`.`en_preparacio`, `Publicacion`.`recomanat`, `Publicacion`.`novetat`, `Publicacion`.`format`, `Publicacion`.`ctecnica`, `Publicacion`.`ilustracion`, `Publicacion`.`num_pagines_interiors`, `Publicacion`.`n_pag_annex`, `Publicacion`.`numero_particelas`, `Publicacion`.`numero_pagines_particelas`, `Publicacion`.`durada`, `Publicacion`.`visible_instrumentacio`, `Publicacion`.`visible_formacions`, `Publicacion`.`pdf_car_estructuracio`, `Publicacion`.`pes`, `Publicacion`.`published`, `Publicacion`.`created`, `Publicacion`.`modified`, `Publicacion`.`ordenacion`, `Publicacion`.`puntuacio`, `Publicacion`.`visto`, `Publicacion`.`rating`, `Publicacion`.`votes`, `Publicacion`.`parent`, `Publicacion`.`has_child`, `RsspostsPublicacion`.`id`, `RsspostsPublicacion`.`rsspost_id`, `RsspostsPublicacion`.`publicacion_id` FROM `publicacions` AS `Publicacion` JOIN `rssposts_publicacions` AS `RsspostsPublicacion` ON (`RsspostsPublicacion`.`rsspost_id` IN (23583, 23584, 23585, 23586, 23587, 23539, 23540, 23529, 23530, 23425) AND `RsspostsPublicacion`.`publicacion_id` = `Publicacion`.`id`) 000
110SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 74 ORDER BY `order` ASC 110
111SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 5423 LIMIT 1110
112SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23583 ORDER BY `order` ASC 002
113SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 74 ORDER BY `order` ASC 110
114SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 5423 LIMIT 1110
115SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23584 ORDER BY `order` ASC 002
116SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 77 ORDER BY `order` ASC 111
117SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4932 LIMIT 1110
118SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23585 ORDER BY `order` ASC 001
119SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 48 ORDER BY `order` ASC 112
120SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4577 LIMIT 1110
121SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23586 ORDER BY `order` ASC 001
122SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 96 ORDER BY `order` ASC 111
123SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 5009 LIMIT 1110
124SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23587 ORDER BY `order` ASC 001
125SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 8 ORDER BY `order` ASC 110
126SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4243 LIMIT 1110
127SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23539 ORDER BY `order` ASC 002
128SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 8 ORDER BY `order` ASC 110
129SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4243 LIMIT 1110
130SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23540 ORDER BY `order` ASC 002
131SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 54 ORDER BY `order` ASC 110
132SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4611 LIMIT 1110
133SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23529 ORDER BY `order` ASC 002
134SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 54 ORDER BY `order` ASC 110
135SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4611 LIMIT 1110
136SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23530 ORDER BY `order` ASC 001
137SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rss' AND `Archivesrelation`.`foreign_id` = 8 ORDER BY `order` ASC 110
138SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4243 LIMIT 1110
139SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Rsspost' AND `Archivesrelation`.`foreign_id` = 23425 ORDER BY `order` ASC 002
140SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 5423 LIMIT 1110
141SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 5423 LIMIT 1110
142SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4932 LIMIT 1110
143SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4577 LIMIT 1110
144SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 5009 LIMIT 1110
145SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4243 LIMIT 1110
146SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4243 LIMIT 1111
147SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4611 LIMIT 1110
148SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4611 LIMIT 1110
149SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 4243 LIMIT 1110