Dinsic > Languages > French

French

2018-02-20 16:24:00

Kyrie dels “Gueux”

Format:

PDF

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

Code | Context

$___viewFn	=	"/var/www/test-dinsic/trunk/app/views/categories/display.ctp"
$___dataForView	=	array(
	"identify" => null,
	"sesionLang" => "en",
	"categories" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"qui_som" => array(
	"Page" => array()
),
	"que_fem" => array(
	"Page" => array()
),
	"listcolleccions" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"listformacions" => array(
	array(),
	array(),
	array()
),
	"listinstruments" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"paypal" => array(
	"Page" => array()
),
	"perfils_lateral" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"cloud" => " &nbsp; <a href="/searches/index/q:somnis" class="word size1">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size3">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size5">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size5">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size4">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size8">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size5">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size8">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size8">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size4">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size2">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size3">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size5">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size6">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size4">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size5">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size3">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size2">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size6">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size4">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size4">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size6">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size9">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size2">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size9">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size4">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size2">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size8">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size6">musica 2</a> &nbsp;",
	"descompte" => 0.05,
	"options_third_level" => array(
	"All types",
	"orchestral_music" => "Orchestral music",
	"vocal_and_choral_music" => "Vocal and Choral Music",
	"instrumental_music" => "Instrumental Music"
),
	"options_instruments_level" => array(
	"All Instruments",
	"brass" => "Brass",
	"clarinets_and_saxes" => "Clarinets and Saxes",
	"double_reed" => "Double Reed ",
	"electronic_keyboard" => "Electronic Keyboard",
	"flutes_recorders_and_pipes" => "Flutes, recorders and pipes",
	"guitares" => "Guitares",
	"harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.",
	"key_hammered_string_piano" => "Key / Hammered String (Piano)",
	"key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ",
	"key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String  (Hurdy-gurdy)",
	"key_wind" => "Key / Wind",
	"orff_percussion" => "Orff Percussion",
	"pitched_percussion" => "Pitched Percussion",
	"stringed_instruments" => "Stringed Instruments",
	"stringed_instruments_violins" => "Stringed Instruments: Violins",
	"ukulele" => "Ukulele",
	"un_piched_percussion" => "Un-piched Percussion",
	"unspecified_percussion" => "Unspecified Percussion",
	"wind_instruments_to_determine" => "Wind instruments to determine "
),
	"pages" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"total_basket" => 0,
	"total_basket_count" => 0,
	"admin" => false,
	"selected_controller" => "idiomas",
	"browser" => array(
	"browsertype" => null,
	"version" => "",
	"platform" => null,
	"AOL" => false
),
	"selectedtab" => false,
	"cookies" => array(
	"Page" => array()
),
	"aviso_cookie" => true,
	"letter_action_url" => "/en/idioma/french",
	"title_section" => "French",
	"vectorUrls" => array(
	"ca_es" => "/idioma/frances",
	"es_es" => "/idioma/frances",
	"en_gb" => "/idioma/french"
),
	"description" => "",
	"breadcrumb" => array(
	array(),
	array()
),
	"letterVector" => array(
	"0_9" => 5,
	"A" => 18,
	"B" => 15,
	"C" => 24,
	"D" => 63,
	"E" => 31,
	"F" => 5,
	"G" => 2,
	"H" => 2,
	"I" => 6,
	"J" => 6,
	"K" => 2,
	"L" => 40,
	"M" => 24,
	"N" => 8,
	"O" => 4,
	"P" => 58,
	"Q" => 8,
	"R" => 7,
	"S" => 19,
	"T" => 21,
	"U" => 2,
	"V" => 10,
	"W" => 2,
	"Y" => 1,
	"Z" => 1
),
	"letter_selected" => "",
	"lastlink" => 58,
	"keywords" => "Kyrie dels “Gueux”, Jo treballo, Au anem amics meus a Sibèria, Donant-nos les mans, Bell matí, Unim nostres veus, Ens agrada fer el rodamon",
	"list" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
)
)
$loadHelpers	=	true
$cached	=	false
$loadedHelpers	=	array(
	"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/en/idioma/french/14"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"Form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/en/idioma/french/14"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"Javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/en/idioma/french/14"
JavascriptHelper::$params = array
JavascriptHelper::$action = "display"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"Library" => LibraryHelper
LibraryHelper::$helpers = array
LibraryHelper::$base = ""
LibraryHelper::$webroot = "/"
LibraryHelper::$themeWeb = NULL
LibraryHelper::$here = "/en/idioma/french/14"
LibraryHelper::$params = array
LibraryHelper::$action = "display"
LibraryHelper::$plugin = NULL
LibraryHelper::$data = NULL
LibraryHelper::$namedArgs = NULL
LibraryHelper::$argSeparator = NULL
LibraryHelper::$validationErrors = NULL
LibraryHelper::$tags = array
LibraryHelper::$__tainted = NULL
LibraryHelper::$__cleaned = NULL
LibraryHelper::$_log = NULL
LibraryHelper::$Html = HtmlHelper object
LibraryHelper::$Javascript = JavascriptHelper object,
	"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "337eccbd43ced36b81f70fcab2883ac8"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1748369397
SessionHelper::$sessionTime = 1748391397
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/en/idioma/french/14"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL,
	"Paginator" => PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = NULL
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/en/idioma/french/14"
PaginatorHelper::$params = array
PaginatorHelper::$action = "display"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object,
	"Ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/en/idioma/french/14"
AjaxHelper::$params = array
AjaxHelper::$action = "display"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
)
$helper	=	"Ajax"
$camelBackedHelper	=	"ajax"
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/en/idioma/french/14"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/en/idioma/french/14"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/en/idioma/french/14"
JavascriptHelper::$params = array
JavascriptHelper::$action = "display"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$library	=	LibraryHelper
LibraryHelper::$helpers = array
LibraryHelper::$base = ""
LibraryHelper::$webroot = "/"
LibraryHelper::$themeWeb = NULL
LibraryHelper::$here = "/en/idioma/french/14"
LibraryHelper::$params = array
LibraryHelper::$action = "display"
LibraryHelper::$plugin = NULL
LibraryHelper::$data = NULL
LibraryHelper::$namedArgs = NULL
LibraryHelper::$argSeparator = NULL
LibraryHelper::$validationErrors = NULL
LibraryHelper::$tags = array
LibraryHelper::$__tainted = NULL
LibraryHelper::$__cleaned = NULL
LibraryHelper::$_log = NULL
LibraryHelper::$Html = HtmlHelper object
LibraryHelper::$Javascript = JavascriptHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "337eccbd43ced36b81f70fcab2883ac8"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1748369397
SessionHelper::$sessionTime = 1748391397
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/en/idioma/french/14"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$paginator	=	PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = NULL
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/en/idioma/french/14"
PaginatorHelper::$params = array
PaginatorHelper::$action = "display"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object
$ajax	=	AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/en/idioma/french/14"
AjaxHelper::$params = array
AjaxHelper::$action = "display"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$identify	=	null
$sesionLang	=	"en"
$categories	=	array(
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
)
)
$qui_som	=	array(
	"Page" => array(
	"id" => "4",
	"order" => "36",
	"parent_id" => null,
	"name" => "About us",
	"html" => "<div>
	Located in the very heart of the old town of Barcelona, DINSIC Publicacions Musicals, SL was found in 1988 by Francesca Galofr&eacute; Mora as a response to her great pedagogical vocation and with the aim of disseminating knowledge and musical production.<br />
	<br />
	Today, with more than twenty years of constant work, the publishing company devotes itself to promoting the publication of several books and materials destined to musical education in all its fields: music schools and conservatories, school in all its levels and university.<br />
	<br />
	Its collection includes scores ranging from solo parts, literature for chamber ensembles and orchestras to the great symphonic repertoire, as well as works for choir in all its formations. Some of these collections include publications of critical studies in several languages.</div>
<div>
	&nbsp;</div>
<ul>
	<li>
		<a href="/en/p/introduction">Introduction</a></li>
	<li>
		<a href="/en/p/aims_of_the_enterprise">Aims of the enterprise</a></li>
	<li>
		<a href="/en/p/the_autors">The autors</a></li>
	<li>
		<a href="/en/p/cooperations">Cooperations</a></li>
	<li>
		<a href="/en/p/commercial_distribution">Commercial distribution</a></li>
	<li>
		<a href="/en/p/catalogue_of_releases">Catalogue of releases</a></li>
</ul>
",
	"url" => "about_us",
	"published" => "1",
	"lft" => "5",
	"rght" => "26",
	"locale" => "en_gb"
)
)
$que_fem	=	array(
	"Page" => array(
	"id" => "41",
	"order" => "8",
	"parent_id" => null,
	"name" => "What we do",
	"html" => "<div>
	At DINSIC, we basically specialize in writing and publishing books and a wide range of materials for music education. We also edit vocal, instrumental and orchestral scores for choirs, chamber ensembles and orchestras.<br />
	<br />
	We have a special interest in publishing music works with comments in several languages: Catalan, Spanish, Bask, French Occitan, Portuguese, English, German etc., and books about music and its world.<br />
	<br />
	We have a department for traditional and popular Catalan and Occitan music, which is soon going to be expanded with music from other regions.<br />
	<br />
	At our publishing company, we work intensively to make the most of the possibilities of the technological applications that new information and communication technologies offer within our field.<br />
	<br />
	Our website exhibits our catalogue of releases, which are available in all sorts of mediums (paper, CD etc.), or on-line.<br />
	<br />
	We have adjoined a virtual store and environment for registered users, who can benefit from additional information and support services.</div>
",
	"url" => "what_we_do",
	"published" => "1",
	"lft" => "71",
	"rght" => "72",
	"locale" => "en_gb"
)
)
$listcolleccions	=	array(
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
)
)
$listformacions	=	array(
	array(
	"Catformacion" => array(),
	"children" => array()
),
	array(
	"Catformacion" => array(),
	"children" => array()
),
	array(
	"Catformacion" => array(),
	"children" => array()
)
)
$listinstruments	=	array(
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
)
)
$paypal	=	array(
	"Page" => array(
	"id" => "42",
	"order" => "9",
	"parent_id" => null,
	"name" => "More ways to pay: PayPal",
	"html" => "<div>
	DINSIC Publicacions Musicals is delighted to announce it already accepts PayPal as an on-line payment method, alongside Visa, Mastercard and other credit cards or other traditional payment methods as COD or shipping service.<br />
	<br />
	For those who don&rsquo;t know PayPal, this system is one of the most efficient ways to make and receive international and &ndash; of course - national payments.<br />
	<br />
	As in payments with credit cards, which are completely safe, the seller doesn&rsquo;t have any access to your banc details.<br />
	<br />
	Link your credit or debit card to PayPal and decide with them your preferred payment method.</div>
",
	"url" => "more_ways_to_pay_paypal",
	"published" => "1",
	"lft" => "73",
	"rght" => "74",
	"locale" => "en_gb"
)
)
$perfils_lateral	=	array(
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
)
)
$cloud	=	" &nbsp; <a href="/searches/index/q:somnis" class="word size1">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size3">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size5">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size5">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size4">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size8">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size5">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size8">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size8">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size4">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size2">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size3">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size5">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size6">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size4">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size5">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size3">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size2">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size6">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size4">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size4">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size6">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size9">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size2">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size9">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size4">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size2">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size8">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size6">musica 2</a> &nbsp;"
$descompte	=	0.05
$options_third_level	=	array(
	"All types",
	"orchestral_music" => "Orchestral music",
	"vocal_and_choral_music" => "Vocal and Choral Music",
	"instrumental_music" => "Instrumental Music"
)
$options_instruments_level	=	array(
	"All Instruments",
	"brass" => "Brass",
	"clarinets_and_saxes" => "Clarinets and Saxes",
	"double_reed" => "Double Reed ",
	"electronic_keyboard" => "Electronic Keyboard",
	"flutes_recorders_and_pipes" => "Flutes, recorders and pipes",
	"guitares" => "Guitares",
	"harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.",
	"key_hammered_string_piano" => "Key / Hammered String (Piano)",
	"key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ",
	"key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String  (Hurdy-gurdy)",
	"key_wind" => "Key / Wind",
	"orff_percussion" => "Orff Percussion",
	"pitched_percussion" => "Pitched Percussion",
	"stringed_instruments" => "Stringed Instruments",
	"stringed_instruments_violins" => "Stringed Instruments: Violins",
	"ukulele" => "Ukulele",
	"un_piched_percussion" => "Un-piched Percussion",
	"unspecified_percussion" => "Unspecified Percussion",
	"wind_instruments_to_determine" => "Wind instruments to determine "
)
$pages	=	array(
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
)
)
$total_basket	=	0
$total_basket_count	=	0
$admin	=	false
$selected_controller	=	"idiomas"
$browser	=	array(
	"browsertype" => null,
	"version" => "",
	"platform" => null,
	"AOL" => false
)
$selectedtab	=	false
$cookies	=	array(
	"Page" => array(
	"locale" => "en_gb",
	"name" => "Politica de cookies",
	"url" => "politica_de_cookies"
)
)
$aviso_cookie	=	true
$letter_action_url	=	"/en/idioma/french"
$title_section	=	"French"
$vectorUrls	=	array(
	"ca_es" => "/idioma/frances",
	"es_es" => "/idioma/frances",
	"en_gb" => "/idioma/french"
)
$description	=	""
$breadcrumb	=	array(
	array(
	"url" => "/en/idiomes",
	"text" => "Languages"
),
	array(
	"url" => "/en/idioma/french",
	"text" => "French"
)
)
$letterVector	=	array(
	"0_9" => 5,
	"A" => 18,
	"B" => 15,
	"C" => 24,
	"D" => 63,
	"E" => 31,
	"F" => 5,
	"G" => 2,
	"H" => 2,
	"I" => 6,
	"J" => 6,
	"K" => 2,
	"L" => 40,
	"M" => 24,
	"N" => 8,
	"O" => 4,
	"P" => 58,
	"Q" => 8,
	"R" => 7,
	"S" => 19,
	"T" => 21,
	"U" => 2,
	"V" => 10,
	"W" => 2,
	"Y" => 1,
	"Z" => 1
)
$letter_selected	=	""
$lastlink	=	58
$keywords	=	"Kyrie dels “Gueux”, Jo treballo, Au anem amics meus a Sibèria, Donant-nos les mans, Bell matí, Unim nostres veus, Ens agrada fer el rodamon"
$list	=	array(
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
)
)
$length	=	0
$i	=	1
$publicacion	=	array(
	"Publicacion" => array(
	"id" => "12827",
	"format" => "PDF",
	"preu" => "1.75",
	"created" => "2018-02-20 16:24:00",
	"en_preparacio" => "0",
	"novetat" => "0",
	"recomanat" => "0",
	"exhaurit" => "0",
	"oferta" => "0",
	"locale" => "en_gb",
	"titol" => "Kyrie dels “Gueux”",
	"url" => "pdf-exxi157p-kyrie_dels_gueux",
	"intro" => "",
	"path" => "scores-elementary"
),
	"Archivesrelation" => array(
	array(),
	array(),
	array()
),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(
	array()
),
	"Category" => array(
	array()
),
	"Colleccion" => array(
	array()
),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"Instrument" => array(
	array(),
	array()
),
	"Mida" => array(
	array()
),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
)
$selected_image	=	"9513"
$pub	=	array(
	"id" => "8058",
	"model" => "Publicacion",
	"foreign_id" => "12827",
	"order" => "0",
	"file_id" => "9513",
	"archivestypes_id" => "2"
)
$urlimage	=	"http://www.dinsic.com/img/cache/b15b0adeb65164ebbb8dad47d37481a7-9513-100.jpg"
$urlimagesize	=	"/var/www/dinsic/root/app/webroot/img/cache/b15b0adeb65164ebbb8dad47d37481a7-9513-100.jpg"
$imgsize	=	array(
	100,
	141,
	2,
	"width="100" height="141"",
	"bits" => 8,
	"channels" => 3,
	"mime" => "image/jpeg"
)
$imgprinted	=	false
$vector	=	array()
$elem	=	array(
	"id" => "5779",
	"nom" => "Artur",
	"cognom" => "Martorell",
	"2cognom" => "Bisbal",
	"curriculum" => "",
	"data_desconeguda" => "0",
	"data_naixement" => "1894-04-14",
	"nomes_any_naixement" => "0",
	"nomes_any_defuncio" => "0",
	"defuncio" => "1",
	"data_defuncio" => "1967-04-04",
	"data_defuncio_desconeguda" => "0",
	"url" => "artur_martorell_bisbal",
	"published" => "1",
	"PublicacionsAutor" => array(
	"id" => "4844",
	"autor_id" => "5779",
	"publicacion_id" => "12827",
	"funcion_id" => "1474"
)
)

                                            //si hay instrumentos => mostrar instrumentos
                                                                                        //debug( $publicacion );
                                            if (count($publicacion['Instrument'])>0 && $publicacion['Publicacion']['visible_instrumentacio']){

include - APP/views/categories/display.ctp, line 394
View::_render() - CORE/cake/libs/view/view.php, line 665
View::render() - CORE/cake/libs/view/view.php, line 375
Controller::render() - CORE/cake/libs/controller/controller.php, line 805
IdiomasController::display() - APP/controllers/idiomas_controller.php, line 318
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88

Collection:

Esplai XXI (peces soltes en pdf) Nr. 157

1.82 € VAT included

2018-02-20 16:24:00

Jo treballo

Format:

PDF

Collection:

Esplai XXI (peces soltes en pdf) Nr. 158

1.82 € VAT included

2018-02-20 16:24:00

Au anem amics meus a Sibèria

Format:

PDF

Author:

Popular alemanya

Collection:

Esplai XXI (peces soltes en pdf) Nr. 159

1.82 € VAT included

2018-02-20 16:24:00

Donant-nos les mans

Format:

PDF

Author:

W. Lemit

Collection:

Esplai XXI (peces soltes en pdf) Nr. 160

1.82 € VAT included

2018-02-20 16:24:00

Bell matí

Format:

PDF

Author:

César Géoffray

Collection:

Esplai XXI (peces soltes en pdf) Nr. 162

1.82 € VAT included

2018-02-20 16:24:00

Unim nostres veus

Format:

PDF

Author:

W. Lemit

Collection:

Esplai XXI (peces soltes en pdf) Nr. 162

1.82 € VAT included

2018-02-20 16:24:00

Ens agrada fer el rodamon

Format:

PDF

Author:

Marcel Corneloup

Collection:

Esplai XXI (peces soltes en pdf) Nr. 163

1.82 € VAT included

<< First << Prev 10 11 12 13 14 15 16 17 18 Next >> Last >>

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

Code | Context

$___viewFn	=	"/var/www/test-dinsic/trunk/app/views/elements/lateral.ctp"
$___dataForView	=	array(
	"identify" => null,
	"sesionLang" => "en",
	"categories" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"qui_som" => array(
	"Page" => array()
),
	"que_fem" => array(
	"Page" => array()
),
	"listcolleccions" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"listformacions" => array(
	array(),
	array(),
	array()
),
	"listinstruments" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"paypal" => array(
	"Page" => array()
),
	"perfils_lateral" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"cloud" => " &nbsp; <a href="/searches/index/q:somnis" class="word size1">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size3">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size5">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size5">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size4">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size8">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size5">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size8">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size8">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size4">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size2">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size3">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size5">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size6">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size4">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size5">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size3">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size2">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size6">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size4">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size4">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size6">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size9">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size2">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size9">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size4">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size2">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size8">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size6">musica 2</a> &nbsp;",
	"descompte" => 0.05,
	"options_third_level" => array(
	"All types",
	"orchestral_music" => "Orchestral music",
	"vocal_and_choral_music" => "Vocal and Choral Music",
	"instrumental_music" => "Instrumental Music"
),
	"options_instruments_level" => array(
	"All Instruments",
	"brass" => "Brass",
	"clarinets_and_saxes" => "Clarinets and Saxes",
	"double_reed" => "Double Reed ",
	"electronic_keyboard" => "Electronic Keyboard",
	"flutes_recorders_and_pipes" => "Flutes, recorders and pipes",
	"guitares" => "Guitares",
	"harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.",
	"key_hammered_string_piano" => "Key / Hammered String (Piano)",
	"key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ",
	"key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String  (Hurdy-gurdy)",
	"key_wind" => "Key / Wind",
	"orff_percussion" => "Orff Percussion",
	"pitched_percussion" => "Pitched Percussion",
	"stringed_instruments" => "Stringed Instruments",
	"stringed_instruments_violins" => "Stringed Instruments: Violins",
	"ukulele" => "Ukulele",
	"un_piched_percussion" => "Un-piched Percussion",
	"unspecified_percussion" => "Unspecified Percussion",
	"wind_instruments_to_determine" => "Wind instruments to determine "
),
	"pages" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"total_basket" => 0,
	"total_basket_count" => 0,
	"admin" => false,
	"selected_controller" => "idiomas",
	"browser" => array(
	"browsertype" => null,
	"version" => "",
	"platform" => null,
	"AOL" => false
),
	"selectedtab" => false,
	"cookies" => array(
	"Page" => array()
),
	"aviso_cookie" => true,
	"letter_action_url" => "/en/idioma/french",
	"title_section" => "French",
	"vectorUrls" => array(
	"ca_es" => "/idioma/frances",
	"es_es" => "/idioma/frances",
	"en_gb" => "/idioma/french"
),
	"description" => "",
	"breadcrumb" => array(
	array(),
	array()
),
	"letterVector" => array(
	"0_9" => 5,
	"A" => 18,
	"B" => 15,
	"C" => 24,
	"D" => 63,
	"E" => 31,
	"F" => 5,
	"G" => 2,
	"H" => 2,
	"I" => 6,
	"J" => 6,
	"K" => 2,
	"L" => 40,
	"M" => 24,
	"N" => 8,
	"O" => 4,
	"P" => 58,
	"Q" => 8,
	"R" => 7,
	"S" => 19,
	"T" => 21,
	"U" => 2,
	"V" => 10,
	"W" => 2,
	"Y" => 1,
	"Z" => 1
),
	"letter_selected" => "",
	"lastlink" => 58,
	"keywords" => "Kyrie dels “Gueux”, Jo treballo, Au anem amics meus a Sibèria, Donant-nos les mans, Bell matí, Unim nostres veus, Ens agrada fer el rodamon",
	"list" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/en/idioma/french/14"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/en/idioma/french/14"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/en/idioma/french/14"
JavascriptHelper::$params = array
JavascriptHelper::$action = "display"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"library" => LibraryHelper
LibraryHelper::$helpers = array
LibraryHelper::$base = ""
LibraryHelper::$webroot = "/"
LibraryHelper::$themeWeb = NULL
LibraryHelper::$here = "/en/idioma/french/14"
LibraryHelper::$params = array
LibraryHelper::$action = "display"
LibraryHelper::$plugin = NULL
LibraryHelper::$data = NULL
LibraryHelper::$namedArgs = NULL
LibraryHelper::$argSeparator = NULL
LibraryHelper::$validationErrors = NULL
LibraryHelper::$tags = array
LibraryHelper::$__tainted = NULL
LibraryHelper::$__cleaned = NULL
LibraryHelper::$_log = NULL
LibraryHelper::$Html = HtmlHelper object
LibraryHelper::$Javascript = JavascriptHelper object,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "337eccbd43ced36b81f70fcab2883ac8"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1748369397
SessionHelper::$sessionTime = 1748391397
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/en/idioma/french/14"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL,
	"paginator" => PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Publicacion"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/en/idioma/french/14"
PaginatorHelper::$params = array
PaginatorHelper::$action = "display"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object,
	"ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/en/idioma/french/14"
AjaxHelper::$params = array
AjaxHelper::$action = "display"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$identify	=	null
$sesionLang	=	"en"
$categories	=	array(
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
),
	array(
	"Category" => array(),
	"Categories" => array()
)
)
$qui_som	=	array(
	"Page" => array(
	"id" => "4",
	"order" => "36",
	"parent_id" => null,
	"name" => "About us",
	"html" => "<div>
	Located in the very heart of the old town of Barcelona, DINSIC Publicacions Musicals, SL was found in 1988 by Francesca Galofr&eacute; Mora as a response to her great pedagogical vocation and with the aim of disseminating knowledge and musical production.<br />
	<br />
	Today, with more than twenty years of constant work, the publishing company devotes itself to promoting the publication of several books and materials destined to musical education in all its fields: music schools and conservatories, school in all its levels and university.<br />
	<br />
	Its collection includes scores ranging from solo parts, literature for chamber ensembles and orchestras to the great symphonic repertoire, as well as works for choir in all its formations. Some of these collections include publications of critical studies in several languages.</div>
<div>
	&nbsp;</div>
<ul>
	<li>
		<a href="/en/p/introduction">Introduction</a></li>
	<li>
		<a href="/en/p/aims_of_the_enterprise">Aims of the enterprise</a></li>
	<li>
		<a href="/en/p/the_autors">The autors</a></li>
	<li>
		<a href="/en/p/cooperations">Cooperations</a></li>
	<li>
		<a href="/en/p/commercial_distribution">Commercial distribution</a></li>
	<li>
		<a href="/en/p/catalogue_of_releases">Catalogue of releases</a></li>
</ul>
",
	"url" => "about_us",
	"published" => "1",
	"lft" => "5",
	"rght" => "26",
	"locale" => "en_gb"
)
)
$que_fem	=	array(
	"Page" => array(
	"id" => "41",
	"order" => "8",
	"parent_id" => null,
	"name" => "What we do",
	"html" => "<div>
	At DINSIC, we basically specialize in writing and publishing books and a wide range of materials for music education. We also edit vocal, instrumental and orchestral scores for choirs, chamber ensembles and orchestras.<br />
	<br />
	We have a special interest in publishing music works with comments in several languages: Catalan, Spanish, Bask, French Occitan, Portuguese, English, German etc., and books about music and its world.<br />
	<br />
	We have a department for traditional and popular Catalan and Occitan music, which is soon going to be expanded with music from other regions.<br />
	<br />
	At our publishing company, we work intensively to make the most of the possibilities of the technological applications that new information and communication technologies offer within our field.<br />
	<br />
	Our website exhibits our catalogue of releases, which are available in all sorts of mediums (paper, CD etc.), or on-line.<br />
	<br />
	We have adjoined a virtual store and environment for registered users, who can benefit from additional information and support services.</div>
",
	"url" => "what_we_do",
	"published" => "1",
	"lft" => "71",
	"rght" => "72",
	"locale" => "en_gb"
)
)
$listcolleccions	=	array(
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
),
	array(
	"Catcolleccion" => array(),
	"children" => array()
)
)
$listformacions	=	array(
	array(
	"Catformacion" => array(),
	"children" => array()
),
	array(
	"Catformacion" => array(),
	"children" => array()
),
	array(
	"Catformacion" => array(),
	"children" => array()
)
)
$listinstruments	=	array(
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
),
	array(
	"Catinstrument" => array(),
	"children" => array()
)
)
$paypal	=	array(
	"Page" => array(
	"id" => "42",
	"order" => "9",
	"parent_id" => null,
	"name" => "More ways to pay: PayPal",
	"html" => "<div>
	DINSIC Publicacions Musicals is delighted to announce it already accepts PayPal as an on-line payment method, alongside Visa, Mastercard and other credit cards or other traditional payment methods as COD or shipping service.<br />
	<br />
	For those who don&rsquo;t know PayPal, this system is one of the most efficient ways to make and receive international and &ndash; of course - national payments.<br />
	<br />
	As in payments with credit cards, which are completely safe, the seller doesn&rsquo;t have any access to your banc details.<br />
	<br />
	Link your credit or debit card to PayPal and decide with them your preferred payment method.</div>
",
	"url" => "more_ways_to_pay_paypal",
	"published" => "1",
	"lft" => "73",
	"rght" => "74",
	"locale" => "en_gb"
)
)
$perfils_lateral	=	array(
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
)
)
$cloud	=	" &nbsp; <a href="/searches/index/q:somnis" class="word size1">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size3">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size5">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size5">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size4">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size8">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size5">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size8">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size8">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size4">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size2">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size3">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size5">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size6">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size4">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size5">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size3">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size2">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size6">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size4">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size4">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size6">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size9">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size2">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size9">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size4">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size2">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size8">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size6">musica 2</a> &nbsp;"
$descompte	=	0.05
$options_third_level	=	array(
	"All types",
	"orchestral_music" => "Orchestral music",
	"vocal_and_choral_music" => "Vocal and Choral Music",
	"instrumental_music" => "Instrumental Music"
)
$options_instruments_level	=	array(
	"All Instruments",
	"brass" => "Brass",
	"clarinets_and_saxes" => "Clarinets and Saxes",
	"double_reed" => "Double Reed ",
	"electronic_keyboard" => "Electronic Keyboard",
	"flutes_recorders_and_pipes" => "Flutes, recorders and pipes",
	"guitares" => "Guitares",
	"harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.",
	"key_hammered_string_piano" => "Key / Hammered String (Piano)",
	"key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ",
	"key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String  (Hurdy-gurdy)",
	"key_wind" => "Key / Wind",
	"orff_percussion" => "Orff Percussion",
	"pitched_percussion" => "Pitched Percussion",
	"stringed_instruments" => "Stringed Instruments",
	"stringed_instruments_violins" => "Stringed Instruments: Violins",
	"ukulele" => "Ukulele",
	"un_piched_percussion" => "Un-piched Percussion",
	"unspecified_percussion" => "Unspecified Percussion",
	"wind_instruments_to_determine" => "Wind instruments to determine "
)
$pages	=	array(
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
),
	array(
	"Page" => array()
)
)
$total_basket	=	0
$total_basket_count	=	0
$admin	=	false
$selected_controller	=	"idiomas"
$browser	=	array(
	"browsertype" => null,
	"version" => "",
	"platform" => null,
	"AOL" => false
)
$selectedtab	=	false
$cookies	=	array(
	"Page" => array(
	"locale" => "en_gb",
	"name" => "Politica de cookies",
	"url" => "politica_de_cookies"
)
)
$aviso_cookie	=	true
$letter_action_url	=	"/en/idioma/french"
$title_section	=	"French"
$vectorUrls	=	array(
	"ca_es" => "/idioma/frances",
	"es_es" => "/idioma/frances",
	"en_gb" => "/idioma/french"
)
$description	=	""
$breadcrumb	=	array(
	array(
	"url" => "/en/idiomes",
	"text" => "Languages"
),
	array(
	"url" => "/en/idioma/french",
	"text" => "French"
)
)
$letterVector	=	array(
	"0_9" => 5,
	"A" => 18,
	"B" => 15,
	"C" => 24,
	"D" => 63,
	"E" => 31,
	"F" => 5,
	"G" => 2,
	"H" => 2,
	"I" => 6,
	"J" => 6,
	"K" => 2,
	"L" => 40,
	"M" => 24,
	"N" => 8,
	"O" => 4,
	"P" => 58,
	"Q" => 8,
	"R" => 7,
	"S" => 19,
	"T" => 21,
	"U" => 2,
	"V" => 10,
	"W" => 2,
	"Y" => 1,
	"Z" => 1
)
$letter_selected	=	""
$lastlink	=	58
$keywords	=	"Kyrie dels “Gueux”, Jo treballo, Au anem amics meus a Sibèria, Donant-nos les mans, Bell matí, Unim nostres veus, Ens agrada fer el rodamon"
$list	=	array(
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
),
	array(
	"Publicacion" => array(),
	"Archivesrelation" => array(),
	"Rating" => array(),
	"Comment" => array(),
	"Autor" => array(),
	"Category" => array(),
	"Colleccion" => array(),
	"Editor" => array(),
	"Enquadernacion" => array(),
	"Formacion" => array(),
	"Idioma" => array(),
	"Instrument" => array(),
	"Mida" => array(),
	"Retractilat" => array(),
	"Newsletter" => array(),
	"Rsspost" => array()
)
)
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/en/idioma/french/14"
HtmlHelper::$params = array
HtmlHelper::$action = "display"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/en/idioma/french/14"
FormHelper::$params = array
FormHelper::$action = "display"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/en/idioma/french/14"
JavascriptHelper::$params = array
JavascriptHelper::$action = "display"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$library	=	LibraryHelper
LibraryHelper::$helpers = array
LibraryHelper::$base = ""
LibraryHelper::$webroot = "/"
LibraryHelper::$themeWeb = NULL
LibraryHelper::$here = "/en/idioma/french/14"
LibraryHelper::$params = array
LibraryHelper::$action = "display"
LibraryHelper::$plugin = NULL
LibraryHelper::$data = NULL
LibraryHelper::$namedArgs = NULL
LibraryHelper::$argSeparator = NULL
LibraryHelper::$validationErrors = NULL
LibraryHelper::$tags = array
LibraryHelper::$__tainted = NULL
LibraryHelper::$__cleaned = NULL
LibraryHelper::$_log = NULL
LibraryHelper::$Html = HtmlHelper object
LibraryHelper::$Javascript = JavascriptHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "337eccbd43ced36b81f70fcab2883ac8"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1748369397
SessionHelper::$sessionTime = 1748391397
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/en/idioma/french/14"
SessionHelper::$params = array
SessionHelper::$action = "display"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$paginator	=	PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Publicacion"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/en/idioma/french/14"
PaginatorHelper::$params = array
PaginatorHelper::$action = "display"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object
$ajax	=	AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/en/idioma/french/14"
AjaxHelper::$params = array
AjaxHelper::$action = "display"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$i	=	0
$cat	=	array(
	"Category" => array(
	"id" => "78",
	"url" => "scores",
	"name" => "Scores",
	"parent_id" => null,
	"descripcio" => "<div>
	Our products are organized into the seven general categories below. Each of these areas are divided according either to educational level, difficulty or type of ensemble.</div>
",
	"order" => "7",
	"lft" => "1",
	"rght" => "8",
	"published" => "1",
	"locale" => "en_gb"
),
	"Categories" => array(
	array(),
	array(),
	array()
)
)
$subcat	=	array(
	"Category" => array(
	"id" => "89",
	"url" => "intermediate",
	"name" => "Intermediate",
	"parent_id" => "78",
	"descripcio" => "",
	"order" => "1",
	"lft" => "4",
	"rght" => "5",
	"published" => "1",
	"locale" => "en_gb"
)
)

                                    <?php echo $form->input('five_level',array('id'=>'instruments_level2','div'=>false,'label'=>false,'type'=>'select','options'=>$five_level_set,'selected'=>$instrument_level_set_selected)); ?>

                                <?php else: ?>

                                    <?php echo $form->input('five_level',array('id'=>'instruments_level2','div'=>false,'label'=>false,'type'=>'select','options'=>$five_level_set)); ?>

