SELECT a.id as artist_id, a.artist_name, a.picture, a.review, a.country, a.city, g. genre_name from jos_muscol_artists a Inner Join jos_muscol_genres g on g.id= a.genre_id where a.id = 'sound' Limit 1             
         </div>   
         

             
            
         
          </div>

        <!-- sidebar -->
        <div class="col-md-3">
        <br />
            


	
  <div class="d-flex flex-column" >
    <div class="p-2 bg-info" style="background-color: #81181c !important; color:#ffffff"><h5>Sponsored</h5></div>
</div>

<div class="card bg-light mb-3" style="max-width:100%">
    <div class="card-body" style="padding:0.5em; font-size:1.2em">

<a href="https://www.malawi-music.com/N/2046-nic-thindwa/12810-kalikonse-mukaona/19128-kalikonse-mukaona-brenda-kadammanja-ft-nic-thindwa"><img style="max-width: 100%" src="https://www.malawi-music.com/timthumb.php?src=http://www.malawi-music.com/images/albums/Kalikose%20Mukawona%20Brenda%20Okada%20Now%20out.jpg&w=750&q=90" /></a>




</div>   
   </div>   
     


   
   

	
    <br/> 

	  
    

	    





<div class="d-flex flex-column" >
    <div class="p-2 bg-info" style="background-color: #be8037 !important; color:#ffffff"><h5>Featured</h5></div>
</div>

<iframe width="100%" height="260" src="https://www.youtube.com/embed/videoseries?list=PLk6gYwyt0Wc1e-IIMfU-z88--ubbZeRf4" frameborder="0" allowfullscreen></iframe>



<div class="d-flex flex-column" >
    <div class="p-2 bg-info" style="background-color: #be8037 !important; color:#ffffff"><h5>Top 10 Chart</h5></div>
</div>


<div class="card bg-light mb-3" style="max-width:100%">
    <div class="card-body">
        <p class="card-text"><ul style="padding: 0; font-size:1.2em">




                 <li class="tracksong" style="background-color: #eeeeee;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">1</strong>.  
                        <a href='https://www.malawi-music.com/P/325-provoice/12749-njinga-provoice-martse-prod-by-cuff-b-jimz-kuwale'>Provoice - Njinga - ProVoice & Martse (Prod. By Cuff-B Jimz & Kuwale)</a></li> <li class="tracksong" style="background-color: #ffffff;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">2</strong>.  
                        <a href='https://www.malawi-music.com/J/245-janta/12750-ex-lover-onesimus-janta'>Janta - Ex Lover (Onesimus & Janta)</a></li> <li class="tracksong" style="background-color: #eeeeee;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">3</strong>.  
                        <a href='https://www.malawi-music.com/D/5-dan-lu/12703-24-7'>Dan Lu - 24-7</a></li> <li class="tracksong" style="background-color: #ffffff;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">4</strong>.  
                        <a href='https://www.malawi-music.com/P/325-provoice/12702-phonebooth-martse-tribute-prod-by-cuff-b-jimz-c-kay'>Provoice - PhoneBooth (Martse Tribute) Prod By Cuff-B Jimz & C-kay</a></li> <li class="tracksong" style="background-color: #eeeeee;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">5</strong>.  
                        <a href='https://www.malawi-music.com/M/276-malinga/12698-malinga-pamalo-prod-dj-sley'>Malinga - Malinga - Pamalo (Prod Dj. Sley)</a></li> <li class="tracksong" style="background-color: #ffffff;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">6</strong>.  
                        <a href='https://www.malawi-music.com/M/1805-martin-anjelz/12654-sitinati-martin-anjelz-vj-ice-ft-rina-hyphen-quest-nepman-black-jack-avokado-charisma-achina-ghattah-ase-dirty-flow-k-banton-vice-roy-spyral-mwenya-jermaino-afana-ceez-prod-martin-anjelz'>Martin Anjelz - Sitinati (Martin Anjelz & Vj Ice ft Rina, Hyphen, Quest, Nepman, Black Jack, Avokado, Charisma, Achina Ghattah Ase, Dirty Flow, K Banton, Vice Roy, Spyral Mwenya, Jermaino & Afana Ceez) Prod. Martin Anjelz</a></li> <li class="tracksong" style="background-color: #eeeeee;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">7</strong>.  
                        <a href='https://www.malawi-music.com/A/739-achina-gattah-ase/12697-nazolowera-ft-fredokiss-prod-martin-anjelz'>Achina Gattah Ase - Nazolowera ft. Fredokiss (Prod. Martin Anjelz)</a></li> <li class="tracksong" style="background-color: #ffffff;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">8</strong>.  
                        <a href='https://www.malawi-music.com/D/3711-driemo/12625-compensation-prod-taktic-x-fat-nyanda'>Driemo - Compensation Prod. Taktic x Fat Nyanda)</a></li> <li class="tracksong" style="background-color: #eeeeee;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">9</strong>.  
                        <a href='https://www.malawi-music.com/B/297-blaze/12621-tulukani-ft--achina-gattah-x-malinga-x-bee-jay-prod-dr-beats-x-king-duda'>Blaze - Tulukani ft  Achina Gattah x Malinga x Bee Jay (Prod. Dr Beats x King Duda)</a></li> <li class="tracksong" style="background-color: #ffffff;; padding-top:7px; padding-bottom:7px;color:#be8037 !important;">
                        <strong style="color:#be8037;">10</strong>.  
                        <a href='https://www.malawi-music.com/T/3852-tremour/12730-anaubebetsa-prod-drue'>Tremour - Anaubebetsa (Prod. Drue)</a></li>

            </ul></p>
    </div>
