<hr><b><font color=red><pre>Došlo k chybě dne 20.05.2013 v 06:13:52</font><br>3: Error writing file '/var/log/mysq.log' (Errcode: 28)<br>Dotaz: <br>SELECT
      DataObjects.id,
      DataObjects.type,
      DataObjects.identifier,
      Blocks.id AS bid,
      Blocks.identifier AS block_identifier
     ,textarea_table.data AS textarea_data
      ,textarea_table.id AS textarea_id
      ,h_textarea_table.data AS h_textarea_data
      ,h_textarea_table.id AS h_textarea_id
      ,text_table.data AS text_data
      ,text_table.id AS text_id
      ,h_text_table.data AS h_text_data
      ,h_text_table.id AS h_text_id
      ,wysiwyg_table.data AS wysiwyg_data
      ,wysiwyg_table.id AS wysiwyg_id
      ,h_wysiwyg_table.data AS h_wysiwyg_data
      ,h_wysiwyg_table.id AS h_wysiwyg_id
      ,include_table.data AS include_data
      ,include_table.id AS include_id
      ,link_table.data AS link_data
      ,link_table.id AS link_id
      ,h_link_table.data AS h_link_data
      ,h_link_table.id AS h_link_id
      ,survey_table.data AS survey_data
      ,survey_table.id AS survey_id
      ,news_table.data AS news_data
      ,news_table.id AS news_id
      ,file_table.data AS file_data
      ,file_table.id AS file_id
      ,h_file_table.data AS h_file_data
      ,h_file_table.id AS h_file_id
      ,h_fileinfo_table.data AS h_fileinfo_data
      ,h_fileinfo_table.id AS h_fileinfo_id
      ,structure_tree_table.data AS structure_tree_data
      ,structure_tree_table.id AS structure_tree_id
      ,map_tree_table.data AS map_tree_data
      ,map_tree_table.id AS map_tree_id
      ,articles_table.data AS articles_data
      ,articles_table.id AS articles_id
      ,forum_table.data AS forum_data
      ,forum_table.id AS forum_id
      ,forum_category_table.data AS forum_category_data
      ,forum_category_table.id AS forum_category_id
      ,switch_table.data AS switch_data
      ,switch_table.id AS switch_id
      ,gallery_link_table.data AS gallery_link_data
      ,gallery_link_table.id AS gallery_link_id
      ,gallery_pict_table.data AS gallery_pict_data
      ,gallery_pict_table.id AS gallery_pict_id
      ,gallery_file_table.data AS gallery_file_data
      ,gallery_file_table.id AS gallery_file_id
      ,prodcatalogue_table.data AS prodcatalogue_data
      ,prodcatalogue_table.id AS prodcatalogue_id
      ,enum_table.data AS enum_data
      ,enum_table.id AS enum_id
      ,banner_table.data AS banner_data
      ,banner_table.id AS banner_id
      ,datetime_table.data AS datetime_data
      ,datetime_table.id AS datetime_id
      ,quiz_table.data AS quiz_data
      ,quiz_table.id AS quiz_id
      ,faq_table.data AS faq_data
      ,faq_table.id AS faq_id
     
       FROM `mcms_structure_data_objects` AS DataObjects
       LEFT JOIN `mcms_structure_blocks` AS Blocks
        ON Blocks.id=DataObjects.id_block
     LEFT JOIN `mcms_structure_data_object_textareas` AS textarea_table
          ON DataObjects.id=textarea_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_textareas` AS h_textarea_table
          ON DataObjects.id=h_textarea_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_texts` AS text_table
          ON DataObjects.id=text_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_texts` AS h_text_table
          ON DataObjects.id=h_text_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_wysiwygs` AS wysiwyg_table
          ON DataObjects.id=wysiwyg_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_wysiwygs` AS h_wysiwyg_table
          ON DataObjects.id=h_wysiwyg_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_includes` AS include_table
          ON DataObjects.id=include_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_links` AS link_table
          ON DataObjects.id=link_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_links` AS h_link_table
          ON DataObjects.id=h_link_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_surveys` AS survey_table
          ON DataObjects.id=survey_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_news` AS news_table
          ON DataObjects.id=news_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_files` AS file_table
          ON DataObjects.id=file_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_files` AS h_file_table
          ON DataObjects.id=h_file_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_files` AS h_fileinfo_table
          ON DataObjects.id=h_fileinfo_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_tree` AS structure_tree_table
          ON DataObjects.id=structure_tree_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_tree` AS map_tree_table
          ON DataObjects.id=map_tree_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_articles` AS articles_table
          ON DataObjects.id=articles_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_forum` AS forum_table
          ON DataObjects.id=forum_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_forum_category` AS forum_category_table
          ON DataObjects.id=forum_category_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_switches` AS switch_table
          ON DataObjects.id=switch_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS gallery_link_table
          ON DataObjects.id=gallery_link_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS gallery_pict_table
          ON DataObjects.id=gallery_pict_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS gallery_file_table
          ON DataObjects.id=gallery_file_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS prodcatalogue_table
          ON DataObjects.id=prodcatalogue_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_varchar255` AS enum_table
          ON DataObjects.id=enum_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS banner_table
          ON DataObjects.id=banner_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS datetime_table
          ON DataObjects.id=datetime_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS quiz_table
          ON DataObjects.id=quiz_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS faq_table
          ON DataObjects.id=faq_table.id_data_object
     
       WHERE
        id_version=14
       GROUP BY
        Blocks.identifier, DataObjects.type, DataObjects.identifier
    </pre></b><hr><br></b><hr><hr><b><font color=red><pre>Došlo k chybě dne 20.05.2013 v 06:13:52</font><br>3: Error writing file '/var/log/mysq.log' (Errcode: 28)<br>Dotaz: <br>SELECT
      DataObjects.id,
      DataObjects.type,
      DataObjects.identifier,
      Blocks.id AS bid,
      Blocks.identifier AS block_identifier
     ,textarea_table.data AS textarea_data
      ,textarea_table.id AS textarea_id
      ,h_textarea_table.data AS h_textarea_data
      ,h_textarea_table.id AS h_textarea_id
      ,text_table.data AS text_data
      ,text_table.id AS text_id
      ,h_text_table.data AS h_text_data
      ,h_text_table.id AS h_text_id
      ,wysiwyg_table.data AS wysiwyg_data
      ,wysiwyg_table.id AS wysiwyg_id
      ,h_wysiwyg_table.data AS h_wysiwyg_data
      ,h_wysiwyg_table.id AS h_wysiwyg_id
      ,include_table.data AS include_data
      ,include_table.id AS include_id
      ,link_table.data AS link_data
      ,link_table.id AS link_id
      ,h_link_table.data AS h_link_data
      ,h_link_table.id AS h_link_id
      ,survey_table.data AS survey_data
      ,survey_table.id AS survey_id
      ,news_table.data AS news_data
      ,news_table.id AS news_id
      ,file_table.data AS file_data
      ,file_table.id AS file_id
      ,h_file_table.data AS h_file_data
      ,h_file_table.id AS h_file_id
      ,h_fileinfo_table.data AS h_fileinfo_data
      ,h_fileinfo_table.id AS h_fileinfo_id
      ,structure_tree_table.data AS structure_tree_data
      ,structure_tree_table.id AS structure_tree_id
      ,map_tree_table.data AS map_tree_data
      ,map_tree_table.id AS map_tree_id
      ,articles_table.data AS articles_data
      ,articles_table.id AS articles_id
      ,forum_table.data AS forum_data
      ,forum_table.id AS forum_id
      ,forum_category_table.data AS forum_category_data
      ,forum_category_table.id AS forum_category_id
      ,switch_table.data AS switch_data
      ,switch_table.id AS switch_id
      ,gallery_link_table.data AS gallery_link_data
      ,gallery_link_table.id AS gallery_link_id
      ,gallery_pict_table.data AS gallery_pict_data
      ,gallery_pict_table.id AS gallery_pict_id
      ,gallery_file_table.data AS gallery_file_data
      ,gallery_file_table.id AS gallery_file_id
      ,prodcatalogue_table.data AS prodcatalogue_data
      ,prodcatalogue_table.id AS prodcatalogue_id
      ,enum_table.data AS enum_data
      ,enum_table.id AS enum_id
      ,banner_table.data AS banner_data
      ,banner_table.id AS banner_id
      ,datetime_table.data AS datetime_data
      ,datetime_table.id AS datetime_id
      ,quiz_table.data AS quiz_data
      ,quiz_table.id AS quiz_id
      ,faq_table.data AS faq_data
      ,faq_table.id AS faq_id
     
       FROM `mcms_structure_data_objects` AS DataObjects
       LEFT JOIN `mcms_structure_blocks` AS Blocks
        ON Blocks.id=DataObjects.id_block
     LEFT JOIN `mcms_structure_data_object_textareas` AS textarea_table
          ON DataObjects.id=textarea_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_textareas` AS h_textarea_table
          ON DataObjects.id=h_textarea_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_texts` AS text_table
          ON DataObjects.id=text_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_texts` AS h_text_table
          ON DataObjects.id=h_text_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_wysiwygs` AS wysiwyg_table
          ON DataObjects.id=wysiwyg_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_wysiwygs` AS h_wysiwyg_table
          ON DataObjects.id=h_wysiwyg_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_includes` AS include_table
          ON DataObjects.id=include_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_links` AS link_table
          ON DataObjects.id=link_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_links` AS h_link_table
          ON DataObjects.id=h_link_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_surveys` AS survey_table
          ON DataObjects.id=survey_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_news` AS news_table
          ON DataObjects.id=news_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_files` AS file_table
          ON DataObjects.id=file_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_files` AS h_file_table
          ON DataObjects.id=h_file_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_files` AS h_fileinfo_table
          ON DataObjects.id=h_fileinfo_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_tree` AS structure_tree_table
          ON DataObjects.id=structure_tree_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_tree` AS map_tree_table
          ON DataObjects.id=map_tree_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_articles` AS articles_table
          ON DataObjects.id=articles_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_forum` AS forum_table
          ON DataObjects.id=forum_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_forum_category` AS forum_category_table
          ON DataObjects.id=forum_category_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_switches` AS switch_table
          ON DataObjects.id=switch_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS gallery_link_table
          ON DataObjects.id=gallery_link_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS gallery_pict_table
          ON DataObjects.id=gallery_pict_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS gallery_file_table
          ON DataObjects.id=gallery_file_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS prodcatalogue_table
          ON DataObjects.id=prodcatalogue_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_varchar255` AS enum_table
          ON DataObjects.id=enum_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS banner_table
          ON DataObjects.id=banner_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS datetime_table
          ON DataObjects.id=datetime_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS quiz_table
          ON DataObjects.id=quiz_table.id_data_object
      LEFT JOIN `mcms_structure_data_object_int11` AS faq_table
          ON DataObjects.id=faq_table.id_data_object
     
       WHERE
        id_version=42
       GROUP BY
        Blocks.identifier, DataObjects.type, DataObjects.identifier
    </pre></b><hr><br></b><hr>