include - APP/views/elements/lateral.ctp, line 145
View::_render() - CORE/cake/libs/view/view.php, line 665
View::element() - CORE/cake/libs/view/view.php, line 342
include - APP/views/layouts/default.ctp, line 493
View::_render() - CORE/cake/libs/view/view.php, line 665
View::renderLayout() - CORE/cake/libs/view/view.php, line 453
View::render() - CORE/cake/libs/view/view.php, line 387
Controller::render() - CORE/cake/libs/controller/controller.php, line 805
IdiomasController::display() - APP/controllers/idiomas_controller.php, line 318
Object::dispatchMethod() - CORE/cake/libs/object.php, line 121
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192
[main] - APP/webroot/index.php, line 88

DIFFICULTY LEVEL:

Subscribe to our Newletter!

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

Associations of which we are part

DINSIC Publicacions Musicals, S.L.
Warehouse: Sepúlveda, 84 - 08015 Barcelona (Calàbria / Metro L1 Rocafort)
From Monday to Friday 9:30 - 13:30
Tels. +34 93 832 69 46
[email protected]
Copyright © 1998-2025

This portal is designed to work with the latest versions of the principal navigators: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. The use of non-compatible navigators or deactivation of some properties such as Javascript compatibility or blocking cookies may reduce the sites functionality. If you are accessing the site through a firewall or a porxy, make sure cookies are enabled.

