0 Products, 0 €

Register

Scores and music books: quality, creativity and service always accessible for you.

Dinsic > Colecciones > Música coral y vocal > Separates d'obres vocals o corals

Música coral y vocal

La colección Separates d'obres corals o vocals (Separatas de obras corales y vocales) presenta por separado obras que aparecen publicadas en recopilaciones de varias piezas, para facilitar que los coros las puedan programar de forma separada, sin seguir el orden de las recopilaciones.

2014-12-09 11:18:00

Cançó de bressol de la Verge

Format:

Score

Author:

Narcís Bonet

Notice (8): Undefined index: visible_instrumentacio [APP/views/categories/display.ctp, line 394]
Collection:

Separates d'obres vocals o corals Nr. 19

4.25 € VAT included

2014-10-30 11:27:00

El pobre alegre (deu cançons populars catalanes)

Format:

Score

Collection:

Separates d'obres vocals o corals Nr. 18

3.24 € VAT included

2014-06-27 11:03:00

Menta i farigola, veus mixtes i piano

Format:

Score

Author:

Eduard Toldrà Soler

Collection:

Separates d'obres vocals o corals Nr. 17

3.24 € VAT included

2014-07-10 12:10:00

Maig, veus mixtes i piano

Format:

Score

Author:

Eduard Toldrà Soler

Notice (8): Undefined index: visible_formacions [APP/views/categories/display.ctp, line 406]
Collection:

Separates d'obres vocals o corals Nr. 16

3.24 € VAT included

2014-05-27 12:27:00

Después que te conocí, veus mixtes i piano

Format:

Score

Author:

Eduard Toldrà Soler

Collection:

Separates d'obres vocals o corals Nr. 15

3.24 € VAT included

2014-06-27 13:23:00

Madre, unos ojuelos vi

Format:

Score

Author:

Eduard Toldrà Soler

Collection:

Separates d'obres vocals o corals Nr. 14

3.24 € VAT included

2014-07-03 11:34:00

Festeig, veus mixtes i piano

Format:

Score

Author:

Eduard Toldrà Soler

Collection:

Separates d'obres vocals o corals Nr. 13

3.24 € VAT included

Partituras

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

Profesores

Discount programme for music teachers and their pupils. Become a member and recover a part of the amount of your purchases.

Directores

Discount programme for choir and orchestra conductors, no matter if they are professionals or amateurs. Become a member and recover a part of the amount of your purchases.

Autores y compositores

Discount programme for authors of works published by our publishing company. Become a member and recover a part of the amount of your purchases.

Tiendas

If you are a shop, you can now purchase on our web site and take advantage of the sector’s usual trade discounts.

Subscribe to our Newletter!

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

About Us

Customer info:

For users

Official information

Latests searches

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

Associations of which we are part

