Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5155]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5186]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5255]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5258]
Notice (8): Undefined variable: tmptext [APP/controllers/publicacions_controller.php, line 5347]
 <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:cantata nadalenca nit de vetlla" class="word size3">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size3">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size8">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size7">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size6">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size5">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size9">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size7">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size7">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size7">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size7">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size2">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size7">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size2">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size2">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size4">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size8">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size6">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size3">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size1">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size3">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size5">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size2">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size5">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size3">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size6">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size3">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size2">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size2">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size2">El timbaler del Bruc</a> &nbsp;", "descompte" => 0.05, "options_third_level" => array( "All types", "orchestral_music" => "Orchestral music", "vocal_and_choral_music" => "Vocal and Choral Music", "instrumental_music" => "Instrumental Music" ), "options_instruments_level" => array( "All Instruments", "brass" => "Brass", "clarinets_and_saxes" => "Clarinets and Saxes", "double_reed" => "Double Reed ", "electronic_keyboard" => "Electronic Keyboard", "flutes_recorders_and_pipes" => "Flutes, recorders and pipes", "guitares" => "Guitares", "harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.", "key_hammered_string_piano" => "Key / Hammered String (Piano)", "key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ", "key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String (Hurdy-gurdy)", "key_wind" => "Key / Wind", "orff_percussion" => "Orff Percussion", "pitched_percussion" => "Pitched Percussion", "stringed_instruments" => "Stringed Instruments", "stringed_instruments_violins" => "Stringed Instruments: Violins", "ukulele" => "Ukulele", "un_piched_percussion" => "Un-piched Percussion", "unspecified_percussion" => "Unspecified Percussion", "wind_instruments_to_determine" => "Wind instruments to determine " ), "pages" => array( array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array() ), "total_basket" => 0, "total_basket_count" => 0, "admin" => false, "selected_controller" => "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_amb_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" => "Lenguaje Musical 4, Lenguaje musical (Grado elemental), Anna, Alegre, Anna, Bassó, Antoni, Bassó, César, Puente, Francesca, Galofré, Jordi, Valls, Lluïsa, Alegre, Paloma, García, Xavier, Torns, Audició 2. Forma i color a la música, Audició, Àngels, Comella, Carles, Riera, Francesca, Galofré, J., Ros-Riba, J., Nieva, Pau, Barceló, Pep, Creus, Romà, Escalas, Solfeig 1, Solfeig (Language of Music - Elementary), Anna, Alegre, Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Xavier, Torns, Solfeig 2, Solfeig (Language of Music - Elementary), Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Jordi, Valls, Josep-Ignasi, Gómez, Mariona, Vila, Narcís, Bonet, Solfeig 3, Solfeig (Language of Music - Elementary), Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Francesca, Galofré, Joan Josep, Gutiérrez, Jordi, Valls, Jordi-Lluís, Rigol, Josep-Ignasi, Gómez, Mariona, Vila, Narcís, Bonet, Solfeig 4, Solfeig (Language of Music - Elementary), Anna, Alegre, Anna, Alegre, Anna, Bassó, Antoni, Bassó, César, Puente, César, Puente, Francesca, Galofré, Jordi, Valls, Jordi, Valls, Lluïsa, Alegre, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Xavier, Torns, Xavier, Torns, Lenguaje Musical 1, Lenguaje musical (Grado elemental), Anna, Alegre, Anna, Bassó, Antoni, Bassó, Asunción, Robles, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Javier, Duque, Javier, Duque, Lluïsa, Alegre, M. Victòria, Maduell, Mariona, Vila, Narcís, Bonet, Roser, Garcia, Xavier, Torns, Partitura", "list" => array( array(), array(), 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-11 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm4-lenguaje_musical_4"><img src="http://www.dinsic.com/img/cache/ab234c2c53f0eaf7504710ae3c78d087-2115-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm4-lenguaje_musical_4">Lenguaje Musical 4</a></h2> <strong>Format:</strong> <p> Score </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/lenguaje_musical_grado_elemental">Lenguaje musical (Grado elemental)</a> Nr. 4</p> </div> <div class="compra"> <div class="afegir pdfonline_1945"> <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="1945" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>19.80 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 20:00:12 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/book_with_cd-au2-audicio_2_forma_i_color_a_la_musica"><img src="http://www.dinsic.com/img/cache/ae0c44338fb97c355111a510c408c4bc-2109-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-au2-audicio_2_forma_i_color_a_la_musica">Audició 2. 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. 2</p> </div> <div class="compra"> <div class="afegir pdfonline_1930"> <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="1930" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>20.50 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s1-solfeig_1"><img src="http://www.dinsic.com/img/cache/fd5feabe441545370878e6fea5c094bd-2105-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s1-solfeig_1">Solfeig 1</a></h2> <strong>Format:</strong> <p> Score </p> <strong>Author:</strong><p><a href="/en/autor/eulalia_galofre_mora">Eulàlia Galofré Mora</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 1</p> </div> <div class="compra"> <div class="afegir pdfonline_1926"> <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="1926" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>14.00 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s2-solfeig_2"><img src="http://www.dinsic.com/img/cache/411618730fdb95e447497b6403c6b2d8-2106-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s2-solfeig_2">Solfeig 2</a></h2> <strong>Format:</strong> <p> Score </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/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 2</p> </div> <div class="compra"> <div class="afegir pdfonline_1927"> <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="1927" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>16.60 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s3-solfeig_3"><img src="http://www.dinsic.com/img/cache/3af28e48b4dbf2f59f4685c91cc5c28b-2107-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s3-solfeig_3">Solfeig 3</a></h2> <strong>Format:</strong> <p> Score </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/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 3</p> </div> <div class="compra"> <div class="afegir pdfonline_1928"> <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="1928" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>17.60 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s4-solfeig_4"><img src="http://www.dinsic.com/img/cache/d096313c8863f3f5d78dada1ecc540f0-2108-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s4-solfeig_4">Solfeig 4</a></h2> <strong>Format:</strong> <p> Score </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/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 4</p> </div> <div class="compra"> <div class="afegir pdfonline_1929"> <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="1929" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>19.80 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm1-lenguaje_musical_1"><img src="http://www.dinsic.com/img/cache/9c38aa549e2608d65d6b8c043fd00f49-2110-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm1-lenguaje_musical_1">Lenguaje Musical 1</a></h2> <strong>Format:</strong> <p> Score </p> <strong>Author:</strong><p><a href="/en/autor/eulalia_galofre_mora">Eulàlia Galofré Mora</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/lenguaje_musical_grado_elemental">Lenguaje musical (Grado elemental)</a> Nr. 1</p> </div> <div class="compra"> <div class="afegir pdfonline_1935"> <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="1935" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>14.00 € VAT included</p> </div> </div> </div> <div class="index"> <form name="form_letter" action="/en/format/pdf_amb_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_amb_audio_mp3"><< First</a> <a class="prev" href="/en/format/pdf_amb_audio_mp3/321">&lt;&lt; Prev</a> <span><a href="/en/format/pdf_amb_audio_mp3/315">315</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/316">316</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/317">317</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/318">318</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/319">319</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/320">320</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/321">321</a></span> <span class="current">322</span> <span><a href="/en/format/pdf_amb_audio_mp3/323">323</a></span> <a href="/en/format/pdf_amb_audio_mp3/323">Next &gt;&gt;</a> <a href="/en/format/pdf_amb_audio_mp3/323">Last >></a></div> </div> ", "scripts_for_layout" => "", "cakeDebug" => "", "html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/en/format/pdf_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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" => "Francesca Galofré Mora", "search" => SearchHelper SearchHelper::$helpers = array SearchHelper::$base = "" SearchHelper::$webroot = "/" SearchHelper::$themeWeb = NULL SearchHelper::$here = "/en/format/pdf_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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 = 1748216426 SessionHelper::$sessionTime = 1748238426 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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:cantata nadalenca nit de vetlla" class="word size3">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size3">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size8">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size7">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:Palau insòlit" class="word size6">Palau insòlit</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size5">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size9">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size7">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size7">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size7">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size7">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size2">Sonatina de Nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size7">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size2">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size2">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size4">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size8">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size6">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size3">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size1">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size3">nadal</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size5">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size2">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size5">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size3">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size6">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size3">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size2">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size2">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size2">El timbaler del Bruc</a> &nbsp;" $descompte = 0.05 $options_third_level = array( "All types", "orchestral_music" => "Orchestral music", "vocal_and_choral_music" => "Vocal and Choral Music", "instrumental_music" => "Instrumental Music" ) $options_instruments_level = array( "All Instruments", "brass" => "Brass", "clarinets_and_saxes" => "Clarinets and Saxes", "double_reed" => "Double Reed ", "electronic_keyboard" => "Electronic Keyboard", "flutes_recorders_and_pipes" => "Flutes, recorders and pipes", "guitares" => "Guitares", "harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.", "key_hammered_string_piano" => "Key / Hammered String (Piano)", "key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ", "key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String (Hurdy-gurdy)", "key_wind" => "Key / Wind", "orff_percussion" => "Orff Percussion", "pitched_percussion" => "Pitched Percussion", "stringed_instruments" => "Stringed Instruments", "stringed_instruments_violins" => "Stringed Instruments: Violins", "ukulele" => "Ukulele", "un_piched_percussion" => "Un-piched Percussion", "unspecified_percussion" => "Unspecified Percussion", "wind_instruments_to_determine" => "Wind instruments to determine " ) $pages = array( array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ) ) $total_basket = 0 $total_basket_count = 0 $admin = false $selected_controller = "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_amb_audio_mp3" $text_section = "" $breadcrumb = array( array( "url" => "/en/format/pdf_amb_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 = "Lenguaje Musical 4, Lenguaje musical (Grado elemental), Anna, Alegre, Anna, Bassó, Antoni, Bassó, César, Puente, Francesca, Galofré, Jordi, Valls, Lluïsa, Alegre, Paloma, García, Xavier, Torns, Audició 2. Forma i color a la música, Audició, Àngels, Comella, Carles, Riera, Francesca, Galofré, J., Ros-Riba, J., Nieva, Pau, Barceló, Pep, Creus, Romà, Escalas, Solfeig 1, Solfeig (Language of Music - Elementary), Anna, Alegre, Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Xavier, Torns, Solfeig 2, Solfeig (Language of Music - Elementary), Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Jordi, Valls, Josep-Ignasi, Gómez, Mariona, Vila, Narcís, Bonet, Solfeig 3, Solfeig (Language of Music - Elementary), Anna, Bassó, Antoni, Bassó, Enriqueta, Farràs, Francesca, Galofré, Joan Josep, Gutiérrez, Jordi, Valls, Jordi-Lluís, Rigol, Josep-Ignasi, Gómez, Mariona, Vila, Narcís, Bonet, Solfeig 4, Solfeig (Language of Music - Elementary), Anna, Alegre, Anna, Alegre, Anna, Bassó, Antoni, Bassó, César, Puente, César, Puente, Francesca, Galofré, Jordi, Valls, Jordi, Valls, Lluïsa, Alegre, Lluïsa, Alegre, Mariona, Vila, Narcís, Bonet, Xavier, Torns, Xavier, Torns, Lenguaje Musical 1, Lenguaje musical (Grado elemental), Anna, Alegre, Anna, Bassó, Antoni, Bassó, Asunción, Robles, Enriqueta, Farràs, Eulàlia, Galofré, Francesca, Galofré, Javier, Duque, Javier, Duque, Lluïsa, Alegre, M. Victòria, Maduell, Mariona, Vila, Narcís, Bonet, Roser, Garcia, Xavier, Torns, Partitura" $list = array( array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ), array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ), array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ), array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ), array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ), array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ), array( "Publicacion" => array(), "Archivesrelation" => array(), "Rating" => array(), "Comment" => array(), "Autor" => array(), "Category" => array(), "Colleccion" => array(), "Editor" => array(), "Enquadernacion" => array(), "Formacion" => array(), "Idioma" => array(), "Instrument" => array(), "Mida" => array(), "Retractilat" => array(), "Newsletter" => array(), "Rsspost" => array() ) ) $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-11 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm4-lenguaje_musical_4"><img src="http://www.dinsic.com/img/cache/ab234c2c53f0eaf7504710ae3c78d087-2115-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm4-lenguaje_musical_4">Lenguaje Musical 4</a></h2> <strong>Format:</strong> <p> Score </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/lenguaje_musical_grado_elemental">Lenguaje musical (Grado elemental)</a> Nr. 4</p> </div> <div class="compra"> <div class="afegir pdfonline_1945"> <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="1945" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>19.80 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 20:00:12 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/book_with_cd-au2-audicio_2_forma_i_color_a_la_musica"><img src="http://www.dinsic.com/img/cache/ae0c44338fb97c355111a510c408c4bc-2109-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-au2-audicio_2_forma_i_color_a_la_musica">Audició 2. 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. 2</p> </div> <div class="compra"> <div class="afegir pdfonline_1930"> <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="1930" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>20.50 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s1-solfeig_1"><img src="http://www.dinsic.com/img/cache/fd5feabe441545370878e6fea5c094bd-2105-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s1-solfeig_1">Solfeig 1</a></h2> <strong>Format:</strong> <p> Score </p> <strong>Author:</strong><p><a href="/en/autor/eulalia_galofre_mora">Eulàlia Galofré Mora</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 1</p> </div> <div class="compra"> <div class="afegir pdfonline_1926"> <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="1926" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>14.00 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s2-solfeig_2"><img src="http://www.dinsic.com/img/cache/411618730fdb95e447497b6403c6b2d8-2106-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s2-solfeig_2">Solfeig 2</a></h2> <strong>Format:</strong> <p> Score </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/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 2</p> </div> <div class="compra"> <div class="afegir pdfonline_1927"> <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="1927" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>16.60 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s3-solfeig_3"><img src="http://www.dinsic.com/img/cache/3af28e48b4dbf2f59f4685c91cc5c28b-2107-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s3-solfeig_3">Solfeig 3</a></h2> <strong>Format:</strong> <p> Score </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/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 3</p> </div> <div class="compra"> <div class="afegir pdfonline_1928"> <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="1928" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>17.60 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s4-solfeig_4"><img src="http://www.dinsic.com/img/cache/d096313c8863f3f5d78dada1ecc540f0-2108-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-s4-solfeig_4">Solfeig 4</a></h2> <strong>Format:</strong> <p> Score </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/solfeig_language_of_music_elementary">Solfeig (Language of Music - Elementary)</a> Nr. 4</p> </div> <div class="compra"> <div class="afegir pdfonline_1929"> <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="1929" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>19.80 € VAT included</p> </div> </div> <div class="element"> 2006-07-10 00:00:00 <div class="tapa"> <a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm1-lenguaje_musical_1"><img src="http://www.dinsic.com/img/cache/9c38aa549e2608d65d6b8c043fd00f49-2110-100.jpg" alt="" /></a> </div> <div class="info"> <h2><a href="/en/publications-subject-areas/music_schools_and_conservatoires-elementary_level/card/score-lm1-lenguaje_musical_1">Lenguaje Musical 1</a></h2> <strong>Format:</strong> <p> Score </p> <strong>Author:</strong><p><a href="/en/autor/eulalia_galofre_mora">Eulàlia Galofré Mora</a>, <a href="/en/autor/francesca_galofre_mora">Francesca Galofré Mora</a></p> <strong>Collection:</strong><p><a href="/en/colleccio/lenguaje_musical_grado_elemental">Lenguaje musical (Grado elemental)</a> Nr. 1</p> </div> <div class="compra"> <div class="afegir pdfonline_1935"> <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="1935" /> <input type="submit" id="botonSubmit" value="Add"> </form> </div> <p>14.00 € VAT included</p> </div> </div> </div> <div class="index"> <form name="form_letter" action="/en/format/pdf_amb_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_amb_audio_mp3"><< First</a> <a class="prev" href="/en/format/pdf_amb_audio_mp3/321">&lt;&lt; Prev</a> <span><a href="/en/format/pdf_amb_audio_mp3/315">315</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/316">316</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/317">317</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/318">318</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/319">319</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/320">320</a></span> <span><a href="/en/format/pdf_amb_audio_mp3/321">321</a></span> <span class="current">322</span> <span><a href="/en/format/pdf_amb_audio_mp3/323">323</a></span> <a href="/en/format/pdf_amb_audio_mp3/323">Next &gt;&gt;</a> <a href="/en/format/pdf_amb_audio_mp3/323">Last >></a></div> </div> " $scripts_for_layout = "" $cakeDebug = "" $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/en/format/pdf_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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 = "Francesca Galofré Mora" $search = SearchHelper SearchHelper::$helpers = array SearchHelper::$base = "" SearchHelper::$webroot = "/" SearchHelper::$themeWeb = NULL SearchHelper::$here = "/en/format/pdf_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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 = 1748216426 SessionHelper::$sessionTime = 1748238426 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3/322" 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_amb_audio_mp3" ) ) $i = 0 $elem = array( "url" => "/en/format/pdf_amb_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 5355 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-10 20:00:12