<p></p>

<!-- autori -->
      
<table class="katalog_hledani">
        <tr>
          <th colspan="2">{stezejni_autori|Stejn autoi}</th>
        </tr>
        <tr class="sudy">
<td>hudba</td><td>Béla Bartók</td>        </tr>
      </table>
<!-- stezejni interti -->
      <table class="katalog_hledani">
        <tr>
          <th colspan="2">{stezejni_interpreti|Stejn interpreti}</th>
        </tr>
        <tr class="sudy">
          <td>dirigent</td><td>Karel Ančerl</td>
        </tr>
        <tr class="lichy">
          <td>klavír</td><td>Eva Bernáthová</td>
        </tr>
        <tr class="sudy">
          <td>housle</td><td>André Gertler</td>
        </tr>
      </table>
      

<!-- stezejni hudebni telesa -->

      <table class="katalog_hledani">
        <tr>
          <th colspan="2">{hudebni_telesa|Hudebn tlesa}</th>
        </tr>
        <tr class="sudy">
          <td><a href="#" onclick="skladba('0','t');return false;">Česká filharmonie</a></td><td>(dirigent: Karel Ančerl)</td>
        </tr>
Error, 
								SELECT DISTINCT
									
									CONCAT(cOsoby.Jmeno, cOsoby.Prijmeni, cRole.Nazev) as jmeno_prijmeni_nazev,
									cOsoby.Jmeno,
									cOsoby.JmenoENG, 
									cOsoby.Prijmeni, 
									cOsoby.PrijmeniENG, 
									cRole.Nazev, 
									cRole.NazevENG
									
								FROM 
									cTelesa
			
								INNER JOIN Sestavy ON cTelesa.IDTelesa = Sestavy.IDTelesa 
								INNER JOIN OsobaSestavy ON Sestavy.IDSestavy = OsobaSestavy.IDSestavy 
								INNER JOIN cOsoby ON OsobaSestavy.IDOsoby = cOsoby.IDOsoby 
								INNER JOIN cRole ON OsobaSestavy.IDRole = cRole.IDRole 
								INNER JOIN SkladbySestavy ON Sestavy.IDSestavy = SkladbySestavy.IDSestavy 
								INNER JOIN Skladby ON SkladbySestavy.IDSkladby = Skladby.IDSkladby 
								INNER JOIN Nosice ON Skladby.IDNosice = Nosice.IDNosice 
								INNER JOIN Tituly ON Nosice.IDTitulu = Tituly.IDTItulu 
								WHERE 
									cTelesa.IDTelesa = '30'
										AND
									Tituly.IDTitulu = '2002739'
								GROUP BY jmeno_prijmeni_nazev 
								ORDER BY OsobaSestavy.Poradi
							 3 : Error writing file '/var/log/mysq.log' (Errcode: 28).<br>
/cs/katalog/databaze-titulu/detail-titulu/
{stezejni_interpreti\|Stejn interpreti}
dirigent	Karel Ančerl
klavír	Eva Bernáthová
housle	André Gertler