(default) 206 queries took 274 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `idiomas`	4	4	13
2	DESCRIBE `archivesrelations`	6	6	3
3	DESCRIBE `publicacions`	43	43	2
4	DESCRIBE `ratings`	8	8	8
5	DESCRIBE `comments`	9	9	16
6	DESCRIBE `autors`	14	14	3
7	DESCRIBE `publicacions_autors`	4	4	3
8	DESCRIBE `autor_translations`	6	6	2
9	DESCRIBE `categories`	9	9	3
10	DESCRIBE `publicacions_categories`	3	3	3
11	DESCRIBE `categories_translations`	6	6	3
12	DESCRIBE `colleccions`	7	7	13
13	DESCRIBE `catcolleccions`	9	9	1
14	DESCRIBE `catcolleccion_translations`	6	6	3
15	DESCRIBE `publicacions_colleccions`	4	4	2
16	DESCRIBE `colleccion_translations`	6	6	1
17	DESCRIBE `editors`	2	2	1
18	DESCRIBE `publicacions_editors`	9	9	1
19	DESCRIBE `enquadernacions`	3	3	0
20	DESCRIBE `publicacions_enquadernacions`	3	3	2
21	DESCRIBE `enquadernacion_translations`	6	6	0
22	DESCRIBE `formacions`	7	7	1
23	DESCRIBE `catformacions`	9	9	0
24	DESCRIBE `catformacion_translations`	6	6	1
25	DESCRIBE `publicacions_formacions`	3	3	0
26	DESCRIBE `formacion_translations`	6	6	0
27	DESCRIBE `instruments`	6	6	1
28	DESCRIBE `catinstruments`	9	9	0
29	DESCRIBE `catinstrument_translations`	6	6	0
30	DESCRIBE `publicacions_instruments`	4	4	1
31	DESCRIBE `instrument_translations`	6	6	2
32	DESCRIBE `midas`	4	4	0
33	DESCRIBE `publicacions_midas`	3	3	1
34	DESCRIBE `mida_translations`	6	6	0
35	DESCRIBE `retractilats`	3	3	0
36	DESCRIBE `publicacions_retractilats`	3	3	1
37	DESCRIBE `retractilat_translations`	6	6	0
38	DESCRIBE `newsletters`	7	7	0
39	DESCRIBE `newsletters_publicacions`	3	3	0
40	DESCRIBE `newsletter_translations`	6	6	1
41	DESCRIBE `rssposts`	10	10	0
42	DESCRIBE `rss`	5	5	0
43	DESCRIBE `rssposts_publicacions`	3	3	1
44	DESCRIBE `publicacions_idiomas`	3	3	1
45	DESCRIBE `publicacion_translations`	6	6	1
46	DESCRIBE `idioma_translations`	6	6	1
47	DESCRIBE `funcions`	4	4	1
48	DESCRIBE `funcion_translations`	6	6	1
49	DESCRIBE `users`	35	35	1
50	DESCRIBE `roles`	5	5	1
51	DESCRIBE `archives`	6	6	1
52	DESCRIBE `archivestypes`	5	5	1
53	DESCRIBE `pages`	9	9	1
54	DESCRIBE `pages_translations`	6	6	2
55	DESCRIBE `orders`	18	18	1
56	DESCRIBE `invoices`	22	22	1
57	DESCRIBE `orderproducts`	10	10	3
58	DESCRIBE `latestsearches`	6	6	1
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` IS NULL AND `Category`.`published` = 1 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	7	7	2
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` = 78 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	3	3	1
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` = 76 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	3	3	1
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` = 75 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	5	5	1
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` = 77 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	0	0	1
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` = 79 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	2	2	1
65	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` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	0	0	1
66	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` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC	0	0	1
67	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` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1	1	1	0
68	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` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1	1	1	1
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` IS NULL AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catcolleccion`.`order` DESC	6	6	1
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` = 95 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	3	3	1
71	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	6	6	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` = 1719 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' 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` = 1719 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	4	4	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` = 96 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	0
75	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	7	7	3
76	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	6	6	0
77	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
78	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	13	13	0
79	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` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC	3	3	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` = 147 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC	0	0	1
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` = 147 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC	8	8	1
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` = 145 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC	0	0	1
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` = 145 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC	18	18	0
84	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` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC	0	0	1
85	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` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC	39	39	1
86	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catinstrument`.`order` DESC	6	6	1
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` = 71 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	5	5	1
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` = 71 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
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` = 70 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	5	5	1
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` = 70 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
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` = 73 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	4	4	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` = 73 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
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` = 72 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	5	5	1
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` = 72 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
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` = 74 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
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` = 74 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	64	64	1
97	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` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	0	0	1
98	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` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	32	32	0
99	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` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1	1	1	1
100	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` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `Page`.`order` DESC	5	5	0
101	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
102	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
103	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` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC	3	3	0
104	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` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC	19	19	0
105	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` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `order` DESC	42	42	3
106	SELECT `I18n__name`.`content`, `I18n__url`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') WHERE `Page`.`id` = 56 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	1
107	SELECT `Idioma`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `idiomas` AS `Idioma` LEFT JOIN `idioma_translations` AS `I18n__nom` ON (`Idioma`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Idioma' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `idioma_translations` AS `I18n__url` ON (`Idioma`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Idioma' AND `I18n__url`.`field` = 'url') LEFT JOIN `idioma_translations` AS `I18n__published` ON (`Idioma`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Idioma' AND `I18n__published`.`field` = 'published') WHERE `I18n__url`.`content` = 'french' AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1	1	1	1
108	SELECT `Idioma`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `idiomas` AS `Idioma` LEFT JOIN `idioma_translations` AS `I18n__nom` ON (`Idioma`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Idioma' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `idioma_translations` AS `I18n__url` ON (`Idioma`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Idioma' AND `I18n__url`.`field` = 'url') LEFT JOIN `idioma_translations` AS `I18n__published` ON (`Idioma`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Idioma' AND `I18n__published`.`field` = 'published') WHERE `Idioma`.`id` = 1879 AND `I18n__nom`.`locale` = 'ca_es' AND `I18n__url`.`locale` = 'ca_es' AND `I18n__published`.`locale` = 'ca_es' LIMIT 1	1	1	1
109	SELECT `Idioma`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `idiomas` AS `Idioma` LEFT JOIN `idioma_translations` AS `I18n__nom` ON (`Idioma`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Idioma' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `idioma_translations` AS `I18n__url` ON (`Idioma`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Idioma' AND `I18n__url`.`field` = 'url') LEFT JOIN `idioma_translations` AS `I18n__published` ON (`Idioma`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Idioma' AND `I18n__published`.`field` = 'published') WHERE `Idioma`.`id` = 1879 AND `I18n__nom`.`locale` = 'es_es' AND `I18n__url`.`locale` = 'es_es' AND `I18n__published`.`locale` = 'es_es' LIMIT 1	1	1	1
110	SELECT `Idioma`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `idiomas` AS `Idioma` LEFT JOIN `idioma_translations` AS `I18n__nom` ON (`Idioma`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Idioma' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `idioma_translations` AS `I18n__url` ON (`Idioma`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Idioma' AND `I18n__url`.`field` = 'url') LEFT JOIN `idioma_translations` AS `I18n__published` ON (`Idioma`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Idioma' AND `I18n__published`.`field` = 'published') WHERE `Idioma`.`id` = 1879 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '0%'	1	1	3
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '1%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '2%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '3%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '3%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '4%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '4%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '5%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '5%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '6%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '6%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '7%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '7%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '8%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '8%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '9%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE '9%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'A%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'A%'	1	1	18
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'B%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'B%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'C%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'C%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'D%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'D%'	1	1	4
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'E%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'E%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'F%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'F%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'G%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'G%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'H%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'H%'	1	1	8
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'I%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'J%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'K%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'L%'	1	1	10
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'M%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'M%'	1	1	2
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'N%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'N%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'O%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'O%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'P%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'P%'	1	1	3
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Q%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'Q%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'R%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'S%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'T%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'T%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'U%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'U%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'V%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'V%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'W%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'X%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Y%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'Y%'	1	1	1
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` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Z%') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `Publicacion`.`titol` LIKE 'Z%'	1	1	1
147	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` = 'en_gb') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879	1	1	9
148	SELECT DISTINCT `Publicacion`.`id`, `Publicacion`.`format`, `Publicacion`.`preu`, `Publicacion`.`created`, `Publicacion`.`en_preparacio`, `Publicacion`.`novetat`, `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_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879 AND `I18n__titol`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__intro`.`locale` = 'en_gb' ORDER BY `Publicacion`.`created` DESC LIMIT 91, 7	7	7	26
149	SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Publicacion' AND `Archivesrelation`.`foreign_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) ORDER BY `Archivesrelation`.`order` ASC	21	21	2
150	SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`name`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`model` = 'Publicacion' AND `Rating`.`model_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833)	0	0	0
151	SELECT `Comment`.`id`, `Comment`.`publicacion_id`, `Comment`.`replay_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`replay_id`=0 AND `Comment`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) ORDER BY `Comment`.`id` ASC	0	0	0
152	SELECT `Autor`.`id`, `Autor`.`nom`, `Autor`.`cognom`, `Autor`.`2cognom`, `Autor`.`curriculum`, `Autor`.`data_desconeguda`, `Autor`.`data_naixement`, `Autor`.`nomes_any_naixement`, `Autor`.`nomes_any_defuncio`, `Autor`.`defuncio`, `Autor`.`data_defuncio`, `Autor`.`data_defuncio_desconeguda`, `Autor`.`url`, `Autor`.`published`, `PublicacionsAutor`.`id`, `PublicacionsAutor`.`autor_id`, `PublicacionsAutor`.`publicacion_id`, `PublicacionsAutor`.`funcion_id` FROM `autors` AS `Autor` JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC	10	10	0
153	SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`parent_id`, `Category`.`descripcio`, `Category`.`order`, `Category`.`lft`, `Category`.`rght`, `Category`.`published`, `PublicacionsCategory`.`id`, `PublicacionsCategory`.`publicacion_id`, `PublicacionsCategory`.`category_id` FROM `categories` AS `Category` JOIN `publicacions_categories` AS `PublicacionsCategory` ON (`PublicacionsCategory`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsCategory`.`category_id` = `Category`.`id`)	7	7	0
154	SELECT `Colleccion`.`id`, `Colleccion`.`nom`, `Colleccion`.`catcolleccion_id`, `Colleccion`.`descripcio`, `Colleccion`.`order`, `Colleccion`.`url`, `Colleccion`.`published`, `PublicacionsColleccion`.`id`, `PublicacionsColleccion`.`colleccion_id`, `PublicacionsColleccion`.`publicacion_id`, `PublicacionsColleccion`.`num_volum` FROM `colleccions` AS `Colleccion` JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC	7	7	0
155	SELECT `Editor`.`id`, `Editor`.`nom`, `PublicacionsEditor`.`id`, `PublicacionsEditor`.`publicacion_id`, `PublicacionsEditor`.`editor_id`, `PublicacionsEditor`.`data_edicio`, `PublicacionsEditor`.`num_edicio`, `PublicacionsEditor`.`data_reimpresio`, `PublicacionsEditor`.`data_reimpresio_nul`, `PublicacionsEditor`.`num_reimpresio`, `PublicacionsEditor`.`deposito_legal` FROM `editors` AS `Editor` JOIN `publicacions_editors` AS `PublicacionsEditor` ON (`PublicacionsEditor`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`)	0	0	0
156	SELECT `Enquadernacion`.`id`, `Enquadernacion`.`nom`, `Enquadernacion`.`published`, `PublicacionsEnquadernacion`.`id`, `PublicacionsEnquadernacion`.`publicacion_id`, `PublicacionsEnquadernacion`.`enquadernacion_id` FROM `enquadernacions` AS `Enquadernacion` JOIN `publicacions_enquadernacions` AS `PublicacionsEnquadernacion` ON (`PublicacionsEnquadernacion`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`)	0	0	0
157	SELECT `Formacion`.`id`, `Formacion`.`nom`, `Formacion`.`catformacion_id`, `Formacion`.`order`, `Formacion`.`url`, `Formacion`.`published`, `Formacion`.`metadescription`, `PublicacionsFormacion`.`id`, `PublicacionsFormacion`.`publicacion_id`, `PublicacionsFormacion`.`formacion_id` FROM `formacions` AS `Formacion` JOIN `publicacions_formacions` AS `PublicacionsFormacion` ON (`PublicacionsFormacion`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`)	0	0	0
158	SELECT `Idioma`.`id`, `Idioma`.`nom`, `Idioma`.`published`, `Idioma`.`url`, `PublicacionsIdioma`.`id`, `PublicacionsIdioma`.`publicacion_id`, `PublicacionsIdioma`.`idioma_id` FROM `idiomas` AS `Idioma` JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`)	35	35	0
159	SELECT `Instrument`.`id`, `Instrument`.`nom`, `Instrument`.`catinstrument_id`, `Instrument`.`published`, `Instrument`.`url`, `Instrument`.`metadescription`, `PublicacionsInstrument`.`id`, `PublicacionsInstrument`.`publicacion_id`, `PublicacionsInstrument`.`instrument_id`, `PublicacionsInstrument`.`priority` FROM `instruments` AS `Instrument` JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC	14	14	0
160	SELECT `Mida`.`id`, `Mida`.`nom`, `Mida`.`orientacio`, `Mida`.`published`, `PublicacionsMida`.`id`, `PublicacionsMida`.`publicacion_id`, `PublicacionsMida`.`mida_id` FROM `midas` AS `Mida` JOIN `publicacions_midas` AS `PublicacionsMida` ON (`PublicacionsMida`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsMida`.`mida_id` = `Mida`.`id`)	7	7	0
161	SELECT `Retractilat`.`id`, `Retractilat`.`nom`, `Retractilat`.`published`, `PublicacionsRetractilat`.`id`, `PublicacionsRetractilat`.`publicacion_id`, `PublicacionsRetractilat`.`retractilat_id` FROM `retractilats` AS `Retractilat` JOIN `publicacions_retractilats` AS `PublicacionsRetractilat` ON (`PublicacionsRetractilat`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`)	0	0	0
162	SELECT `Newsletter`.`id`, `Newsletter`.`slug`, `Newsletter`.`titol`, `Newsletter`.`assumpte`, `Newsletter`.`intro`, `Newsletter`.`data`, `Newsletter`.`published`, `NewslettersPublicacion`.`id`, `NewslettersPublicacion`.`publicacion_id`, `NewslettersPublicacion`.`newsletter_id` FROM `newsletters` AS `Newsletter` JOIN `newsletters_publicacions` AS `NewslettersPublicacion` ON (`NewslettersPublicacion`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`)	0	0	0
163	SELECT `Rsspost`.`id`, `Rsspost`.`rss_id`, `Rsspost`.`titol`, `Rsspost`.`html`, `Rsspost`.`data_creacio`, `Rsspost`.`data_ordenacio`, `Rsspost`.`data_publica`, `Rsspost`.`slug`, `Rsspost`.`extlink`, `Rsspost`.`published`, `RsspostsPublicacion`.`id`, `RsspostsPublicacion`.`rsspost_id`, `RsspostsPublicacion`.`publicacion_id` FROM `rssposts` AS `Rsspost` JOIN `rssposts_publicacions` AS `RsspostsPublicacion` ON (`RsspostsPublicacion`.`publicacion_id` IN (12827, 12828, 12829, 12830, 12831, 12832, 12833) AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`)	0	0	0
164	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` = 'en_gb') INNER JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id`=`Publicacion`.`id`) WHERE `PublicacionsIdioma`.`idioma_id` = 1879	1	1	0
165	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
166	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
167	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
168	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
169	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
170	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
171	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
172	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
173	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
174	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
175	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
176	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
177	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
178	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
179	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
180	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
181	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
182	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
183	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 802 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
184	SELECT `Instrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') WHERE `Instrument`.`id` = 906 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
185	SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 5625 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
186	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
187	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
188	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
189	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
190	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
191	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
192	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
193	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
194	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
195	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
196	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
197	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
198	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 88 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
199	SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 78 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1	1	1	0
200	SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 9513 LIMIT 1	1	1	0

Cookies

French

Kyrie dels “Gueux”

Jo treballo

Au anem amics meus a Sibèria

Donant-nos les mans

Bell matí

Unim nostres veus

Ens agrada fer el rodamon

Scores

Teachers

Conductors

Authors and composers

Botigues

Subscribe to our Newletter!

About Us

Customer info:

For users

Official information

Latests searches

Associations of which we are part