20.50 € VAT included

2006-07-10 00:00:00

14.00 € VAT included

2006-07-10 00:00:00

16.60 € VAT included

2006-07-10 00:00:00

17.60 € VAT included

2006-07-10 00:00:00

14.00 € 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-2025
This portal is designed to work with the latest versions of the principal navigators: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. The use of non-compatible navigators or deactivation of some properties such as Javascript compatibility or blocking cookies may reduce the sites functionality. If you are accessing the site through a firewall or a porxy, make sure cookies are enabled.
(default) 190 queries took 1225 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `publicacions`43437
2DESCRIBE `archivesrelations`661
3DESCRIBE `ratings`882
4DESCRIBE `comments`9912
5DESCRIBE `autors`14149
6DESCRIBE `publicacions_autors`4413
7DESCRIBE `autor_translations`662
8DESCRIBE `categories`9914
9DESCRIBE `publicacions_categories`3311
10DESCRIBE `categories_translations`663
11DESCRIBE `colleccions`772
12DESCRIBE `catcolleccions`993
13DESCRIBE `catcolleccion_translations`663
14DESCRIBE `publicacions_colleccions`441
15DESCRIBE `colleccion_translations`667
16DESCRIBE `editors`223
17DESCRIBE `publicacions_editors`996
18DESCRIBE `enquadernacions`333
19DESCRIBE `publicacions_enquadernacions`333
20DESCRIBE `enquadernacion_translations`669
21DESCRIBE `formacions`773
22DESCRIBE `catformacions`993
23DESCRIBE `catformacion_translations`663
24DESCRIBE `publicacions_formacions`333
25DESCRIBE `formacion_translations`663
26DESCRIBE `idiomas`443
27DESCRIBE `publicacions_idiomas`336
28DESCRIBE `idioma_translations`663
29DESCRIBE `instruments`666
30DESCRIBE `catinstruments`993
31DESCRIBE `catinstrument_translations`663
32DESCRIBE `publicacions_instruments`440
33DESCRIBE `instrument_translations`662
34DESCRIBE `midas`440
35DESCRIBE `publicacions_midas`337
36DESCRIBE `mida_translations`665
37DESCRIBE `retractilats`333
38DESCRIBE `publicacions_retractilats`333
39DESCRIBE `retractilat_translations`663
40DESCRIBE `newsletters`773
41DESCRIBE `newsletters_publicacions`333
42DESCRIBE `newsletter_translations`666
43DESCRIBE `rssposts`10106
44DESCRIBE `rss`553
45DESCRIBE `rssposts_publicacions`330
46DESCRIBE `publicacion_translations`665
47DESCRIBE `relacionats`440
48DESCRIBE `funcions`4413
49DESCRIBE `funcion_translations`663
50DESCRIBE `archives`669
51DESCRIBE `codes`773
52DESCRIBE `users`35359
53DESCRIBE `roles`554
54DESCRIBE `archivestypes`552
55DESCRIBE `pages`993
56DESCRIBE `pages_translations`663
57DESCRIBE `orders`18186
58DESCRIBE `invoices`22229
59DESCRIBE `orderproducts`10103
60DESCRIBE `latestsearches`664
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 771
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 331
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 551
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 222
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 001
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 001
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 1111
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 1116
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 661
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 331
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 665
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 441
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 772
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 666
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 002
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 13131
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 332
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 006
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 881
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 001
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 18184
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 005
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 39391
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 551
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 004
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 551
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 001
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 4412
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 006
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 002
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 64641
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 001
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 32321
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 1111
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 556
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 3030301
104SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1111
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 331
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 19191
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 42421
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 1111
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%' 1112
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%' 111
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%' 111
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%' 117
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%' 114
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%' 113
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%' 1123
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%' 1148
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%' 1126
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%' 1131
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%' 1111
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%' 117
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%' 111
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%' 1113
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%' 119
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%' 112
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%' 112
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%' 118
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%' 113
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%' 112
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%' 117
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%' 116
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%' 112
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%' 111
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 1164
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 2247, 777371
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) ORDER BY `Archivesrelation`.`order` ASC 996
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) 003
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) ORDER BY `Comment`.`id` ASC 002
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsAutor`.`autor_id` = `Autor`.`id`) ORDER BY nom ASC 76763
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsCategory`.`category_id` = `Category`.`id`) 771
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsColleccion`.`colleccion_id` = `Colleccion`.`id`) ORDER BY `Colleccion`.`nom` ASC 774
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsEditor`.`editor_id` = `Editor`.`id`) 771
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsEnquadernacion`.`enquadernacion_id` = `Enquadernacion`.`id`) 772
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 003
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 771
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsInstrument`.`instrument_id` = `Instrument`.`id`) ORDER BY `PublicacionsInstrument`.`priority` DESC 003
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsMida`.`mida_id` = `Mida`.`id`) 772
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 771
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `NewslettersPublicacion`.`newsletter_id` = `Newsletter`.`id`) 553
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 (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `RsspostsPublicacion`.`rsspost_id` = `Rsspost`.`id`) 221
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 1185
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` = 1797 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1114
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` = 1756 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` = 1804 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1112
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` = 1804 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1111
167SELECT `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` = 1804 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1113
168SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1804 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1116
169SELECT `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` = 1797 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1111
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` = 81 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` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1114
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` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1111
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` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1112
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` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1112
175SELECT `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 1118
176SELECT `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 1112
177SELECT `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
178SELECT `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 1113
179SELECT `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
180SELECT `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 1112
181SELECT `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 1112
182SELECT `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
183SELECT `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
184SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2115 LIMIT 1110
185SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2109 LIMIT 1110
186SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2105 LIMIT 1110
187SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2106 LIMIT 1110
188SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2107 LIMIT 1110
189SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2108 LIMIT 1110
190SELECT `Archive`.`id`, `Archive`.`name`, `Archive`.`filename`, `Archive`.`originalname`, `Archive`.`archivesize`, `Archive`.`filetype` FROM `archives` AS `Archive` WHERE `Archive`.`id` = 2110 LIMIT 1110