Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5153]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5184]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5253]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5256]
Notice (8): Undefined variable: tmptext [APP/controllers/publicacions_controller.php, line 5345]
 <pre class="cake-debug"> <a href='javascript:void(0);' onclick='document.getElementById("CakeStackTrace6").style.display = (document.getElementById("CakeStackTrace6").style.display == "none" ? "" : "none")'><b>Notice</b> (8)</a>: Undefined index: text [<b>APP/views/layouts/default.ctp</b>, line <b>18</b>] </pre> <div id="CakeStackTrace6" class="cake-stack-trace" style="display: none;"><a href='javascript:void(0);' onclick='document.getElementById("CakeErrorCode6").style.display = (document.getElementById("CakeErrorCode6").style.display == "none" ? "" : "none")'>Code</a> | <a href='javascript:void(0);' onclick='document.getElementById("CakeErrorContext6").style.display = (document.getElementById("CakeErrorContext6").style.display == "none" ? "" : "none")'>Context</a><pre id="CakeErrorContext6" class="cake-context" style="display: none;">$___viewFn = "/var/www/test-dinsic/trunk/app/views/layouts/default.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:abesten 3" class="word size3">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size3">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size7">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size2">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size3">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size7">somnis</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:abesten 4" class="word size2">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size9">partitura</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:Palau insòlit" class="word size4">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size5">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size9">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size8">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size1">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size9">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size2">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size9">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size4">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size2">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size9">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size9">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size9">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size1">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size6">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size4">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size5">Da Camera 22</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:els músics més petits" class="word size3">els músics més petits</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() ), "total_basket" => 0, "total_basket_count" => 0, "admin" => false, "selected_controller" => "publicacions", "browser" => array( "browsertype" => null, "version" => "", "platform" => null, "AOL" => false ), "selectedtab" => false, "cookies" => array( "Page" => array() ), "aviso_cookie" => true, "letter_action_url" => "/en/format/pdf_con_audio_mp3", "text_section" => "", "breadcrumb" => array( array() ), "letterVector" => array( "0_9" => 31, "A" => 99, "B" => 63, "C" => 227, "D" => 164, "E" => 367, "F" => 55, "G" => 10, "H" => 60, "I" => 39, "J" => 31, "K" => 7, "L" => 206, "M" => 164, "N" => 32, "O" => 26, "P" => 137, "Q" => 53, "R" => 46, "S" => 168, "T" => 140, "U" => 15, "V" => 35, "W" => 3, "X" => 3, "Y" => 3, "Z" => 2 ), "letter_selected" => "", "lastlink" => 323, "keywords" => "Audició 1. Forma i color a la música, Audició, Anna, Bassó, Àngels, Comella, Carles, Riera, Francesca, Galofré, Gabriel, Serra, Romà, Escalas, Abesten 4, Abesten, Ana, Etxebarría, Anna, Alegre, Anna, Bassó, Antoni, Bassó, César, Puente, Francesca, Galofré, Jordi, Valls, Lluïsa, Alegre, Sabin, Salaberri, Tomás, Aragüés, Xavier, Torns, Zuriñe, Fernández, Abesten 3, Abesten, Ana, Etxebarría, Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Francesca, Galofré, Itziar, Bilbao, Joan Josep, Gutiérrez, Jordi, Valls, Jordi, Valls, Jordi-Lluís, Rigol, Josep-Ignasi, Gómez, Josep-Ignasi, Gómez, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Sabin, Salaberri, Tomás, Aragüés, Xavier, Torns, Zuriñe, Fernández, Abesten 2, Abesten, Ana, Etxebarría, Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Itziar, Bilbao, Javier, Duque, Joan Josep, Gutiérrez, Jordi, Valls, Josep-Ignasi, Gómez, Juan-Luís, Milán, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Sabin, Salaberri, Tomás, Aragüés, Xavier, Torns, Llibre", "list" => array( array(), array(), array(), array() ), "vectorUrls" => array( "ca_es" => "/format/", "es_es" => "/format/", "en_gb" => "/format/" ), "title_for_layout" => "Publicacions", "content_for_layout" => " <style type="text/css"> .filtre img { margin-left: 10px; } .filtre{ overflow:visible; } </style> <div class="filtre"> <div> </div> <div style="clear:both;"></div> </div> <div class="llista"> <div class="element"> 2006-07-07 19:16:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/book_with_cd-au1-audicio_1_forma_i_color_a_la_musica"><img src="http://www.dinsic.com/img/cache/395e687e2aa2cf478672f20d88168d83-2104-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/book_with_cd-au1-audicio_1_forma_i_color_a_la_musica">Audició 1. Forma i color a la música</a></h2> <strong>Format:</strong> <p> Book with CD </p> <strong>Author:</strong><p><a href="/en/autor/carles_riera_pujals">Carles Riera Pujals</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/roma_escalas_llimona">Romà Escalas Llimona</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/audicio">Audició</a> Nr. 1</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1920"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1920"> --> <div class="afegir pdfonline_1920"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1920" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>15.00 € VAT included</p> </div> </div> <div class="element"> 2006-07-07 18:26:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab4-abesten_4"><img src="http://www.dinsic.com/img/cache/6900dd79ec194030de0dd1d95e1d7748-2103-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab4-abesten_4">Abesten 4</a></h2> <strong>Format:</strong> <p> Book </p> <strong>Author:</strong><p><a href="/en/autor/anna_alegre_valls">Anna Alegre Valls</a>, <a href="/en/autor/cesar_puente_morales">César Puente Morales</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/jordi_valls_fuster">Jordi Valls Fuster</a>, <a href="/en/autor/llu_sa_alegre_heitzmann">Lluïsa Alegre Heitzmann</a>, <a href="/en/autor/xavier_torns_cuende">Xavier Torns Cuende</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/abesten">Abesten</a> Nr. 4</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1919"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1919"> --> <div class="afegir pdfonline_1919"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1919" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>20.50 € VAT included</p> </div> </div> <div class="element"> 2006-06-30 18:43:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab3-abesten_3"><img src="http://www.dinsic.com/img/cache/125395659db6639032b827c27aeff823-2102-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab3-abesten_3">Abesten 3</a></h2> <strong>Format:</strong> <p> Book </p> <strong>Author:</strong><p><a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/jordi_valls_fuster">Jordi Valls Fuster</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/abesten">Abesten</a> Nr. 3</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1916"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1916"> --> <div class="afegir pdfonline_1916"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1916" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>18.50 € VAT included</p> </div> </div> <div class="element"> 2006-06-22 18:57:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab2-abesten_2"><img src="http://www.dinsic.com/img/cache/80db24a0c04d153fbe8b47beec3581d2-2101-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab2-abesten_2">Abesten 2</a></h2> <strong>Format:</strong> <p> Book </p> <strong>Author:</strong><p><a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/josep_ignasi_gomez_margarit">Josep-Ignasi Gómez Margarit</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/abesten">Abesten</a> Nr. 2</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1896"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1896"> --> <div class="afegir pdfonline_1896"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1896" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>17.68 € VAT included</p> </div> </div> </div> <div class="index"> <form name="form_letter" action="/en/format/pdf_con_audio_mp3" method="post"> <input type="hidden" value="" name="letter" id="letter"/> <ul> <li class="all"><a class="a_letter_all" style="color:#7A0000;" href="#">ALL</a></li> <li class=""> <a class="a_letter cap-0_9" href="#"> 0-9 </a> </li> <li class=""> <a class="a_letter cap-A" href="#"> A </a> </li> <li class=""> <a class="a_letter cap-B" href="#"> B </a> </li> <li class=""> <a class="a_letter cap-C" href="#"> C </a> </li> <li class=""> <a class="a_letter cap-D" href="#"> D </a> </li> <li class=""> <a class="a_letter cap-E" href="#"> E </a> </li> <li class=""> <a class="a_letter cap-F" href="#"> F </a> </li> <li class=""> <a class="a_letter cap-G" href="#"> G </a> </li> <li class=""> <a class="a_letter cap-H" href="#"> H </a> </li> <li class=""> <a class="a_letter cap-I" href="#"> I </a> </li> <li class=""> <a class="a_letter cap-J" href="#"> J </a> </li> <li class=""> <a class="a_letter cap-K" href="#"> K </a> </li> <li class=""> <a class="a_letter cap-L" href="#"> L </a> </li> <li class=""> <a class="a_letter cap-M" href="#"> M </a> </li> <li class=""> <a class="a_letter cap-N" href="#"> N </a> </li> <li class=""> <a class="a_letter cap-O" href="#"> O </a> </li> <li class=""> <a class="a_letter cap-P" href="#"> P </a> </li> <li class=""> <a class="a_letter cap-Q" href="#"> Q </a> </li> <li class=""> <a class="a_letter cap-R" href="#"> R </a> </li> <li class=""> <a class="a_letter cap-S" href="#"> S </a> </li> <li class=""> <a class="a_letter cap-T" href="#"> T </a> </li> <li class=""> <a class="a_letter cap-U" href="#"> U </a> </li> <li class=""> <a class="a_letter cap-V" href="#"> V </a> </li> <li class=""> <a class="a_letter cap-W" href="#"> W </a> </li> <li class=""> <a class="a_letter cap-X" href="#"> X </a> </li> <li class=""> <a class="a_letter cap-Y" href="#"> Y </a> </li> <li class=""> <a class="a_letter cap-Z" href="#"> Z </a> </li> </ul> </form> </div> <script type="text/javascript"> $(document).ready(function(){ $(".a_letter_all").bind('click',function(e){ e.preventDefault(); $('#letter').val('-1'); document.forms['form_letter'].submit(); }); $(".a_letter").bind('click',function(e){ e.preventDefault(); var val = $(this).attr('class'); val = val.split(" "); val = val[1]; var letter = val.split("-"); letter = letter[1]; $('#letter').val(letter); document.forms['form_letter'].submit(); }); }); </script> <div id="pagination" class="paginador"> <div class="paging"><a href="/en/format/pdf_con_audio_mp3"><< First</a> <a class="prev" href="/en/format/pdf_con_audio_mp3/322">&lt;&lt; Prev</a> <span><a href="/en/format/pdf_con_audio_mp3/315">315</a></span> <span><a href="/en/format/pdf_con_audio_mp3/316">316</a></span> <span><a href="/en/format/pdf_con_audio_mp3/317">317</a></span> <span><a href="/en/format/pdf_con_audio_mp3/318">318</a></span> <span><a href="/en/format/pdf_con_audio_mp3/319">319</a></span> <span><a href="/en/format/pdf_con_audio_mp3/320">320</a></span> <span><a href="/en/format/pdf_con_audio_mp3/321">321</a></span> <span><a href="/en/format/pdf_con_audio_mp3/322">322</a></span> <span class="current">323</span> </div> </div> ", "scripts_for_layout" => "", "cakeDebug" => "", "html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/en/format/pdf_con_audio_mp3/323" HtmlHelper::$params = array HtmlHelper::$action = "display_home_types" 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/format/pdf_con_audio_mp3/323" FormHelper::$params = array FormHelper::$action = "display_home_types" 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, "text" => "Josep-Ignasi Gómez Margarit", "search" => SearchHelper SearchHelper::$helpers = array SearchHelper::$base = "" SearchHelper::$webroot = "/" SearchHelper::$themeWeb = NULL SearchHelper::$here = "/en/format/pdf_con_audio_mp3/323" SearchHelper::$params = array SearchHelper::$action = "display_home_types" SearchHelper::$plugin = NULL SearchHelper::$data = NULL SearchHelper::$namedArgs = NULL SearchHelper::$argSeparator = NULL SearchHelper::$validationErrors = NULL SearchHelper::$tags = array SearchHelper::$__tainted = NULL SearchHelper::$__cleaned = NULL SearchHelper::$_log = NULL SearchHelper::$Html = HtmlHelper object SearchHelper::$Javascript = JavascriptHelper 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/format/pdf_con_audio_mp3/323" JavascriptHelper::$params = array JavascriptHelper::$action = "display_home_types" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL, "adminmenu" => AdminmenuHelper AdminmenuHelper::$helpers = array AdminmenuHelper::$base = "" AdminmenuHelper::$webroot = "/" AdminmenuHelper::$themeWeb = NULL AdminmenuHelper::$here = "/en/format/pdf_con_audio_mp3/323" AdminmenuHelper::$params = array AdminmenuHelper::$action = "display_home_types" AdminmenuHelper::$plugin = NULL AdminmenuHelper::$data = NULL AdminmenuHelper::$namedArgs = NULL AdminmenuHelper::$argSeparator = NULL AdminmenuHelper::$validationErrors = NULL AdminmenuHelper::$tags = array AdminmenuHelper::$__tainted = NULL AdminmenuHelper::$__cleaned = NULL AdminmenuHelper::$_log = NULL AdminmenuHelper::$Html = HtmlHelper object AdminmenuHelper::$Javascript = JavascriptHelper object, "rss" => RssHelper RssHelper::$helpers = array RssHelper::$base = "" RssHelper::$here = "/en/format/pdf_con_audio_mp3/323" RssHelper::$params = array RssHelper::$action = "display_home_types" RssHelper::$data = NULL RssHelper::$model = NULL RssHelper::$field = NULL RssHelper::$version = "2.0" RssHelper::$encoding = "UTF-8" RssHelper::$webroot = "/" RssHelper::$themeWeb = NULL RssHelper::$plugin = NULL RssHelper::$namedArgs = NULL RssHelper::$argSeparator = NULL RssHelper::$validationErrors = NULL RssHelper::$tags = array RssHelper::$__tainted = NULL RssHelper::$__cleaned = NULL RssHelper::$_log = NULL RssHelper::$Xml = Xml object RssHelper::$Time = TimeHelper object, "time" => TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/en/format/pdf_con_audio_mp3/323" TimeHelper::$params = array TimeHelper::$action = "display_home_types" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL, "library" => LibraryHelper LibraryHelper::$helpers = array LibraryHelper::$base = "" LibraryHelper::$webroot = "/" LibraryHelper::$themeWeb = NULL LibraryHelper::$here = "/en/format/pdf_con_audio_mp3/323" LibraryHelper::$params = array LibraryHelper::$action = "display_home_types" 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 = 1714166483 SessionHelper::$sessionTime = 1714188483 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/en/format/pdf_con_audio_mp3/323" SessionHelper::$params = array SessionHelper::$action = "display_home_types" 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/format/pdf_con_audio_mp3/323" PaginatorHelper::$params = array PaginatorHelper::$action = "display_home_types" 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/format/pdf_con_audio_mp3/323" AjaxHelper::$params = array AjaxHelper::$action = "display_home_types" 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 = true $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:abesten 3" class="word size3">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size3">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size7">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size2">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size3">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size7">somnis</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:abesten 4" class="word size2">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size9">partitura</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:Palau insòlit" class="word size4">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size5">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size9">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size8">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size1">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size9">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:cantata nadalenca nit de vetlla" class="word size2">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size9">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size4">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size2">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size9">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size9">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size9">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size1">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size6">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size4">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size5">Da Camera 22</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:els músics més petits" class="word size3">els músics més petits</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() ) ) $total_basket = 0 $total_basket_count = 0 $admin = false $selected_controller = "publicacions" $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/format/pdf_con_audio_mp3" $text_section = "" $breadcrumb = array( array( "url" => "/en/format/pdf_con_audio_mp3" ) ) $letterVector = array( "0_9" => 31, "A" => 99, "B" => 63, "C" => 227, "D" => 164, "E" => 367, "F" => 55, "G" => 10, "H" => 60, "I" => 39, "J" => 31, "K" => 7, "L" => 206, "M" => 164, "N" => 32, "O" => 26, "P" => 137, "Q" => 53, "R" => 46, "S" => 168, "T" => 140, "U" => 15, "V" => 35, "W" => 3, "X" => 3, "Y" => 3, "Z" => 2 ) $letter_selected = "" $lastlink = 323 $keywords = "Audició 1. Forma i color a la música, Audició, Anna, Bassó, Àngels, Comella, Carles, Riera, Francesca, Galofré, Gabriel, Serra, Romà, Escalas, Abesten 4, Abesten, Ana, Etxebarría, Anna, Alegre, Anna, Bassó, Antoni, Bassó, César, Puente, Francesca, Galofré, Jordi, Valls, Lluïsa, Alegre, Sabin, Salaberri, Tomás, Aragüés, Xavier, Torns, Zuriñe, Fernández, Abesten 3, Abesten, Ana, Etxebarría, Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Francesca, Galofré, Itziar, Bilbao, Joan Josep, Gutiérrez, Jordi, Valls, Jordi, Valls, Jordi-Lluís, Rigol, Josep-Ignasi, Gómez, Josep-Ignasi, Gómez, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Sabin, Salaberri, Tomás, Aragüés, Xavier, Torns, Zuriñe, Fernández, Abesten 2, Abesten, Ana, Etxebarría, Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Itziar, Bilbao, Javier, Duque, Joan Josep, Gutiérrez, Jordi, Valls, Josep-Ignasi, Gómez, Juan-Luís, Milán, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Sabin, Salaberri, Tomás, Aragüés, Xavier, Torns, Llibre" $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() ) ) $vectorUrls = array( "ca_es" => "/format/", "es_es" => "/format/", "en_gb" => "/format/" ) $title_for_layout = "Publicacions" $content_for_layout = " <style type="text/css"> .filtre img { margin-left: 10px; } .filtre{ overflow:visible; } </style> <div class="filtre"> <div> </div> <div style="clear:both;"></div> </div> <div class="llista"> <div class="element"> 2006-07-07 19:16:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/book_with_cd-au1-audicio_1_forma_i_color_a_la_musica"><img src="http://www.dinsic.com/img/cache/395e687e2aa2cf478672f20d88168d83-2104-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/book_with_cd-au1-audicio_1_forma_i_color_a_la_musica">Audició 1. Forma i color a la música</a></h2> <strong>Format:</strong> <p> Book with CD </p> <strong>Author:</strong><p><a href="/en/autor/carles_riera_pujals">Carles Riera Pujals</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/roma_escalas_llimona">Romà Escalas Llimona</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/audicio">Audició</a> Nr. 1</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1920"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1920"> --> <div class="afegir pdfonline_1920"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1920" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>15.00 € VAT included</p> </div> </div> <div class="element"> 2006-07-07 18:26:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab4-abesten_4"><img src="http://www.dinsic.com/img/cache/6900dd79ec194030de0dd1d95e1d7748-2103-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab4-abesten_4">Abesten 4</a></h2> <strong>Format:</strong> <p> Book </p> <strong>Author:</strong><p><a href="/en/autor/anna_alegre_valls">Anna Alegre Valls</a>, <a href="/en/autor/cesar_puente_morales">César Puente Morales</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/jordi_valls_fuster">Jordi Valls Fuster</a>, <a href="/en/autor/llu_sa_alegre_heitzmann">Lluïsa Alegre Heitzmann</a>, <a href="/en/autor/xavier_torns_cuende">Xavier Torns Cuende</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/abesten">Abesten</a> Nr. 4</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1919"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1919"> --> <div class="afegir pdfonline_1919"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1919" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>20.50 € VAT included</p> </div> </div> <div class="element"> 2006-06-30 18:43:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab3-abesten_3"><img src="http://www.dinsic.com/img/cache/125395659db6639032b827c27aeff823-2102-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab3-abesten_3">Abesten 3</a></h2> <strong>Format:</strong> <p> Book </p> <strong>Author:</strong><p><a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/jordi_valls_fuster">Jordi Valls Fuster</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/abesten">Abesten</a> Nr. 3</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1916"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1916"> --> <div class="afegir pdfonline_1916"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1916" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>18.50 € VAT included</p> </div> </div> <div class="element"> 2006-06-22 18:57:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab2-abesten_2"><img src="http://www.dinsic.com/img/cache/80db24a0c04d153fbe8b47beec3581d2-2101-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-ab2-abesten_2">Abesten 2</a></h2> <strong>Format:</strong> <p> Book </p> <strong>Author:</strong><p><a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a>, <a href="/en/autor/josep_ignasi_gomez_margarit">Josep-Ignasi Gómez Margarit</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/abesten">Abesten</a> Nr. 2</p> </div> <div class="compra"> <!-- <div class="en_produccion soon_1896"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1896"> --> <div class="afegir pdfonline_1896"> <form id="AddtoshoppingcartAddForm" method="post" action="/en/shoppingcart/add"><fieldset style="display:none;"><input type="hidden" name="_method" value="POST" /></fieldset> <input type="hidden" name="product" value="1896" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>17.68 € VAT included</p> </div> </div> </div> <div class="index"> <form name="form_letter" action="/en/format/pdf_con_audio_mp3" method="post"> <input type="hidden" value="" name="letter" id="letter"/> <ul> <li class="all"><a class="a_letter_all" style="color:#7A0000;" href="#">ALL</a></li> <li class=""> <a class="a_letter cap-0_9" href="#"> 0-9 </a> </li> <li class=""> <a class="a_letter cap-A" href="#"> A </a> </li> <li class=""> <a class="a_letter cap-B" href="#"> B </a> </li> <li class=""> <a class="a_letter cap-C" href="#"> C </a> </li> <li class=""> <a class="a_letter cap-D" href="#"> D </a> </li> <li class=""> <a class="a_letter cap-E" href="#"> E </a> </li> <li class=""> <a class="a_letter cap-F" href="#"> F </a> </li> <li class=""> <a class="a_letter cap-G" href="#"> G </a> </li> <li class=""> <a class="a_letter cap-H" href="#"> H </a> </li> <li class=""> <a class="a_letter cap-I" href="#"> I </a> </li> <li class=""> <a class="a_letter cap-J" href="#"> J </a> </li> <li class=""> <a class="a_letter cap-K" href="#"> K </a> </li> <li class=""> <a class="a_letter cap-L" href="#"> L </a> </li> <li class=""> <a class="a_letter cap-M" href="#"> M </a> </li> <li class=""> <a class="a_letter cap-N" href="#"> N </a> </li> <li class=""> <a class="a_letter cap-O" href="#"> O </a> </li> <li class=""> <a class="a_letter cap-P" href="#"> P </a> </li> <li class=""> <a class="a_letter cap-Q" href="#"> Q </a> </li> <li class=""> <a class="a_letter cap-R" href="#"> R </a> </li> <li class=""> <a class="a_letter cap-S" href="#"> S </a> </li> <li class=""> <a class="a_letter cap-T" href="#"> T </a> </li> <li class=""> <a class="a_letter cap-U" href="#"> U </a> </li> <li class=""> <a class="a_letter cap-V" href="#"> V </a> </li> <li class=""> <a class="a_letter cap-W" href="#"> W </a> </li> <li class=""> <a class="a_letter cap-X" href="#"> X </a> </li> <li class=""> <a class="a_letter cap-Y" href="#"> Y </a> </li> <li class=""> <a class="a_letter cap-Z" href="#"> Z </a> </li> </ul> </form> </div> <script type="text/javascript"> $(document).ready(function(){ $(".a_letter_all").bind('click',function(e){ e.preventDefault(); $('#letter').val('-1'); document.forms['form_letter'].submit(); }); $(".a_letter").bind('click',function(e){ e.preventDefault(); var val = $(this).attr('class'); val = val.split(" "); val = val[1]; var letter = val.split("-"); letter = letter[1]; $('#letter').val(letter); document.forms['form_letter'].submit(); }); }); </script> <div id="pagination" class="paginador"> <div class="paging"><a href="/en/format/pdf_con_audio_mp3"><< First</a> <a class="prev" href="/en/format/pdf_con_audio_mp3/322">&lt;&lt; Prev</a> <span><a href="/en/format/pdf_con_audio_mp3/315">315</a></span> <span><a href="/en/format/pdf_con_audio_mp3/316">316</a></span> <span><a href="/en/format/pdf_con_audio_mp3/317">317</a></span> <span><a href="/en/format/pdf_con_audio_mp3/318">318</a></span> <span><a href="/en/format/pdf_con_audio_mp3/319">319</a></span> <span><a href="/en/format/pdf_con_audio_mp3/320">320</a></span> <span><a href="/en/format/pdf_con_audio_mp3/321">321</a></span> <span><a href="/en/format/pdf_con_audio_mp3/322">322</a></span> <span class="current">323</span> </div> </div> " $scripts_for_layout = "" $cakeDebug = "" $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/en/format/pdf_con_audio_mp3/323" HtmlHelper::$params = array HtmlHelper::$action = "display_home_types" 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/format/pdf_con_audio_mp3/323" FormHelper::$params = array FormHelper::$action = "display_home_types" 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 $text = "Josep-Ignasi Gómez Margarit" $search = SearchHelper SearchHelper::$helpers = array SearchHelper::$base = "" SearchHelper::$webroot = "/" SearchHelper::$themeWeb = NULL SearchHelper::$here = "/en/format/pdf_con_audio_mp3/323" SearchHelper::$params = array SearchHelper::$action = "display_home_types" SearchHelper::$plugin = NULL SearchHelper::$data = NULL SearchHelper::$namedArgs = NULL SearchHelper::$argSeparator = NULL SearchHelper::$validationErrors = NULL SearchHelper::$tags = array SearchHelper::$__tainted = NULL SearchHelper::$__cleaned = NULL SearchHelper::$_log = NULL SearchHelper::$Html = HtmlHelper object SearchHelper::$Javascript = JavascriptHelper 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/format/pdf_con_audio_mp3/323" JavascriptHelper::$params = array JavascriptHelper::$action = "display_home_types" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL $adminmenu = AdminmenuHelper AdminmenuHelper::$helpers = array AdminmenuHelper::$base = "" AdminmenuHelper::$webroot = "/" AdminmenuHelper::$themeWeb = NULL AdminmenuHelper::$here = "/en/format/pdf_con_audio_mp3/323" AdminmenuHelper::$params = array AdminmenuHelper::$action = "display_home_types" AdminmenuHelper::$plugin = NULL AdminmenuHelper::$data = NULL AdminmenuHelper::$namedArgs = NULL AdminmenuHelper::$argSeparator = NULL AdminmenuHelper::$validationErrors = NULL AdminmenuHelper::$tags = array AdminmenuHelper::$__tainted = NULL AdminmenuHelper::$__cleaned = NULL AdminmenuHelper::$_log = NULL AdminmenuHelper::$Html = HtmlHelper object AdminmenuHelper::$Javascript = JavascriptHelper object $rss = RssHelper RssHelper::$helpers = array RssHelper::$base = "" RssHelper::$here = "/en/format/pdf_con_audio_mp3/323" RssHelper::$params = array RssHelper::$action = "display_home_types" RssHelper::$data = NULL RssHelper::$model = NULL RssHelper::$field = NULL RssHelper::$version = "2.0" RssHelper::$encoding = "UTF-8" RssHelper::$webroot = "/" RssHelper::$themeWeb = NULL RssHelper::$plugin = NULL RssHelper::$namedArgs = NULL RssHelper::$argSeparator = NULL RssHelper::$validationErrors = NULL RssHelper::$tags = array RssHelper::$__tainted = NULL RssHelper::$__cleaned = NULL RssHelper::$_log = NULL RssHelper::$Xml = Xml object RssHelper::$Time = TimeHelper object $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/en/format/pdf_con_audio_mp3/323" TimeHelper::$params = array TimeHelper::$action = "display_home_types" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL $library = LibraryHelper LibraryHelper::$helpers = array LibraryHelper::$base = "" LibraryHelper::$webroot = "/" LibraryHelper::$themeWeb = NULL LibraryHelper::$here = "/en/format/pdf_con_audio_mp3/323" LibraryHelper::$params = array LibraryHelper::$action = "display_home_types" 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 = 1714166483 SessionHelper::$sessionTime = 1714188483 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/en/format/pdf_con_audio_mp3/323" SessionHelper::$params = array SessionHelper::$action = "display_home_types" 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/format/pdf_con_audio_mp3/323" PaginatorHelper::$params = array PaginatorHelper::$action = "display_home_types" 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/format/pdf_con_audio_mp3/323" AjaxHelper::$params = array AjaxHelper::$action = "display_home_types" 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 $path_title = array( array( "url" => "/en/format/pdf_con_audio_mp3" ) ) $i = 0 $elem = array( "url" => "/en/format/pdf_con_audio_mp3" )</pre><div id="CakeErrorCode6" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">                    //    echo __('nivell',true).' ';</span></code> <code><span style="color: #000000">                    //}</span></code> <span class="code-highlight"><code><span style="color: #000000">                    echo $elem['text'].' ';                            </span></code></span> </pre></div><pre>include - APP/views/layouts/default.ctp, line 18 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 PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5353 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</pre></div>