DINSIC Publicacions Musicals, S.L.
Warehouse: Sepúlveda, 84 - 08015 Barcelona (Calàbria / Metro L1 Rocafort)
From Monday to Friday 9:30 - 13:30
Tels. +34 93 832 69 46
[email protected]
Copyright © 1998-2025
This portal is designed to work with the latest versions of the principal navigators: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. The use of non-compatible navigators or deactivation of some properties such as Javascript compatibility or blocking cookies may reduce the sites functionality. If you are accessing the site through a firewall or a porxy, make sure cookies are enabled.
(default) 207 queries took 19 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `colleccions`770
2DESCRIBE `catcolleccions`990
3DESCRIBE `archivesrelations`660
4DESCRIBE `catcolleccion_translations`660
5DESCRIBE `publicacions`43431
6DESCRIBE `ratings`880
7DESCRIBE `comments`990
8DESCRIBE `autors`14140
9DESCRIBE `publicacions_autors`440
10DESCRIBE `autor_translations`660
11DESCRIBE `categories`990
12DESCRIBE `publicacions_categories`330
13DESCRIBE `categories_translations`660
14DESCRIBE `editors`220
15DESCRIBE `publicacions_editors`990
16DESCRIBE `enquadernacions`330
17DESCRIBE `publicacions_enquadernacions`330
18DESCRIBE `enquadernacion_translations`660
19DESCRIBE `formacions`770
20DESCRIBE `catformacions`990
21DESCRIBE `catformacion_translations`660
22DESCRIBE `publicacions_formacions`330
23DESCRIBE `formacion_translations`660
24DESCRIBE `idiomas`440
25DESCRIBE `publicacions_idiomas`330
26DESCRIBE `idioma_translations`660
27DESCRIBE `instruments`660
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`10100
42DESCRIBE `rss`550
43DESCRIBE `rssposts_publicacions`330
44DESCRIBE `publicacions_colleccions`440
45DESCRIBE `publicacion_translations`660
46DESCRIBE `colleccion_translations`660
47DESCRIBE `funcions`440
48DESCRIBE `funcion_translations`660
49DESCRIBE `users`35350
50DESCRIBE `roles`550
51DESCRIBE `archives`660
52DESCRIBE `archivestypes`550
53DESCRIBE `pages`990
54DESCRIBE `pages_translations`660
55DESCRIBE `orders`18180
56DESCRIBE `invoices`22220
57DESCRIBE `orderproducts`10100
58DESCRIBE `latestsearches`660
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 42420
106SELECT `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 `I18n__url`.`content` = 'separates_d_obres_vocals_o_corals' AND `I18n__nom`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1116
107SELECT `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`.`id` = 1877 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1110
108SELECT `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` = 1877 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__descripcio`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' 27270
109SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '0%' 110
110SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '1%' 110
111SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '2%' 110
112SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '3%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '3%' 111
113SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '4%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '4%' 110
114SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '5%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '5%' 110
115SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '6%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '6%' 110
116SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '7%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '7%' 110
117SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '8%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '8%' 110
118SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '9%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE '9%' 111
119SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'A%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'A%' 111
120SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'B%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'B%' 110
121SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'C%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'C%' 110
122SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'D%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'D%' 110
123SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'E%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'E%' 110
124SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'F%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'F%' 110
125SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'G%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'G%' 110
126SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'H%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'H%' 110
127SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'I%' 110
128SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'J%' 110
129SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'K%' 110
130SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'L%' 110
131SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'M%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'M%' 111
132SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'N%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'N%' 110
133SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'O%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'O%' 110
134SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'P%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'P%' 110
135SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Q%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'Q%' 110
136SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'R%' 110
137SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'S%' 110
138SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'T%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'T%' 110
139SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'U%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'U%' 110
140SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'V%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'V%' 110
141SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'W%' 110
142SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'X%' 110
143SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Y%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'Y%' 110
144SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Z%') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `Publicacion`.`titol` LIKE 'Z%' 110
145SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 111
146SELECT DISTINCT `Publicacion`.`id`, `Publicacion`.`format`, `Publicacion`.`preu`, `Publicacion`.`created`, `Publicacion`.`novetat`, `Publicacion`.`en_preparacio`, `Publicacion`.`recomanat`, `Publicacion`.`exhaurit`, `Publicacion`.`oferta`, `I18n__titol`.`content`, `I18n__url`.`content`, `I18n__intro`.`content`, `Publicacion`.`id` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__titol` ON (`Publicacion`.`id` = `I18n__titol`.`foreign_key` AND `I18n__titol`.`model` = 'Publicacion' AND `I18n__titol`.`field` = 'titol') LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `publicacion_translations` AS `I18n__intro` ON (`Publicacion`.`id` = `I18n__intro`.`foreign_key` AND `I18n__intro`.`model` = 'Publicacion' AND `I18n__intro`.`field` = 'intro') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 AND `I18n__titol`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__intro`.`locale` = 'es_es' ORDER BY `PublicacionsColleccion`.`num_volum` DESC LIMIT 7772
147SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Publicacion' AND `Archivesrelation`.`foreign_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) ORDER BY `Archivesrelation`.`order` ASC 21212
148SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`name`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`model` = 'Publicacion' AND `Rating`.`model_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) 000
149SELECT `Comment`.`id`, `Comment`.`publicacion_id`, `Comment`.`replay_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`replay_id`=0 AND `Comment`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) ORDER BY `Comment`.`id` ASC 000
150SELECT `Autor`.`id`, `Autor`.`nom`, `Autor`.`cognom`, `Autor`.`2cognom`, `Autor`.`curriculum`, `Autor`.`data_desconeguda`, `Autor`.`data_naixement`, `Autor`.`nomes_any_naixement`, `Autor`.`nomes_any_defuncio`, `Autor`.`defuncio`, `Autor`.`data_defuncio`, `Autor`.`data_defuncio_desconeguda`, `Autor`.`url`, `Autor`.`published`, `PublicacionsAutor`.`id`, `PublicacionsAutor`.`autor_id`, `PublicacionsAutor`.`publicacion_id`, `PublicacionsAutor`.`funcion_id` FROM `autors` AS `Autor` JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC 19191
151SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`parent_id`, `Category`.`descripcio`, `Category`.`order`, `Category`.`lft`, `Category`.`rght`, `Category`.`published`, `PublicacionsCategory`.`id`, `PublicacionsCategory`.`publicacion_id`, `PublicacionsCategory`.`category_id` FROM `categories` AS `Category` JOIN `publicacions_categories` AS `PublicacionsCategory` ON (`PublicacionsCategory`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 12120
152SELECT `Colleccion`.`id`, `Colleccion`.`nom`, `Colleccion`.`catcolleccion_id`, `Colleccion`.`descripcio`, `Colleccion`.`order`, `Colleccion`.`url`, `Colleccion`.`published`, `PublicacionsColleccion`.`id`, `PublicacionsColleccion`.`colleccion_id`, `PublicacionsColleccion`.`publicacion_id`, `PublicacionsColleccion`.`num_volum` FROM `colleccions` AS `Colleccion` JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC 770
153SELECT `Editor`.`id`, `Editor`.`nom`, `PublicacionsEditor`.`id`, `PublicacionsEditor`.`publicacion_id`, `PublicacionsEditor`.`editor_id`, `PublicacionsEditor`.`data_edicio`, `PublicacionsEditor`.`num_edicio`, `PublicacionsEditor`.`data_reimpresio`, `PublicacionsEditor`.`data_reimpresio_nul`, `PublicacionsEditor`.`num_reimpresio`, `PublicacionsEditor`.`deposito_legal` FROM `editors` AS `Editor` JOIN `publicacions_editors` AS `PublicacionsEditor` ON (`PublicacionsEditor`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`) 550
154SELECT `Enquadernacion`.`id`, `Enquadernacion`.`nom`, `Enquadernacion`.`published`, `PublicacionsEnquadernacion`.`id`, `PublicacionsEnquadernacion`.`publicacion_id`, `PublicacionsEnquadernacion`.`enquadernacion_id` FROM `enquadernacions` AS `Enquadernacion` JOIN `publicacions_enquadernacions` AS `PublicacionsEnquadernacion` ON (`PublicacionsEnquadernacion`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`) 770
155SELECT `Formacion`.`id`, `Formacion`.`nom`, `Formacion`.`catformacion_id`, `Formacion`.`order`, `Formacion`.`url`, `Formacion`.`published`, `Formacion`.`metadescription`, `PublicacionsFormacion`.`id`, `PublicacionsFormacion`.`publicacion_id`, `PublicacionsFormacion`.`formacion_id` FROM `formacions` AS `Formacion` JOIN `publicacions_formacions` AS `PublicacionsFormacion` ON (`PublicacionsFormacion`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 330
156SELECT `Idioma`.`id`, `Idioma`.`nom`, `Idioma`.`published`, `Idioma`.`url`, `PublicacionsIdioma`.`id`, `PublicacionsIdioma`.`publicacion_id`, `PublicacionsIdioma`.`idioma_id` FROM `idiomas` AS `Idioma` JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 20200
157SELECT `Instrument`.`id`, `Instrument`.`nom`, `Instrument`.`catinstrument_id`, `Instrument`.`published`, `Instrument`.`url`, `Instrument`.`metadescription`, `PublicacionsInstrument`.`id`, `PublicacionsInstrument`.`publicacion_id`, `PublicacionsInstrument`.`instrument_id`, `PublicacionsInstrument`.`priority` FROM `instruments` AS `Instrument` JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC 14140
158SELECT `Mida`.`id`, `Mida`.`nom`, `Mida`.`orientacio`, `Mida`.`published`, `PublicacionsMida`.`id`, `PublicacionsMida`.`publicacion_id`, `PublicacionsMida`.`mida_id` FROM `midas` AS `Mida` JOIN `publicacions_midas` AS `PublicacionsMida` ON (`PublicacionsMida`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsMida`.`mida_id` = `Mida`.`id`) 770
159SELECT `Retractilat`.`id`, `Retractilat`.`nom`, `Retractilat`.`published`, `PublicacionsRetractilat`.`id`, `PublicacionsRetractilat`.`publicacion_id`, `PublicacionsRetractilat`.`retractilat_id` FROM `retractilats` AS `Retractilat` JOIN `publicacions_retractilats` AS `PublicacionsRetractilat` ON (`PublicacionsRetractilat`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 000
160SELECT `Newsletter`.`id`, `Newsletter`.`slug`, `Newsletter`.`titol`, `Newsletter`.`assumpte`, `Newsletter`.`intro`, `Newsletter`.`data`, `Newsletter`.`published`, `NewslettersPublicacion`.`id`, `NewslettersPublicacion`.`publicacion_id`, `NewslettersPublicacion`.`newsletter_id` FROM `newsletters` AS `Newsletter` JOIN `newsletters_publicacions` AS `NewslettersPublicacion` ON (`NewslettersPublicacion`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`) 880
161SELECT `Rsspost`.`id`, `Rsspost`.`rss_id`, `Rsspost`.`titol`, `Rsspost`.`html`, `Rsspost`.`data_creacio`, `Rsspost`.`data_ordenacio`, `Rsspost`.`data_publica`, `Rsspost`.`slug`, `Rsspost`.`extlink`, `Rsspost`.`published`, `RsspostsPublicacion`.`id`, `RsspostsPublicacion`.`rsspost_id`, `RsspostsPublicacion`.`publicacion_id` FROM `rssposts` AS `Rsspost` JOIN `rssposts_publicacions` AS `RsspostsPublicacion` ON (`RsspostsPublicacion`.`publicacion_id` IN (11715, 11695, 11651, 11657, 11653, 11655, 11656) AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 000
162SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'es_es') INNER JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsColleccion`.`colleccion_id` = 5575 AND `Publicacion`.`published` = 1 110
163SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 751 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
164SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
165SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 834 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
166SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
167SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1111
168SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
169SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 835 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
170SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
171SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
172SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 835 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
173SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
174SELECT `Formacion`.`id`, `I18n__nom`.`content`, `I18n__url`.`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') WHERE `Formacion`.`id` = 5306 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1111
175SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
176SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
177SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 835 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
178SELECT `Formacion`.`id`, `I18n__nom`.`content`, `I18n__url`.`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') WHERE `Formacion`.`id` = 537 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
179SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
180SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 835 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
181SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
182SELECT `Formacion`.`id`, `I18n__nom`.`content`, `I18n__url`.`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') WHERE `Formacion`.`id` = 561 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
183SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
184SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 835 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
185SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`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__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 901 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
186SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5575 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
187SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
188SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
189SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 82 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
190SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
191SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 82 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
192SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
193SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 90 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
194SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
195SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 83 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
196SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
197SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 83 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
198SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
199SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 82 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110
200SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'es_es' LIMIT 1110