</div>





<div class="d-flex flex-column" >
    <div class="p-2 bg-info" style="background-color: #be8037 !important; color:#ffffff"><h5>The Nation Malawi - Ads</h5></div>
</div>

<div class="card bg-light mb-3" style="padding:0px;max-width:100%">
    <div class="card-body" style="padding:0px;font-size:1.2em">

        <p class="card-text" style="padding:0px;">

             <script src="https://cdn.jsdelivr.net/npm/@splidejs/splide@latest/dist/js/splide.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@splidejs/splide@latest/dist/css/splide.min.css">
 <div class="splide">
    <div class="splide__track">
        <ul class="splide__list">
			<li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img src="/ads/17.jpeg" alt="" style="max-width:100%"></a></li>
			<!--<li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img src="/ads/12.jpeg" alt="" style="max-width:100%"></a></li>
            
            <li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img src="/ads/9.jpeg" alt="" style="max-width:100%"></a></li>
			<li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img src="/ads/five.jpg" alt="" style="max-width:100%"></a></li>
            <li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img style="max-width:100%" src="/ads/one.jpeg" alt=""></a></li>
            <li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img style="max-width:100%" src="/ads/two.jpeg" alt=""></a></li>
            <li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img style="max-width:100%" src="/ads/three.jpeg" alt=""></a></li>
            <li class="splide__slide"><a href="http://www.mwnation.com/epaper"><img style="max-width:100%" src="/ads/four.jpeg" alt=""></a></li> -->
        </ul>
    </div>
</div>

<script>
    new Splide( '.splide' ).mount();
</script>

        </p>
    </div>
</div>






<div class="d-flex flex-column" >
    <div class="p-2 bg-info" style="background-color: #be8037 !important; color:#ffffff"><h5>News from the Blog</h5></div>
</div>

<div class="card bg-light mb-3" style="max-width:100%">
    <div class="card-body" style="padding:0.5em; font-size:1.2em">

        <p class="card-text">

                      <!--<h4>Upcoming Events</h4>-->
        <ul style=" list-style-type: circle;  background-color:#eeeeee;;">            <li  style="margin: 7px 0;"><a target="_blank" href="https://blog.malawi-music.com/2022/07/eli-njuchi-to-launch-red-flag-album-in-mangochi/"><h7>ELi Njuchi To Launch ‘Red Flag’ Album In Mangochi</h7></a></li> 
            <!--<div></div>-->
                        <li  style="margin: 7px 0;"><a target="_blank" href="https://blog.malawi-music.com/2022/07/piksy-drops-anana-visuals/"><h7>Piksy Drops ‘Anana’ Visuals</h7></a></li> 
            <!--<div></div>-->
                        <li  style="margin: 7px 0;"><a target="_blank" href="https://blog.malawi-music.com/2022/07/boy-magic-to-undergo-mental-treatment/"><h7>Boy Magic To Undergo Mental Treatment</h7></a></li> 
            <!--<div></div>-->
                        <li  style="margin: 7px 0;"><a target="_blank" href="https://blog.malawi-music.com/2022/07/renowned-musician-keturah-off-to-america/"><h7>Renowned Musician Keturah off to America</h7></a></li> 
            <!--<div></div>-->
                        <li  style="margin: 7px 0;"><a target="_blank" href="https://blog.malawi-music.com/2022/06/musician-med-c-magic-fingers-entertainment-part-ways/"><h7>Musician Med C, Magic Fingers Entertainment part ways</h7></a></li> 
            <!--<div></div>-->
                    </ul>
        
        


        </p>
    </div>
