Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5153]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5184]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5253]
Notice (8): Undefined variable: conditions [APP/controllers/publicacions_controller.php, line 5256]
Notice (8): Undefined variable: tmptext [APP/controllers/publicacions_controller.php, line 5345]
 <pre class="cake-debug"> <a href='javascript:void(0);' onclick='document.getElementById("CakeStackTrace6").style.display = (document.getElementById("CakeStackTrace6").style.display == "none" ? "" : "none")'><b>Notice</b> (8)</a>: Undefined index: text [<b>APP/views/layouts/default.ctp</b>, line <b>18</b>] </pre> <div id="CakeStackTrace6" class="cake-stack-trace" style="display: none;"><a href='javascript:void(0);' onclick='document.getElementById("CakeErrorCode6").style.display = (document.getElementById("CakeErrorCode6").style.display == "none" ? "" : "none")'>Code</a> | <a href='javascript:void(0);' onclick='document.getElementById("CakeErrorContext6").style.display = (document.getElementById("CakeErrorContext6").style.display == "none" ? "" : "none")'>Context</a><pre id="CakeErrorContext6" class="cake-context" style="display: none;">$___viewFn = "/var/www/test-dinsic/trunk/app/views/layouts/default.ctp" $___dataForView = array( "identify" => null, "sesionLang" => "en", "categories" => array( array(), array(), array(), array(), array(), array(), array() ), "qui_som" => array( "Page" => array() ), "que_fem" => array( "Page" => array() ), "listcolleccions" => array( array(), array(), array(), array(), array(), array() ), "listformacions" => array( array(), array(), array() ), "listinstruments" => array( array(), array(), array(), array(), array(), array() ), "paypal" => array( "Page" => array() ), "perfils_lateral" => array( array(), array(), array(), array(), array() ), "cloud" => " &nbsp; <a href="/searches/index/q:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size9">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size5">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size7">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size3">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size7">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size1">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size7">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size8">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size1">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size4">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size6">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size2">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size1">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size6">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size8">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size1">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size5">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size2">nadal</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:cantata nadalenca nit de vetlla" class="word size6">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size6">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size8">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size9">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size4">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size7">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size6">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size4">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size2">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size5">Sonatina de Nadal</a> &nbsp;", "descompte" => 0.05, "options_third_level" => array( "All types", "orchestral_music" => "Orchestral music", "vocal_and_choral_music" => "Vocal and Choral Music", "instrumental_music" => "Instrumental Music" ), "options_instruments_level" => array( "All Instruments", "brass" => "Brass", "clarinets_and_saxes" => "Clarinets and Saxes", "double_reed" => "Double Reed ", "electronic_keyboard" => "Electronic Keyboard", "flutes_recorders_and_pipes" => "Flutes, recorders and pipes", "guitares" => "Guitares", "harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.", "key_hammered_string_piano" => "Key / Hammered String (Piano)", "key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ", "key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String (Hurdy-gurdy)", "key_wind" => "Key / Wind", "orff_percussion" => "Orff Percussion", "pitched_percussion" => "Pitched Percussion", "stringed_instruments" => "Stringed Instruments", "stringed_instruments_violins" => "Stringed Instruments: Violins", "ukulele" => "Ukulele", "un_piched_percussion" => "Un-piched Percussion", "unspecified_percussion" => "Unspecified Percussion", "wind_instruments_to_determine" => "Wind instruments to determine " ), "pages" => array( array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array() ), "total_basket" => 0, "total_basket_count" => 0, "admin" => false, "selected_controller" => "publicacions", "browser" => array( "browsertype" => null, "version" => "", "platform" => null, "AOL" => false ), "selectedtab" => false, "cookies" => array( "Page" => array() ), "aviso_cookie" => true, "letter_action_url" => "/en/format/pdf_con_audio_mp3", "text_section" => "", "breadcrumb" => array( array() ), "letterVector" => array( "0_9" => 31, "A" => 99, "B" => 63, "C" => 227, "D" => 164, "E" => 367, "F" => 55, "G" => 10, "H" => 60, "I" => 39, "J" => 31, "K" => 7, "L" => 206, "M" => 164, "N" => 32, "O" => 26, "P" => 137, "Q" => 53, "R" => 46, "S" => 168, "T" => 140, "U" => 15, "V" => 35, "W" => 3, "X" => 3, "Y" => 3, "Z" => 2 ), "letter_selected" => "", "lastlink" => 323, "keywords" => "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="en_produccion soon_1945"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1945"> --> <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="en_produccion soon_1930"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1930"> --> <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="en_produccion soon_1926"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1926"> --> <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="en_produccion soon_1927"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1927"> --> <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="en_produccion soon_1928"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1928"> --> <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="en_produccion soon_1929"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1929"> --> <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="en_produccion soon_1935"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1935"> --> <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_con_audio_mp3" method="post"> <input type="hidden" value="" name="letter" id="letter"/> <ul> <li class="all"><a class="a_letter_all" style="color:#7A0000;" href="#">ALL</a></li> <li class=""> <a class="a_letter cap-0_9" href="#"> 0-9 </a> </li> <li class=""> <a class="a_letter cap-A" href="#"> A </a> </li> <li class=""> <a class="a_letter cap-B" href="#"> B </a> </li> <li class=""> <a class="a_letter cap-C" href="#"> C </a> </li> <li class=""> <a class="a_letter cap-D" href="#"> D </a> </li> <li class=""> <a class="a_letter cap-E" href="#"> E </a> </li> <li class=""> <a class="a_letter cap-F" href="#"> F </a> </li> <li class=""> <a class="a_letter cap-G" href="#"> G </a> </li> <li class=""> <a class="a_letter cap-H" href="#"> H </a> </li> <li class=""> <a class="a_letter cap-I" href="#"> I </a> </li> <li class=""> <a class="a_letter cap-J" href="#"> J </a> </li> <li class=""> <a class="a_letter cap-K" href="#"> K </a> </li> <li class=""> <a class="a_letter cap-L" href="#"> L </a> </li> <li class=""> <a class="a_letter cap-M" href="#"> M </a> </li> <li class=""> <a class="a_letter cap-N" href="#"> N </a> </li> <li class=""> <a class="a_letter cap-O" href="#"> O </a> </li> <li class=""> <a class="a_letter cap-P" href="#"> P </a> </li> <li class=""> <a class="a_letter cap-Q" href="#"> Q </a> </li> <li class=""> <a class="a_letter cap-R" href="#"> R </a> </li> <li class=""> <a class="a_letter cap-S" href="#"> S </a> </li> <li class=""> <a class="a_letter cap-T" href="#"> T </a> </li> <li class=""> <a class="a_letter cap-U" href="#"> U </a> </li> <li class=""> <a class="a_letter cap-V" href="#"> V </a> </li> <li class=""> <a class="a_letter cap-W" href="#"> W </a> </li> <li class=""> <a class="a_letter cap-X" href="#"> X </a> </li> <li class=""> <a class="a_letter cap-Y" href="#"> Y </a> </li> <li class=""> <a class="a_letter cap-Z" href="#"> Z </a> </li> </ul> </form> </div> <script type="text/javascript"> $(document).ready(function(){ $(".a_letter_all").bind('click',function(e){ e.preventDefault(); $('#letter').val('-1'); document.forms['form_letter'].submit(); }); $(".a_letter").bind('click',function(e){ e.preventDefault(); var val = $(this).attr('class'); val = val.split(" "); val = val[1]; var letter = val.split("-"); letter = letter[1]; $('#letter').val(letter); document.forms['form_letter'].submit(); }); }); </script> <div id="pagination" class="paginador"> <div class="paging"><a href="/en/format/pdf_con_audio_mp3"><< First</a> <a class="prev" href="/en/format/pdf_con_audio_mp3/321">&lt;&lt; Prev</a> <span><a href="/en/format/pdf_con_audio_mp3/315">315</a></span> <span><a href="/en/format/pdf_con_audio_mp3/316">316</a></span> <span><a href="/en/format/pdf_con_audio_mp3/317">317</a></span> <span><a href="/en/format/pdf_con_audio_mp3/318">318</a></span> <span><a href="/en/format/pdf_con_audio_mp3/319">319</a></span> <span><a href="/en/format/pdf_con_audio_mp3/320">320</a></span> <span><a href="/en/format/pdf_con_audio_mp3/321">321</a></span> <span class="current">322</span> <span><a href="/en/format/pdf_con_audio_mp3/323">323</a></span> <a href="/en/format/pdf_con_audio_mp3/323">Next &gt;&gt;</a> <a href="/en/format/pdf_con_audio_mp3/323">Last >></a></div> </div> ", "scripts_for_layout" => "", "cakeDebug" => "", "html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/en/format/pdf_con_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_con_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_con_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_con_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_con_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_con_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_con_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_con_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 = 1715067863 SessionHelper::$sessionTime = 1715089863 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/en/format/pdf_con_audio_mp3/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_con_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_con_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:Da Camera 22: Tres danses americanes per a quartet de corda" class="word size9">Da Camera 22: Tres danses americanes per a quartet de corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Catala" class="word size5">Catala</a> &nbsp; &nbsp; <a href="/searches/index/q:Musica" class="word size7">Musica</a> &nbsp; &nbsp; <a href="/searches/index/q:cançó" class="word size3">cançó</a> &nbsp; &nbsp; <a href="/searches/index/q:El timbaler del Bruc" class="word size7">El timbaler del Bruc</a> &nbsp; &nbsp; <a href="/searches/index/q:Carnestoltes" class="word size1">Carnestoltes</a> &nbsp; &nbsp; <a href="/searches/index/q:Da Camera 22" class="word size7">Da Camera 22</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 2" class="word size5">abesten 2</a> &nbsp; &nbsp; <a href="/searches/index/q:piano" class="word size8">piano</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten" class="word size1">abesten</a> &nbsp; &nbsp; <a href="/searches/index/q:somnis" class="word size4">somnis</a> &nbsp; &nbsp; <a href="/searches/index/q:passeport" class="word size6">passeport</a> &nbsp; &nbsp; <a href="/searches/index/q:els músics més petits" class="word size2">els músics més petits</a> &nbsp; &nbsp; <a href="/searches/index/q:musica 2" class="word size1">musica 2</a> &nbsp; &nbsp; <a href="/searches/index/q:corda" class="word size6">corda</a> &nbsp; &nbsp; <a href="/searches/index/q:Quartet de corda núm. 3" class="word size8">Quartet de corda núm. 3</a> &nbsp; &nbsp; <a href="/searches/index/q:soliloquis" class="word size1">soliloquis</a> &nbsp; &nbsp; <a href="/searches/index/q:acompañamiento de canciones infantiles" class="word size5">acompañamiento de canciones infantiles</a> &nbsp; &nbsp; <a href="/searches/index/q:nadal" class="word size2">nadal</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:cantata nadalenca nit de vetlla" class="word size6">cantata nadalenca nit de vetlla</a> &nbsp; &nbsp; <a href="/searches/index/q:flauta" class="word size6">flauta</a> &nbsp; &nbsp; <a href="/searches/index/q:orquestra i cada instrument" class="word size8">orquestra i cada instrument</a> &nbsp; &nbsp; <a href="/searches/index/q:cançoner" class="word size9">cançoner</a> &nbsp; &nbsp; <a href="/searches/index/q:Literatura e interpretación de la trompeta" class="word size4">Literatura e interpretación de la trompeta</a> &nbsp; &nbsp; <a href="/searches/index/q:tot ho podem expressar" class="word size7">tot ho podem expressar</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 3" class="word size6">abesten 3</a> &nbsp; &nbsp; <a href="/searches/index/q:partitura" class="word size4">partitura</a> &nbsp; &nbsp; <a href="/searches/index/q:abesten 4" class="word size2">abesten 4</a> &nbsp; &nbsp; <a href="/searches/index/q:Sonatina de Nadal" class="word size5">Sonatina de Nadal</a> &nbsp;" $descompte = 0.05 $options_third_level = array( "All types", "orchestral_music" => "Orchestral music", "vocal_and_choral_music" => "Vocal and Choral Music", "instrumental_music" => "Instrumental Music" ) $options_instruments_level = array( "All Instruments", "brass" => "Brass", "clarinets_and_saxes" => "Clarinets and Saxes", "double_reed" => "Double Reed ", "electronic_keyboard" => "Electronic Keyboard", "flutes_recorders_and_pipes" => "Flutes, recorders and pipes", "guitares" => "Guitares", "harp_lyre_electric_bass_etc" => "Harp, Lyre, Electric Bass, etc.", "key_hammered_string_piano" => "Key / Hammered String (Piano)", "key_plucked_string_harpsichord" => "Key / Plucked String (Harpsichord). ", "key_wheel_bowed_string_hurdy_gurdy" => "Key / Wheel-bowed String (Hurdy-gurdy)", "key_wind" => "Key / Wind", "orff_percussion" => "Orff Percussion", "pitched_percussion" => "Pitched Percussion", "stringed_instruments" => "Stringed Instruments", "stringed_instruments_violins" => "Stringed Instruments: Violins", "ukulele" => "Ukulele", "un_piched_percussion" => "Un-piched Percussion", "unspecified_percussion" => "Unspecified Percussion", "wind_instruments_to_determine" => "Wind instruments to determine " ) $pages = array( array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ), array( "Page" => array() ) ) $total_basket = 0 $total_basket_count = 0 $admin = false $selected_controller = "publicacions" $browser = array( "browsertype" => null, "version" => "", "platform" => null, "AOL" => false ) $selectedtab = false $cookies = array( "Page" => array( "locale" => "en_gb", "name" => "Politica de cookies", "url" => "politica_de_cookies" ) ) $aviso_cookie = true $letter_action_url = "/en/format/pdf_con_audio_mp3" $text_section = "" $breadcrumb = array( array( "url" => "/en/format/pdf_con_audio_mp3" ) ) $letterVector = array( "0_9" => 31, "A" => 99, "B" => 63, "C" => 227, "D" => 164, "E" => 367, "F" => 55, "G" => 10, "H" => 60, "I" => 39, "J" => 31, "K" => 7, "L" => 206, "M" => 164, "N" => 32, "O" => 26, "P" => 137, "Q" => 53, "R" => 46, "S" => 168, "T" => 140, "U" => 15, "V" => 35, "W" => 3, "X" => 3, "Y" => 3, "Z" => 2 ) $letter_selected = "" $lastlink = 323 $keywords = "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="en_produccion soon_1945"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1945"> --> <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="en_produccion soon_1930"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1930"> --> <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="en_produccion soon_1926"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1926"> --> <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="en_produccion soon_1927"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1927"> --> <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="en_produccion soon_1928"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1928"> --> <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="en_produccion soon_1929"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1929"> --> <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="en_produccion soon_1935"> <p>Comming Soon</p> </div> <div style="display:none;" class="afegir pdfonline_1935"> --> <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_con_audio_mp3" method="post"> <input type="hidden" value="" name="letter" id="letter"/> <ul> <li class="all"><a class="a_letter_all" style="color:#7A0000;" href="#">ALL</a></li> <li class=""> <a class="a_letter cap-0_9" href="#"> 0-9 </a> </li> <li class=""> <a class="a_letter cap-A" href="#"> A </a> </li> <li class=""> <a class="a_letter cap-B" href="#"> B </a> </li> <li class=""> <a class="a_letter cap-C" href="#"> C </a> </li> <li class=""> <a class="a_letter cap-D" href="#"> D </a> </li> <li class=""> <a class="a_letter cap-E" href="#"> E </a> </li> <li class=""> <a class="a_letter cap-F" href="#"> F </a> </li> <li class=""> <a class="a_letter cap-G" href="#"> G </a> </li> <li class=""> <a class="a_letter cap-H" href="#"> H </a> </li> <li class=""> <a class="a_letter cap-I" href="#"> I </a> </li> <li class=""> <a class="a_letter cap-J" href="#"> J </a> </li> <li class=""> <a class="a_letter cap-K" href="#"> K </a> </li> <li class=""> <a class="a_letter cap-L" href="#"> L </a> </li> <li class=""> <a class="a_letter cap-M" href="#"> M </a> </li> <li class=""> <a class="a_letter cap-N" href="#"> N </a> </li> <li class=""> <a class="a_letter cap-O" href="#"> O </a> </li> <li class=""> <a class="a_letter cap-P" href="#"> P </a> </li> <li class=""> <a class="a_letter cap-Q" href="#"> Q </a> </li> <li class=""> <a class="a_letter cap-R" href="#"> R </a> </li> <li class=""> <a class="a_letter cap-S" href="#"> S </a> </li> <li class=""> <a class="a_letter cap-T" href="#"> T </a> </li> <li class=""> <a class="a_letter cap-U" href="#"> U </a> </li> <li class=""> <a class="a_letter cap-V" href="#"> V </a> </li> <li class=""> <a class="a_letter cap-W" href="#"> W </a> </li> <li class=""> <a class="a_letter cap-X" href="#"> X </a> </li> <li class=""> <a class="a_letter cap-Y" href="#"> Y </a> </li> <li class=""> <a class="a_letter cap-Z" href="#"> Z </a> </li> </ul> </form> </div> <script type="text/javascript"> $(document).ready(function(){ $(".a_letter_all").bind('click',function(e){ e.preventDefault(); $('#letter').val('-1'); document.forms['form_letter'].submit(); }); $(".a_letter").bind('click',function(e){ e.preventDefault(); var val = $(this).attr('class'); val = val.split(" "); val = val[1]; var letter = val.split("-"); letter = letter[1]; $('#letter').val(letter); document.forms['form_letter'].submit(); }); }); </script> <div id="pagination" class="paginador"> <div class="paging"><a href="/en/format/pdf_con_audio_mp3"><< First</a> <a class="prev" href="/en/format/pdf_con_audio_mp3/321">&lt;&lt; Prev</a> <span><a href="/en/format/pdf_con_audio_mp3/315">315</a></span> <span><a href="/en/format/pdf_con_audio_mp3/316">316</a></span> <span><a href="/en/format/pdf_con_audio_mp3/317">317</a></span> <span><a href="/en/format/pdf_con_audio_mp3/318">318</a></span> <span><a href="/en/format/pdf_con_audio_mp3/319">319</a></span> <span><a href="/en/format/pdf_con_audio_mp3/320">320</a></span> <span><a href="/en/format/pdf_con_audio_mp3/321">321</a></span> <span class="current">322</span> <span><a href="/en/format/pdf_con_audio_mp3/323">323</a></span> <a href="/en/format/pdf_con_audio_mp3/323">Next &gt;&gt;</a> <a href="/en/format/pdf_con_audio_mp3/323">Last >></a></div> </div> " $scripts_for_layout = "" $cakeDebug = "" $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/en/format/pdf_con_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_con_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_con_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_con_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_con_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_con_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_con_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_con_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 = 1715067863 SessionHelper::$sessionTime = 1715089863 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/en/format/pdf_con_audio_mp3/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_con_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_con_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_con_audio_mp3" ) ) $i = 0 $elem = array( "url" => "/en/format/pdf_con_audio_mp3" )</pre><div id="CakeErrorCode6" class="cake-code-dump" style="display: none;"><pre><code><span style="color: #000000">                    //    echo __('nivell',true).' ';</span></code> <code><span style="color: #000000">                    //}</span></code> <span class="code-highlight"><code><span style="color: #000000">                    echo $elem['text'].' ';                            </span></code></span> </pre></div><pre>include - APP/views/layouts/default.ctp, line 18 View::_render() - CORE/cake/libs/view/view.php, line 665 View::renderLayout() - CORE/cake/libs/view/view.php, line 453 View::render() - CORE/cake/libs/view/view.php, line 387 Controller::render() - CORE/cake/libs/controller/controller.php, line 805 PublicacionsController::display_home_types() - APP/controllers/publicacions_controller.php, line 5353 Object::dispatchMethod() - CORE/cake/libs/object.php, line 121 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 225 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 192 [main] - APP/webroot/index.php, line 88</pre></div>
×

Cookies

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

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

2006-07-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-2024
This portal is designed to work with the latest versions of the principal navigators: Firefox 4.0, Google Chrome 3.0, Internet Explorer 9.0. The use of non-compatible navigators or deactivation of some properties such as Javascript compatibility or blocking cookies may reduce the sites functionality. If you are accessing the site through a firewall or a porxy, make sure cookies are enabled.
(default) 190 queries took 651 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `publicacions`43432
2DESCRIBE `archivesrelations`661
3DESCRIBE `ratings`881
4DESCRIBE `comments`991
5DESCRIBE `autors`14141
6DESCRIBE `publicacions_autors`441
7DESCRIBE `autor_translations`661
8DESCRIBE `categories`991
9DESCRIBE `publicacions_categories`331
10DESCRIBE `categories_translations`661
11DESCRIBE `colleccions`771
12DESCRIBE `catcolleccions`991
13DESCRIBE `catcolleccion_translations`661
14DESCRIBE `publicacions_colleccions`441
15DESCRIBE `colleccion_translations`661
16DESCRIBE `editors`221
17DESCRIBE `publicacions_editors`991
18DESCRIBE `enquadernacions`331
19DESCRIBE `publicacions_enquadernacions`331
20DESCRIBE `enquadernacion_translations`661
21DESCRIBE `formacions`771
22DESCRIBE `catformacions`991
23DESCRIBE `catformacion_translations`661
24DESCRIBE `publicacions_formacions`331
25DESCRIBE `formacion_translations`661
26DESCRIBE `idiomas`441
27DESCRIBE `publicacions_idiomas`331
28DESCRIBE `idioma_translations`661
29DESCRIBE `instruments`661
30DESCRIBE `catinstruments`991
31DESCRIBE `catinstrument_translations`661
32DESCRIBE `publicacions_instruments`441
33DESCRIBE `instrument_translations`661
34DESCRIBE `midas`441
35DESCRIBE `publicacions_midas`331
36DESCRIBE `mida_translations`661
37DESCRIBE `retractilats`331
38DESCRIBE `publicacions_retractilats`331
39DESCRIBE `retractilat_translations`661
40DESCRIBE `newsletters`771
41DESCRIBE `newsletters_publicacions`331
42DESCRIBE `newsletter_translations`661
43DESCRIBE `rssposts`10101
44DESCRIBE `rss`551
45DESCRIBE `rssposts_publicacions`331
46DESCRIBE `publicacion_translations`661
47DESCRIBE `relacionats`441
48DESCRIBE `funcions`441
49DESCRIBE `funcion_translations`661
50DESCRIBE `archives`661
51DESCRIBE `codes`771
52DESCRIBE `users`35351
53DESCRIBE `roles`551
54DESCRIBE `archivestypes`551
55DESCRIBE `pages`991
56DESCRIBE `pages_translations`661
57DESCRIBE `orders`18181
58DESCRIBE `invoices`22221
59DESCRIBE `orderproducts`10101
60DESCRIBE `latestsearches`661
61SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` IS NULL AND `Category`.`published` = 1 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 770
62SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 78 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 330
63SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 76 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 330
64SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 75 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 550
65SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 77 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 000
66SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 79 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 220
67SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 3002 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 000
68SELECT `Category`.*, `I18n__name`.`content`, `I18n__published`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') LEFT JOIN `categories_translations` AS `I18n__published` ON (`Category`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Category' AND `I18n__published`.`field` = 'published') LEFT JOIN `categories_translations` AS `I18n__descripcio` ON (`Category`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Category' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`parent_id` = 80 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `order` DESC 000
69SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 4 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1110
70SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 41 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1110
71SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` IS NULL AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catcolleccion`.`order` DESC 660
72SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 95 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 330
73SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 94 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 660
74SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1719 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
75SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 1719 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 440
76SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 96 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
77SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 96 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 770
78SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1720 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 660
79SELECT `Catcolleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catcolleccions` AS `Catcolleccion` LEFT JOIN `catcolleccion_translations` AS `I18n__nom` ON (`Catcolleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catcolleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catcolleccion_translations` AS `I18n__descripcio` ON (`Catcolleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catcolleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catcolleccion_translations` AS `I18n__url` ON (`Catcolleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catcolleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccion_translations` AS `I18n__published` ON (`Catcolleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catcolleccion' AND `I18n__published`.`field` = 'published') WHERE `Catcolleccion`.`parent_id` = 1721 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
80SELECT `Colleccion`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__descripcio` ON (`Colleccion`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Colleccion' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `colleccion_translations` AS `I18n__published` ON (`Colleccion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Colleccion' AND `I18n__published`.`field` = 'published') WHERE `Colleccion`.`catcolleccion_id` = 1721 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 13130
81SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` IS NULL AND `Catformacion`.`published` = 1 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC 330
82SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 147 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC 000
83SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 147 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC 880
84SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 145 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC 000
85SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 145 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC 18180
86SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` = 146 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC 000
87SELECT `Formacion`.*, `I18n__nom`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `formacions` AS `Formacion` LEFT JOIN `formacion_translations` AS `I18n__nom` ON (`Formacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Formacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `formacion_translations` AS `I18n__url` ON (`Formacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Formacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `formacion_translations` AS `I18n__published` ON (`Formacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Formacion' AND `I18n__published`.`field` = 'published') LEFT JOIN `formacion_translations` AS `I18n__metadescription` ON (`Formacion`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Formacion' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Formacion`.`catformacion_id` = 146 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `Formacion`.`nom` ASC 39390
88SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` IS NULL AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catinstrument`.`order` DESC 660
89SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 71 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 550
90SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 71 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
91SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 70 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 550
92SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 70 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
93SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 73 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 440
94SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 73 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
95SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 72 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 550
96SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 72 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
97SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 74 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
98SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 74 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 64640
99SELECT `Catinstrument`.*, `I18n__nom`.`content`, `I18n__descripcio`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__descripcio` ON (`Catinstrument`.`id` = `I18n__descripcio`.`foreign_key` AND `I18n__descripcio`.`model` = 'Catinstrument' AND `I18n__descripcio`.`field` = 'descripcio') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `catinstrument_translations` AS `I18n__published` ON (`Catinstrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catinstrument' AND `I18n__published`.`field` = 'published') WHERE `Catinstrument`.`parent_id` = 1699 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 000
100SELECT `Instrument`.*, `I18n__nom`.`content`, `I18n__plural`.`content`, `I18n__abreviacio`.`content`, `I18n__url`.`content`, `I18n__published`.`content`, `I18n__metadescription`.`content` FROM `instruments` AS `Instrument` LEFT JOIN `instrument_translations` AS `I18n__nom` ON (`Instrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Instrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `instrument_translations` AS `I18n__plural` ON (`Instrument`.`id` = `I18n__plural`.`foreign_key` AND `I18n__plural`.`model` = 'Instrument' AND `I18n__plural`.`field` = 'plural') LEFT JOIN `instrument_translations` AS `I18n__abreviacio` ON (`Instrument`.`id` = `I18n__abreviacio`.`foreign_key` AND `I18n__abreviacio`.`model` = 'Instrument' AND `I18n__abreviacio`.`field` = 'abreviacio') LEFT JOIN `instrument_translations` AS `I18n__url` ON (`Instrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Instrument' AND `I18n__url`.`field` = 'url') LEFT JOIN `instrument_translations` AS `I18n__published` ON (`Instrument`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Instrument' AND `I18n__published`.`field` = 'published') LEFT JOIN `instrument_translations` AS `I18n__metadescription` ON (`Instrument`.`id` = `I18n__metadescription`.`foreign_key` AND `I18n__metadescription`.`model` = 'Instrument' AND `I18n__metadescription`.`field` = 'metadescription') WHERE `Instrument`.`catinstrument_id` = 1699 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__plural`.`locale` = 'en_gb' AND `I18n__abreviacio`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' AND `I18n__metadescription`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 32320
101SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`id` = 42 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' LIMIT 1110
102SELECT `Page`.`id`, `I18n__name`.`content`, `I18n__url`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') WHERE `Page`.`parent_id` = 43 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `Page`.`order` DESC 550
103SELECT `Latestsearch`.`id`, `Latestsearch`.`text`, `Latestsearch`.`q`, `Latestsearch`.`url`, `Latestsearch`.`count`, `Latestsearch`.`lang` FROM `latestsearches` AS `Latestsearch` WHERE 1 = 1 ORDER BY `count` DESC LIMIT 3030300
104SELECT `Role`.`id`, `Role`.`name`, `Role`.`descompte`, `Role`.`descompte_afiliat`, `Role`.`descompte_usuari` FROM `roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1110
105SELECT `Catformacion`.*, `I18n__nom`.`content`, `I18n__descripcion`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `catformacions` AS `Catformacion` LEFT JOIN `catformacion_translations` AS `I18n__nom` ON (`Catformacion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catformacion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catformacion_translations` AS `I18n__descripcion` ON (`Catformacion`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Catformacion' AND `I18n__descripcion`.`field` = 'descripcion') LEFT JOIN `catformacion_translations` AS `I18n__url` ON (`Catformacion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catformacion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catformacion_translations` AS `I18n__published` ON (`Catformacion`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Catformacion' AND `I18n__published`.`field` = 'published') WHERE `Catformacion`.`parent_id` IS NULL AND `Catformacion`.`published` = '1' AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__descripcion`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `Catformacion`.`order` DESC 330
106SELECT `Catinstrument`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `catinstruments` AS `Catinstrument` LEFT JOIN `catinstrument_translations` AS `I18n__nom` ON (`Catinstrument`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Catinstrument' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `catinstrument_translations` AS `I18n__url` ON (`Catinstrument`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Catinstrument' AND `I18n__url`.`field` = 'url') WHERE `Catinstrument`.`parent_id` IN (70,71,72,73,74,1699) AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' ORDER BY `I18n__nom`.`content` ASC 19190
107SELECT `Page`.*, `I18n__name`.`content`, `I18n__html`.`content`, `I18n__url`.`content`, `I18n__published`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__html` ON (`Page`.`id` = `I18n__html`.`foreign_key` AND `I18n__html`.`model` = 'Page' AND `I18n__html`.`field` = 'html') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') LEFT JOIN `pages_translations` AS `I18n__published` ON (`Page`.`id` = `I18n__published`.`foreign_key` AND `I18n__published`.`model` = 'Page' AND `I18n__published`.`field` = 'published') WHERE `Page`.`published` = '1' AND `I18n__name`.`locale` = 'en_gb' AND `I18n__html`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' AND `I18n__published`.`locale` = 'en_gb' ORDER BY `order` DESC 41410
108SELECT `I18n__name`.`content`, `I18n__url`.`content` FROM `pages` AS `Page` LEFT JOIN `pages_translations` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name') LEFT JOIN `pages_translations` AS `I18n__url` ON (`Page`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Page' AND `I18n__url`.`field` = 'url') WHERE `Page`.`id` = 56 AND `I18n__name`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
109SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '0%') WHERE `Publicacion`.`titol` LIKE '0%' 113
110SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '1%') WHERE `Publicacion`.`titol` LIKE '1%' 113
111SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE '2%') WHERE `Publicacion`.`titol` LIKE '2%' 113
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%' 113
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%' 112
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%' 112
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%' 112
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%' 112
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%' 112
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%' 112
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%' 1110
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%' 117
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%' 1119
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%' 1116
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%' 1123
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%' 116
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%' 114
127SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'I%') WHERE `Publicacion`.`titol` LIKE 'I%' 114
128SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'J%') WHERE `Publicacion`.`titol` LIKE 'J%' 113
129SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'K%') WHERE `Publicacion`.`titol` LIKE 'K%' 112
130SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'L%') WHERE `Publicacion`.`titol` LIKE 'L%' 1112
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%' 1110
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%' 113
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%' 113
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%' 115
136SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'R%') WHERE `Publicacion`.`titol` LIKE 'R%' 114
137SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'S%') WHERE `Publicacion`.`titol` LIKE 'S%' 1111
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%' 1110
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%' 113
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%' 114
141SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'W%') WHERE `Publicacion`.`titol` LIKE 'W%' 112
142SELECT COUNT(DISTINCT(`Publicacion`.`id`)) AS count FROM `publicacions` AS `Publicacion` INNER JOIN publicacion_translations AS `PublicacionI18n` ON (`Publicacion`.`id` = `PublicacionI18n`.`foreign_key` AND `PublicacionI18n`.`model` = 'Publicacion' AND `PublicacionI18n`.`locale` = 'en_gb' AND `PublicacionI18n`.`field` = 'titol' AND `PublicacionI18n`.`content` LIKE 'X%') WHERE `Publicacion`.`titol` LIKE 'X%' 112
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%' 112
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%' 112
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 1190
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, 777285
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 994
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) 000
149SELECT `Comment`.`id`, `Comment`.`publicacion_id`, `Comment`.`replay_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`replay_id`=0 AND `Comment`.`publicacion_id` IN (1945, 1930, 1926, 1927, 1928, 1929, 1935) ORDER BY `Comment`.`id` ASC 000
150SELECT `Autor`.`id`, `Autor`.`nom`, `Autor`.`cognom`, `Autor`.`2cognom`, `Autor`.`curriculum`, `Autor`.`data_desconeguda`, `Autor`.`data_naixement`, `Autor`.`nomes_any_naixement`, `Autor`.`nomes_any_defuncio`, `Autor`.`defuncio`, `Autor`.`data_defuncio`, `Autor`.`data_defuncio_desconeguda`, `Autor`.`url`, `Autor`.`published`, `PublicacionsAutor`.`id`, `PublicacionsAutor`.`autor_id`, `PublicacionsAutor`.`publicacion_id`, `PublicacionsAutor`.`funcion_id` FROM `autors` AS `Autor` JOIN `publicacions_autors` AS `PublicacionsAutor` ON (`PublicacionsAutor`.`publicacion_id` IN (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 771
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`) 770
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`) 770
155SELECT `Formacion`.`id`, `Formacion`.`nom`, `Formacion`.`catformacion_id`, `Formacion`.`order`, `Formacion`.`url`, `Formacion`.`published`, `Formacion`.`metadescription`, `PublicacionsFormacion`.`id`, `PublicacionsFormacion`.`publicacion_id`, `PublicacionsFormacion`.`formacion_id` FROM `formacions` AS `Formacion` JOIN `publicacions_formacions` AS `PublicacionsFormacion` ON (`PublicacionsFormacion`.`publicacion_id` IN (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsFormacion`.`formacion_id` = `Formacion`.`id`) 000
156SELECT `Idioma`.`id`, `Idioma`.`nom`, `Idioma`.`published`, `Idioma`.`url`, `PublicacionsIdioma`.`id`, `PublicacionsIdioma`.`publicacion_id`, `PublicacionsIdioma`.`idioma_id` FROM `idiomas` AS `Idioma` JOIN `publicacions_idiomas` AS `PublicacionsIdioma` ON (`PublicacionsIdioma`.`publicacion_id` IN (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsIdioma`.`idioma_id` = `Idioma`.`id`) 770
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 000
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`) 770
159SELECT `Retractilat`.`id`, `Retractilat`.`nom`, `Retractilat`.`published`, `PublicacionsRetractilat`.`id`, `PublicacionsRetractilat`.`publicacion_id`, `PublicacionsRetractilat`.`retractilat_id` FROM `retractilats` AS `Retractilat` JOIN `publicacions_retractilats` AS `PublicacionsRetractilat` ON (`PublicacionsRetractilat`.`publicacion_id` IN (1945, 1930, 1926, 1927, 1928, 1929, 1935) AND `PublicacionsRetractilat`.`retractilat_id` = `Retractilat`.`id`) 770
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`) 551
161SELECT `Rsspost`.`id`, `Rsspost`.`rss_id`, `Rsspost`.`titol`, `Rsspost`.`html`, `Rsspost`.`data_creacio`, `Rsspost`.`data_ordenacio`, `Rsspost`.`data_publica`, `Rsspost`.`slug`, `Rsspost`.`extlink`, `Rsspost`.`published`, `RsspostsPublicacion`.`id`, `RsspostsPublicacion`.`rsspost_id`, `RsspostsPublicacion`.`publicacion_id` FROM `rssposts` AS `Rsspost` JOIN `rssposts_publicacions` AS `RsspostsPublicacion` ON (`RsspostsPublicacion`.`publicacion_id` IN (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 110
163SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1797 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1111
164SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 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 1110
166SELECT `Colleccion`.`id`, `I18n__nom`.`content`, `I18n__url`.`content` FROM `colleccions` AS `Colleccion` LEFT JOIN `colleccion_translations` AS `I18n__nom` ON (`Colleccion`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Colleccion' AND `I18n__nom`.`field` = 'nom') LEFT JOIN `colleccion_translations` AS `I18n__url` ON (`Colleccion`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Colleccion' AND `I18n__url`.`field` = 'url') LEFT JOIN `catcolleccions` AS `Catcolleccion` ON (`Colleccion`.`catcolleccion_id` = `Catcolleccion`.`id`) WHERE `Colleccion`.`id` = 1804 AND `I18n__nom`.`locale` = 'en_gb' AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
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 1110
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 1110
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 1110
170SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 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 1110
172SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
173SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 75 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
174SELECT `Category`.`id`, `I18n__url`.`content` FROM `categories` AS `Category` LEFT JOIN `categories_translations` AS `I18n__url` ON (`Category`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Category' AND `I18n__url`.`field` = 'url') WHERE `Category`.`id` = 81 AND `I18n__url`.`locale` = 'en_gb' LIMIT 1110
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 1110
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 1110
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 1110
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 1110
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 1110
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 1111
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 1111