corda_2
Ho sentim, no s'han trobat resultats.
Pots fer una cerca mitjançant el cercador de la capçalera.
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '0%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '0%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '1%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '1%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '2%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '2%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '3%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '3%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '3%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '4%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '4%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '4%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '5%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '5%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '5%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '6%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '6%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '6%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '7%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '7%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '7%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '8%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '8%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '8%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '9%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '9%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '9%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'A%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'A%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'A%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'B%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'B%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'B%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'C%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'C%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'C%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'D%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'D%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'D%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'E%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'E%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'E%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'F%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'F%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'F%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'G%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'G%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'G%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'H%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'H%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'H%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'I%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'I%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'J%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'J%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'K%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'K%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'L%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'L%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'M%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'M%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'M%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'N%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'N%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'N%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'O%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'O%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'O%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'P%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'P%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'P%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'Q%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Q%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'Q%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'R%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'R%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'S%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'S%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'T%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'T%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'T%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'U%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'U%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'U%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'V%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'V%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'V%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'W%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'W%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'X%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'X%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'Y%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Y%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'Y%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'Z%'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Z%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'Z%'
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN ()
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `I18n__titol`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
Query: SELECT 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_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `I18n__titol`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__intro`.`locale` = 'ca_es' ORDER BY `Publicacion`.`created` DESC LIMIT 7
Query: SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN ()
Warning (2): Invalid argument supplied for foreach() [APP/controllers/catinstruments_controller.php, line 282]
Partitures i llibres de música: qualitat, creativitat i servei, sempre al teu abast
Pots fer una cerca mitjançant el cercador de la capçalera.
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | DESCRIBE `catinstruments` | 9 | 9 | 1 | |
2 | DESCRIBE `archivesrelations` | 6 | 6 | 0 | |
3 | DESCRIBE `instruments` | 6 | 6 | 0 | |
4 | DESCRIBE `publicacions` | 43 | 43 | 1 | |
5 | DESCRIBE `ratings` | 8 | 8 | 0 | |
6 | DESCRIBE `comments` | 9 | 9 | 0 | |
7 | DESCRIBE `autors` | 14 | 14 | 0 | |
8 | DESCRIBE `publicacions_autors` | 4 | 4 | 0 | |
9 | DESCRIBE `autor_translations` | 6 | 6 | 0 | |
10 | DESCRIBE `categories` | 9 | 9 | 0 | |
11 | DESCRIBE `publicacions_categories` | 3 | 3 | 0 | |
12 | DESCRIBE `categories_translations` | 6 | 6 | 0 | |
13 | DESCRIBE `colleccions` | 7 | 7 | 0 | |
14 | DESCRIBE `catcolleccions` | 9 | 9 | 0 | |
15 | DESCRIBE `catcolleccion_translations` | 6 | 6 | 0 | |
16 | DESCRIBE `publicacions_colleccions` | 4 | 4 | 0 | |
17 | DESCRIBE `colleccion_translations` | 6 | 6 | 0 | |
18 | DESCRIBE `editors` | 2 | 2 | 0 | |
19 | DESCRIBE `publicacions_editors` | 9 | 9 | 0 | |
20 | DESCRIBE `enquadernacions` | 3 | 3 | 0 | |
21 | DESCRIBE `publicacions_enquadernacions` | 3 | 3 | 0 | |
22 | DESCRIBE `enquadernacion_translations` | 6 | 6 | 0 | |
23 | DESCRIBE `formacions` | 7 | 7 | 0 | |
24 | DESCRIBE `catformacions` | 9 | 9 | 0 | |
25 | DESCRIBE `catformacion_translations` | 6 | 6 | 0 | |
26 | DESCRIBE `publicacions_formacions` | 3 | 3 | 0 | |
27 | DESCRIBE `formacion_translations` | 6 | 6 | 0 | |
28 | DESCRIBE `idiomas` | 4 | 4 | 0 | |
29 | DESCRIBE `publicacions_idiomas` | 3 | 3 | 0 | |
30 | DESCRIBE `idioma_translations` | 6 | 6 | 0 | |
31 | DESCRIBE `midas` | 4 | 4 | 0 | |
32 | DESCRIBE `publicacions_midas` | 3 | 3 | 0 | |
33 | DESCRIBE `mida_translations` | 6 | 6 | 0 | |
34 | DESCRIBE `retractilats` | 3 | 3 | 0 | |
35 | DESCRIBE `publicacions_retractilats` | 3 | 3 | 0 | |
36 | DESCRIBE `retractilat_translations` | 6 | 6 | 0 | |
37 | DESCRIBE `newsletters` | 7 | 7 | 0 | |
38 | DESCRIBE `newsletters_publicacions` | 3 | 3 | 0 | |
39 | DESCRIBE `newsletter_translations` | 6 | 6 | 0 | |
40 | DESCRIBE `rssposts` | 10 | 10 | 0 | |
41 | DESCRIBE `rss` | 5 | 5 | 0 | |
42 | DESCRIBE `rssposts_publicacions` | 3 | 3 | 0 | |
43 | DESCRIBE `publicacions_instruments` | 4 | 4 | 0 | |
44 | DESCRIBE `publicacion_translations` | 6 | 6 | 4 | |
45 | DESCRIBE `instrument_translations` | 6 | 6 | 0 | |
46 | DESCRIBE `catinstrument_translations` | 6 | 6 | 0 | |
47 | DESCRIBE `users` | 35 | 35 | 0 | |
48 | DESCRIBE `roles` | 5 | 5 | 0 | |
49 | DESCRIBE `archives` | 6 | 6 | 0 | |
50 | DESCRIBE `archivestypes` | 5 | 5 | 0 | |
51 | DESCRIBE `pages` | 9 | 9 | 0 | |
52 | DESCRIBE `pages_translations` | 6 | 6 | 0 | |
53 | DESCRIBE `orders` | 18 | 18 | 0 | |
54 | DESCRIBE `invoices` | 22 | 22 | 0 | |
55 | DESCRIBE `orderproducts` | 10 | 10 | 0 | |
56 | DESCRIBE `latestsearches` | 6 | 6 | 0 | |
57 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` IS NULL AND `Category`.`published` = 1 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 7 | 7 | 0 | |
58 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 78 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 3 | 3 | 0 | |
59 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 76 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 3 | 3 | 0 | |
60 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 75 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 5 | 5 | 0 | |
61 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 77 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 0 | 0 | 0 | |
62 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 79 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 2 | 2 | 0 | |
63 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 3002 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 0 | 0 | 0 | |
64 | SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 80 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `order` DESC | 0 | 0 | 0 | |
65 | SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 4 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1 | 1 | 1 | 0 | |
66 | SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 41 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1 | 1 | 1 | 0 | |
67 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` IS NULL AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catcolleccion`.`order` DESC | 6 | 6 | 0 | |
68 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 95 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 3 | 3 | 0 | |
69 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 94 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 6 | 6 | 0 | |
70 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1719 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
71 | SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 1719 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 4 | 4 | 0 | |
72 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 96 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
73 | SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 96 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 7 | 7 | 0 | |
74 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1720 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 6 | 6 | 0 | |
75 | SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1721 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
76 | SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 1721 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 13 | 13 | 0 | |
77 | SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` IS NULL AND `Catformacion`.`published` = 1 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC | 3 | 3 | 0 | |
78 | SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 147 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC | 0 | 0 | 0 | |
79 | SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 147 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Formacion`.`nom` ASC | 8 | 8 | 0 | |
80 | SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 145 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC | 0 | 0 | 0 | |
81 | SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 145 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Formacion`.`nom` ASC | 18 | 18 | 0 | |
82 | SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 146 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC | 0 | 0 | 0 | |
83 | SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 146 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Formacion`.`nom` ASC | 39 | 39 | 0 | |
84 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` IS NULL AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catinstrument`.`order` DESC | 6 | 6 | 0 | |
85 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 71 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 6 | 6 | 0 | |
86 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 71 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
87 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 70 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 5 | 5 | 0 | |
88 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 70 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
89 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 73 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 4 | 4 | 0 | |
90 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 73 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
91 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 72 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 5 | 5 | 0 | |
92 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 72 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
93 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 74 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
94 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 74 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 19 | 19 | 0 | |
95 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 1699 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 0 | 0 | 0 | |
96 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 1699 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 8 | 8 | 0 | |
97 | SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 42 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1 | 1 | 1 | 0 | |
98 | SELECT `Page`.`id`, `I18n__name`.`content`, `I18n__url`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') WHERE `Page`.`parent_id` = 43 AND `I18n__name`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `Page`.`order` DESC | 5 | 5 | 0 | |
99 | SELECT `Latestsearch`.`id`, `Latestsearch`.`text`, `Latestsearch`.`q`, `Latestsearch`.`url`, `Latestsearch`.`count`, `Latestsearch`.`lang` FROM `latestsearches` AS `Latestsearch` WHERE 1 = 1 ORDER BY `count` DESC LIMIT 30 | 30 | 30 | 0 | |
100 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
101 | SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` IS NULL AND `Catformacion`.`published` = '1' AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcion`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `Catformacion`.`order` DESC | 3 | 3 | 0 | |
102 | SELECT `Catinstrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') WHERE `Catinstrument`.`parent_id` IN (70,71,72,73,74,1699) AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' ORDER BY `I18n__nom`.`content` ASC | 20 | 20 | 0 | |
103 | SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`published` = '1' AND `I18n__name`.`locale` = 'ca_es' AND `I18n__html`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' ORDER BY `order` DESC | 44 | 44 | 0 | |
104 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `I18n__url`.`content` = 'corda_2' AND `Catinstrument`.`parent_id` <> "NULL" AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1 | 1 | 1 | 1 | |
105 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`id` = 1720 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1 | 1 | 1 | 0 | |
106 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`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' LIMIT 1 | 0 | 0 | 0 | |
107 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`id` = 1720 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1 | 0 | 0 | 0 | |
108 | SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 1720 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__descripcio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' | 0 | 0 | 0 | |
109 | SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` IN (1720) AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__plural`.`locale` = 'ca_es' AND `I18n__abreviacio`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' AND `I18n__metadescription`.`locale` = 'ca_es' ORDER BY `Instrument`.`nom` ASC | 0 | 0 | 1 | |
110 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '0%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '0%'' at line 1 | 0 | ||
111 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '1%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '1%'' at line 1 | 0 | ||
112 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '2%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '2%'' at line 1 | 0 | ||
113 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '3%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '3%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '3%'' at line 1 | 0 | ||
114 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '4%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '4%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '4%'' at line 1 | 0 | ||
115 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '5%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '5%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '5%'' at line 1 | 0 | ||
116 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '6%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '6%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '6%'' at line 1 | 0 | ||
117 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '7%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '7%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '7%'' at line 1 | 0 | ||
118 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '8%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '8%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '8%'' at line 1 | 0 | ||
119 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '9%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE '9%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE '9%'' at line 1 | 0 | ||
120 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'A%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'A%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'A%'' at line 1 | 0 | ||
121 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'B%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'B%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'B%'' at line 1 | 0 | ||
122 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'C%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'C%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'C%'' at line 1 | 0 | ||
123 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'D%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'D%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'D%'' at line 1 | 0 | ||
124 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'E%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'E%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'E%'' at line 1 | 0 | ||
125 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'F%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'F%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'F%'' at line 1 | 0 | ||
126 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'G%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'G%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'G%'' at line 1 | 0 | ||
127 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'H%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'H%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'H%'' at line 1 | 0 | ||
128 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'I%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'I%'' at line 1 | 0 | ||
129 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'J%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'J%'' at line 1 | 0 | ||
130 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'K%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'K%'' at line 1 | 0 | ||
131 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'L%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'L%'' at line 1 | 0 | ||
132 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'M%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'M%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'M%'' at line 1 | 0 | ||
133 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'N%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'N%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'N%'' at line 1 | 0 | ||
134 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'O%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'O%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'O%'' at line 1 | 0 | ||
135 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'P%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'P%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'P%'' at line 1 | 0 | ||
136 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Q%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'Q%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'Q%'' at line 1 | 0 | ||
137 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'R%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'R%'' at line 1 | 0 | ||
138 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'S%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'S%'' at line 1 | 0 | ||
139 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'T%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'T%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'T%'' at line 1 | 0 | ||
140 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'U%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'U%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'U%'' at line 1 | 0 | ||
141 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'V%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'V%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'V%'' at line 1 | 0 | ||
142 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'W%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'W%'' at line 1 | 0 | ||
143 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'X%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'X%'' at line 1 | 0 | ||
144 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Y%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'Y%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'Y%'' at line 1 | 0 | ||
145 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Z%') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `Publicacion`.`titol` LIKE 'Z%' | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Publicacion`.`titol` LIKE 'Z%'' at line 1 | 0 | ||
146 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 | 0 | ||
147 | SELECT 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_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () AND `I18n__titol`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__intro`.`locale` = 'ca_es' ORDER BY `Publicacion`.`created` DESC LIMIT 7 | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `I18n__titol`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I' at line 1 | 0 | ||
148 | SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'ca_es') INNER JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsInstrument`.`instrument_id` IN () | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 | 0 |