</div>

<div class="d-flex flex-column">
    <div class="p-2 bg-info" style="background-color: #be8037 !important; color:#ffffff"><h5>We are on Facebook</h5></div>
</div>

<div class="fb-page" data-href="https://www.facebook.com/musicfrommalawi/" data-tabs="timeline" data-small-header="true" data-adapt-container-width="true" data-hide-cover="false" data-show-facepile="true"><blockquote cite="https://www.facebook.com/musicfrommalawi/" class="fb-xfbml-parse-ignore"><a href="https://www.facebook.com/musicfrommalawi/">Music From Malawi</a></blockquote></div>
<br>
<br>

<div class="d-flex flex-column" >
    <div class="p-2 bg-info" style="background-color: #be8037 !important; color:#ffffff"><h5>Follow us on IG</h5></div>
</div>
<!-- LightWidget WIDGET --><script src="https://cdn.lightwidget.com/widgets/lightwidget.js"></script><iframe src="https://cdn.lightwidget.com/widgets/8cf21702cbdc5ca68670aa66c811793e.html" scrolling="no" allowtransparency="true" class="lightwidget-widget" style="width:100%;border:0;overflow:hidden;"></iframe>





<!-- facebook plugin starts -->
<div id="fb-root"></div>
<script>(function(d, s, id) {
    var js, fjs = d.getElementsByTagName(s)[0];
    if (d.getElementById(id)) return;
    js = d.createElement(s); js.id = id;
    js.src = 'https://connect.facebook.net/en_US/sdk.js#xfbml=1&version=v3.2';
    fjs.parentNode.insertBefore(js, fjs);
    }(document, 'script', 'facebook-jssdk'));</script>


        </div>
    </div>
</div>             




              

             
                

        


<!-- footer -->
<!-- Footer -->
<footer class="page-footer font-small" style="background-color:#343a40; color:white;">

    <div style="background-color: #be8037;">
      <div class="container-fluid">

        <!-- Grid row-->
        <div class="row py-4 d-flex align-items-center">

          <!-- Grid column -->
          <div class="col-md-6 col-lg-5 text-center text-md-left mb-4 mb-md-0" style="color:white;">
            <h6 class="mb-0">To stay up-to-date with the latest find us on <a style="color:#ffffff !important;" href="https://www.facebook.com/musicfrommalawi" target="_blank">Facebook</a> and follow us on <a style="color:#ffffff !important;" href="https://twitter.com/MusicFromMalawi" target="_blank">Twitter</a>.</h6>
          </div>
          <!-- Grid column -->

          <!-- Grid column -->
          <div class="col-md-6 col-lg-7 text-center text-md-right" style="color:white;">

            <!-- Facebook -->
            <a href="http://www.facebook.com/musicfrommalawi" target="_blank" id="footerlinks" ><i class="fab fa-facebook-f white-text mr-4"> </i>
            </a>
            <!-- Twitter -->
            <a href="https://twitter.com/MusicFromMalawi" target="_blank" id="footerlinks" >
              <i class="fab fa-twitter white-text mr-4"> </i>
            </a>
            <!--Instagram-->
            <a href="https://www.instagram.com/nyimbo_zachimalawi/" target="_blank" id="footerlinks">
              <i class="fab fa-instagram white-text"> </i>
            </a>

          </div>
          <!-- Grid column -->

        </div>
        <!-- Grid row-->

      </div>
    </div>

      
<div class="footer2" style="text-align:center;">

<div style="padding:10px; font-size:14px">Discover new music : <a href="/music-charts/">Official Malawi Music Top 20 Chart</a> | <a href="/music-charts/hip-hop-top-20/">Urban Top 20 Chart</a> | <a href="/music-charts/reggae-top-20/">Reggea Top 20 Chart</a> | <a href="/music-charts/gospel-top-20/">Gospel Top 20 Chart</a> | <a target="_blank" href="http://www.youtube.com/channel/UCRtLP6Yqu85ZjAoxGP8YssA">YouTube Channel</a> </div>