×

Cookies

This site uses cookies to offer you the best user experience possible. In continuing to browse, you are consenting to accept both the aforementioned cookies and our cookies policy..

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

2006-07-07 19:16:00

15.00 € VAT included

2006-07-07 18:26:00

20.50 € VAT included

2006-06-30 18:43:00

Abesten 3

Format:

Book

Author:

Francesca Galofré Mora, Jordi Valls Fuster

Collection:

Abesten Nr. 3

18.50 € VAT included

2006-06-22 18:57:00

17.68 € VAT included

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
dinsic@dinsic.com
Copyright © 1998-2024
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) 178 queries took 582 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `publicacions`43431
2DESCRIBE `archivesrelations`661
3DESCRIBE `ratings`880
4DESCRIBE `comments`990
5DESCRIBE `autors`14141
6DESCRIBE `publicacions_autors`440
7DESCRIBE `autor_translations`660
8DESCRIBE `categories`991
9DESCRIBE `publicacions_categories`330
10DESCRIBE `categories_translations`660
11DESCRIBE `colleccions`771
12DESCRIBE `catcolleccions`991
13DESCRIBE `catcolleccion_translations`660
14DESCRIBE `publicacions_colleccions`440
15DESCRIBE `colleccion_translations`660
16DESCRIBE `editors`220
17DESCRIBE `publicacions_editors`990
18DESCRIBE `enquadernacions`330
19DESCRIBE `publicacions_enquadernacions`330
20DESCRIBE `enquadernacion_translations`660
21DESCRIBE `formacions`770
22DESCRIBE `catformacions`990
23DESCRIBE `catformacion_translations`660
24DESCRIBE `publicacions_formacions`331
25DESCRIBE `formacion_translations`661
26DESCRIBE `idiomas`441
27DESCRIBE `publicacions_idiomas`330
28DESCRIBE `idioma_translations`660
29DESCRIBE `instruments`660
30DESCRIBE `catinstruments`991
31DESCRIBE `catinstrument_translations`660
32DESCRIBE `publicacions_instruments`440
33DESCRIBE `instrument_translations`660
34DESCRIBE `midas`440
35DESCRIBE `publicacions_midas`330
36DESCRIBE `mida_translations`661
37DESCRIBE `retractilats`330
38DESCRIBE `publicacions_retractilats`330
39DESCRIBE `retractilat_translations`660
40DESCRIBE `newsletters`771
41DESCRIBE `newsletters_publicacions`330
42DESCRIBE `newsletter_translations`660
43DESCRIBE `rssposts`10100
44DESCRIBE `rss`550
45DESCRIBE `rssposts_publicacions`330
46DESCRIBE `publicacion_translations`661
47DESCRIBE `relacionats`441
48DESCRIBE `funcions`441
49DESCRIBE `funcion_translations`660
50DESCRIBE `archives`660
51DESCRIBE `codes`771
52DESCRIBE `users`35351
53DESCRIBE `roles`551
54DESCRIBE `archivestypes`551
55DESCRIBE `pages`991
56DESCRIBE `pages_translations`661
57DESCRIBE `orders`18181
58DESCRIBE `invoices`22221
59DESCRIBE `orderproducts`10101
60DESCRIBE `latestsearches`660
61SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` 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 770
62SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 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 330
63SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 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 330
64SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 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 550
65SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 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 000
66SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 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 220
67SELECT `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 000
68SELECT `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 000
69SELECT `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 1110
70SELECT `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 1110
71SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` 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 660
72SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 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 330
73SELECT `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 660
74SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 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 000
75SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 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 440
76SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 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 000
77SELECT `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 770
78SELECT `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 660
79SELECT `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 000
80SELECT `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 13130
81SELECT `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 330
82SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 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 000
83SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 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 880
84SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 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 000
85SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 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 18180
86SELECT `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 000
87SELECT `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 39390
88SELECT `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 660
89SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 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 550
90SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 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 000
91SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 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 550
92SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 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 000
93SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 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 440
94SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 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 000
95SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 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 550
96SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 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 000
97SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 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 000
98SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 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 64640
99SELECT `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 000
100SELECT `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 32320
101SELECT `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 1110
102SELECT `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 550
103SELECT `Latestsearch`.`id`, `Latestsearch`.`text`, `Latestsearch`.`q`, `Latestsearch`.`url`, `Latestsearch`.`count`, `Latestsearch`.`lang` FROM `latestsearches` AS `Latestsearch` WHERE 1 = 1 ORDER BY `count` DESC LIMIT 3030300
104SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1110
105SELECT `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 330
106SELECT `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 19190
107SELECT `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 41410
108SELECT `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 1110
109SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') WHERE `Publicacion`.`titol` LIKE '0%' 112
110SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') WHERE `Publicacion`.`titol` LIKE '1%' 113
111SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') WHERE `Publicacion`.`titol` LIKE '2%' 112
112SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '3%') WHERE `Publicacion`.`titol` LIKE '3%' 111
113SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '4%') WHERE `Publicacion`.`titol` LIKE '4%' 111
114SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '5%') WHERE `Publicacion`.`titol` LIKE '5%' 111
115SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '6%') WHERE `Publicacion`.`titol` LIKE '6%' 111
116SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '7%') WHERE `Publicacion`.`titol` LIKE '7%' 111
117SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '8%') WHERE `Publicacion`.`titol` LIKE '8%' 111
118SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '9%') WHERE `Publicacion`.`titol` LIKE '9%' 111
119SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'A%') WHERE `Publicacion`.`titol` LIKE 'A%' 118
120SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'B%') WHERE `Publicacion`.`titol` LIKE 'B%' 116
121SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'C%') WHERE `Publicacion`.`titol` LIKE 'C%' 1114
122SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'D%') WHERE `Publicacion`.`titol` LIKE 'D%' 1111
123SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'E%') WHERE `Publicacion`.`titol` LIKE 'E%' 1119
124SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'F%') WHERE `Publicacion`.`titol` LIKE 'F%' 115
125SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'G%') WHERE `Publicacion`.`titol` LIKE 'G%' 112
126SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'H%') WHERE `Publicacion`.`titol` LIKE 'H%' 115
127SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') WHERE `Publicacion`.`titol` LIKE 'I%' 114
128SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') WHERE `Publicacion`.`titol` LIKE 'J%' 114
129SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') WHERE `Publicacion`.`titol` LIKE 'K%' 112
130SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') WHERE `Publicacion`.`titol` LIKE 'L%' 1114
131SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'M%') WHERE `Publicacion`.`titol` LIKE 'M%' 1111
132SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'N%') WHERE `Publicacion`.`titol` LIKE 'N%' 114
133SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'O%') WHERE `Publicacion`.`titol` LIKE 'O%' 114
134SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'P%') WHERE `Publicacion`.`titol` LIKE 'P%' 119
135SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Q%') WHERE `Publicacion`.`titol` LIKE 'Q%' 115
136SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') WHERE `Publicacion`.`titol` LIKE 'R%' 114
137SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') WHERE `Publicacion`.`titol` LIKE 'S%' 1110
138SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'T%') WHERE `Publicacion`.`titol` LIKE 'T%' 119
139SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'U%') WHERE `Publicacion`.`titol` LIKE 'U%' 112
140SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'V%') WHERE `Publicacion`.`titol` LIKE 'V%' 113
141SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') WHERE `Publicacion`.`titol` LIKE 'W%' 112
142SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') WHERE `Publicacion`.`titol` LIKE 'X%' 111
143SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Y%') WHERE `Publicacion`.`titol` LIKE 'Y%' 111
144SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'Z%') WHERE `Publicacion`.`titol` LIKE 'Z%' 111
145SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb') WHERE 1 = 1 1179
146SELECT DISTINCT `Publicacion`.`id`, `Publicacion`.`format`, `Publicacion`.`preu`, `Publicacion`.`created`, `Publicacion`.`novetat`, `Publicacion`.`en_preparacio`, `Publicacion`.`recomanat`, `Publicacion`.`exhaurit`, `Publicacion`.`oferta`, `I18n__titol`.`content`, `I18n__url`.`content`, `I18n__intro`.`content`, `Publicacion`.`id` FROM `publicacions` AS `Publicacion` LEFT JOIN `publicacion_translations` AS `I18n__titol` ON (`Publicacion`.`id` = `I18n__titol`.`foreign_key` AND `I18n__titol`.`model` = 'Publicacion' AND `I18n__titol`.`field` = 'titol') LEFT JOIN `publicacion_translations` AS `I18n__url` ON (`Publicacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Publicacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `publicacion_translations` AS `I18n__intro` ON (`Publicacion`.`id` = `I18n__intro`.`foreign_key` AND `I18n__intro`.`model` = 'Publicacion' AND `I18n__intro`.`field` = 'intro') WHERE `I18n__titol`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__intro`.`locale` = 'en_gb' ORDER BY `Publicacion`.`created` DESC LIMIT 2254, 744290
147SELECT `Archivesrelation`.`id`, `Archivesrelation`.`model`, `Archivesrelation`.`foreign_id`, `Archivesrelation`.`order`, `Archivesrelation`.`file_id`, `Archivesrelation`.`archivestypes_id` FROM `archivesrelations` AS `Archivesrelation` WHERE `model` = 'Publicacion' AND `Archivesrelation`.`foreign_id` IN (1920, 1919, 1916, 1896) ORDER BY `Archivesrelation`.`order` ASC 444
148SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`name`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`model` = 'Publicacion' AND `Rating`.`model_id` IN (1920, 1919, 1916, 1896) 001
149SELECT `Comment`.`id`, `Comment`.`publicacion_id`, `Comment`.`replay_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`replay_id`=0 AND `Comment`.`publicacion_id` IN (1920, 1919, 1916, 1896) ORDER BY `Comment`.`id` ASC 000
150SELECT `Autor`.`id`, `Autor`.`nom`, `Autor`.`cognom`, `Autor`.`2cognom`, `Autor`.`curriculum`, `Autor`.`data_desconeguda`, `Autor`.`data_naixement`, `Autor`.`nomes_any_naixement`, `Autor`.`nomes_any_defuncio`, `Autor`.`defuncio`, `Autor`.`data_defuncio`, `Autor`.`data_defuncio_desconeguda`, `Autor`.`url`, `Autor`.`published`, `PublicacionsAutor`.`id`, `PublicacionsAutor`.`autor_id`, `PublicacionsAutor`.`publicacion_id`, `PublicacionsAutor`.`funcion_id` FROM `autors` AS `Autor` JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC 55552
151SELECT `Category`.`id`, `Category`.`url`, `Category`.`name`, `Category`.`parent_id`, `Category`.`descripcio`, `Category`.`order`, `Category`.`lft`, `Category`.`rght`, `Category`.`published`, `PublicacionsCategory`.`id`, `PublicacionsCategory`.`publicacion_id`, `PublicacionsCategory`.`category_id` FROM `categories` AS `Category` JOIN `publicacions_categories` AS `PublicacionsCategory` ON (`PublicacionsCategory`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 441
152SELECT `Colleccion`.`id`, `Colleccion`.`nom`, `Colleccion`.`catcolleccion_id`, `Colleccion`.`descripcio`, `Colleccion`.`order`, `Colleccion`.`url`, `Colleccion`.`published`, `PublicacionsColleccion`.`id`, `PublicacionsColleccion`.`colleccion_id`, `PublicacionsColleccion`.`publicacion_id`, `PublicacionsColleccion`.`num_volum` FROM `colleccions` AS `Colleccion` JOIN `publicacions_colleccions` AS `PublicacionsColleccion` ON (`PublicacionsColleccion`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC 441
153SELECT `Editor`.`id`, `Editor`.`nom`, `PublicacionsEditor`.`id`, `PublicacionsEditor`.`publicacion_id`, `PublicacionsEditor`.`editor_id`, `PublicacionsEditor`.`data_edicio`, `PublicacionsEditor`.`num_edicio`, `PublicacionsEditor`.`data_reimpresio`, `PublicacionsEditor`.`data_reimpresio_nul`, `PublicacionsEditor`.`num_reimpresio`, `PublicacionsEditor`.`deposito_legal` FROM `editors` AS `Editor` JOIN `publicacions_editors` AS `PublicacionsEditor` ON (`PublicacionsEditor`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`) 440
154SELECT `Enquadernacion`.`id`, `Enquadernacion`.`nom`, `Enquadernacion`.`published`, `PublicacionsEnquadernacion`.`id`, `PublicacionsEnquadernacion`.`publicacion_id`, `PublicacionsEnquadernacion`.`enquadernacion_id` FROM `enquadernacions` AS `Enquadernacion` JOIN `publicacions_enquadernacions` AS `PublicacionsEnquadernacion` ON (`PublicacionsEnquadernacion`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`) 220
155SELECT `Formacion`.`id`, `Formacion`.`nom`, `Formacion`.`catformacion_id`, `Formacion`.`order`, `Formacion`.`url`, `Formacion`.`published`, `Formacion`.`metadescription`, `PublicacionsFormacion`.`id`, `PublicacionsFormacion`.`publicacion_id`, `PublicacionsFormacion`.`formacion_id` FROM `formacions` AS `Formacion` JOIN `publicacions_formacions` AS `PublicacionsFormacion` ON (`PublicacionsFormacion`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 000
156SELECT `Idioma`.`id`, `Idioma`.`nom`, `Idioma`.`published`, `Idioma`.`url`, `PublicacionsIdioma`.`id`, `PublicacionsIdioma`.`publicacion_id`, `PublicacionsIdioma`.`idioma_id` FROM `idiomas` AS `Idioma` JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 440
157SELECT `Instrument`.`id`, `Instrument`.`nom`, `Instrument`.`catinstrument_id`, `Instrument`.`published`, `Instrument`.`url`, `Instrument`.`metadescription`, `PublicacionsInstrument`.`id`, `PublicacionsInstrument`.`publicacion_id`, `PublicacionsInstrument`.`instrument_id`, `PublicacionsInstrument`.`priority` FROM `instruments` AS `Instrument` JOIN `publicacions_instruments` AS `PublicacionsInstrument` ON (`PublicacionsInstrument`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC 001
158SELECT `Mida`.`id`, `Mida`.`nom`, `Mida`.`orientacio`, `Mida`.`published`, `PublicacionsMida`.`id`, `PublicacionsMida`.`publicacion_id`, `PublicacionsMida`.`mida_id` FROM `midas` AS `Mida` JOIN `publicacions_midas` AS `PublicacionsMida` ON (`PublicacionsMida`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsMida`.`mida_id` = `Mida`.`id`) 441
159SELECT `Retractilat`.`id`, `Retractilat`.`nom`, `Retractilat`.`published`, `PublicacionsRetractilat`.`id`, `PublicacionsRetractilat`.`publicacion_id`, `PublicacionsRetractilat`.`retractilat_id` FROM `retractilats` AS `Retractilat` JOIN `publicacions_retractilats` AS `PublicacionsRetractilat` ON (`PublicacionsRetractilat`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 440
160SELECT `Newsletter`.`id`, `Newsletter`.`slug`, `Newsletter`.`titol`, `Newsletter`.`assumpte`, `Newsletter`.`intro`, `Newsletter`.`data`, `Newsletter`.`published`, `NewslettersPublicacion`.`id`, `NewslettersPublicacion`.`publicacion_id`, `NewslettersPublicacion`.`newsletter_id` FROM `newsletters` AS `Newsletter` JOIN `newsletters_publicacions` AS `NewslettersPublicacion` ON (`NewslettersPublicacion`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`) 551
161SELECT `Rsspost`.`id`, `Rsspost`.`rss_id`, `Rsspost`.`titol`, `Rsspost`.`html`, `Rsspost`.`data_creacio`, `Rsspost`.`data_ordenacio`, `Rsspost`.`data_publica`, `Rsspost`.`slug`, `Rsspost`.`extlink`, `Rsspost`.`published`, `RsspostsPublicacion`.`id`, `RsspostsPublicacion`.`rsspost_id`, `RsspostsPublicacion`.`publicacion_id` FROM `rssposts` AS `Rsspost` JOIN `rssposts_publicacions` AS `RsspostsPublicacion` ON (`RsspostsPublicacion`.`publicacion_id` IN (1920, 1919, 1916, 1896) AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 111
162SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN `publicacion_translations` AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb') WHERE 1 = 1 110
163SELECT `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` = 1756 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1111
164SELECT `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` = 674 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
165SELECT `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` = 674 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
166SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 674 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
167SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
168SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
169SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
170SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
171SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
172SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
173SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
174SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
175SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2104 LIMIT 1111
176SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2103 LIMIT 1110
177SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2102 LIMIT 1110
178SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2101 LIMIT 1110