<div style="padding:10px; font-size:14px">Stream and Download : <a href="https://www.malawi-music.com/playlist-18-best-of-2021-malawi-music-com">Best of 2021</a> | <a href="https://www.malawi-music.com/playlist-17-best-of-2020-malawi-music-com">Best of 2020</a> | <a href="https://www.malawi-music.com/playlist-16-best-of-2019-malawi-music-com">Best of 2019</a> | <a href="http://www.malawi-music.com/playlist-15-best-of-2018-malawi-music-com">Best of 2018</a> | <a href="http://www.malawi-music.com/playlist-37-best-of-2017-malawi-music-com">Best of 2017</a> | <a href="http://www.malawi-music.com/playlist-1-best-of-2016-jan-to-sept-malawi-music-com">Best of 2016</a> | <a href="http://www.malawi-music.com/playlist-2-best-of-2015-malawi-music-com">Best of 2015</a> | <a href="http://www.malawi-music.com/playlist-7-best-of-2014-malawi-music-com">Best of 2014</a> | <a href="http://www.malawi-music.com/playlist-8-best-of-2013-malawi-music-com">Best of 2013</a> | <a href="http://www.malawi-music.com/playlist-9-best-of-2012-malawi-music-com">Best of 2012</a> | <a href="http://www.malawi-music.com/playlist-10-best-of-2011-malawi-music-com">Best of 2011</a></div>

<div style="padding:10px;font-size:14px"><a href="/faq/">Frequently Asked Questions (FAQ)</a> | <a href="/contact-us/">Contact us</a> | <a href="/privacy-policy/">Privacy Policy</a> | <a href="/terms-and-conditions/">Terms and Conditions</a> | <a href="/faq/">Submit music</a> | <a href="/contact-us/donate/">Donate</a></div>

<table border="0" style="font-size: 14px;margin: 0 auto;">
<tbody>
<tr>
<td><center><img border="0" style="line-height: 1.3em;" src="http://www.malawi-music.com/mam.png"> <img border="0" style="line-height: 1.3em;" src="http://www.malawi-music.com/cosoma.jpg"></center>
</td>
</tr>
<tr>
<td style="margin-left:5px;">
<p>We are proudly working with Musicians Union of Malawi (MAM) -&nbsp;<span style="line-height: 1.3em;">Southern Divison </span> & Copyrights Society of Malawi (COSOMA)</p>
</td>
</tr>
</tbody>
</table>


			</div>



    <!-- Copyright -->
    <div class="footer-copyright text-center py-3"  style="background-color:#212529; color:white;">© 2010 - 2022      <a href="https://www.malawi-music.com" id="footerlinks">Malawi Music</a> website released by Dot Solutions.
    </div>
    <!-- Copyright -->

  </footer>

  
  <!-- Footer -->
  
<script type="text/javascript">(function(d, t, e, m){
    
    // Async Rating-Widget initialization.
    window.RW_Async_Init = function(){
                
        RW.init({
            huid: "294308",
            uid: "c4607f4aaadd08fe552c2fd7b0139f95",
            source: "website",
            options: {
                "advanced": {
                    "text": {
                        "rateAwful": "Mbola",
                        "ratePoor": "Wayesesa",
                        "rateAverage": "Akumveka",
                        "rateThis": "Vote for this",
                        "thanks": "Zikomo"
                    }
                },
                "size": "medium",
                "style": "flat_brown",
                "isDummy": false
            } 
        });
        RW.render();
    };
        // Append Rating-Widget JavaScript library.
    var rw, s = d.getElementsByTagName(e)[0], id = "rw-js",
        l = d.location, ck = "Y" + t.getFullYear() + 
        "M" + t.getMonth() + "D" + t.getDate(), p = l.protocol,
        f = ((l.search.indexOf("DBG=") > -1) ? "" : ".min"),
        a = ("https:" == p ? "secure." + m + "js/" : "js." + m);
    if (d.getElementById(id)) return;              
    rw = d.createElement(e);
    rw.id = id; rw.async = true; rw.type = "text/javascript";
    rw.src = p + "//" + a + "external" + f + ".js?ck=" + ck;
    s.parentNode.insertBefore(rw, s);
    }(document, new Date(), "script", "rating-widget.com/"));</script>
    
      
    <!-- Optional JavaScript -->
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->

    <!--<script src="/js/jquery-3.3.1.slim.min.js"></script>-->
    
   <!-- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css"> -->
    <!-- <script src="/js/bootstrap.min.js"></script> 
    <script src="/js/facebook.js"></script>
    <script src="/js/validator.js"></script>
    <script defer src="/fonts/js/all.js"></script>load all styles -->
   
      
  <!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>-->
    
  </body>
</html>